Job Description The Senior Test Engineer serves as the quality owner for the Informatica-to-dbt migration, responsible for defining and overseeing the end-to-end testing strategy across Extract, Load, and Transform layers. This role ensures data is landed accurately from source systems using Python-based ingestion and that dbt transformations meet functional equivalence with legacy Informatica outputs. The Senior Test Engineer provides test leadership across multiple migration waves and parallel business units (SWP and IMS), while mentoring Test Engineers and coordinating closely with Technical Leads and SMEs. Key Responsibilities • Define the overall test strategy, test approach, and validation framework for EL and dbt Transform components. • Establish testing standards, reusable test cases, and automation patterns where applicable. • Validate Python-based extract/load processes for: o Row counts o Schema alignment o Data completeness o Data type consistency • Oversee dbt transformation validation, including: o Pre- vs post-migration data reconciliation o Aggregation and business rule validation o Incremental and full-load behavior • Review and approve test execution results and defect triage. • Coordinate testing activities across SWP and IMS migration waves. • Partner with Informatica SMEs to understand legacy validation logic and expected outputs. • Support SIT, UAT cycles, and production release readiness. • Provide reporting on test progress, defect trends, and release quality metrics. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements • 8+ years of data testing experience in large-scale data migration or ETL programs • Strong SQL skills (Oracle, SQL Server, or similar RDBMS) • Experience validating ETL/ELT pipelines and transformations • Familiarity with dbt testing concepts (schema tests, data tests preferred) • Experience testing Python-based data pipelines • Strong understanding of reconciliation techniques and data validation frameworks • Prior experience working in offshore delivery models