QA Data Warehouse Engineer

QA Data Warehouse Engineer

Project: UMG (Universal Music Group)

Experience: 3 years+

Number of openings:01

 

Responsibilities

As a QA Data Warehouse Engineer,  your focus will be to design software that is fit for purpose and use. This a unique position where you and the SCRUM master are going to establish a high preforming team.

  • Test planning and execution: create, enhance and maintain effective and high-value test scenarios for report testing, ensuring adequate depth and breadth of test coverage
  • Understand the requirements from technical and business specifications
  • Interrogate tables in different RDBMS databases: DB2, MySQL, SQL Server SSIS Staging and Datastore DBs, Redshift DB
  • Data preparation, data loads for journaling or ETL and processing in test environments
  • Carry out end-to-end, data completeness and quality, regression testing, including standard data validation and ensure data maintains integrity at all stages of transformation (ETL) and data flow
  • Data reconciliation in BI reports by means of reports comparison and by executing SQL queries
  • Work closely with the cross functional DWH team, liaise with the team to resolve problems or further fulfil user requirements
  • Actively support Agile development methods and best practices
  • Contribute to the overall test strategy with ideas of tools and technologies, including the use of automated testing
  • Using JIRA to track defects and tasks
  • Take part in meetings, provide estimates, assist in presenting issues and solutions both orally and in writing
  • Assist business test team in UAT

Requirements

  • Minimum of 3 years of Software Testing experience within SDLC, preferably in an agile or iterative development environment
  • Data Warehouse (DWH), ETL and BI testing experience
  • Strong experience of relational databases and SQL, ability to write involved SQL queries to extract and interrogate data
  • Proficiency in Excel usage
  • Ability to work with complex calculations for different metrics
  • Solid understanding of software testing concepts and methodologies
  • Hands-on experience of test planning, execution and maintenance of test scenarios
  • Experience in defining functional and non-functional testing frameworks
  • Test automation experience
  • Understanding of risk identification and analysis
  • Great communication skills
  • Excellent problem solving skills and attention to detail

Desirable 

  • Experience with AWS technology, MicroStrategy BI reporting tool
  • Knowledge of JIRA, Confluence
  • ISTQB qualifications

 

Benefits

  • Training on application
  • Access to training for self-development
  • Be part of a dynamic team
  • Floating holidays
  • Flexible benefits basket
  • Fresh fruits and beverages
  • Fun PS4 games and various team bounding and team building programs
  • Attractive compensation scheme

About the client

Universal Music Group is the world’s leading music company and the home for music’s greatest artists, innovators and entrepreneurs. They own and operate a broad array of businesses engaged in recorded music, music publishing, merchandising, and audiovisual content in more than 60 countries.

Join our team! Apply here!

 

About the Author

Leave a Reply