Test Engineer

Logic Era Inc.; Dearborn, Northern (MI, KY); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Logic Era Inc. seeks a data quality and testing engineer to design and execute end-to-end ETL tests for bank data warehouse solutions across Bronze to OBT layers, ensuring data completeness, accuracy, and referential integrity.

Strong SQL/BigQuery validation and test automation experience are required. You will validate Gold-layer transformations, conduct data reconciliation, and support AML/transaction scenarios while implementing AI-assisted testing automation to improve coverage and

Qualifications

• Bachelor’s degree in Information Systems or Computer Science.
• 2–3 years of testing/ETL experience.
• Experience with SQL/BigQuery validation and data warehouse testing.

Responsibilities

• Develop and execute comprehensive test strategies for Bank Data Warehouse solutions across Bronze, Silver, Gold, OBT, and reporting layers.
• Execute ETL and data warehouse testing for data completeness, accuracy, timeliness, and referential integrity.
• Develop complex BigQuery SQL validation scripts using joins, CTEs, window functions, date functions, and aggregations.

Skills

Agil

Jira

Azure DevOps

PMP

CSM

Education

Bachelor’s degree in Information Systems or Computer Science

Job description

Responsibilities:

• Develop and execute comprehensive test strategies and plans for Bank Data Warehouse solutions covering Bronze, Silver, Gold, OBT, and reporting layers, including risk-based priorities and coverage
• Execute ETL and data warehouse testing to validate data completeness, accuracy, timeliness, schema integrity, transformations, deduplication, null handling, and referential integrity.
• Develop complex BigQuery SQL validation scripts using joins, CTEs, window functions, date functions, and aggregations to independently validate expected results and business rules.
• Perform source-to-target data reconciliation across Bronze, Silver, Gold, and OBT layers by validating row counts, financial amounts, key counts, balances, transactions, and customer/account data.
• Validate Gold-layer transformations and data models, including SCD Type 2 dimensions, effective dates, surrogate keys, bitemporal facts, referential integrity, transaction classifications, and historical data.
• Test OBT and downstream banking reports to validate join accuracy, derived fields, data completeness, reconciliation, report traceability, refresh accuracy, and query performance.
• Execute functional, integration, regression, and end-to-end business scenario testing covering customer onboarding, deposits, money movement, CD maturity, wire transfers, fraud, AML, and account lifecycle processes.
• Perform data quality and governance testing covering completeness, accuracy, consistency, timeliness, uniqueness, validity, PII handling, data lineage, and data-volume/drift validation.
• Develop and implement AI-assisted testing agents to analyze requirements, generate test scenarios and test cases, orchestrate automated test execution, and support SQL/data validation and regression testing.
• Manage defects and testing documentation by creating JIRA defects with SQL evidence, expected versus actual results, affected tables/reports, severity, test cases, traceability, and test reports.

Requirement:

Education : Bachelor’s degree in Information Systems or Computer Science with 2-3 years of experience.

Skills Required : Agil, Jira, Azure DevOps, PMP, CSM