Data Integration Test Engineer II
Western & Southern Financial Group · Cincinnati, Ohio, US
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 stan...
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 extractio...