Data Engineer (Informatica / Snowflake)
Employment Type: Contract (12+ months)
Location: Texas (Telework)
**MUST RESIDE IN TEXAS
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.
Qualifications/Requirements
- 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
Responsibilities
- 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
Genius Road, LLC is proud to be a Certified Women's Business Enterprise, an Equal Opportunity Employer, and values diversity. All employment decisions are made on the basis of qualifications, merit, and business need.
Never miss an opportunity! Create an alert based on the job you applied for.
