ETL Operations Engineer

We are seeking experienced ETL Operations Engineers to join our team and play a critical role in monitoring and supporting enterprise data warehouse environments. The primary focus of this role is to ensure the successful execution of ETL jobs, maintain database performance, oversee backup operations, and comply with operational service level agreements (SLAs). The ideal candidate will be proactive in identifying and resolving issues, maintaining system availability, and supporting continuous data operations within a dynamic, fast-paced environment.

Key Responsibilities

- Perform Teradata user administration, manage database space, and conduct routine monitoring to ensure optimal database health.
- Monitor Informatica PowerCenter workflows, promptly troubleshoot job failures, and escalate unresolved issues to the appropriate teams.
- Oversee SJLM scheduled jobs, ensuring all jobs complete successfully and on time.
- Monitor NetBackup and DSA backup operations, identifying and reporting any backup failures.
- Utilize Teradata Viewpoint dashboards to monitor system performance, availability alerts, and overall health of the data warehouse environment.
- Analyze database statistics to detect performance anomalies and potential bottlenecks.
- Investigate production incidents, job failures, and operational alerts to minimize downtime and impact on business operations.
- Maintain detailed incident tickets, operational logs, and shift handover documentation to ensure smooth transitions between shifts.
- Adhere to ITIL-based processes, including incident management, escalation procedures, and compliance with SLAs.
- Provide rotational shift support, including weekends and on-call duties, to maintain 24/7 operational coverage.

Required Qualifications

- Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related technical field.
- Solid understanding of data warehousing concepts, ETL processes, and production support operations.
- Basic proficiency with Teradata Database, Teradata Viewpoint, and SQL query language.
- Experience monitoring and troubleshooting Informatica PowerCenter workflows.
- Familiarity with job scheduling tools, preferably SJLM, for managing ETL and batch jobs.
- Basic knowledge of backup and recovery processes using NetBackup and DSA.
- Working knowledge of ITIL frameworks, incident management, and ticketing systems.
- Strong analytical and troubleshooting skills, coupled with excellent communication and documentation abilities.
- Ability to work effectively in rotational shifts while meeting operational SLAs.

Preferred Qualifications and Benefits

- Exposure to telecom data environments and large-scale ETL ecosystems is highly advantageous.
- Candidates with experience in high-volume, complex data warehouse operations will be preferred.

This role offers the opportunity to work within a critical operational team supporting enterprise-level data infrastructure. Candidates should be prepared for a dynamic work environment requiring attention to detail, strong problem-solving skills, and a commitment to maintaining high availability and performance standards. Rotational shifts and on-call responsibilities are essential to ensure continuous operational support.