BI DWH Tester

About Inetum, Positive digital flow:

Inetum is an IT services company that provides digital services and solutions and a global group that helps companies and institutions to get the most out of digital flow. The Inetum group is committed towards all these players to innovate, continue to adapt and stay ahead. With its multi-expert profile, Inetum offers its clients a unique combination of proximity, a sectorial organization and solutions of industrial quality. Operating in more than 26 countries, the Group has nearly 27,000 employees and in 2020 generated revenues of €1,965 billion.

Inetum Romania is an important player in the IT services and solutions market in our country, with over 15 years of activity. It is a stable, growing and profitable company with over 500 employees who provides IT consulting services, infrastructure and software development assistance, digital services implementation and support.

In an Agile format, our teams work on cloud initiatives, application development, business intelligence, automation and digitalization projects that contribute to the profit and evolution of our clients. The diversity of our projects offers team members the opportunity for learning and growth. The company had a turnover of 20 million EURO in 2021.

• Experience in Quality Assurance and Software Testing in Data Warehousing and Business Intelligence solutions
• Have experience in testing reconcile initial and delta daily loads
• Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading
• Experienced in interacting with Business Owners, Business Analysts, UAT Users and Developers
• Excellent interpersonal, communication, documentation and presentation skills
• Excellent working knowledge of System Development Life Cycle, Software Testing Life Cycle and Defect Life Cycle
• Experienced in Functional testing, System testing, Performance testing, Regression testing, Smoke testing, Recovery testing, Reports testing, UAT testing
• Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, Defect status reports, Test Summary report
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like JIRA and Enterprise Tester.
• Expert in writing complex SQL queries for Reports data validations
• Have solid experience on database query tools such as TOAD, SQL Navigator or SQL Developer
• Have tested several complex Reports
• Experience in testing the reports for both cosmetic static content and data validations as per Report specification documents
• Experience in Data Analysis, Data Cleansing Scrubbing, Data Validation and Verification, Data Conversion, Data Migrations
• Expert level skills in testing Enterprise Data Warehouses using Informatica or other ETL tools.

• Understand how data within the core business systems relates to business activity
• Fully understanding the data within the core business systems. This will include ensuring all data is mapped correctly for KPI and analytic reporting purposes and that this it in line with the business operational approach
• Understand the mappings of source systems to dimensional data models in the target data warehouse schema
• Test Extract Transformation and Load (ETL) processes developed using Oracle ODI and PL/SQL procedures in order to ensure the accuracy of data mapping and applied business rules
• Write, update and execute test cases
• Report, follow-up, confirm and close issues
• Regression testing of software prior to code releases
• Liaise with the development teams during system testing phases of the project to identify and work to resolve defects
• Liaise with business analysts and key stake holders during user acceptance testing phases of a project to ensure that deliverables are meeting set business requirements and working to achieve this if not contribute to the definition and implement testing practices for the BI
• Make defect prioritization decisions based upon considering both technical merit and business value
• Ensure that standardized testing processes are in place and followed.