BI&DWH Tester (Bucharest)12 Jun 2020

  • Client: Multinational Telecom Company, Romania
  • Office Location: Bucharest
  • Contract Duration: At least 12 months

 

Job Description

 

General

We are looking for Testing Specialists with working experience in BI&DWH solutions, to be part of our client Enterprise Data Management Department.

Responsibilities/Activities

  • Understand how data within the core business systems relates to business activity
  • Fully understanding the data within the core business systems
  • 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

Requirements

Technical

  • At least 3-4 years of relevant experience in testing environment
  • At least 2-3 years of experience in Quality Assurance and Software Testing in Data Warehousing and Business Intelligence solutions
  • Experience in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading
  • Experience with: QA Tools (JIRA, Enterprise Tester), BI/Reporting Tools (Business Objects, Tableau), ETL Tools (Informatica, ODI, PL/SQL Procedures), Query Tools (TOAD, PL/SQL Developer, SQL Navigator) 
  • Expert level skills in testing Enterprise Data Warehouses using Informatica and ETL tools
  • Experience in testing reconcile initial and delta daily loads
  • Expert in writing complex SQL queries for Reports data validations
  • Experience in testing of 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
  • Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, Defect status reports, Test Summary report
  • Experience in Functional testing, System testing, Performance testing, Regression testing, Smoke testing, Recovery testing, Reports testing, UAT testing
  • Experienced in interacting with Business Owners, Business Analysts, UAT Users and Developers
  • Excellent working knowledge of System Development Life Cycle, Software Testing Life Cycle and Defect Life Cycle
  • Good knowledge of PL/SQL programming languages
  • Good knowledge of Oracle Databases 11g
  • Proficiency in Defect management, including Defect creation, modification, tracking and reporting using Industry standard Tools like JIRA and Enterprise Tester 

Education

  • Technical University Degree

Others

  • Good level of English, verbal & written
  • High degree of accuracy and attention to detail
  • Ability to work comfortably in a fast-changing environment
  • Interpersonal, communication, documentation and presentation skills
  • Organization and coordination skills

Nice to have requirements

  • Experience within Telecom Industry

Send your CV now, using the form below:

upload cv