Design, develop and maintain end-to-end ETL solutions using Informatica PowerCenter (8.x/9.x). Act as ETL architect, create complex mappings, implement auditing/error handling, support testing and implementation, and work on DW/BI projects (financial domain preferred).
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:-
- Skills: Informatica 8.x, 9.x
- Should have at least 5+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x
- At least 2 years of experience in Architect capacity to provide end to end ETL solution using Informatica and other ETL tools
- Knowledge / Experience on using Informatica Power center and ETL using different data sources
- Experience on implementing auditing and error handling
- Experience in test planning, testing and implementation support
- Experience in creating mappings using complex transformations
Preferred:-
- At least 7+ years of experience in DW/BI related technologies and tools
- At least 7+ years of experience in software development life cycle.
- At least 7+ years of experience in Project life cycle activities on development and maintenance projects.
- At least 4 years of experience in Design and architecture review.
- Ability to work in team in diverse/ multiple stakeholder environment
- Experience to Financial domain
- Analytical skills
- Experience and desire to work in a Global delivery environment
Basic Qualifications :-
- Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
- At least 7 years of experience with Informatica.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a FULL TIME job oppurtunity.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
- No OPT-EAD & H1-B for this position.
- Please mention your Visa Status in your email or resume.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Lead design and implement Informatica Data Quality (IDQ 9.1) and PowerCenter solutions across the SDLC, perform data profiling, develop complex quality rules and cleansing pipelines, integrate with ETL/real-time flows, and use Oracle SQL and Unix for data operations. Communicate with stakeholders and apply DQ best practices.
Top Skills:
Informatica Idq 9.1Informatica MdmInformatica PowercenterOracle SqlUnix
Information Technology • Professional Services • Software • Consulting
Design and implement Informatica IDQ 9.1 and PowerCenter data quality solutions across the SDLC: data profiling, quality rules, cleansing, parsing, standardization, validation, scorecards, exception handling, reporting, and ETL/real-time integration; use Oracle SQL and Unix.
Top Skills:
ETLInformatica Idq 9.1Informatica MdmInformatica PowercenterOracle SqlUnix
Information Technology • Professional Services • Software • Consulting
Design and architect Informatica MDM/IDQ solutions, define MDM framework, standards and processes, gather business requirements, implement data solutions, coordinate vendors, provide technology advisory, and work in a consulting environment with regular travel.
Top Skills:
Business IntelligenceDatabasesInformatica IdqInformatica MdmMaster Data Management
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
