ETL Lead - IDMC/Snowflake

Acunor Inc

Plainsboro Township, NJ, United States

15 days ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Compensation

$93,713.0 - $121,827.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

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

+8 more

Freeform SQL Sql Optimization Informatica Powercenter Snowflake Software Troubleshooting Integration Frameworks Veeva Data Pipelines

Job 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

Requirements

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.

Benefits & conditions

$93,713-121,827 per year Job Description In the assigned Job Role of Package Project Lead 1, your Area Of Responsibility will be as below: Develop project timelines, proactively identify and address …
1 month ago +