Description
Build and maintain data pipelines and ETL workflows for the Enterprise Data Warehousing team.
Responsibilities
- Develop technical specifications, programming, and testing for data engineering components.
- Create data pipelines and ETL workflows using change data capture (CDC) to move data to cloud providers.
- Implement automated data pipelines, stored procedures, functions, and ETL workflows through configuration and scripting.
- Follow architecture, design, and change control practices to ensure enterprise programming standards are met.
- Participate in a 24-hour on-call rotation to support the platform.
Required Skills
- 5+ years of experience in data engineering.
- Proficiency in PL/SQL, Python, and T-SQL.
- Experience with Oracle, EDB PostgreSQL, Snowflake, and SQL Server.
- Working knowledge of Windows Server and Linux OS.
- Strong analytical reasoning and critical thinking skills.
- Ability to automate repeatable processes.
- Experience with Informatica PowerCenter and StreamSets.
Preferred Skills
- Experience with near-realtime data pipelines and traditional EDW workflows.