Informatica lead
Job Description :
Define the target ELT architecture using dbt on Snowflake, integrated with Azure services (ADF, ADLS, Synapse/Databricks, Key Vault, Azure DevOps/GitHub).
Translate legacy Informatica mappings, workflows, and sessions into modular dbt models (staging, core, mart layers).
Establish modeling standards (naming conventions, layer design, folder/package structure) for staging, integration, and mart layers.
Define and implement performance-optimized patterns in dbt and Snowflake (incremental models, clustering, partitioning logic, query tuning).
Lead the migration strategy, roadmap, and wave planning for converting Informatica jobs to dbt on Snowflake.
Analyze existing ETL logic, dependencies, and schedules in Informatica and design equivalent or improved logic in dbt.
Design a repeatable migration factory: templates, accelerators, mapping spreadsheets, and conversion playbooks for Informatica dbt.
Oversee conversion, unit testing, and parallel runs to validate that dbt models match legacy outputs (row counts, aggregates, business rules).
Lead hands-on development of dbt models, seeds, snapshots, tests, macros, and documentation.
Define and implement testing strategy using dbt tests (schema tests, data tests, custom tests) and integrate with broader data quality checks.
Set up and maintain dbt environments (dev/test/prod), profiles, and connections to Snowflake on Azure.
Introduce and enforce code quality practices.
Code reviews & pull requests
Modular, reusable models and packages
Minimum Skills Required:
8+ years total experience in Data Engineering / ETL / Data Warehousing.
3+ years hands-on experience with dbt (Core or Cloud) building production-grade pipelines.
Proven experience leading an Informatica dbt migration to Snowflake on Azure (or similar large-scale ETL modernization).
Strong Snowflake experience: designing and developing schemas, views, warehouses, and performance optimization.
Solid working knowledge of Azure data stack: Azure Data Factory, ADLS, Azure DevOps/GitHub.
Recommended Jobs
Senior Core Data Engineer - Chicago
Flow Traders is looking for a Senior Core Data Engineer to own the end-to-end lifecycle of our most fundamental data products, including our Security Master; our reconciled ETF Compositions; high-…
Intern - Operations Risk
Achieving our goals starts with supporting yours. Grow your career, access top-tier health and wellness benefits, build lasting connections with your team and our customers, and travel the world usin…
Tooling Product Engineer
Tooling Product Engineer - Send Resume Now The Full-time Tooling Proudct Engineer: •Leads and is responsible for key projects, processes, data and analysis to include tool/die design and preparation…
Certified Nursing Assistant C.N.A.
ATC Healthcare Services is looking for Certified Nursing Assistants (C.N.A.'s) for our long-term, intermediate, and skilled nursing facility client located in Joliet, IL. Pay rate is $23.00 an hour. W…
Advisor Development Program Client Associate
Advisor Development Program Client Associate Merrill Wealth Management is a leading provider of comprehensive wealth management and investment products and services for individuals, companie…
Customer Service Specialist
Customer Support Representatives JOB-10045944 Anticipated Start Date March 9, 2026 Location Florence, KY Type of Employment Direct Hire Employer Info Our clien…
Sassetti U 2026
SASSETTI UNIVERSITY 2026 – PROGRAM OPPORTUNITY Sassetti LLC is proud to announce Sassetti University 2026, our immersive program designed for students passionate about public accounting. PROGRA…
Technical Support Engineer
Technical Support Engineer - Rockford USA To provide DSE’s external customers with high quality, value adding technical support on the full range of the company’s electronic control modules for a …
Jr. Credit Analyst - To $75K - Chicago, IL - Job # 3645
Jr. Credit Analyst – To $75K – Chicago, IL – Job # 3645 Who We Are The Symicor Group is a boutique talent acquisition firm based in Schaumburg, IL & Rockport, TX. Our nationally unique value proposi…
Training Lead Technician
Please take this virtual tour to get a sneak peek of one of our Plasma Donation Centers. About BioLife Plasma Services Every day at BioLife, we feel good knowing that what we do helps i…