DE&A - Core - Big Data Engineering - ETL Orchestration DE&A - Core

Job Description

Design of complex ETL interfaces with agnostic tool set for various source/target types (SAP BODS preferred) Performance Tuning & Troubleshooting skills across all technologies used Strong in DB and SQLs with decent data modeling skills Ability to lead developers and QA and adhere to committed timelines Agile experience is preferred Ability to work with upstream, downstream, and reporting system stakeholders and convert business requirements into technical requirements (JIRA stories) 10 years of experience in: - ETL tools - Repository maintenance - Migration of jobs/workflows/dataflows - Job monitoring, break fix, user maintenance - CDC (Change Data Capture) - Oracle Golden Gate - Working with different sources/targets (Oracle, SAP, Files as source; SQL Server, file uploads as targets) Role Description : - Responsible for planning, developing, implementing, and managing data warehouse project deliverables - Design documents and high-level data mapping for ETL specifications - Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load - Provide support for integration testing, defect fixing, and deployment Proficient knowledge in: - Transformations like Query Push down, SQL Table Comparison, Pivot, Look up, etc. - Databases like Oracle, SQL Queries, SQL Server - Dimensional modeling, data mining, and data warehouse concepts Excellent analytical skills Knowledge to transfer data from Oracle, SQL Server tables, and Web Services either incrementally (Delta Load) or full load to the data warehouse on a periodic basis Troubleshooting existing ETL jobs and improving performance of existing jobs Creating and loading data into aggregate tables using transformations Ability to perform tasks individually and independently Design of complex ETL interfaces with agnostic tool set for various source/target types (SAP BODS preferred) Performance Tuning & Troubleshooting skills across all technologies used Strong in DB and SQLs with decent data modeling skills Ability to lead developers and QA and adhere to committed timelines Agile experience is preferred Ability to work with upstream, downstream, and reporting system stakeholders and convert business requirements into technical requirements (JIRA stories) 10 years of experience in: - ETL tools - Repository maintenance - Migration of jobs/workflows/dataflows - Job monitoring, break fix, user maintenance - CDC (Change Data Capture) - Oracle Golden Gate - Working with different sources/targets (Oracle, SAP, Files as source; SQL Server, file uploads as targets) Role Description : - Responsible for planning, developing, implementing, and managing data warehouse project deliverables - Design documents and high-level data mapping for ETL specifications - Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load - Provide support for integration testing, defect fixing, and deployment Proficient knowledge in: - Transformations like Query Push down, SQL Table Comparison, Pivot, Look up, etc. - Databases like Oracle, SQL Queries, SQL Server - Dimensional modeling, data mining, and data warehouse concepts Excellent analytical skills Knowledge to transfer data from Oracle, SQL Server tables, and Web Services either incrementally (Delta Load) or full load to the data warehouse on a periodic basis Troubleshooting existing ETL jobs and improving performance of existing jobs Creating and loading data into aggregate tables using transformations Ability to perform tasks individually and independently