ETL QA Professional
Tech Next Software · Remote · remote · Posted 35d ago
Undisclosed7–12 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Summary
Responsibilities
Requirements
Must have
Nice to have (strong pluses)
Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
This is a remote position. About the role This role is critical to Clients backend modernization and data consolidation effort, which involves migrating and merging 30 disparate databases into a single consolidated MySQL instance. This is not a standard functional UI testing role; it is a heavy backend, data-centric QA position. The engineer will validate ETL pipelines, ensure zero data loss or corruption during migration, and automate data parity checks between legacy systems and the new architecture.
Responsibilities
- Data Validation: Write complex SQL queries to validate data extraction, transformation, and loading (ETL) from legacy SQL databases into the new consolidated MySQL instance.
- Migration Parity Testing: Design and execute automated reconciliation scripts to compare millions of rows between source and target systems, ensuring data integrity and business rule alignment.
- Pipeline Automation: Build and maintain automated test frameworks for data pipelines, replacing manual sampling with comprehensive automated data quality checks.
- API Data Verification: Work alongside C# and Java developers to verify that the newly built APIs and Data Access Layers (DAL) are surfacing the migrated data correctly.
- Defect Triage: Identify, log, and troubleshoot data drift, truncation errors, mapping failures, and performance bottlenecks.
Requirements
Must have
- Deep SQL Expertise: 7+ years of writing advanced SQL queries (Joins, CTEs, Window Functions, Stored Procedures) in MySQL and SQL Server.
- ETL/Data Migration Testing: Proven experience testing large-scale database consolidations, data warehouse migrations, or complex ETL pipelines.
- Test Automation: Hands-on experience building automated data validation scripts using Python, C#, or specialized data testing tools (e.g., Great Expectations, dbt tests, QuerySurge).
- Backend Mindset: Strong understanding of database schemas, primary/foreign key relationships, indexing, and data mapping documents.
- Parity Discipline: Proves data equivalence through automated reconciliation, not just manual spot-checking.
Nice to have (strong pluses)
- API Testing Experience: Familiarity with Postman, REST Assured, or equivalent tools to test data payloads at the API level.
- Code Reading Skills: Ability to read C# or Java code to understand how the Data Access Layer is transforming data.
- Cloud DevOps: Experience with Azure/AWS data services and CI/CD pipelines for automated test execution.
Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
data qualitydata extractionAutomationCI/CD Pipelinesdata servicesapisadvanced sqlamazon web servicesData Verificationdata mappingData MigrationcloudArchitectureAPI TestingData ValidationMicrosoft AzureData TestingData Pipeline
About Tech Next Software
Tech Next Software
Software Product
₹8L PA avg
Avg at Tech Next Software
About
Tech Next Software specializes in innovative IT solutions, addressing industry needs with a focus on effective communication and leadership within its workforce.
Industries
Software Product
Employee ratings
10 reviews
3.1/ 5
Culture
1.7
Career growth
1.6
Work-life
2.2
Employees rate it well for
Compensation & Benefits34Work-Life Balance32
Find them on