Data Integration QA Engineer II: ETL & Data Warehousing

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

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.