Data Integration Test Engineer

Western & Southern Financial Group; Cincinnati (OH); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Medical, dental, vision, and life insurance

401(k) savings plan with pension options

Tuition reimbursement

Paid time off increasing with tenure

Access to on-site amenities

Job summary

Western & Southern Financial Group is seeking a Data Integration Engineer II to develop and improve data warehouse testing strategies in Cincinnati, Ohio. This role is pivotal in ensuring data quality and mentoring team members.

The ideal candidate will have substantial experience in SQL, ETL tools like Informatica, and data integration testing. Premier benefits including medical insurance, 401(k) plans with pension options, and tuition reimbursement are offered.

Qualifications

• Hands-on experience writing complex SQL queries for various data storage solutions.
• Experience with business intelligence testing in a complex environment.
• Knowledge of data concepts such as OLTP, OLAP, and dimension modeling.

Responsibilities

• Lead and standardize enterprise data integration test strategies.
• Manage data requests and align with integrated application timelines.
• Design and maintain automated testing frameworks.

Skills

SQL querying

Data Integration Testing

ETL tools

Cognos or Tableau

Software Testing Life Cycle

Tools

Informatica

Job description

This position is 100% on site in downtown Cincinnati, Ohio. We do not offer remote work nor do we assist with relocation.

A Day in the Life of a Data Integration Engineer II

The SQA Data Integration Engineer II partners with management and team members to define, implement, and continuously improve data warehouse and Business Intelligence testing strategies, standards, and processes. This role develops and maintains project-level data testing frameworks, drives innovation to improve testing efficiency, and provides expertise in automating data warehouse and operational data store validations. The engineer also mentors peers and junior DI Engineers, and plays a key role in ensuring data quality, consistency, and maintaining sustainable test automation practices.

Responsibilities

• Lead and standardize enterprise data integration test strategies.
• Manage the process for accepting, provisioning, and fulfilling data requests from ongoing projects, coordinating with the release team to align timelines with integrated application environments and code availability.
• Design, execute, and maintain automated ETL, data warehouse, and operational data store testing using Informatica and related tools.
• Develop and maintain reusable, scalable data testing frameworks, standards, and drive continuous improvement in data testing processes.
• Mentor and train data testing team members while ensuring compliance with enterprise policies and standards.

Job Requirements

• Preferred: hands‑on experience writing complex SQL queries for testing ODS, Data Marts, Relational Databases, NoSQL databases, and Data Warehouses.
• Preferred: hands‑on experience with various Data Integration / Business Intelligence testing in a complex environment working with an engine‑based ETL tool as well as Cognos or Tableau reporting tools.
• Preferred: hands‑on experience with data concepts including OLTP, OLAP, centralized, functional, federated data warehouses, data merging, cleansing, scrubbing, aggregation, dependent and independent data marts, star schema, various table dimensions, types of facts and fact tables, dimension modeling, and different types of OLAPs.
• Hands‑on experience in software test engineering using the Software Testing Life Cycle (STLC).
• Experience with data models from a technical solution and business use.

Premier Benefits to Support You

• Medical, dental, vision, and life insurance.
• 401(k) savings plan with pension options.
• Paid time off increasing with tenure.
• Tuition reimbursement and individualized career development plans.
• Parental leave and maternity leave with a 4-week transition back to work.
• Access to on-site amenities like a fitness center, cafeteria and more.
• Extensive employee discount program.