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
Digital Media • Information Technology • News + Entertainment
Sells Comcast mobile and integrated communication products to small and medium-sized businesses. Responsibilities include prospecting, cold calling, canvassing, lead generation, face-to-face presentations, territory development, relationship management, customer retention, competitive research, sales reporting, and meeting financial and unit targets. The role requires customer visits, persuasive communication, independent judgment, and availability for nights, weekends, variable schedules, and overtime.
Digital Media • Information Technology • News + Entertainment
Sells Comcast Business communication products and bundled services to small and medium-sized businesses. Responsibilities include prospecting, cold calling, canvassing, conducting face-to-face presentations, developing territories, cultivating business partnerships, negotiating sales, meeting revenue targets, retaining customers, and preparing activity reports. The role requires regular customer meetings, strong communication and persuasion skills, independent judgment, and flexibility to work nights, weekends, variable schedules, and overtime.
Digital Media • Information Technology • News + Entertainment
Sells Comcast Internet, Data, Video, and Voice services to small and mid-sized businesses. Develops territories, generates leads through prospecting and partnerships, delivers sales presentations, consults on advanced communications solutions such as PRI and Hosted PBX, manages qualified pipelines, coordinates with technical and support teams, and meets or exceeds sales quotas and customer satisfaction objectives.
Top Skills:
Hosted PbxPri
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
