Join our team as a Senior Specialist in Testing Engineering, focusing on ensuring the integrity and accuracy of our data transformation processes. This role is crucial for validating extract/load functions and data transformations, ensuring seamless data migration and consistent output.

You will play a key role in validating data pipelines, comparing outputs from different systems, and collaborating with engineering teams to uphold data quality standards. Your efforts will directly contribute to the success of our data migration initiatives.

This position requires a meticulous approach to testing and a strong understanding of data validation techniques. We are looking for a proactive individual who can effectively manage test cycles and contribute to process improvements.

Execute comprehensive test cases for Python-based extract/load processes, meticulously verifying record counts, field-level data accuracy, and schema/data type consistency.

Conduct dbt transformation validation utilizing SQL-based reconciliation queries. Compare legacy Informatica outputs against dbt-generated results according to established criteria.

Log, track, and re-test defects until successful resolution. Support SIT and UAT test cycles throughout various migration phases.

Maintain essential test artifacts, evidence, and execution logs. Assist in regression testing as new data waves are integrated.

Collaborate closely with Data Engineers to clarify expected outcomes and troubleshoot any encountered issues.

Proven experience in software testing, with a focus on data pipelines and transformations.

Proficiency in Python for scripting and test execution. Strong SQL skills are essential for data validation and reconciliation.

Experience with dbt for data transformation and validation is required. Familiarity with Informatica is also beneficial for comparing outputs.

Ability to log, track, and manage defects effectively through to resolution. Experience supporting SIT and UAT cycles is a plus.

Excellent collaboration and communication skills to work effectively with Data Engineers. The ability to maintain thorough test documentation is important.