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 • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead pricing and packaging strategy for ServiceNow's portfolio, focusing on AI and SaaS offerings. Develop monetization models, run pricing experiments and analyses, track price realization KPIs, identify growth opportunities, and align stakeholders across product, GTM, and operations to implement pricing changes.
Top Skills:
A/B TestingAIConjoint AnalysisSaaS
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead Americas corporate and product public relations, building a high-performing PR team, managing agencies and budgets, driving AI-enabled communications, handling crisis and financial communications, and advising executives on narrative, product launches, and media strategy.
Top Skills:
Ai-Powered Communications ToolsCloudEnterprise SoftwareGenaiNow Platform
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Design, develop, and maintain backend services and APIs for an IAM platform; lead the Access Review feature; build identity lifecycle (provisioning/de-provisioning, access policies); implement logging, monitoring, and auditing; ensure scalability, security, and performance; collaborate with product, UX, and security teams to meet requirements and drive platform improvements.
Top Skills:
AWSAzureCachingDistributed SystemsDockerGoGoogle Cloud PlatformIamJavaKubernetesMicroservicesNoSQLRestful ApisSQL
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
