ETL Lead - IDMC/Snowflake

Acunor Inc

ETL Lead IICS / IDMC / Snowflake

Location: Plainsboro, NJ
Work Model: Hybrid 4 days onsite
Experience: 10+ Years

Job Summary

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.

Key Responsibilities

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.

Required Skills

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.

Apply

Vacancy posted 2 days ago

Similar jobs that could be interesting for youBased on the ETL Lead - IDMC/Snowflake in Plainsboro, NJ vacancy

U.S. Biosimilars Regulatory Lead — Hybrid Work
...Sandoz Inc in Princeton, NJ, is looking for an Associate Director of Regulatory Affairs – Biosimilars to lead U.S. regulatory strategy for biosimilar development. This pivotal role involves overseeing regulatory submission processes and ensuring compliance with FDA regulations...
Suggested
U023 (FCRS = US023) Sandoz Inc
Princeton, NJ
4 days ago
Team Lead
...Team Lead Brand: LensCrafters Location: Princeton, NJ, US, 08540-5930 Store #: 000250 LensCrafters Position: Full-Time Total Rewards: Benefits/Incentive Information LensCrafters is a place for visionaries. We've got a vision for pairing state-of-the-art technology...
Suggested
Minimum wage
Full time
Local area
EssilorLuxottica SA
Princeton, NJ
19 hours ago
Shift Lead
Job Description Job Summary: Opens and closes the store in the absence of store management, including all required systems startups, required cash handling, and ensuring the floor and stock room are ready for the business day. Responsible for opening back door ...
Suggested
Work experience placement
Seasonal work
Local area
Flexible hours
Shift work
Afternoon shift
Walgreens Boots Alliance
Princeton Junction, NJ
19 hours ago
Team Lead
$16 - $19 per hour
...Team Lead Share Apply Part-time $16.00 - 19.00 per hour The Team Lead is responsible for managing restaurant operations, in conjunction with or in the absence of the Restaurant Manager. Uses discretion in daily management decisions with accountability for living...
Suggested
Hourly pay
Part time
Flexible hours
Qdoba
Princeton, NJ
2 days ago
Lead Technician
$20 - $28 per hour
...working hard, learning fast, and being part of something bigger than yourself? Voda Cleaning & Restoration is looking for a motivated Lead Technician to join our growing team and help us build something incredible from the ground up! Why Join Us? ~ Paid Training &...
Suggested
Hourly pay
Work from home
Institute of Inspection , Cleaning and Restoration Certifica...
Princeton Junction, NJ
19 hours ago
Lead Tech Operations Maintenance
$26 - $42.53 per hour
...expert understanding of all levels of the job family and has thorough knowledge of jobs outside area of responsibility Takes the lead in effectively applying new processes and skills in accomplishing assignments May provide technical guidance and training to others...
Hourly pay
Temporary work
For contractors
Work experience placement
Local area
Immediate start
Monday to Friday
Flexible hours
Shift work
Cardinal Health
Cranbury, NJ
4 days ago
Outlet Floor Lead, C&B
...Outlet Lead We inspire purpose-filled living that brings joy to the modern home. With a team of more than 8,000 associates spanning 130 store and distribution locations across the U.S. and Canada, we achieve together, drive results and innovate to inspire. Drawn together...
Full time
Work at office
Flexible hours
Shift work
Night shift
Crate and Barrel
Princeton, NJ
19 hours ago
Contract Guest Experience Lead | Princeton
$24 - $27.61 per hour
...Guest Experience Lead lululemon is an innovative performance apparel company for yoga, running, training, and other athletic pursuits. Setting the bar in technical fabrics and functional design, we create transformational products and experiences that support people...
Minimum wage
Contract work
Part time
Shift work
Night shift
Weekend work
Day shift
Afternoon shift
Early shift
Lululemon athletica
Princeton, NJ
1 day ago
Lead / Supervisory Transportation Security Officer - No Experience Required for Entry-Level TSA Careers
$25 - $50 per hour
...Role Overview TSA is accepting applications for Lead and Supervisory Transportation Security Officers at airports in Kingston. These roles are ideal for individuals looking to step into leadership positions within airport security operations. TSA provides training...
Shift work
Night shift
Weekend work
Airport Security Careers
Kingston, NJ
more than 2 months ago
[PRI] Sr Engagement Lead-Medical Affairs
...published perspectives — to build the practice's visibility and credibility in market. Client Delivery & Relationship Management Lead Medical Affairs consulting engagements end-to-end across the product lifecycle — including analytics-heavy workstreams (evidence gap...
Full time
ProcDNA
Princeton, NJ
10 days ago
Lead Intellectual Property Counsel
...medicines more affordable to discovering innovative treatment options to satisfy unmet medical needs, we are dedicated to helping people lead longer and healthier lives. We are seeking dynamic and energetic individuals ready to inspire, ready to make a difference for their...
Permanent employment
Work experience placement
Work at office
Visa sponsorship
Dr Reddy's Laboratories Limited
Princeton, NJ
3 days ago
Lead Intellectual Property Counsel
...We are seeking an accomplished and strategic Lead Intellectual Property Counsel for Dr.Reddy's North America business. As an Attorney in the IP department, you will collaborate with internal and external stakeholders to design and implement IP strategies to advance Dr...
Permanent employment
Work experience placement
Work at office
Visa sponsorship
Biopharma Careers
Princeton, NJ
2 days ago
Lead Carpenter
$32 - $35 per hour
...surprises that aren't visible until the job is underway, since the drawings don't always match what's actually in the house. You'll lead the crew on-site, setting the pace, assigning tasks, and reviewing quality before anything is called finished. You'll work directly...
Hourly pay
Full time
Immediate start
Work from home
Rowe Carpentry LLC
Princeton, NJ
10 days ago
Multi Site Customer Service Coordinator
$17.69 - $22.28 per hour
Job Description $17.69 - $22.28 per hour This position offers a $1000 sign on bonus to New Ricoh team members! Job Title: Area Customer Service Coordinator Summary: Join our team as an Area Customer Service Coordinator, where you'll...
Hourly pay
Work experience placement
Work at office
Worldwide
Relocation package
Flexible hours
Shift work
Ricoh USA, Inc.
Princeton, NJ
4 days ago
Salon Manager Trainee: Lead Teams, Grow Guests
...performing hair care services, resolving guest issues, and supporting business growth initiatives. A flexible schedule is essential, including evenings and weekends. Join Supercuts to lead and develop a dynamic salon team while driving salon profitability. #J-18808-Ljbffr...
Traineeship
Flexible hours
Afternoon shift
Supercuts
Plainsboro, NJ
2 days ago
Lead QA Automation
...NessContact: Meghana GorusuCompany: SRI Tech SolutionsJob Title: Lead QA AutomationLocation: Princeton, NJ (Hybrid)Key Roles & Responsibilities... ...accuracy and integrity by designing and executing test plans for ETL to ELT processes. Develop automated testing scripts and monitor...
SRI Tech
Princeton, NJ
5 days ago
Lead Line Cook
$17.21 - $22.37 per hour
...Position Overview The Technical Lead is responsible for intermediate level set up and operation of small to large-scale audiovisual systems in a hospitality environment while ensuring complete customer satisfaction. This position reports to an Operations Manager, Operations...
Hourly pay
Work experience placement
Worldwide
Afternoon shift
Encore
Princeton, NJ
2 days ago
Lead Medical Assistant (Full Time)
$20 - $25 per hour
...Schweiger is one of the leading dermatology practices in the country with over 580+ healthcare providers and over 170+ offices in New York, New Jersey, Pennsylvania, Connecticut, Florida, Illinois, Missouri, Minnesota, and California. Schweiger provides medical, cosmetic...
Hourly pay
Full time
Work at office
Local area
Monday to Friday
Shift work
Weekend work
Weekday work
Schweiger Dermatology Group
Princeton, NJ
3 days ago
Lead Medical Assistant (Full Time)
...Job Summary Full‑time Lead Medical Assistant for the Princeton and Somerset offices. The Lead Medical Assistant provides administrative support to physicians, physician assistants, and medical assistants/LPNs through supervision, staff development, and day‑to‑day clinical...
Full time
Temporary work
Work at office
Local area
Monday to Friday
Shift work
Weekend work
Weekday work
SDG MGMT Company LLC
Princeton, NJ
19 hours ago
Lead Quality Inspector
$26.21 - $35.38 per hour
...s possible and making headway to innovate new treatment pathways to advance patient outcomes and set new standards of care. The Lead Quality Inspector serves as a Lead Associate, Quality Inspector for the Plainsboro Manufacturing Site, Collagen Manufacturing Center...
Hourly pay
Temporary work
Work at office
Shift work
Weekend work
Integra LifeSciences
Plainsboro, NJ
1 day ago
Enterprise IT Architect Lead - Strategy & Modernization
$166.75k - $228.85k
...services, and strong leadership skills. Key responsibilities include developing enterprise architecture, overseeing governance, and leading modernization initiatives. The role offers a competitive salary range of $166,750 - $228,850, and includes comprehensive benefits....
Jobleads-US
Princeton, NJ
1 day ago
Ophthalmics Senior Medical Affairs Director & Field Lead
Sun Pharmaceutical Industries, Inc. is seeking a Senior Director for Medical Affairs, based in Princeton, NJ. This strategic leader will manage the field medical organization in ophthalmology and engage with top-tier Key Opinion Leaders to enhance patient outcomes. ...
Jobleads-US
Princeton, NJ
1 day ago
Vice President, U.S. Brand Lead, Cobenfy, Psychiatry
...Vice President, U.S. Brand Lead, Cobenfy, Psychiatry About the Company Internationally renowned biopharmaceutical company Industry Pharmaceuticals Type Public Company Founded 1858 Employees 10,001+ Categories Pharmaceuticals Biotechnology...
Confidential
Princeton, NJ
3 days ago
Customer Experience Coordinator - Part Time
$16.92 - $17.42 per hour
...ll find abundant opportunities to learn, thrive, and make an impact. Come join our TJX family—a Fortune 100 company and the world’s leading off-price retailer. \n \n \n \n Job Description: \n Opportunity: Grow Your Career \n Responsible for promoting an...
Hourly pay
Temporary work
Part time
Local area
Home office
Flexible hours
Night shift
TJX Companies
Princeton, NJ
19 hours ago
Senior Director, Medical Affairs, Therapeutic Head & National Field Lead, Ophthalmics, Princeton, NJ
$243k - $297k
...how often (in days) to receive an alert: Create Alert Title: Senior Director, Medical Affairs, Therapeutic Head & National Field Lead, Ophthalmics, Princeton, NJ Location: Princeton, NJ Company: Sun Pharmaceutical Industries, Inc (USA) Driven by a bold pursuit...
Work at office
Local area
Flexible hours
Sun Pharmaceutical Industries, Inc.
Princeton, NJ
4 days ago
Lead Line Chef
...Job Description Job Description Lead Line Cook Position Summary We are looking for an experienced, hands-on Lead Line Cook who is ready to take the next step in their culinary career. This is a great opportunity for someone who loves being in the kitchen...
Local area
Gecko Hospitality - NY & NJ
Rocky Hill, NJ
16 days ago
Veterinary Technician Lead
Veterinary Technician City: Princeton State: New Jersey Hospital Name: Princeton Animal Hospital & Carnegie Cat Clinic National Veterinary Association
National Veterinary Association
Princeton, NJ
9 hours ago
Veterinary Technician Lead
$20 - $32 per hour
...Veterinary Technician Lead At Princeton Animal Hospital and Carnegie Cat Clinic, we are a compassionate, AAHA-accredited veterinary hospital dedicated to providing the highest level of care to our patients and supporting our team's professional growth. We believe that...
Hourly pay
All Creatures Animal Clinic
Princeton, NJ
2 days ago
Senior Lead Technical Architect
...Job Description Job Description Looking for a Senior Lead Technical Architect with 10+ years of experience to lead the technical... ...expertise in the following tools: Salesforce, AWS, and Snowflake (Data Warehouse). Experience with similar tools will be considered...
Core Software Technologies Inc.
Trenton, NJ
20 days ago
Lead Associate - SAP
...medicines more affordable to discovering innovative treatment options to satisfy unmet medical needs, we are dedicated to helping people lead longer and healthier lives. We are seeking dynamic and energetic individuals ready to inspire, ready to make a difference for their...
Permanent employment
Full time
Work experience placement
Immediate start
Visa sponsorship
Shift work
Dr Reddy's Laboratories Limited
Princeton, NJ
19 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to ETL Lead - IDMC/Snowflake. Be the first to apply!