Data Test Engineer

About the Company

Synechron is a global consulting firm that leverages digital technologies to revolutionize businesses. With over 20 years of expertise, the company drives innovative solutions across Artificial Intelligence, Cloud, DevOps, Data, and Software Engineering to support financial and technology sectors worldwide. It boasts a workforce of more than 14,000 employees across 55 offices in 20 countries. The company fosters research and development through FinLabs, innovating in areas such as AI, Blockchain, Data Science, and mobile applications. Synechron has been repeatedly recognized for its workplace excellence.

Role Overview

We are in pursuit of a seasoned Data Test Engineer with a minimum of 7 years experience, who possesses deep expertise in data warehousing, ETL pipelines, SQL queries, and data validation techniques.

Key Responsibilities

• Craft and carry out testing plans for data extraction, transformation, and loading workflows as well as data warehouse systems.
• Ensure data integrity by validating accuracy, completeness, consistency, and correctness of transformation logic.
• Conduct source-to-target data verification and reconcile discrepancies.
• Test mechanisms such as Slowly Changing Dimensions Types 1 & 2, audit columns, incremental data loading, and historical databases.
• Formulate and run intricate SQL queries to validate and analyze data.
• Detect, report, and follow up on data-related defects until resolution.
• Work collaboratively with data engineers, software developers, analysts, and stakeholders.
• Support testing efforts on contemporary data platforms and cloud-native data pipelines.
• Prepare comprehensive documentation including test cases, outcomes, defect logs, and validation reports.

Required Skills and Qualifications

• Proven hands-on experience in data testing and validation techniques.
• In-depth knowledge of ETL concepts and data warehousing principles.
• Familiarity with data transformation concepts like SCD, audit columns, and reconciliation processes.
• Proficiency in advanced SQL querying involving joins, aggregations, and subqueries.
• Experience testing both batch and real-time data streaming pipelines.
• Exposure to latest data platforms such as Databricks, Snowflake, Microsoft Azure, or Amazon Web Services.
• Strong grasp of data quality management, defect tracking, and testing best practices.
• Excellent analytical thinking and problem resolution abilities.

Preferred Qualifications

• Hands-on experience with Databricks or similar cloud-based data environments.
• Knowledge of automation testing tools and Agile/Scrum methodologies.
• Previous involvement in banking or financial service projects, notably with organizations like ASB.