Data Engineer

Posted 28d ago

The employer’s full description could not be read from their board. This is a summary of the posting — follow the apply link for the original.

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

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

Skills