> Markdown version of [/jobs/ext/2172248-data-engineer-informatica-snowflake](https://www.wearedevelopers.com/jobs/ext/2172248-data-engineer-informatica-snowflake). 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). --- # Data Engineer (Informatica / Snowflake) - **Company:** Genius Road, LLC - **Location:** Dallas, TX, United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Databases, Data Integration, Extract Transform Load (ETL), Data Sharing, Data Systems, Data Warehousing, Relational Databases, Dimensional Modeling, Data Flow Control, Github, Python (Programming Language), Oracle Databases, Oracle (Applications), Performance Tuning, Software Deployment, Freeform SQL, Data Ingestion, Snowflake, Informatica Cloud, Change Data Capture, Api Design, Restful APIs, Software Version Control, Data Pipelines - **Published:** August 21, 2026 - **Apply:** https://www.dice.com/job-detail/76207396-87a7-4a88-ad73-874e5f652c03 ## About the Role * 4+ years of hands-on experience with Informatica Cloud Data Integration (IICS) * 5+ years of experience developing advanced SQL queries and performing data interrogation * Experience translating business requirements and design specifications into data mappings and data pipeline solutions * Experience with relational database design and Oracle RDBMS * Experience with Snowflake, including database creation, management, optimization, and Snowflake SQL * 2+ years of experience with Informatica Mass Ingestion * 3+ years of experience with static mapping and Change Data Capture (CDC) for bulk data movement * 3+ years of experience with data warehouse architecture and dimensional modeling, including Facts and Dimensions * Experience developing ETL/ELT mappings and workflows using Informatica Cloud * Experience working with Oracle as a data source and Snowflake as a target platform * Experience with data pipeline development, troubleshooting, and production deployments * Familiarity with GitHub or equivalent version control systems * Ability to create technical documentation, data-flow diagrams, and ERDs * Experience working with state agencies and applicable security protocols and processes * Experience with Snowpark and Python is preferred * Experience with Snowflake Data Sharing is preferred * Experience developing RESTful API-based data integrations is preferred * Knowledge of Informatica Pushdown Optimization is preferred * Experience supporting Data Scientist or analytical workloads within Snowflake is preferred ## Description We are seeking a Data Engineer with strong hands-on experience with Informatica Cloud (IICS), Oracle, and Snowflake to support the development of enterprise data integration and data pipeline solutions. This role will focus on building and maintaining data ingestion pipelines from Oracle transactional databases into Snowflake, developing ETL/ELT workflows, supporting data warehouse modeling, and implementing bulk data movement and Change Data Capture (CDC) processes., * Develop and maintain data integration pipelines using Informatica Cloud Data Integration * Build mass ingestion pipelines to move data from Oracle transactional databases into Snowflake * Develop source-to-target mappings, ETL/ELT workflows, and data integration processes * Implement one-time data loads and Change Data Capture processes for bulk data movement * Design and develop Snowflake databases and data warehouse structures * Develop dimensional data models to support reporting, analytics, and performance requirements * Support API-based data ingestion and Snowflake Data Sharing initiatives * Analyze business and technical requirements and translate them into effective data solutions * Troubleshoot data pipeline issues and assist with performance optimization * Review development work, provide technical feedback, and support delivery deadlines * Promote code and data integration solutions through development and production environments * Create and maintain technical documentation, data-flow diagrams, and ERDs * Work collaboratively with technical teams and stakeholders to support ongoing data integration initiatives ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)