ETL Operations Engineer: Data Warehouse Support & SLA

iSystems Ltd; Islamabad; On-site; PKR 1,200,000 - 2,400,000; Full time

Job summary

iSystems Ltd. seeks an ETL Operations Engineer to monitor and support enterprise data warehouse environments, ensuring ETL job execution, database performance, and SLA adherence. The role covers Teradata administration, PowerCenter workflow monitoring, and backup operations.

The candidate should have a CS/IT/SE degree, knowledge of data warehousing and ETL processes, and experience with SJLM scheduling. Willingness to work rotating shifts and weekends is required.

Qualifications

• Bachelor's degree as specified in the Requirements.
• Knowledge of data warehousing and ETL processes.
• Basic Teradata knowledge (Teradata DB, Viewpoint) and SQL.
• Familiarity with Informatica PowerCenter workflow monitoring and troubleshooting.
• Understanding of job scheduling tools, preferably SJLM.
• Know how NetBackup/DSA backup and recovery monitoring works.
• Familiarity with ITIL processes, incident management, and ticketing systems.
• Strong analytical, troubleshooting, communication, and documentation skills.
• Ability to work in rotational shifts and meet SLAs.
• Exposure to telecom data environments and large-scale ETL ecosystems is an advantage.

Responsibilities

• Monitor and support enterprise data warehouse environments and ETL job execution.
• Perform Teradata user administration and space management; monitor performance.
• Troubleshoot Informatica PowerCenter workflows and escalation of issues.
• Oversee SJLM scheduled jobs and ensure successful completion.
• Monitor NetBackup/DSA backup operations and report failures.
• Review Teradata Viewpoint dashboards and system availability alerts.
• Investigate production incidents and operational alerts.
• Maintain incident tickets and shift handover documentation.
• Follow ITIL processes, escalation, and SLA requirements.
• Provide rotational shift support including weekends and on-call duties.

Skills

Analytical thinking

Troubleshooting

Communication

Documentation

Education

Bachelor's degree in Computer Science, Information Technology, Software Engineering, or related field

Tools

Informatica PowerCenter

SJLM

Teradata Viewpoint

NetBackup/DSA

Job description

iSystems Ltd. seeks an ETL Operations Engineer to monitor and support enterprise data warehouse environments, ensuring ETL job execution, database performance, and SLA adherence. The role covers Teradata administration, PowerCenter workflow monitoring, and backup operations.

The candidate should have a CS/IT/SE degree, knowledge of data warehousing and ETL processes, and experience with SJLM scheduling. Willingness to work rotating shifts and weekends is required.