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.