Design, develop, and troubleshoot ETL/ELT solutions and data warehouses using Informatica (including B2B and Data Transformation Studio). Apply dimensional modeling and DW architecture, work with Unix/Linux and shell scripting, collaborate across stakeholders in a global delivery environment.
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
Design, develop, configure and support enterprise BI solutions using Informatica ETL and OBIEE with Siebel CRM and Oracle EBS sources. Build ETL mappings, metadata, analytics repository, dimensional models, reports and dashboards; tune ETL and OBIEE performance; create technical design artifacts and mentor teams.
Top Skills:
DacDimensional ModelingETLInformaticaLinuxObieeOlapOracle BiOracle E-Business SuitePentahoPl/SqlRpdShell ScriptingSiebel CrmSolarisSQLUnixWindows
Professional Services • Industrial • Manufacturing
Design and develop Informatica ETL mappings for data warehousing; perform unit testing, support SIT/UAT, fix defects, plan and facilitate code deployments, and coordinate with customers, offshore teams, and infrastructure support.
Top Skills:
Data WarehousingETLInformaticaOracleSQL
Information Technology • Professional Services • Software • Consulting
Design, develop, and troubleshoot ETL/ELT processes using Informatica for data warehouses. Implement dimensional models, collaborate with stakeholders, work in global delivery, and perform DW/BI lifecycle activities and support.
Top Skills:
Data WarehouseDimensional ModelingDw/BiEltETLInformaticaInformatica B2BInformatica Data TransformationLinuxShell ScriptingUnix
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
