Lead ETL development using Informatica for DW/BI projects. Design/implement ETL/ELT frameworks, perform dimensional modeling, troubleshoot data transformations, use Unix/shell scripting, collaborate with global stakeholders, and support full project lifecycle.
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.
- Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica, Informatica B2B, Best Practices and Troubleshooting
- Working knowledge of Informatica Data Transformation and Data Transformation studio
- Understanding of Unix/Linux system, file systems, shell scripting
- Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
- Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
- Ability to work in team in diverse/ multiple stakeholder environment
- Strong analytical skills
- Experience and desire to work in a Global delivery environment.
- 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 4 years of experience with Information Technology.
- At least 3 years of experience with DW/BI and ETL tools
- At least 2 years of hands on experience in Design, Development & Build activities in Informatica Projects - MUST
- At least 3 years of experience in Project life cycle activities on DW/BI development and maintenance projects.
** 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 H1-B & OPT is applicable for this position.
- Please mention your email id in your email or resume.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Lead ETL developer responsible for designing, developing, and building Informatica-based ETL solutions within DW/BI projects. Participate across project lifecycle, development, maintenance, and data warehouse/BI activities, ensuring delivery of ETL mappings and integrations.
Top Skills:
Dw/BiETLInformatica
Information Technology • Professional Services • Software • Consulting
Lead ETL design and development using Informatica for DW/BI projects. Build ETL/ELT frameworks, perform dimensional modeling, troubleshoot data transformations, collaborate with global stakeholders, and support full project life-cycle activities.
Top Skills:
Data Transformation StudioData WarehouseDimensional ModelingDw/BiEltETLInformaticaInformatica B2BInformatica Data TransformationLinuxShell ScriptingUnix
Information Technology • Software
Lead development for BI projects using Informatica, managing offshore teams, resolving bugs, and ensuring timely delivery of BI solutions.
Top Skills:
AutosysInformaticaOraclePl-SqlTeradata
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
