SAP HANA BI/BW QA Tester at Expleo Group

This role requires the candidate to perform testing activities for implementation of successful business solutions, defect fixes and system enhancements in the Business Intelligence stream for a retail client. Particular focus towards data quality and validity for a SAP BW system will require the candidate to have strong SQL skills and a good understanding of various data flows to also contribute innovative ways to enable efficient and reliable data testing services.

Responsibilities

• Responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in tables.

Qualifications

• Graduate/Post Graduate(BSc, or equivalent professional qualification) in IT, Computer Science, Engineering or related disciplines

Skills

• Strong analytical and problem solving skills
• Ability to communicate with senior executive level stakeholders

Experience

• Working experience in ETL testing including Data Completeness and Data Quality for various data feeds coming from the source
• Experience in Data Warehousing / BI Testing
• Working knowledge of SQL and relational databasesWorking experience with developers, support, offshore/onshore for various testing activities including test case/script writing, clarification, data load, etc
• Good understanding of various data models
• Good knowledge Data Warehousing concepts
• Experience in creating Stored Procedures, Functions, Tables & handling big data
• Experience on working of Joins, Subqueries, CTEs and complex query writing skills
• Using data analytics tools to validate data such as Eclipse, SAP Analysis for Office
• Advanced experience in Microsoft Excel
• Extensive experience in writing and troubleshooting SQL Queries
• Develop automated test scripts for testing ETL, Data warehouse and BI layers
• Perform SQL validation to verify the data extracts in the database tables by writing SQL queries
• Design and execute test cases to verify functionality, data integrity, security and overall usability of the solution
• Provide Test Metrics, reports and schedules for Automation & Manual test activities
• Work experience in SAP BW testing/development roles
• Work experience with SAP HANA and SQL Server with advanced SQL skills
• Experience in ERP systems