Description

You will lead the design, development, and optimization of ETL workflows and scalable data solutions on Snowflake.

Responsibilities

• Design and optimize ETL workflows using Informatica PowerCenter and IICS on Snowflake Data Warehouse.
• Develop robust data models utilizing facts and dimensions to drive business insights.
• Lead a team of data engineers through complex integration efforts and legacy data migrations to Snowflake.
• Translate unstructured business problems into structured, scalable data solutions.
• Partner with stakeholders and line-of-business leaders to prioritize data engineering opportunities.
• Produce technical documentation and business presentations for technical and executive audiences.

Required Skills

• 8+ years of experience in data engineering and ETL.
• Hands-on expertise in Informatica (PowerCenter and IICS).
• Advanced SQL skills with experience in performance tuning.
• Proven experience designing and optimizing solutions within Snowflake.
• Strong foundation in data warehouse design and dimensional modeling.
• Proficiency in Python, SQL, PL/SQL, and T-SQL.
• Experience with Talend, IICS, and Alation.
• Strong project management and team leadership abilities.
• Ability to manage ambiguity and shifting priorities.

Preferred Skills

• Pharma domain experience with exposure to IQVIA, Komodo, and VEEVA datasets.

Key Skills

Education

Any Gradute