Work Timing: 2:00 PM to 11:30 PM IST | Afternoon Shift
Extended Working Hours: May be required based on project or business needs
Domain: Customs Brokerage | Trade | Logistics
About Naveera
Naveera is a global technology and engineering partner helping enterprises build, modernize, and scale their digital ecosystems through Data Engineering, Generative AI, Application Engineering, Cloud, and IT Infrastructure.
With 15+ years of experience in technology services and consulting, Naveera helps organizations turn complex technology challenges into scalable, production-ready solutions that deliver measurable business value.
Our approach is built around Production over Pilots. We focus on taking technology initiatives beyond experimentation and into production, scale, and measurable business outcomes.
Through our Center of Excellence driven delivery model, product engineering approach, and globally integrated teams, Naveera combines technical expertise, domain knowledge, and disciplined execution to serve enterprise clients across industries including Healthcare and Life Sciences, Financial Services, Manufacturing, Retail, Energy, and Technology.
At Naveera, you will work with experienced engineering teams solving complex enterprise data and technology challenges across modern cloud and data platforms.
About the Role
Naveera is looking for an experienced Senior ETL Test Engineer with strong expertise in ETL Testing, Data Warehouse Testing, Complex SQL, Data Pipeline Validation, API Testing, Python, AWS, and GCP.
In this role, you will be responsible for validating large-scale data pipelines, data transformations, data warehouses, cloud-based data platforms, and downstream data applications.
You will work closely with Data Engineers, Developers, Business Analysts, Architects, and client stakeholders to ensure enterprise data meets the highest standards of accuracy, completeness, consistency, integrity, and reliability.
The ideal candidate will have strong hands-on experience testing modern data platforms across AWS and GCP environments. Experience in Customs Brokerage, Trade, Logistics, Transportation, or Supply Chain will be highly preferred.
What You’ll Do
- Execute ETL and Data Warehouse testing for enterprise data platforms and data migration projects
- Develop comprehensive test strategies, test plans, test scenarios, test cases, and test scripts for data pipelines
- Validate end-to-end data flow across source systems, staging layers, transformation layers, data warehouses, and downstream applications
- Write and execute complex SQL queries to validate data accuracy, transformations, aggregations, joins, reconciliations, and business rules
- Perform source-to-target data validation and identify missing records, duplicates, data mismatches, and transformation issues
- Validate data pipelines and workflows implemented using AWS and GCP cloud services
- Test AWS-based data platforms involving AWS Glue, Amazon S3, Amazon Redshift, and DBT
- Test and validate 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 and response payloads, status codes, data mappings, and business rules
- Develop and execute Python-based test scripts and data validation utilities
- Perform data reconciliation across multiple systems and platforms
- Validate data migration and cloud-to-cloud data movement across AWS and GCP environments
- Identify data quality issues and work with engineering teams on root-cause analysis
- Track defects and provide detailed defect documentation
- Coordinate with development teams for defect 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
- Participate in client discussions, requirement clarification, defect triage, and project status meetings
- Prepare test execution reports, defect metrics, testing status, and quality dashboards
Required Skills & Experience
ETL & Data Warehouse Testing
- Strong hands-on experience in ETL Testing and Data Warehouse Testing
- Strong understanding of ETL/ELT concepts and modern data pipeline architecture
- Experience with source-to-target validation and data reconciliation
- Strong understanding of dimensional data models, fact tables, dimension tables, and data transformations
- Experience testing large-volume datasets and complex data processing workflows
- Experience validating end-to-end data pipelines and data quality
SQL
Strong proficiency in complex SQL queries with hands-on experience in:
- Complex joins
- CTEs
- Subqueries
- Window functions
- Aggregations
- Stored procedures
- Data reconciliation
- Data validation and profiling
- Data discrepancy analysis
Ability to independently investigate and troubleshoot data discrepancies using SQL.
AWS
Hands-on experience testing data solutions using:
- AWS Glue
- Amazon S3
- Amazon Redshift
- DBT
- AWS-based ETL and data pipelines
GCP
Experience with:
- Google BigQuery
- Google Cloud Storage (GCS)
- GCP-based data pipelines
- Data validation across GCP data platforms
- Cloud-based data migration and validation
Experience testing data movement between AWS and GCP environments will be an advantage.
API Testing
- Hands-on experience with REST API testing
- Understanding of API request and response validation
- Experience validating JSON and XML payloads
- Experience validating data mappings and business rules
- Familiarity with 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
What You Can Expect at Naveera
At Naveera, you will work on complex enterprise data engineering and cloud transformation initiatives across modern technology environments.
You will have opportunities to:
- Work with modern AWS and GCP data platforms
- Gain exposure to large-scale enterprise data pipelines and cloud architectures
- Work alongside experienced Data Engineering and technology teams
- Solve complex data quality and validation challenges
- Contribute to production-grade enterprise data solutions
- Develop expertise across modern data platforms and technologies
- Work on industry-specific solutions within Trade, Logistics, and Supply Chain
Join Naveera
If you are an experienced ETL Test Engineer with strong expertise in data validation, complex SQL, cloud data platforms, API testing, and Python, and are passionate about ensuring the quality and reliability of enterprise data, we would like to hear from you.