Description

Key Responsibilities:

 

  • Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS
  • Architect high-performance, scalable solutions on Snowflake Data Warehouse
  • Design robust data models with strong understanding of facts and dimensions
  • Act as a strategic advisor to business stakeholders, using data to drive insights and business outcomes
  • Partner with line-of-business leaders to identify and prioritize opportunities where data engineering can deliver measurable value
  • Lead a team of data engineers through complex integration efforts with a problem-solving attitude
  • Translate unstructured problems into structured, scalable data solutions
  • Deliver high-quality business presentations and solution documentation tailored to technical and executive audiences
  • Ensure alignment between technical delivery and business value realization
  • Optimize performance through effective data modeling, partitioning, and indexing.
  • Lead data migration and integration projects to move legacy data systems to Snowflake.
  • Collaborate with business analysts, data engineers, and stakeholders to define requirements and deliver data solutions. 

     

Required Skills & Qualifications:

 

  • 8+ years of experience in data engineering and ETL, with hands-on expertise in Informatica (PowerCenter and IICS)
  • Advanced SQL skills and experience with performance tuning
  • Proven experience designing and optimizing solutions in Snowflake
  • Strong foundation in data warehouse design, with a focus on dimensional modeling
  • Prior experience in pharma domain with exposure to IQVIA, Komodo, and VEEVA datasets – strongly preferred
  • Exceptional communication and stakeholder engagement skills
  • Demonstrated consultative mindset, capable of influencing and leading cross-functional discussions on data-driven value generation
  • Experience writing business process and technical documentation
  • Strong project management, organization, and team leadership skills
  • Ability to work in fast-paced environments with ambiguity and shifting priorities

Education

Any Gradute