Test Engineer - Data Migration & Transformation Validation

BCforward; Chicago (IL); Hybrid; USD 71,000 - 83,000; Full time

Benefits offered by this job

Competitive compensation

Growth opportunities

Inclusive culture

Job summary

BCforward is seeking a Database Testing Lead in Chicago for a 6-month temp position focusing on SQL-based backend validation, large-scale data migrations, and AI-driven test automation.

You will design data validation strategies, reconcile data across systems, and collaborate with data engineers and application teams to implement an automation-first testing approach.

Qualifications

• Strong experience in Database Testing using SQL, including joins, aggregations, and subqueries.
• File-to-file data validation and backend reconciliation across systems and databases.
• Volume testing and large data set validation for batch and real-time pipelines.
• Ability to validate data pipelines from AWS sources to downstream systems, including PNR creation on PID data.
• Strong understanding of data integrity, accuracy, and consistency checks with defect analysis.

Responsibilities

• Lead testing for data transformation and migration across enterprise platforms.
• Design and execute validation strategies for data accuracy and integrity.
• Develop SQL queries and scripts to reconcile source and target data.
• Validate ETL/ELT processes, transformations, and data mappings.
• Perform end-to-end testing of batch, real-time, and incremental migrations.
• Identify and troubleshoot data quality issues, defects, and anomalies.
• Collaborate with engineers and analysts to define test strategies and criteria.
• Generate data quality metrics and migration readiness reports.

Skills

SQL Testing

AI-driven testing

Data Validation

ETL/ELT Validation

Volume Testing

Tools

PostgreSQL

Oracle

SQL Server

MySQL

Swagger

Job description

Job Title: Test Engineer - Data Migration & Transformation ValidationLocation: Chicago, IL (Hybrid, onsite 2 days a week)Duration: Temp - 6 monthsPay Range: $34/hr $40/hr (W2)Job ID: 410219

About BCforwardBCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Job DescriptionWe are seeking a Database Testing Lead to join our dynamic team. The ideal candidate will have strong experience in SQL-based backend validation, large-scale data migration testing, and AI-driven test automation and a proven ability to design and execute data validation strategies, reconcile large datasets across systems, and ensure accurate end-to-end data flows.

Responsibilities:

• Lead testing for data transformation and migration across enterprise Network Operation platforms handling millions of records.
• Design and execute strategies to validate data accuracy, completeness, consistency, and integrity during migrations.
• Develop complex SQL queries and automated scripts to reconcile source and target systems at scale, including file-to-file validation.
• Validate ETL/ELT processes, transformation rules, data mappings, and business logic across multiple domains.
• Perform end-to-end testing of batch, real-time, and incremental migration workflows, including volume and large data set validation.
• Identify and troubleshoot data quality issues, migration defects, duplicates, missing records, and transformation anomalies.
• Collaborate with data engineers, architects, business analysts, and application teams to define test strategies and acceptance criteria.
• Generate data quality metrics, reconciliation reports, and migration readiness assessments for stakeholders.
• Drive best practices in database testing, automation, and data quality engineering for enterprise migrations.
• Partner with AI agent onboarding partners to define and execute onboarding for UA agents and establish an automation-first testing strategy.
• Review architecture diagrams and solution objectives to understand end-to-end agent workflows and testing requirements.
• Identify opportunities for AI-driven test automation to improve coverage, efficiency, and workflow validation.
• Collaborate with development, architecture, AI partners, and QA to embed database automation and AI agents into the lifecycle.
• Define test scenarios for AI-agent-based workflows covering functional, integration, data, and end-to-end validation.

Required Skills & Qualifications:

• Strong experience in Database Testing using SQL, including joins, aggregations, and subqueries.
• Experience with AI-driven test automation and scripting for data validation.
• File-to-file data validation and backend reconciliation across systems and databases.
• Volume testing and large data set validation for batch and real-time pipelines.
• Ability to validate data pipelines, transformations, and end-to-end data flow from AWS sources to downstream systems, including PNR creation on PID data.
• Strong understanding of data integrity, accuracy, and consistency checks with defect analysis.

Preferred Skills:

• Experience with enterprise data migration programs and ETL/ELT validation best practices.
• Familiarity with AWS-based data sources and validation patterns.

Secondary Skills

• API testing using Postman, Swagger, or similar tools.
• Understanding of REST APIs and HTTP methods.
• Ability to validate API responses against database data with JSON/XML checks.
• Technical SkillsSQL.Oracle, SQL Server, PostgreSQL, or MySQL.AWS data validation.
• Experience with large data volumes, data migration, and ETL validation.

Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

• Competitive compensation and benefits.
• Opportunities for growth with global clients.
• A supportive, inclusive culture that values innovation and people.
• Exposure to cutting-edge technologies and projects.

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.