> Markdown version of [/jobs/ext/2160497-remote-local-informatica-snowflake-developer](https://www.wearedevelopers.com/jobs/ext/2160497-remote-local-informatica-snowflake-developer). 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). --- # Remote/Local Informatica/Snowflake Developer - **Company:** innoSoul, Inc. - **Location:** Austin, TX, United States (Remote available) - **Experience:** Experienced - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Architectural Patterns, Cloud Database, Databases, Data Architecture, Data Integration, Extract Transform Load (ETL), Data Sharing, Data Warehousing, Relational Databases, Database Design, Database Models, Dimensional Modeling, Github, Python (Programming Language), Oracle Databases, Oracle (Applications), Oracle Warehouse Builder, Data Processing, Freeform SQL, Cloud Platform System, Data Ingestion, Snowflake, Informatica Cloud, Change Data Capture, Data Lakes, Restful APIs, Software Version Control, Data Pipelines - **Published:** August 21, 2026 - **Apply:** https://www.dice.com/job-detail/1cda46a2-ec6e-4e5f-a544-807fdebb2e3e ## About the Role 5+ Required Generating advanced SQL queries and using other data interrogation methods.. 6+ Required Experience with Informatica Products with at least 4 years direct experience with Informatica Cloud Data Integration. 5+ Required Reviewing, interpreting, and translation business r equirements and design specifications into data m appings, and data pipeline development using all major data integration patterns. 4+ Required Experience in relational database design concepts which including direct experience in Oracle RDBMS. 3+ Required Experience with Data Warehouse architectural patterns including modeling Facts and Dimensions. 3+ Required Experience with static mapping and Change Data Capture (CDC) for bulk data movement. 2+ Required Experience with Informatica Mass Ingestion. 2+ Required Experience using Snowflake (creating, managing, optimizing databases as well as time-travel and other technical advantages of cloud data warehousing). 1+ Helpful or preferred (Not Required) Any experience working with Snowpark, servicing the needs of Python programmers, or understanding Data Scientists requirements against Snowflake databases will make the candidate more successful., Development of ETL/ELT data mappings and workflows for data pipeline development with Informatica Cloud Data Integration. Practical experience using and building Informatica Mass Ingestion Pipelines. Demonstrated experience with Oracle Database as a Data Connector source. Expert with Snowflake as a Target database platform. Experience with the Snowflake platform and ecosystem. Knowledge of Snowflake data sharing and Snowpark is a plus. Knowledge of the advantages as well as previous experience working with Informatica push-down optimization Experience with Snowflake database creation, optimization, and architectural advantages. Practical experience with Snowflake SQL. Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems. Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures. Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply. Performs related work as assigned. Practical experience with one time data loads as well as Change Data Capture (CDC) for bulk data movement. Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a multiple release effort. Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required. Ability to promote code from development environments to production. Familiarity with GitHub or equivalent version control systems. Experience working with state agencies as well as security protocols and processes. ## Description Performs advanced (senior-level) Data Pipeline development work with Informatica Cloud (IICS) including data integration, source to target data modeling, Extract-Transaction-Load development, consuming Oracle data connections, RESTful API application-based data connections, targeting Snowflake data connections, designing Snowflake target data lake databases, data warehouse modeling with ELT. This candidate will be using Informatica Cloud to build mass ingestion pipelines or other EL from an Oracle transaction database(s) to our Snowflake Data Lake. Additional duties may include working within Snowflake to create other API based data ingestion routines and/or setting up Data Sharing of these accumulated data. Dimensional modeling of data may be required in our Data Warehouse to accomplish other objectives like data reporting and improved performance data handling. ## 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) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [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) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [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) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [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) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)