DataMart Platform Engineer Senior

Overview

Senior DataMart Platform Engineer providing technical and operational leadership for business-critical DataMart services supporting reporting, analytics, downstream interfaces and client processing.

What you'll do

• Lead production and non-production support for DataMart environments, monitoring platform health, data loads, interfaces and reporting availability.
• Oversee end-to-end batch processing, validating source extracts, ingestion, transformation, dependencies and completion within required service windows.
• Lead technical recovery during critical incidents across application, database, scheduling, file-transfer, batch and reporting layers.
• Perform advanced Oracle troubleshooting, including SQL, PL/SQL, execution plans, contention, data-quality issues and batch-processing bottlenecks.
• Drive root-cause analysis for recurring or high-impact incidents and implement sustainable corrective actions that improve platform reliability.
• Support SAP BusinessObjects and Web Intelligence services, resolving reporting availability, connectivity, authentication, scheduling and DataMart-related failures.
• Lead operational readiness for releases, patches, schema changes, environment refreshes, migrations, cutovers, rollback planning and post-production stabilization.
• Develop and enhance scripts, monitoring and operational tooling to improve detection, validation, recovery and reduce manual intervention.
• Support disaster-recovery planning and exercises, maintain recovery procedures, dependency information and validation checklists across platform components.
• Provide technical direction and mentoring to support engineers while coordinating effectively with applications, databases, infrastructure and client-support teams.

What you'll need

• 7–10 years of experience in DataMart, data warehouse, application, database or enterprise production support.
• 3+ years of experience in a senior or lead technical capacity supporting business-critical enterprise platforms.
• Strong Oracle Database troubleshooting experience, including performance analysis, execution plans, contention and high-volume processing issues.
• Advanced SQL and PL/SQL skills, including troubleshooting packages, procedures, data loads and data-quality issues.
• Strong Linux/Unix experience with shell scripting or comparable automation capabilities.
• Demonstrated experience supporting enterprise batch processing, workload scheduling, ETL workflows and managed file-transfer processes.
• Strong incident management, problem management and root-cause analysis skills across database, application and infrastructure layers.

Nice to have

• Experience supporting SAP BusinessObjects and Web Intelligence in enterprise production environments.
• Experience with CI/CD practices, database deployment automation, monitoring, alerting and service-management platforms.
• Experience with Oracle database maintenance, capacity management, schema changes, imports, exports, upgrades and environment refreshes.
• Experience improving production reliability through automation, proactive monitoring and reusable diagnostic tooling.
• Knowledge of disaster recovery, service resilience, release management and production-readiness practices.
• Strong communication and technical leadership skills, including coordinating distributed teams during complex production incidents.

Details

• Location: Pune, India.