Data Engineer
Core
Designing, building, and maintaining ETL workflows and data pipelines to populate on-premises enterprise data warehouses and cloud platforms.
Role type
Mid-level Data Engineer (ETL & Data Warehousing)
Builds
ETL workflows, data pipelines, and data marts for enterprise reporting
Domain
Enterprise Data Warehousing, Cloud Migration, On-premises Systems
Required skills
Oracle, SQL Server, Snowflake, PL/SQL, T-SQL, Informatica CDI-PC, Informatica IICS, Linux, Windows Server, Enterprise Data Warehouse (EDW) architecture, Data Pipeline automation (via careerplan.io/jobs/g16277cd-data-engineer-at-digital-technology-solutions)
Preferred skills
Change data capture (CDC), Stored procedures, Flat-file extraction, Salesforce integration
Technologies
Snowflake, Informatica, Oracle, SQL Server, Linux, Windows, Salesforce
Responsibilities
Build data pipelines and ETL workflows in accordance with team design standards; Develop Informatica CDI-PC ETL workflows to populate an on-premises EDW; Configure and script automated data pipelines including stored procedures and functions; Build ETL workflows moving data from on-premises sources to cloud platforms like Snowflake; Participate in a 24-hour on-call rotation to support the platform.
