Data Warehouse, Integration Engineer

Warner Music Group

Data Warehouse & Integration Engineer at Warner Music Group responsible for data quality and architecture. Serving as a mentor while ensuring reliable data pipelines and business continuity in a hybrid team environment.

Posted 6/11/2026full-timeBangalore • 🇮🇳 IndiaMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ApacheCloudETLLinuxOraclePythonSQLSwift

About the role

Key responsibilities & impact

Design and maintain rigorous data quality and reconciliation checks to align our system with upstream SAP data. Independently manage suspense queues to catch, investigate, and remediate SAP data inconsistencies before they impact downstream users.
Maintain the backend database architecture and pipelines that support our large non-finance user base, ensuring 100% data accuracy and uptime for critical sales revenue reporting.
Monitor, optimize, and troubleshoot existing ETL processes built in Pentaho, ensuring stable data delivery from Oracle to our Snowflake target environment.
Actively participate in researching, testing, and executing a migration strategy to transition our data pipelines away from Pentaho to a low-to-no-cost open-source alternative (e.g., Apache Hop, Airbyte, or Python/SQL).
Write, refine, and optimize advanced Oracle PL/SQL packages, stored procedures, and views required to process complex revenue data and handle data remediation.
Monitor daily batch jobs and schedules using AppWorx in a Linux environment, taking swift ownership of resolving daily load failures.
Ensure the underlying data structures feeding SAP BusinessObjects are performing optimally and perfectly reconciled against business rules.
Act as a technical mentor for junior or peer team members. Establish and champion best practices for code design, documentation, and data validation, leading informal design reviews to ensure consistency across all work.

Requirements

What you’ll need

3 to 5+ years of experience in Data Warehousing, Data Integration, or Data Operations.
Strong expertise in Oracle database development, with proven experience writing PL/SQL to handle inconsistencies in source data.
Practical experience with Pentaho (Data Integration/PDI), with an appetite to help migrate legacy workflows to modern open-source pipeline tools.
Comfort navigating Linux environments and a solid understanding of cloud data warehousing (specifically Snowflake).
A strong background in data reconciliation, error handling, and managing suspense data. You take pride in chasing down data discrepancies to achieve 100% accuracy.
Familiarity with enterprise scheduling tools (experience with AppWorx is a major plus).
Highly independent, analytical, and adaptive. You look at a "black box" system failure as a puzzle to be solved rather than a roadblock.
Ability and desire to guide other developers, explain complex technical concepts clearly, and review work for quality, optimization, and adherence to standards.

Benefits

Comp & perks

A mission-critical role where your work directly safeguards business continuity and user trust
The autonomy to help select and implement a new, cost-effective ETL tooling stack
Opportunity to flex and grow your technical leadership skills, serving as a mentor and architectural guide without the administrative burden of people management

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

OraclePL/SQLETLdata reconciliationdata integrationdata operationsdata warehousingPentahoApache HopAirbyte

Soft Skills

analyticalindependentadaptivementorshipproblem-solvingcommunicationleadershipattention to detailcollaborationquality assurance