Design, develop, and maintain Informatica ETL mappings, workflows, and sessions for enterprise data warehouse loads. Lead ETL design, implement auditing/error-handling frameworks, tune performance, integrate with third-party tools, support production cycles, resolve data quality issues, and prepare technical documentation while collaborating with global cross-functional teams.
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- 4+ year’s hands-on experience in development in Informatica 8.x and above.
- Should have experience on at least two end to end full DW project life cycles.
- Strong working knowledge of Data warehouse concepts, dimensional modeling, OLAP processing.
- Must have a strong knowledge of system development, understanding of emerging technologies, and familiarity with current processes/methodologies
- Experience in Auditing and Error handling framework for ETL architecture.
- Experience in auditing and error handling frameworks using Informatica.
- Experience with normalized designs and DataMart
- Experience in performance tuning of Informatica mapping.
- Experience in integrating ETL with third party tools.
- Lead ETL design based on requirement gathered while working on cross functional project team.
- Administer and developed Informatica workflows, mappings and sessions to load large data volumes from multiple sources into enterprise data warehouse.
- Support ETL cycles including production issue and environment quality issue.
- Prepare technical documentation of product sub systems.
- Performance tune ETL code in a high volume environment.
- Resolved data problem discovered by quality QA and developed solution to the problem.
- Define/improve processes for development and support functions.
- Ability to write and understand UNIX shell scripting, Perl.
- Experience and desire to work in a Global delivery environment
- Ability to work in team environment and client interfacing skills.
- Must have strong Writing, Communication and Analytical Skills
- 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 within the Information Technologies.
Connect with me at https://www.linkedin.com/in/mir-hasham-ali/ (For Direct Clients Requirements)
** 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 Full-Time & Permanent job opportunity for you.
- Only US Citizen, Green Card Holder & GC-EAD can apply.
- No OPT-EAD, H1B, H4-EAD, L2-EAD & TN 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
Cloud • Information Technology • Software • Consulting
Support and maintain core data repositories by designing, developing, and operating ETL processes using Informatica on UNIX environments against large relational databases. Collaborate with team members, communicate effectively, and proactively ask questions to ensure high-quality data solutions. 12-24 month contract role based in San Francisco or St. Louis.
Top Skills:
ETLInformaticaRelational Database SystemsUnix
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
Information Technology • Professional Services • Software • Consulting
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.
Top Skills:
BiData Transformation StudioData WarehouseDimensional ModelingEltETLInformaticaInformatica B2BInformatica Data TransformationLinuxShell ScriptingUnix
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
