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

• 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