Design, develop, test, and maintain ETL solutions using Informatica PowerCenter for large data volumes. Translate business requirements into ETL mappings/workflows, set up ETL environments, manage migrations between environments, collaborate with analysts and operations, and document testing (unit/UAT/SIT).
Company Description
SonSoft Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. SonSoft Inc is growing at a steady pace specializing in the fields of Software Development, Software Consultancy, and Information Technology Enabled Services.
Job Description- Provides ETL processing subject matter expertise to client projects
- Designs and implements industry best ETL technologies to satisfy client requirements
- Designs and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sources
- Gathers and translates business requirements into analytical applications.
- Collaborates with other project members and drive the development of BI initiatives
- Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes
- Establishes ETL environments according to project requirements
- Design and implements an efficient migration process to move ETL objects from development to test and production environments
- Understands database design, programming concepts, data modeling and framework management.
Daily Tasks Performed.
- Discuss and understand ETL requirements with Data Analysts
- Develop, build Informatica mapping, workflows, create scripts for
- production jobs; under a supervision of ETL Architect.
- Working with Operations to implement jobs and support warranty
- Unit test, UAT, and SIT the data and able to document all the test
- process and results.
Wants
- At least 5 years of Informatica PowerCenter experience.
- This person will be the backup developer of the existing ETL developers, working well with the person is a crucial criterion.
- Due to the project requirements, this person cannot take a long vacation (more than 1 week) in the first 6 months.
- The visa status must allow the person to work in CA for two years.
- Informatica PowerCenter v9+
- Developer with 5+ years direct experience
- Familiarity with DB2, SQL Server Database
- Knowledge of Big Data is a plus
Musts
- BA/BS in Computer Science or equivalent training
Business Experience
- Data Warehousing 3-5 years
- ETL 3-5 years
- Informatica 3-5 years
- Oracle/SQL 3-5 years
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Contract job opportunity for you.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD & TN-Visa can apply.
- No OPT-EAD & H1B candidates, please.
- Please mention your Visa Status in your email or resume.
** All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Artificial Intelligence • Hardware • Healthtech • Software
Lead backend engineering for cloud-native, event-driven data pipelines and customer integrations (especially EHRs). Evolve core data models and APIs, improve scalability and reliability, mentor engineers, define best practices, and drive end-to-end testing and AWS-based solutions.
Top Skills:
APIsAws FargateAws KinesisAws LambdaAws RdsAws SnsAws SqsClaude CodeCursorDynamoDBEhr IntegrationsEvent-Driven ArchitectureNode.jsPostgresReactServerlessTypescript
Artificial Intelligence • Hardware • Healthtech • Software
Lead system-level product strategy for Inspiren's connected hardware ecosystem. Define requirements, trade-offs, and success criteria across hardware, embedded, and software through concept to mass production. Drive discovery of sensing technologies, partner with commercial and implementation teams, own end-to-end implementation and deployment experience, and use data and AI to inform product decisions that improve resident safety and business outcomes.
Top Skills:
Ai/MlAudio SensorsBle BeaconsCamerasEmbedded SystemsOn-Device MlPerception PipelinesRadarTelemetry Anomaly DetectionThermal Sensors
.png)
Artificial Intelligence • Healthtech • Information Technology • Logistics
The Head of Growth Marketing will drive pipeline growth, execute demand generation campaigns, and establish brand positioning in home healthcare technology.
Top Skills:
Google AnalyticsHubspotLinkedin Ads
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
