Fort Washington Investment Advisors, Inc. · 2 hours ago
Data Integration Test Engineer III
US-OH-CINCINNATI
Full-time
Onsite
Mid LevelFort Washington Investment Advisors, Inc. is seeking a Data Integration Test Engineer III to work closely with SQA and Development Leadership. The role involves defining data warehouse and Business Intelligence testing strategies and processes while creating and maintaining a project level data testing strategy and framework.
Financial Services
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
Qualification
Required
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. -
Preferred
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
Company
Fort Washington Investment Advisors, Inc.
Fort Washington Investment Advisors, Inc.
Founded in 1990
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Maribeth Rahe
President & CEO
Amy L. Mickey
Executive Assistant to the President & CEO
Company data provided by crunchbase