Data Integration Test Engineer

Job Title: Data Integration Test Engineer

Location: Cincinnati OH (Fully Onsite)

Who We Are: Vernovis is a Total Talent Solutions company that specializes in Technology, Cybersecurity, Finance & Accounting functions. At Vernovis, we help these professionals achieve their career goals, matching them with innovative projects and dynamic direct hire opportunities in Ohio and across the Midwest.

Vernovis is looking for a Data Integration Test Engineer who will collaborate with leadership and technical teams to design, implement, and continuously improve testing strategies, standards, and processes for data warehouse and business intelligence solutions. This role will build and maintain scalable data testing frameworks, enhance testing efficiency through automation and process improvements, while ensuring reliable validation of data warehouses and operational data stores. Successful candidates will provide guidance to junior team members, and contribute to maintaining high standards for data quality, consistency, and sustainable test automation practices.

What You'll Do:

• Lead and standardize enterprise data integration test strategies.
• Manages 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.

What You'll Have:

• 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.
• Technologies used: SQL, NoSQL, MongoDB, Oracle, Informatica, DB2, XML, Flat Files

Vernovis does not accept inquiries from Corp to Corp recruiting companies. Applicants must be currently authorized to work in the United States on a full-time basis and not violate any immigration or discrimination laws.

Vernovis provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://vernovis.com/privacy-policy-2/.