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 technical guidance to junior and mid-level ETL testers.
- Participate in client discussions, requirement clarification, defect triage, and project status meetings.
- Prepare test execution reports, defect metrics, testing status, and quality dashboards.

Required Technical Skills

ETL & Data Warehouse Testing

- Strong hands-on experience in ETL Testing and Data Warehouse Testing.
- Strong understanding of ETL/ELT concepts and data pipeline architecture.
- Experience with source-to-target validation and data reconciliation.




- Strong understanding of dimensional data models, fact and dimension tables, and data transformations.
- Experience testing large-volume datasets and complex data processing workflows.

SQL

- Strong proficiency in complex SQL queries.
- Hands-on experience with:
- - Complex Joins
- CTEs
- Subqueries
- Window Functions
- Aggregations
- Stored Procedures
- Data reconciliation
- Data validation and profiling
- Ability to independently troubleshoot data discrepancies using SQL.

AWS Hands-on experience testing data solutions using:

- AWS Glue
- Amazon S3
- Amazon Redshift
- DBT
- AWS-based ETL/data pipelines

GCP

Experience with

- Google BigQuery
- Google Cloud Storage (GCS)
- GCP-based data pipelines and data validation
- Data migration/testing between cloud environments is an added advantage.

API Testing

- Experience with REST API testing.
- Understanding of API request/response validation.
- Experience validating JSON/XML payloads and data mappings.
- Familiarity with tools such as Postman or similar API testing tools.

Python

- Good hands-on knowledge of Python for data validation and test automation.
- Experience using Python for data comparison, reconciliation, validation, and test utilities.
- Familiarity with Pandas and other data-processing libraries is an advantage.

If you are Interested please share the details below along with your updated resume to [email protected]

Candidate Full Name

Contact Number

Email ID

Total Experience

Rel Exp in ETL & Data Warehouse Testing:

Rel Exp in Writing complex SQL queries:

Rel Exp in AWS (Glue, S3, Redshift, DBT) & GCP (BigQuery, GCS):

Rel Exp in Python

Current Company

Pls mention the designation mentioned as per your offer letter/Payslips:

Current CTC

Expected CTC

Current Location

Your Native Location

Are you willing to Relocate to Madurai Location with your family (Yes/NO)

Preferred Working Mode (Hybrid) & Monthly travel to the Madurai office is required, with a mandatory 5-working-day stay. Please note that accommodation and travel expenses will not be reimbursed by the company? (Yes/NO):

Are you willing to relocate to Madurai and Work 2-3 Days from the office? (YES/NO):

Are you willing to work from the Madurai office for one Week every month? (YES/NO):

Current Notice Period: If you are serving Notice Please mention the Last working day:

If you are holding any offer, Pls mention the offered CTC, Location, Mode of Work and date of joining:

If you are get selected, Pls mention the Date of Joining with us:

Reason for Job Change

Are you willing to work in the 2:00 PM to 11:30 PM IST shift? Please note that extended working hours may be required rarely based on business needs. (Yes/No)

Marital Status

LinkedIn URL

Do you have an active PF account?: (Yes/No)

Rate your communication out of 5:

Any Gaps in your Career/Employment:

Available for the Virtual interview on Weekdays (Yes/No):

📌 Senior ETL Test Engineer (Madurai)
🏢 Naveera Technology
📍 Madurai