Roles and Responsibilities

• Responsible for Planning, Developing, Implementing and Managing Data Warehouse Project Deliverables, Design Documents and High-Level Data Mapping for ETL Specifications
• Design of complex ETL interfaces with agnostic tool set for various source/target types
• SAP BODS experience is strongly preferred.
• Performance Tuning & Troubleshooting skills across all technologies used
• Strong in DB and SQLs with decent data modeling skills
• Ability to lead the developers and QA and adhere to timelines committed.
• Ability to work with both upstream, downstream and reporting system stakeholders and convert the business requirements into technical requirements / JIRA stories.
• Should be able to create and load data into Aggregate Tables using transformations.
• Should be able to perform tasks individually and independently
• Provide support for integration testing, defect fixing and deployment. Proficient knowledge in transformations like Query, Push down, SQL, Table Comparison, Pivot, Look up etc.
• Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load.

 

Qualifications

• 8+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break fix, user maintenance, CDC, Oracle Golden Gate, worked with different sources targets to load the data (Oracle, SAP, Files as source; SQL Server, file uploads etc. as targets).
• Proficient Knowledge in Databases like Oracle (SQL Queries), SQL Server
• Proficient Knowledge in Dimensional modelling, Data Mining and Data warehouse concepts
• Knowledge to transfer data from Oracle, SQL Server tables and Web Services either Incrementally (Delta Load) or full Load to the Data warehouse on periodic basis.
• Knowledge in Trouble shooting existing ETL jobs and improve performance of the existing jobs.
• Agile experience is preferred.