Senior Informatica B2B DW/ETL Lead

SmartRecruiters, Inc.; Springfield (MA); On-site; USD 90,000 - 130,000; Full time

Job summary

Sonsoft, Inc. is seeking a seasoned DW/BI and ETL specialist to design and implement data warehouses and ETL frameworks using Informatica. You will lead development, apply best practices, and troubleshoot complex data flows across teams in a diverse stakeholder environment.

Ideal candidates have strong Dimensional Modelling skills, hands-on Informatica experience, and a track record of delivering DW/BI projects in an insurance domain context.

Qualifications

• Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
• At least 5 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 7 years of experience in Project life cycle activities on DW/BI development and maintenance projects

Responsibilities

• 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
• Experience in Insurance domain

Skills

DW/BI knowledge

ETL troubleshooting

Team collaboration

Problem solving

Unix/Linux understanding

Education

Bachelor's degree or foreign equivalent

Tools

Informatica

Informatica B2B

Data Transformation Studio

Job description

Sonsoft, Inc. is seeking a seasoned DW/BI and ETL specialist to design and implement data warehouses and ETL frameworks using Informatica. You will lead development, apply best practices, and troubleshoot complex data flows across teams in a diverse stakeholder environment.

Ideal candidates have strong Dimensional Modelling skills, hands-on Informatica experience, and a track record of delivering DW/BI projects in an insurance domain context.