Description

You will design and manage complex ETL interfaces and data warehouse project deliverables.

Responsibilities

• Design high-level data mapping, ETL specifications, and technical documentation.
• Develop transformations for data cleansing, standardization, and loading into aggregate tables.
• Manage repository maintenance, job migrations, workflows, and dataflow monitoring.
• Lead developers and QA teams to meet committed timelines and convert business requirements into technical JIRA stories.
• Troubleshoot existing ETL jobs and implement performance tuning across all technologies.

Required Skills

• 10+ years of experience in ETL tool development and job monitoring.
• Proficiency in SAP BODS for designing complex interfaces.
• Strong expertise in SQL, Oracle, and SQL Server.
• Hands-on experience with Change Data Capture (CDC) and Oracle GoldenGate.
• Deep understanding of Dimensional Data Modeling and Data Warehouse concepts.
• Experience loading data from Oracle, SQL Server, and Web Services using incremental, delta, or full loads.
• Ability to manage data transfers from various sources to targets like SQL Server and files.
• Proficiency in ETL transformations including Query Pushdown, SQL Table Comparison, Pivot, and Lookup.
• Strong analytical skills for data mining and defect fixing.
• Dimensional Data Modeling and Ms Excel.

Preferred Skills

• Agile development experience.

Key Skills

Education

Any Gradute