ETL Testing Lead

Tanqeeb; Muscat; On-site; OMR 22,000 - 32,000; Full time

Job summary

Tanqeeb in Oman is seeking a Senior ETL Tester with 5+ years of experience in telecom data to validate complex data pipelines from source systems to data warehouse and data lake.

You will use Informatica PowerCenter, Teradata SQL, Hive/HDFS and Python to ensure data quality, performance, and seamless data movement in Hadoop ecosystems.

Relocation to Oman is mandatory; the role requires hands-on testing and collaboration with ETL developers, data architects and business analysts.

Qualifications

• 5+ years of ETL / Data Warehouse testing experience.
• Telecom domain knowledge (OSS/BSS, Billing, CRM).
• Strong SQL skills in Teradata; complex data validation.
• Experience with Hadoop ecosystems and data quality testing.

Responsibilities

• Data Validation & Quality Assurance: Design, develop, and execute test plans for ETL processes using Informatica PowerCenter.
• Database Testing: Write advanced, optimized Teradata SQL queries for source-to-target validation, data integrity, and performance testing.
• Big Data Testing: Validate data ingestion and processing within Hadoop ecosystems (Hive, HDFS, Spark).
• Automation & Scripting: Use Python to automate testing tasks and data reconciliation.
• Telecom Domain Analysis: Leverage telecom data knowledge to analyze requirements and data anomalies.
• Defect Management & Collaboration: Track defects with Jira/ALM and collaborate with ETL developers and data architects.
• Data Migration & Integration Testing: Verify transformations across multiple data layers.

Skills

ETL Testing

Python scripting

Agile/Scrum

Data Warehousing

Communication

Tools

Informatica PowerCenter

Teradata SQL

Hive/HDFS

Spark

Hadoop

Python

Jira

ALM

Azure DevOps

Snowflake

AWS

Azure

Jenkins

Git

ISTQB

Job description

Industry Information Technology and Services

Note: 5 days working from customer location (OMAN Location-Middle East) Rounds of Interview: L1 Virtual, L2+L3- Face to face in Bengaluru Tech Mahindra's Office

Senior ETL Tester (Telecom Domain) Position Overview We are seeking a skilled and analytical Senior ETL Tester with 5+ 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.

Desired Candidate Profile

• Overall Experience: Minimum 5 years of dedicated experience in ETL / Data Warehouse testing.
• Domain Expertise: At least 23 years of experience working within the Telecom domain (OSS/BSS systems, Billing, Mediated data, or Network analytics).
• 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.