> Markdown version of [/jobs/ext/2866918-etl-lead-idmc-snowflake](https://www.wearedevelopers.com/jobs/ext/2866918-etl-lead-idmc-snowflake). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Lead - IDMC/Snowflake

- **Company:** Acunor Inc
- **Location:** Plainsboro Township, NJ, United States
- **Experience:** Expert
- **Salary:** $93,713.0 - $121,827.0
- **Contract:** Temporary to permanent
- **Skills:** Artificial Intelligence, Data Analysis, ARM Architecture, Big Data, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Systems, Data Warehousing, Dimensional Modeling, Performance Tuning, SQL Databases, Freeform SQL, Sql Optimization, Informatica Powercenter, Snowflake, Software Troubleshooting, Integration Frameworks, Veeva, Data Pipelines
- **Published:** September 12, 2026
- **Apply:** https://www.careerjet.com/jobad/us2f4661429b8ba76f9450e227af4158aa

## About the Role

We are seeking an experienced ETL Lead with strong hands-on expertise in Informatica IICS/IDMC, Snowflake, SQL, and Data Warehousing. The ideal candidate will combine deep technical expertise with team leadership, solution design, problem-solving, and strong client-facing communication skills.
Experience working with Pharmaceutical/Life Sciences data, including datasets and platforms such as IQVIA, Komodo, and Veeva, is highly preferred., Strong hands-on experience with Informatica IICS / IDMC.
Experience with Informatica PowerCenter.
Strong expertise in Snowflake architecture, development, and performance optimization.
Advanced SQL skills.
Strong understanding of Data Warehousing and dimensional modeling.
Hands-on experience designing facts, dimensions, and analytical data models.
Experience designing enterprise ETL/data integration architectures.
Strong troubleshooting and problem-solving capabilities.
Experience leading technical teams and mentoring developers.
Excellent business communication, presentation, and stakeholder management skills.
Ability to translate complex technical information into clear business and technical narratives.
Preferred Skills
Pharmaceutical or Life Sciences domain experience.
Experience working with IQVIA, Komodo, Veeva, or similar Life Sciences datasets/platforms.
Understanding of Snowflake Cortex AI or AI-enabled data solutions.
Experience leading solution architecture and data engineering initiatives.

## Description

Lead the design, development, and implementation of enterprise ETL and data engineering solutions.
Design scalable data warehouse architectures, dimensional models, facts, and dimensions.
Develop and optimize data integration solutions using Informatica IICS/IDMC and PowerCenter.
Design and optimize solutions on Snowflake Data Warehouse.
Build complex SQL queries, transformations, data pipelines, and integration workflows.
Provide technical leadership and guide development teams through complex implementation challenges.
Develop first-cut architecture and solution designs for data engineering initiatives.
Troubleshoot data integration, performance, and data quality issues.
Lead technical discussions with business, architecture, and engineering stakeholders.
Create technical architecture, process, and solution documentation.
Identify technical risks and proactively recommend solutions.
Support small to large-scale data engineering programs from design through execution., Job Description In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will be as below: Contribute to the requirements elicitation process by docum…

 + 1 month ago


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)
- [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)
- [What Industries Outside of AI Are Hiring The Most AI Experts?](https://www.wearedevelopers.com/magazine/98-what-industries-outside-of-ai-are-hiring-the-most-ai-experts)