QA Tester SAP HANA BI/BW with SQL

This role requires the candidate to perform quality assurance and data analytics/reporting activities in the Business Intelligence space. Particular focus towards data quality and validity for an enterprise 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.

• Working experience in ETL testing including Data Completeness and Data Quality for various data feeds coming from the source
• Experience in Data Warehousing / data validation testing
• Must have strong SQL coding and debugging skills
• Working knowledge of SQL and relational databases (eg. SAP HANA or SQL Server)
• Good knowledge Data Warehousing concepts
• Experience in creating Stored Procedures, Functions, Tables & handling big data
• Experience on working of Joins, Subqueries, and complex query writing skills
• Responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in tables.
• Advanced experience in Microsoft Excel
• Extensive experience in writing and troubleshooting SQL Queries
• Perform SQL validation to verify the data extracts in the database tables by writing SQL queries
• Strong analytical and problem solving skills
• Work experience with SQL Databases such as SAP HANA and SQL Server with advanced SQL skills

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

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

• 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