Data Tester

Job Description

Insight Global is looking to hire a Data Tester (Quality Engineer) for one of our largest clients in Northeast, Ohio. As a Data Tester, you are responsible for validating 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 across multiple test and production environments. You will be responsible for exposing issues with data inconsistence, data quality, data security, ETL process performance and end user experience.

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 reporting or dashboarding tools, including Excel. Finally, testers also validate non-functional requirements, including performance and security access

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day.

We are an equal opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

If you need assistance and / or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy : .

Required Skills & Experience

2 years experience in an ETL data testing role

oAbility to test data effectively that has been transformed via ETL processes across multiple environments for data warehouses, data marts, fit for purpose marts and landed data

Experience with Cognos, DB Visualizer, or other reporting tools

oAbility to validate data, UI, and non-functional requirements for Cognos reports, Tableau and other dashboards, visualizations, and reports

Development of data test strategies / solutions, test plans, and test cases

owhat 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.
• Jira

Nice to Have Skills & Experience

• DB Visualizer
• Tosca for API and data testing

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.