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 • Information Technology • Consulting
Leads product strategy, roadmap planning, and execution for HPE cloud infrastructure and AI networking hardware serving hyperscalers, cloud providers, and Neoclouds. Owns hardware product strategy, customer requirements, competitive analysis, NPI programs, engineering commitments, and go-to-market execution. Partners with corporate strategy, R&D, sales, marketing, customers, and systems engineering to expand adoption, revenue, and market share across global cloud infrastructure markets.
Top Skills:
Ai NetworkingCloud InfrastructureData Center NetworkingHyperscaler PlatformsIp NetworkingNetwork AsicsNetwork HardwareNetwork Operating SystemsNetworking ProtocolsWan Networking
Artificial Intelligence • Cloud • Information Technology • Consulting
Develops North American field enablement strategy for HPE Networking by creating sales plays, learning experiences, coaching, seller tools, and reinforcement programs. Translates networking technologies into customer-focused stories, use cases, discovery questions, and repeatable sales actions. Partners with sales leaders and cross-functional teams to drive adoption, behavior change, pipeline progression, and measurable business outcomes. The role also defines enablement content standards, facilitates training, and evaluates field engagement and business impact.
Top Skills:
AiopsArtificial IntelligenceCampus NetworkingData Center NetworkingEnterprise NetworkingNetwork ManagementNetwork SecurityRoutingSales SimulationsSwitchingVideo LearningWireless
Artificial Intelligence • Cloud • Information Technology • Consulting
Designs, develops, tests, troubleshoots, and debugs systems software for packet forwarding, operating systems, networking, and related tools. Responsibilities include implementing enhancements, analyzing designs, writing code and test plans, debugging issues, documenting results, and collaborating with internal and outsourced engineering teams. The role requires C and C++ programming, Python-based testing, software systems design, multi-platform development, and strong communication skills.
Top Skills:
CC++DatabasesNetworkingOperating SystemsPythonRoutersSoftware Systems Testing
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
