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.
- ...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...Suggested
$137k - $228k
Global Supply Chain Lead, Pharma SolutionsBuild and Personally Deliver the Supply Chain Backbone of a Growing Global Pharma BusinessPharma Solutions is a growing business within Croda, serving pharmaceutical, biotechnology, and veterinary-health customers through innovative...SuggestedContract work$235k - $270k
...clients and captives, and fully reimbursed fronting solutions for corporate clients.Position SummaryWe are seeking an ART Underwriting Lead who will report to the Head of Alternative Risk Transfer. This senior role will lead the end-to-end underwriting and execution of...SuggestedFull timeContract work- ...and Information Technology Enabled Services.Job DescriptionKnowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs Knowledge of data loading techniques using DatastageDevelop Datastage Parallel Extender jobs using different stages...SuggestedWork experience placement
- About the Role:Grade Level (for internal use):12S&P GlobalThe role: Lead, IT Service OperationsThe location: Dalas, TX (hybrid - 2 days onsite per week)Role & Responsibility Summary: As a Cloud Engineer, you’ll be an integral part of our global team of Cloud Engineers...SuggestedFull timeSecond jobLive inWorldwideFlexible hoursRotating shift2 days per week
$210.9k - $379.2k
...career experience, with the potential to make a significant impact on patients' lives worldwide.Moderna is seeking a Global Medical Lead to lead medical affairs strategy across our Oncology portfolio, spanning early development through commercialization. This role offers...Permanent employmentFull timeWork at officeWork from homeWorldwide- Company DescriptionSonSoft Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. SonSoft Inc is growing at a steady pace specializing in the fields of Software Development, Software Consultancy, and Information Technology Enabled ...Permanent employmentFull timeH1b
$99.3k - $198.7k
...helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 122,000 colleagues serve...WorldwideShift work$137.5k - $229k
...or any basis prohibited by the laws that govern its operations.How does this role contribute to our collective success?The Portfolio Lead serves as the operating partner to the Business Lead and Value Stream Lead for the Claims and Corporate strategic investment...Full timeWork at office3 days per week- ...to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Oracle GTM Functional Lead to join our team in Plainsboro, New Jersey (US-NJ), United States (US).Oracle Global Trade Management Functional Lead Job...
$116.2k - $229.1k
...communication skillsMeticulous attention to detail and quality of work productAbility to build and sustain professional relationshipsAbility to lead projects or workstreamsAbility to manage and prioritize multiple tasks in a fast-paced and dynamic environmentStrong interpersonal...Local area$135k - $230k
...the frontline managers and play a critical role in developing and leading individuals with diverse experiences and expertise spanning... ...focused metrics and process observabilityDevelop data modeling and ETL skills within the team and collaborate with Engineering teams to...Temporary workFor contractorsWork experience placement$130k - $160k
About the Role:Grade Level (for internal use):11Position Title: Lead, Oracle EPM AdministratorLocation: Hybrid 2 days per week onsite; Princeton, NJ, New York, NY, Charlottesville, VA, Raleigh, NC, Englewood, CO.Team Overview: Join the Corporate Finance IT EPM Team, which...Full timeSecond jobLive inWork at officeWorldwideFlexible hours2 days per week$120k - $145k
...teams and contribute to the design, development, and characterization of new excipient systems and the improvement of existing ones.Lead the design and synthesis of chemical systems, including polymers, small molecules, and hybrid materials for pharmaceutical applicationsApply...Temporary workImmediate start$243k - $297k
Senior Medical Director - Global Medical Affairs Lead (GMAL), Dermatology Position SummarySun Pharma is seeking an experienced and strategic medical leader to support the continued expansion of its Global Medical Affairs organization within Dermatology. This contract position...Contract workFlexible hours- ...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 employmentWork experience placement
$120k - $202.5k
Who we are looking forAn experienced Artificial Intelligence Compliance & Automation Lead who will play a critical role in modernizing and scaling the firm's Cyber Application Compliance Program through the strategic use of artificial intelligence, machine learning, automation...Full timeTemporary workFlexible hours- ...Summit Therapeutics Inc. is seeking an Associate Director, Risk Based Quality Management Lead to drive RBQM across clinical studies, partnering with operations, data management, medical monitoring and CROs. You will implement and maintain risk management, centralized...
Summit-Therapeutics
Princeton, NJ1 day ago $17.69 - $22.28 per hour
$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 be a vital link in ensuring exceptional service...Hourly payWork experience placementWork at officeWorldwideRelocation packageFlexible hoursShift workRicoh Americas Corporation
Princeton, NJ2 days ago$20 - $28 per hour
...Lead TechnicianAre you experienced in carpet cleaning or water restoration (1–3 years)? Do you take pride in 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...Work from homeIICRC
Princeton Junction, NJ2 days ago$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 wageContract workPart timeShift workNight shiftWeekend workDay shiftAfternoon shiftEarly shift$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 payTemporary workFor contractorsWork experience placementLocal areaImmediate startMonday to FridayFlexible hoursShift work- ...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 timeWork at officeFlexible hoursShift workNight shift
- ...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 employmentWork experience placementWork at officeVisa sponsorship
Dr Reddy's Laboratories Limited
Princeton, NJ1 day ago - A leading healthcare organization is seeking a Senior Patient Safety and GxP Document Oversight Manager in Plainsboro Township, NJ. This role involves overseeing GxP documentation, ensuring compliance, and collaborating across departments. The ideal candidate will hold...
$15.92 - $18.89 per hour
Zone Lead (Full-Time) Pay: $15.92 - $18.89/hr Job Summary The Zone Lead (ZL) reports to the Assistant Store Manager and supports merchandising in designated zones, maintaining an active selling culture by ensuring all visual aspects are set and upheld to documented company...Full timeTemporary workPart timeSeasonal workFlexible hoursShift workNight shift- Spiro is seeking a Hybrid Convention Coordinator in Plainsboro, NJ to support a pharmaceutical client. The role involves budget oversight, show planning, and cross-functional collaboration across brand teams and sales/marketing. Expect interaction with regulatory/compliance...
$109.25k - $149.5k
...possible and making headway to innovate new treatment pathways to advance patient outcomes and set new standards of care.SUMMARYThe Lead Auditor, Quality Compliance will form part of the Corporate Audit team and will lead, coordinate and perform corporate audits of the...Full timeTemporary workWork experience placement- ...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, NJ12 days ago - A startup incubator is looking for a Quantum Computing Co-Founder / CPTO to lead your own startup while receiving mentorship from unicorn founders. You will be responsible for building and scaling your company, with options for salary or funding support. Ideal candidates...Remote job
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Lead - IDMC/Snowflake. Be the first to apply!
