Data Engineer (Informatica / Snowflake)

Genius Road, LLC

Dallas, TX, United States

15 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

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

+12 more

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

Job 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

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