Logo for ICONMA

Sr./Lead Data Engineer – Snowflake & Informatica IDMC

ICONMA

Role overview

Qualifications

  • 8+ years in data engineering, ETL development, and enterprise data warehousing
  • Strong Snowflake expertise in SQL, data loading, security, performance tuning, scalability, and cost optimization
  • Strong IDMC development experience with CDI mappings, tasks, taskflows, parameters, deployment, and monitoring
  • Proficiency in Python and SQL, plus Git-based CI/CD using Jenkins, Azure DevOps, GitHub Actions, or similar tools

Responsibilities

  • Design, develop, test, deploy, and support scalable batch and near-real-time data pipelines using Snowflake and IDMC
  • Implement ETL/ELT solutions, dimensional models, and SCD Types 1 and 2 for enterprise DW
  • Develop efficient SQL and Python components, reusable frameworks, automation, and validation utilities
  • Build CI/CD pipelines for data code, IDMC assets, Snowflake objects, testing, and environment promotion

Key facts

Hard skills

Other skills

  • Communication
  • Troubleshooting (Problem Solving)
  • Leadership
  • Mentorship

About the company

ICONMA logo

ICONMA

Management Consulting

We provide Professional Staffing Services & Project-Based Solutions for a broad range of Fortune 500 organizations. ICONMA is a certified Woman-Owned staffing company and was founded in 2000. ICONMA’s corporate headquarters is in Troy, Michigan, and has 15+ locations worldwide. What makes ICONMA stand out in a fiercely competitive industry? *We provide integrated, full lifecycle services across a broad range of business and technical platforms. *No single company can duplicate our full range of staffing and permanent recruiting services nationwide. *Proven track record of attracting and retaining exceedingly skilled professional workers in a highly competitive market. SERVICES OFFERED Staff Augmentation (Contract, Contract to Hire, Direct Hire, Single Source) Data Analysis Project-Based Services & Solutions Hire Train Deploy Service Model Offshore Staff Augmentation Payroll Services AREAS OF EXPERTISE - Information Technology - Engineering - Business Professional - Accounting/Finance - Admin/Clerical/Call Center - Healthcare/Clinical/Scientific - Marketing/Creative mail linkedin@iconma.com Phone (888) 451-2519 Website http://www.iconma.com

Company details

Company typeLarge
IndustryManagement Consulting
Company size1001 - 5000

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Our Client, an IT Services and Consultant company, is looking for a Sr./Lead Data Engineer – Snowflake & Informatica IDMC for their Remote location.
 
Responsibilities:
  • Design, develop, test, deploy, and support scalable batch and near-real-time data pipelines using Snowflake and IDMC.
  • Implement ETL/ELT solutions, dimensional models, and SCD Types 1 and 2 for enterprise DW.
  • Develop efficient SQL and Python components, reusable frameworks, automation, and validation utilities.
  • Build CI/CD pipelines for data code, IDMC assets, Snowflake objects, testing, and environment promotion.
  • Optimize Snowflake performance, scalability, reliability, security, and cost; support AWS and/or Databricks workloads.
  • Implement data quality, reconciliation, lineage, monitoring, governance, and audit controls.
  • Troubleshoot production issues and partner with architecture, QA, DevOps, analytics, and business teams.
  • Lead design and code reviews, mentor engineers, and drive engineering standards and solution ownership.
 
Requirements:
  • 8+ years in data engineering, ETL development, and enterprise data warehousing.
  • Strong Snowflake expertise in SQL, data loading, security, performance tuning, scalability, and cost optimization.
  • Strong IDMC development experience with CDI mappings, tasks, taskflows, parameters, deployment, and monitoring.
  • Proficiency in Python and SQL, plus Git-based CI/CD using Jenkins, Azure DevOps, GitHub Actions, or similar tools.
  • Hands-on experience with AWS data services and/or Databricks/Spark, including data quality, governance, and production support.
  • Strong analytical, troubleshooting, communication, documentation, and stakeholder-management skills.
  • Preferred Qualifications
  • Bachelor’s degree in a relevant field or equivalent experience.
  • Healthcare data experience across claims, eligibility, provider, clinical, or pharmacy domains.
  • Exposure to Snowpark, PySpark, AWS Glue/S3/Lambda, streaming, or automated data testing.
  • Snowflake, Informatica, AWS, or Databricks certification is a plus
 
Why Should You Apply?

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Data Engineer Related jobs

California (USA)Data Engineer

Other jobs at ICONMA

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.