ETL Tester (Location- Oman, Middle East)

Tech Mahindra; Oman; On-site; OMR 6,000 - 10,000; Full time

Job summary

Tech Mahindra in Oman is seeking an ETL Tester with 4+ years to validate data pipelines, ensure data integrity, and verify end-to-end flow from source systems to our data warehouse and data lake. The ideal candidate will master Teradata SQL and Informatica PowerCenter, with hands-on experience in Hadoop (Hive), Python, and telecom data testing.

Based in Oman, relocation is required; you will collaborate with ETL developers, data architects, and business analysts to deliver reliable data

Qualifications

• 4+ years of ETL testing experience in data warehousing environments.
• Strong Teradata SQL skills for data validation and performance testing.
• Hands-on Informatica PowerCenter experience and big data testing.
• Strong analytical and communication skills in Telecom data contexts.

Responsibilities

• Design and execute test plans and scripts for ETL pipelines.
• Validate data migration and end-to-end data flows.
• Collaborate with ETL developers and data architects to resolve issues.
• Automate repetitive testing tasks with Python where possible.

Skills

ETL Testing

Teradata SQL

Informatica PowerCenter

Hadoop/Hive

Python scripting

Telecom data

Agile/Scrum

Jira/ALM

Tools

Informatica PowerCenter

Teradata

Hadoop

Hive

Job description

Job Details

• Role: ETL Tester
• Experience: 4-7 Years
• Job Base Location: Oman(Middle East)
• Work Mode- Work from Office(Client Location-Oman)
• Band - U3
  

Job Description: ETL Tester Position OverviewWe are seeking a skilled and analytical Senior ETL Tester with 4+ years of experience to join our data engineering and analytics team. In this role, you will be responsible for validating complex data pipelines, ensuring data integrity, and verifying end-to-end data flow from various source systems to our enterprise data warehouse and data lake.The ideal candidate will have deep expertise in Telecom data structures, strong proficiency in Teradata SQL and Informatica PowerCenter, and hands-on experience handling big data environments using Hadoop and Python, NIFI, HIVE etc.. Mandatory Requirement: This position is based in Oman. Candidates must be fully willing to relocate to Oman.

Key Responsibilities

• Data Validation & Quality Assurance: Design, develop, and execute comprehensive test plans, test cases, and test scripts for complex ETL processes using Informatica PowerCenter.
• Database Testing: Write advanced, highly optimized SQL queries in Teradata to perform source-to-target data mapping validation, data integrity checks, and performance testing.
• Big Data Testing: Validate data ingestion and processing within Hadoop ecosystems (Hive, HDFS, or Spark), ensuring seamless data flow between traditional data warehouses and big data platforms.
• Automation & Scripting: Leverage Python to automate repetitive testing tasks, build data reconciliation scripts, and streamline the QA regression suite.
• Telecom Domain Analysis: Apply deep knowledge of telecom data (e.g., CDRs, billing records, network performance data, CRM, provisioning) to analyze business requirements and identify critical data anomalies.
• Defect Management & Collaboration: Track, log, and manage defects using tools like Jira or ALM. Work closely with ETL Developers, Data Architects, and Business Analysts to resolve data discrepancies and performance bottlenecks.
• Data Migration & Integration Testing: Verify complex transformations, aggregations, and business logic implementation across multiple data layers.

Technical Skillset

• ETL Tools: Strong hands-on experience testing pipelines built with Informatica PowerCenter (understanding workflows, mappings, and transformations).
• Databases & SQL: Expert-level knowledge of Teradata SQL (stored procedures, macros, joins, indexes, and analytical functions).
• Big Data Ecosystem: Practical exposure to Hadoop environments (querying via Hive/Impala, navigating HDFS).
• Programming/Scripting: Proficiency in Python for automated data validation and file processing.
• Methodologies: Strong understanding of Data Warehousing concepts (Star/Snowflake schemas, SCD Type 1/Type 2, Fact and Dimension tables).

Soft Skills & Tools

• Experience with Agile/Scrum methodologies.
• Proficiency with test management and defect tracking tools (Jira, HP ALM, Azure DevOps).
• Excellent analytical, problem-solving, and communication skills to bridge the gap between technical teams and business requirements.

Preferred Qualifications (Nice to have)

• Experience with CI/CD pipelines (Jenkins, Git) for automated testing.
• Exposure to cloud data platforms (e.g., Snowflake, AWS, or Azure) is a plus.
• ISTQB or equivalent software testing certification.