Job Description
Key Responsibilities
n
- n
- Develop, maintain, and optimize SQL-based ETL processes, stored procedures, and data transformations across DB2 and SQL Server environmentsn
- Support and monitor ~225 scheduled jobs and ~40 job streams using IBM Workload Scheduler, ensuring timely execution and prompt failure resolutionn
- Build and maintain data pipelines using IBM DataStage and UNIX scripting for enterprise data integration workflowsn
- Support Oracle GoldenGate for real-time data replication and change data capture (CDC) across source and target systemsn
- Develop and maintain data integration workflows from source systems to analytics platforms, including validation and reconciliation logicn
- Provide operational support for DB2 and SQL Server environments encompassing ~160 schemas, ~20TB active storage, ~4,000 tables, and ~3,300 viewsn
- Monitor pipeline health proactively, detect anomalies, and resolve data quality and availability issues within defined SLAsn
- Support Dev/QA/Prod environment management including release coordination and production readiness validationn
- Assist with AWS stabilization activities for analytics data layers post migration from on-premises infrastructuren
- Track and manage all work through ServiceNow, ensuring accurate classification, status updates, and SLA compliancen
- Collaborate with Tableau and BusinessObjects developers to ensure data availability and pipeline reliability for reportingn
- Participate in L1/L2 triage for pipeline incidents, data quality failures, and integration issuesn
- Contribute to runbook documentation and standard operating procedures for supported pipelines and jobsn
nRequired Qualifications
n
- n
- Minimum Degree Required: Bachelor’s Degree in Engineering, Statistics, Mathematics, Computer Science, Data Science, Economics, or a related quantitative fieldn
- 2-5 years of experience in data engineering, ETL development, or data integration rolesn
- Robust SQL proficien
📌 Data Engineer (Bengaluru)
🏢 PwC
📍 Bengaluru