Etl Administrator - Immediate or not working or 15 days

Kairos Technologies; Hyderabad; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Kairos Technologies is seeking an ETL Admin to ensure the stability and performance of enterprise ETL platforms. You will manage incident response, data reconciliation, and platform maintenance across Matillion, Perspectium, HVR, and DaaS.

The role requires 3+ years in production support with strong SQL skills, experience in data quality validation, and cloud familiarity (Azure/AWS). Flexibility for shifts and a readiness to collaborate with cross-functional teams are essential.

Qualifications

• 3+ years of experience working with ETL platforms such as Matillion, Perspectium, HVR, and similar.
• Strong SQL proficiency and data integration expertise.
• Experience in incident management and production support across ETL pipelines.
• Hands-on data reconciliation and data quality validation.
• Experience with job scheduling and ETL orchestration.

Responsibilities

• Respond to incidents and provide 24/7 on-call support.
• Manage ETL deployments across development, test, and production.
• Monitor data pipelines and troubleshoot failures in real time.
• Perform data reconciliation and quality checks post-deployments.
• Document RCA, corrective actions, and preventive measures.

Skills

SQL

Data reconciliation

Data quality validation

Job scheduling

ETL orchestration

Cloud platforms

PostgreSQL

SQL Server

Incident handling

Tools

Matillion

Perspectium

HVR

DaaS

Job description

Below are the mandatory screening criteria for ETL Admin and Power BI Admin profiles:

Minimum 3 years of L2 Production Support experience.

Hands-on experience handling P1 and P2 incidents/tickets.

Must be flexible to work in shifts.

Job Summary

The ETL Administrator (L2) is responsible for ensuring the operational stability, availability, and performance of enterprise ETL platforms, including Matillion, Perspectium, HVR, and DaaS.

The role involves incident response, troubleshooting, deployments, platform maintenance, upgrades, certificate rotations, data reconciliation, monitoring, and problem management with Root Cause Analysis (RCA).

The administrator will support high availability through 24/7 production support, proactive monitoring, and close collaboration with development, infrastructure, and vendor support teams.

Key Responsibilities

1. Incident Management & Production Support

• Respond to and resolve incidents across Matillion, Perspectium, HVR, and DaaS within defined SLA requirements.
• Perform triage and troubleshooting for data integration and ETL job failures.
• Monitor ETL jobs, identify failures, and take appropriate corrective actions.
• Provide 24/7 on-call support as part of the incident response rotation.
• Handle critical production incidents under pressure and ensure timely resolution.

2. Service Requests & Platform Administration

• Execute service requests related to:
  • Connection configurations
  • ETL job scheduling
  • User access management
  • Credentials and configuration changes
• Maintain ETL platform configurations and operational settings.
• Manage job scheduling, execution monitoring, and performance optimization.

3. Data Reconciliation & Data Quality

• Perform data reconciliation to validate ETL job accuracy and completeness.
• Conduct data quality validation following deployments and production changes.
• Investigate and resolve data discrepancies and data quality issues.
• Ensure data pipelines deliver accurate and complete data across source and target systems.

4. ETL Deployments

• Execute ETL job deployments across:
  • Development
  • Test
  • Production
• Validate deployments through data quality checks and reconciliation testing.
• Coordinate deployment schedules with development and infrastructure teams.
• Execute rollback procedures when required.

5. Platform Maintenance & Upgrades

• Perform platform upgrades and maintenance activities for:
  • Matillion
  • Perspectium
  • HVR
  • DaaS
• Execute certificate rotations and credential updates.
• Ensure platform configurations remain compliant with security and operational standards.
• Support security and compliance-related activities.

6. Monitoring & Performance Management

• Proactively monitor ETL platforms, jobs, and data pipelines.
• Analyze logs and alerts to identify potential issues.
• Troubleshoot performance-related problems and optimize ETL job execution.
• Identify recurring failures and implement preventive measures.

7. Problem Management & Root Cause Analysis

• Conduct Root Cause Analysis (RCA) for recurring incidents and data quality issues.
• Document problem tickets with:
  • Technical findings
  • Root cause
  • Corrective actions
  • Resolution steps
• Identify trends and recommend permanent solutions to recurring issues.

8. Documentation & Process Improvement

• Maintain accurate platform configurations, runbooks, and technical documentation.
• Create and update operational procedures and troubleshooting guides.
• Identify opportunities for automation and process improvement.
• Work closely with development, infrastructure, and vendor teams to improve platform reliability.

Required Qualifications

Technical Skills

• 3+ years of experience working with ETL platforms such as:
  • Matillion
  • Perspectium
  • HVR
  • Similar ETL/Data Integration platforms
• Strong understanding of:
  • ETL workflows
  • Data integration patterns
  • Data pipelines
  • Data movement and transformation
• Strong proficiency in SQL.
• Hands-on experience with data reconciliation and data quality validation.
• Experience with:
  • Job scheduling
  • ETL orchestration
  • Error handling
  • Job monitoring
• Familiarity with cloud platforms such as:
  • Microsoft Azure
  • AWS
• Experience working with databases such as:
  • PostgreSQL
  • SQL Server