Description

You will lead the design, development, and optimization of ETL workflows.

Responsibilities

• Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS to build scalable solutions on Snowflake Data Warehouse.
• Design robust data models, focusing on facts and dimensions, and optimize performance via modeling, partitioning, and indexing.
• Act as a strategic advisor to stakeholders, translating unstructured problems into structured, scalable data solutions to drive business outcomes.
• Lead data migration and integration projects, moving legacy data systems into Snowflake.
• Collaborate with business analysts and stakeholders to define requirements and deliver high-quality data solutions and documentation.

Required Skills

• 8+ years of experience in data engineering and ETL.
• Expertise with Informatica (PowerCenter and IICS).
• Advanced SQL skills with proven experience in performance tuning.
• Strong experience designing and optimizing solutions in Snowflake.
• Deep understanding of data warehouse design, specifically dimensional modeling.
• Proven experience in the pharma domain, ideally with IQVIA, Komodo, and VEEVA datasets.
• Demonstrated consultative mindset capable of influencing cross-functional discussions.
• Strong project management and team leadership skills.
• Ability to work effectively with ambiguity and shifting priorities.

Key Skills

Education

Any Gradute