Job Description
Insight Global is seeking a Data Tester to join one of our largest insurance clients. They will be a part of an Agile Team within the BI Enhancements Group. At first, they will be working in Cognos and reporting to learn the environment on the visual side. As they progress further into the project, they will work on DB Visualizer and work heavily with SQL, data validation, and more. They will be a part of daily standup meetings, producing acceptance criteria and how to test. They will collaborate heavily with developers on the team both onshore and offshore. Most of the testing will be done in DB Visualizer, and they will be pulling data from any application in up to 100 different environments.
- Verify that data properly ingests according to the defined schema and there is no data corruption.
- Testers validate the correctness of data by comparing source and target data. Including direct moves or data transformations. This includes data warehouses, data marts and online data stores. Testers support multiple environments.
- Testers expose issues with data inconsistency, data quality, data security, Extract, Transform & Load process, performance, and end user experience.
o This includes validating the loading of all required rows, correct execution of all transformations and data quality. The team also validates stored procedures or queries that produce aggregate or summary tables.
- Data testing is performed by writing SQL to validate correctness of data from source to target by consumption of requirements and source to target mappings.
- Testers validate end user UI either via Cognos, Tableau, or other deliverables (excel). Validate data to source and validate non-functional requirements including security access.
Required Skills & Experience
- 4+ years' experience in an ETL data testing role
- Experience with Cognos, DB Visualizer, or other reporting tools
- Understanding concepts of data warehousing and data marts and their place in an information management environment
- Development of data test strategies/solutions, test plans, and test cases
o what they are and how to develop them, specifically for data warehouses and decision support systems.
- Creating effective test cases and scenarios based on business and user requirements.
- Intermediate to strong SQL query writing.
Nice to Have Skills & Experience
- Tosca
- DB Visualizer
ETL Development experience
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.