Data Integration Test Engineer II

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

Job summary

Western & Southern Financial Group in Cincinnati is seeking a Data Testing Specialist. The role includes defining data warehouse testing strategies and maintaining testing frameworks using Informatica.

Ideal candidates should have a Bachelor's Degree, experience with BI testing, and expertise in SQL. This position is critical for ensuring data quality and supporting ongoing projects in a dynamic environment.

Qualifications

• Required Bachelor's Degree or commensurate experience.
• Proficient in data integration and business intelligence testing.
• Experience with complex SQL queries.

Responsibilities

• Collaborates with SQA leadership to define testing strategy.
• Designs and implements testing frameworks using Informatica.
• Manages data request processes and coordinates with teams.

Skills

Data Integration / Business Intelligence testing

Complex SQL queries

Problem-solving and data analysis

Attention to detail

Fast-paced environment adaptability

Education

Bachelor's Degree or equivalent experience

Tools

Informatica

Job description

Overview

This role works closely with the SQA Manager or Director to define data warehouse and BI testing strategy and processes in line with Enterprise standards. Responsible for creating, executing and maintaining a project level data testing strategy and framework for a given set of data testing tools.

Responsibilities

• Collaborates with the SQA Manager or Director and project teams to establish the data testing strategy, approach, and plan for projects
• Designs and implements test data management and testing frameworks using Informatica or similar technologies.
• Adheres to Enterprise practices for various aspects of test data management, including data masking, retention, historical data management, virtualization, sub-setting, synthesis, randomization, cleansing, refreshing, aging, cloning, archiving, versioning, disposal, prioritization, and traceability.
• 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.
• Utilizes Informatica to test ETL loads at different stages of data acquisition, including extraction (from operational sources, XML, DB2, flat files, COBOL, etc.), transformation (merging, cleansing, scrubbing, aggregation), staging, pre-load, and deployment to data warehouses and operational data stores.
• Provides expertise in automating data warehouse and operational data store testing processes and validations using Informatica and other automation tools.
• Tests data quality and collaborates with the business team to document quality requirements.
• Identifies test data environment requirements and collaborates with infrastructure, network operations, environment, and release teams to set up the necessary environments for fulfilling test data requests.
• Works with various stakeholders to define and document test data requirements, identify common data elements, and establish business rules.
• Creates knowledge management deliverables, including documentation of processes and procedures.
• Develops an automation suite for master data preparation across various applications.
• Performs other duties as assigned.
• Complies with all policies and standards.

Qualifications

• Bachelor's Degree Or commensurate selection criteria experience. - Required
• Data Integration / Business Intelligence testing in a complex environment working with an engine based ETL tool - Required
• Experience identifying, defining and quantifying problems, collecting and interpreting data, establishing facts, and providing effective solutions. Examples from work experience include identifying moderate to complex issues, quantifying these problems, and delivering effective resolutions. - Required
• Understand data models from a technical solution and business use perspective -
• Proficient in writing complex SQL queries for testing ODS, DataMarts, and Data Warehouses. -
• Thrives in a fast-paced environment, working across multiple platforms, architectures, and diverse technologies -
• Ability to deliver quality results in a busy and dynamic business focused environment. -
• Meticulous attention to detail, consistently seeking ways to improve and promote quality, and applying feedback to enhance individual performance. -
• Quick learner of product and data architecture through existing diagrams, schemas, and blueprints. -
• Committed to achieving excellence in customer satisfaction, process, product quality, and reliability. -
• Ability to document procedures and activities in a manner that is understandable to others and prepared using a prescribed format. -
• Microsoft Certifications in C# and SQL (MCP, MSCE, etc.) Upon Hire - Preferred
• Current Certified Software Engineer (CSTE) Upon Hire - Preferred
• ISTQB Certified Tester, Foundation Level (CTFL) Upon Hire - Preferred
• Quality Improvement Associate Certification (CQIA) Upon Hire - Preferred
• TDWI's DW Certification or equivalent Upon Hire - Preferred

Work Setting/Position Demands:

• Works in an office setting and remains in a stationary position for long periods of time while working at a desk, on a computer or with other standard office equipment, or while in meetings.
• Requires the ability to verbally communicate and exchange accurate information to customers and associates on a regular basis.
• Requires visual acuity to read and interpret a variety of correspondence, procedures, reports and forms via paper and electronic documents, visual inspection involving small defects; small parts, and/or operation of machinery (including inspection); using measurement devices continuously. Visual acuity is required to determine accuracy, neatness, and thoroughness of work assigned.
• Requires the ability to prepare written correspondence, reports and forms using prescribed formats and conforming to rules of punctuation, grammar, diction, and style on a regular basis.
• Requires the ability to apply principles of logical thinking to define problems, collect data, establish facts, and draw valid conclusions
• Performs substantial movement of wrists, hands, and fingers for continuous computer work.
• Extended hours required during peak workloads or special projects/events.
• Occasional after-hours work needed