Senior ETL Test Engineer (Madurai)

Dear Candidate, Greetings of the day!! I am Kantha, and I'm reaching out to you regarding an exciting prospect with Naveera. You can connect with me on LinkedIn: https://www.linkedin.com/in/kantha-m-ashwin-186ba3244/ About Company Naveera is a trusted global engineering partner delivering Data Engineering, Generative AI, Application Development and IT Infrastructure solutions. With over 15 years of experience in IT services and consulting. we help organizations transform raw data into deployable business value. Our approach emphasises Production over Pilots we dont stop at proof-of-concepts; we engineer systems that go live, scale reliably, and deliver measurable outcomes. With our CoE-driven delivery model, product engineering DNA, and a scalable talent acquisition engine, we align deeply with enterprise demands for performance, compliance, continuity and innovation. From Digital Health to Financial Services, and E-Commerce to Technology, we serve a diverse industry base and back every engagement with proven frameworks, low-attrition teams and agile global delivery. At Naveera, we empower clients to turn challenge into growth, data into insight and concepts into platforms. Website https://naveeratech.com/ Specialties Data Engineering & Modern Data Stack, Generative AI Solutions & Model Deployment, Application Development (Web, Mobile & Enterprise), Artificial Intelligence (Predictive, Conversational, Computer Vision), IT Infrastructure Services (Cloud & On-Prem), Security, DR, Cloud Transformation & Microservices, DevOps, API & Systems Integration, Extended Technology Teams & Dedicated Delivery, Real-Time Streaming & Analytics, and BI & Data Warehousing We're Hiring: Senior ETL Test Engineer & Lead Key Skills: ETL Testing, DWH Testing, Writing Complex SQL Queries, AWS (Glue, S3, Redshift, DBT) & GCP (BigQuery, GCS), API Testing, Data pipeline, Python. Experience: 6 to 15 Yrs Location: Madurai After Noon Shift: 2 PM to 11.30 PM Extended working hours: May be required based on project/business needs Mode : Hybrid 2 Days per Week from Madurai Office Domain: Custom Brokerage, Trade & Logistics About the Role We are looking for an experienced Senior ETL Test Engineer / ETL Test Lead with strong expertise in ETL Testing, Data Warehouse Testing, Complex SQL, Data Pipeline Validation, API Testing, Python, AWS, and GCP. The ideal candidate should have hands-on experience validating large-scale data pipelines, data transformations, data warehouses, and cloud-based data platforms. The role will involve working closely with Data Engineers, Developers, Business Analysts, and client stakeholders to ensure the accuracy, completeness, consistency, and reliability of enterprise data. Experience in the Customs Brokerage, Trade, Logistics, Transportation, or Supply Chain domain will be highly preferred. Key Responsibilities - Lead and execute ETL and Data Warehouse testing for enterprise data platforms and migration projects. - Develop comprehensive test strategies, test plans, test scenarios, test cases, and test scripts for data pipelines. - Validate end-to-end data flow from source systems to staging, transformation layers, data warehouses, and downstream applications. - Write and execute complex SQL queries to validate data accuracy, transformation logic, aggregations, joins, reconciliations, and business rules. - Perform source-to-target data validation and identify data mismatches, missing records, duplicates, and transformation issues. - Validate data pipelines and workflows implemented using AWS and GCP cloud services. - Perform testing of AWS-based data platforms involving AWS Glue, S3, Redshift, and DBT. - Perform testing and validation of GCP-based data platforms involving BigQuery and Google Cloud Storage (GCS). - Validate DBT models, transformations, dependencies, and data quality. - Perform API testing to validate data exchanged between applications and data platforms. - Validate REST APIs, request/response payloads, status codes, data mappings, and business rules. - Develop and execute Python-based test scripts and data validation utilities where required. - Perform data reconciliation between multiple systems and platforms. - Validate data migration and cloud-to-cloud data movement across AWS and GCP environments. - Identify data quality issues and work closely with engineering teams to perform root-cause analysis. - Track defects, provide detailed defect documentation, and coordinate with development teams for resolution and retesting. - Perform regression, integration, system, functional, and end-to-end testing of data pipelines. - Validate data completeness, accuracy, consistency, uniqueness, integrity, and timeliness. - Review technical requirements, mapping documents, source-to-target specifications, and transformation logic. - Collaborate with Data Engineers and Architects to understand pipeline architecture and testing requirements. - Lead testing activities and provide .