Note: The job is a remote job and is open to candidates in USA. Genius Road is seeking a Data Engineer to support enterprise data integration and data pipeline solutions. The role involves building and maintaining Oracle-to-Snowflake ingestion pipelines, developing ETL/ELT workflows, supporting data warehouse modeling, and implementing bulk data movement and Change Data Capture processes.
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
Skills
- 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
Company Overview