Data Warehouse & Integration Engineer

Warner Music Group; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Benefits offered by this job

Flexible working hours

Career development opportunities

Job summary

Warner Music Group is looking for a Data Warehouse & Integration Engineer to join their Business Intelligence team in Bengaluru. The role involves managing data accuracy and reconciliation, monitoring ETL processes, and providing technical guidance within the team.

Your work will ensure seamless reporting and support a diverse user base amidst migration to new systems. A background in data warehousing and strong Oracle PL/SQL skills are essential for this mission-critical position.

Qualifications

• 3 to 5+ years of experience in Data Warehousing, Data Integration, or Data Operations.
• Strong expertise in Oracle database development and PL/SQL.
• Familiarity with Pentaho and open-source pipeline tools.

Responsibilities

• Design and maintain data quality checks for SAP data.
• Manage backend database architecture for non-finance users.
• Monitor ETL processes to ensure stable data delivery.

Skills

Data Warehousing

Data Integration

Oracle PL/SQL

ETL Processes

Linux Environments

Education

Bachelor's degree in Computer Science or equivalent

Tools

Pentaho

Snowflake

AppWorx

Job description

At Warner Music Group, We’re a Global Collective Of Music Makers And Music Lovers, Tech Innovators And Inspired Entrepreneurs, Game-changing Creatives And Passionate Team Members. Here, We Turn Dreams Into Stardom And Audiences Into Fans. We Are Guided By Three Core Values That Underpin Everything We Do Across All Our Diverse Businesses.

• Curiosity: We do our best work when we’re immersing ourselves in culture and breaking through barriers. Curiosity is the driving force behind creativity and ingenuity. It fuels innovation, and innovation is the key to our future.
• Collaboration: Making music and bringing it to the world is all about the power of originality amplified by teamwork. A great idea, like a great song, travels globally. We ignite passions and build connections across our diverse community of artists, songwriters, partners, and fans.
• Commitment: We pursue excellence for our team and our talent. Everything in music starts with a leap into the unknown, and we’re committed to keeping the faith, acting with integrity, and delivering on our promises.

Warner Music Group (WMG) is a global music entertainment company with a rich history and a diverse roster of artists, such as Ed Sheeran, Dua Lipa, Diljit Dosanjh, Armaan Malik, Darshan Raval, and Ayushmann Khurrana. We are committed to innovation and leveraging technology to enhance the music experience for our artists and fans.

WMG is home to a wide range of artists, musicians, and songwriters that fuel our success. That is why we are committed to creating a work environment that actively values, appreciates, and respects everyone. We encourage applications from people with a wide variety of backgrounds and experiences.

We are seeking an independent, highly resilient Data Warehouse & Integration Engineer to join our Business Intelligence team. While corporate systems migrate toward SAP for core finance, our platform remains the vital engine for business continuity, serving a large, critical community of non-finance users who rely on us for accessible, transparent sales revenue data.

We ingest data from SAP and legacy systems, manage complex suspense queues, but drive toward 100% data accuracy and reconciliation—ensuring our users have a seamless, dependable, and highly accurate reporting layer. If you love deep database forensics, complex PL/SQL logic, and building data pipelines that ensure business continuity amidst major system transitions, this role is for you.

In addition to hands‑on engineering, you will serve as a technical anchor for the team—guiding other team members, promoting engineering best practices, and ensuring a high standard of code quality and data consistency.

Your Role

• Willingness to work in timezone overlapping India, Europe, and the US (1 PM to 10 PM IST)
• 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

Here You’ll Get To

• Data Quality, Reconciliation & Suspense Management: 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.
• Business Continuity Support: 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.
• Data Pipeline Management: Monitor, optimize, and troubleshoot existing ETL processes built in Pentaho, ensuring stable data delivery from Oracle to our Snowflake target environment.
• ETL Migration Project: 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).
• Database Development: Write, refine, and optimize advanced Oracle PL/SQL packages, stored procedures, and views required to process complex revenue data and handle data remediation.
• Production Support & Scheduling: Monitor daily batch jobs and schedules using AppWorx in a Linux environment, taking swift ownership of resolving daily load failures.
• BI Layer Integrity: Ensure the underlying data structures feeding SAP BusinessObjects are performing optimally and perfectly reconciled against business rules.
• Technical Guidance & Quality Advocacy: 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.

About You

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

We’d Love It If You Also Had

• Understanding of SAP data structures, financial data models, or extraction methods
• Experience with open‑source data integration tools (e.g., Apache Hop, Airbyte, dbt Core)
• Linux shell scripting (Bash)