What are the responsibilities and job description for the ETL Lead Data Enginner position at Argyll Infotech Enterprise Pvt Ltd?
Job Title: ETL Lead Data Engineer
Location: Plainsboro, NJ (Hybrid )(Locals)
Skills:-ETL, Informatica PowerCenter, IICS, Data Warehousing, Snowflake, business stakeholders
Preferred Qualifications
We are seeking a highly skilled and consultative ETL Lead Data Engineer with deep experience in Data Warehousing and Informatica to lead data integration initiatives for a Life Science practice . This role is ideal for someone who not only excels technically but thrives as a thought partner to business stakeholders, helping to uncover opportunities for value creation through data.
Key Responsibilities
Location: Plainsboro, NJ (Hybrid )(Locals)
Skills:-ETL, Informatica PowerCenter, IICS, Data Warehousing, Snowflake, business stakeholders
Preferred Qualifications
- SnowPro certification is highly desirable.
- Very strong SQL and Informatica (PowerCenter & IICS) capabilities
- Deep understanding of Pharma datasets and commercial analytics
- Proven consultative approach with ability to drive thought leadership and business impact
- Excellent stakeholder management and presentation skills
We are seeking a highly skilled and consultative ETL Lead Data Engineer with deep experience in Data Warehousing and Informatica to lead data integration initiatives for a Life Science practice . This role is ideal for someone who not only excels technically but thrives as a thought partner to business stakeholders, helping to uncover opportunities for value creation through data.
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.
- 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
Salary : $65 - $70