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
Sell Comcast Internet, Video and Voice solutions to small and mid-size businesses. Develop territory and partnerships, generate new leads, deliver face-to-face presentations, manage pipeline and quotas, promote bundled and advanced communications solutions (PRI, Hosted PBX), and coordinate with technical and support teams to ensure customer satisfaction and revenue growth.
Top Skills:
Comcast Business InternetComcast Business VideoComcast Business VoiceHosted PbxPri
.png)
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Software • Generative AI
Manage and automate security operations across SaaS and endpoints: deploy and tune PHI DLP, run AI-powered email security, configure MDR/EDR, harden Okta and Google Workspace, lead incident response, automate compliance evidence collection, maintain runbooks, and build automation and reporting to improve security posture.
Top Skills:
AbnormalAi Email SecurityConfluenceDlpEap-TlsEdrGitGoGoogle WorkspaceHoxhuntJAMFJIRAKandjiKnowbe4Living SecurityLlmmacOSMaterialMdrMimecastOktaOkta Device TrustProofpointPythonScimSecurew2SlackSublimeTerraformTypescript
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Provide tax planning, compliance, and strategy advice to clients; prepare and file tax returns; analyze financial data; optimize tax positions; draft tax documents; mentor junior staff; build client relationships while upholding professional standards.
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
