> Markdown version of [/jobs/ext/4795447-snowflake-informatica-data-engineer](https://www.wearedevelopers.com/jobs/ext/4795447-snowflake-informatica-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Snowflake & Informatica Data Engineer - **Company:** Stellar Professionals - **Location:** Denver, CO, United States (Remote available) - **Experience:** Expert - **Contract:** Contract - **Skills:** Query Performance, Data Analysis, Microsoft Azure, Cloud Computing, Code Review, Continuous Integration, Data Deduplication, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Profiling, Data Systems, DevOps, Meta-Data Management, Data Ingestion, Delivery Pipeline, Snowflake, Informatica Cloud, Infrastructure as Code (IaC), Git, Git Flow, Terraform, Software Version Control, Data Pipelines - **Published:** November 20, 2026 - **Apply:** https://www.dice.com/job-detail/f9449317-3467-4321-b001-0e12100fa156 ## About the Role * Snowflake ETL/ELT: Minimum 5 years of demonstrated experience building, orchestrating, and optimizing complex ETL/ELT pipelines and transformation logic natively within Snowflake. * Informatica CDGC: Minimum 1 year of hands-on experience using Informatica Cloud Data Governance and Catalog (CDGC) for metadata management, data profiling, cataloging, and automated quality validation. * Infrastructure as Code (IaC): Minimum 1 year of experience utilizing Terraform to provision, configure, and maintain cloud infrastructure. * DevOps & Version Control: Demonstrated proficiency implementing automated build, test, and release pipelines in Azure DevOps, paired with expert Git version control skills (branching strategies, PRs, code reviews). < data-path-to-node="18" dir="ltr">Preferred Qualifications * Prior experience working with public-sector, longitudinal education, or workforce data systems. * Experience with deterministic/probabilistic record linkage and entity resolution across disparate public datasets. * Familiarity with federal/state privacy regulations (FERPA, COPPA, cell suppression) and authoring structured test cases in Azure Test Plans. ## Description Seeking a Senior Data Engineer to design, build, and maintain automated ETL/ELT data pipelines using Snowflake and Informatica for a Statewide Longitudinal Data System (SLDS). Joining under a shared delivery model, this role executes structured knowledge transfer from an implementation partner, leads new agency data ingestions, enforces multi-tier data quality and privacy rules, and transitions into full production ownership of the analytics data foundation. < data-path-to-node="14" dir="ltr">Key Responsibilities * Data Ingestion & ETL/ELT Pipelines: Design, build, test, and deploy automated Informatica workflows and Snowflake SQL transformation pipelines to ingest and harmonize partner agency feeds into a common longitudinal data model. * Record Linkage & Analytics Layer: Execute internal identity-matching logic to link student and workforce records across agencies, maintain analytics-layer tables/views, and optimize Snowflake compute and query performance. * Data Quality & Privacy Governance: Implement L1 (structural), L2 (completeness/deduplication), and L3 (referential integrity) validation rules, layout-change detection, and cell-suppression standards compliant with FERPA, COPPA, and state statutes. * Production Operations & DevOps: Transition from shadowing/co-running to full operational ownership of scheduled feed runs, while managing code reviews, Azure Test Plans, and CI/CD releases in Azure DevOps.