We are seeking ETL Operations Engineers to join our team, responsible for monitoring and supporting enterprise data warehouse environments. The role focuses on ensuring the successful execution of ETL jobs, maintaining database performance, managing backup operations, and adhering to operational service level agreements (SLAs). The ideal candidate will play a critical role in maintaining system availability and reliability through proactive monitoring and incident management.
Key Responsibilities
- Perform Teradata user administration, manage space allocation, and conduct routine database health checks.
- Monitor Informatica PowerCenter workflows, troubleshoot job failures, and escalate unresolved issues to the appropriate teams.
- Oversee SJLM scheduled jobs to ensure timely and successful completion.
- Monitor NetBackup and DSA backup operations, promptly reporting any failures or irregularities.
- Utilize Teradata Viewpoint dashboards to track system performance, availability alerts, and overall health metrics.
- Analyze database statistics to detect and address performance anomalies.
- Investigate production incidents, job failures, and operational alerts to minimize downtime.
- Maintain detailed incident tickets, operational logs, and shift handover documentation to ensure smooth transitions.
- Follow ITIL-based processes, including escalation procedures and compliance with SLA requirements.
- Provide rotational shift support, which includes weekend coverage and on-call duties as needed.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
- Solid understanding of data warehousing concepts, ETL processes, and production support operations.
- Basic proficiency with Teradata Database, Teradata Viewpoint, and SQL querying.
- Experience with monitoring and troubleshooting Informatica PowerCenter workflows.
- Familiarity with job scheduling tools, preferably SJLM.
- Basic knowledge of backup and recovery monitoring using NetBackup and DSA.
- Understanding of ITIL frameworks, incident management, and ticketing systems.
- Strong analytical and troubleshooting abilities, with excellent communication and documentation skills.
- Willingness and ability to work in rotational shifts while consistently meeting operational SLAs.
Preferred Qualifications and Benefits
- Exposure to telecom data environments and experience working within large-scale ETL ecosystems is considered an advantage.
This position offers the opportunity to work in a dynamic, fast-paced environment where attention to detail and proactive problem-solving are highly valued. Candidates will gain experience supporting critical enterprise data infrastructure and contribute to maintaining high availability and performance standards.