Data Integration Test Engineer III

Western & Southern Financial Group•Cincinnati, OH

5h•Onsite

About The Position

This role works closely with the SQA and Development Leadership to define data warehouse and Business Intelligence testing strategy and processes in line with enterprise standards. The candidate is responsible for creating, executing and maintaining a project level data testing strategy and framework for a given set of data testing tools and demonstrating innovations to increase data warehouse testing efficiency.

Requirements

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 as wells as Cognos or Tableau reporting tools - Required
Skilled in identifying, defining, and quantifying problems; collecting and interpreting data, establishing facts, and providing effective solutions. Demonstrated experience in resolving moderate to complex problems. - Required
Understand data models from a technical solution and business use perspective - Required
Strong understanding of 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.
Proficient in writing complex SQL queries for testing ODS, DataMarts, and Data Warehouses. -
In-depth knowledge of various SDLC processes, QA lifecycle, and methodologies, with expertise in leading data testing methodologies. -
Thrives in a fast-paced environment with multiple platforms, architectures, and diverse technologies; demonstrated personal motivation, creativity, and a proactive approach. -
High accuracy, thoroughness, and attention to detail; continuously seeks ways to improve and promote quality; applies feedback to enhance performance. -
Ability to deliver quality results in a dynamic, business-focused environment. -
Committed to achieving excellence in customer satisfaction, process and product quality, and reliability. -
Excellent verbal and written communication skills, effectively conveying technical and application information to internal and external customers in a clear, accurate, and concise manner. -

Nice To Haves

Experience with TDM tools such as CA Test Data Manager, Delphix, or Informatica TDM - Preferred
Microsoft Certifications in C# and SQL (MCP, MSCE, etc.) Upon Hire - Preferred
Certified Software Test Engineer Upon Hire - Preferred
ASQ Certified Quality Improvement Associate (ASQ CQIA) Upon Hire - Preferred
TDWI's DW Certification or equivalent Upon Hire - Preferred

Responsibilities

Collaborates with SQA management and platform teams to standardize reusable data testing strategies, approaches, and methodologies.
Establishes enterprise-wide best practices for various aspects of test data management, including data masking, retention, historical data management, virtualization, sub-setting, synthesizing, randomizing, cleansing, refreshing, aging, cloning, archiving, versioning, disposing, prioritizing, and traceability.
Reviews and approves automation suites for master data preparation across various applications.
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, preload, 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.
Defines, implements, and oversees enterprise standards and processes for testing data quality in collaboration with business and architecture teams.
Creates knowledge management deliverables, such as documentation of enterprise processes and procedures, and enables enterprise users to follow these processes and procedures.
Drives continuous process improvements in test data management and data warehouse testing domains.
Trains and mentors enterprise data test team members to enhance their skills.
Defines, documents, and governs repeatable and reusable test data management processes such as profiling, provisioning, governance, and automation.
Develops and standardizes reusable test data management and data warehouse testing frameworks for the enterprise.
Performs other duties as assigned.
Complies with all policies and standards.