- Delivery of Testing needs for BI & DWH Projects.
- Ability to effectively communicate with team members across geographies effectively
- Perform unstructured data / big data testing both in on-premise and cloud platform.
- Thorough understanding of Requirements and provide feedback on the requirements.
- Develop Test Strategy for Testing BI & DWH Projects for various aspects like ETL testing & Reports testing (Front end and Backend Testing), Integration Testing and UAT as needed. Provide inputs for Test Planning aligned with Test Strategy.
- Perform Test Case design, identify opportunity for Test Automation. Develop Test Cases both Manual and Automation Scripts as required.
- Ensure Test readiness (Test Environment, Test Data, Tools Licenses etc)
- Perform Test execution and report the progress. Report defects and liaise with development & other relevant team for defect resolution.
- Prepare Test Report and provide inputs to Test Lead for Test Sign off/ Closure
- Provide support in Project meetings/ calls with Client for status reporting.
- Provide inputs on Test Metrics to Test Lead. Support in Analysis of Metric trends and implementing improvement actions as necessary.
- Handling changes and conducting Regression Testing
- Generate Test Summary Reports
- Co-coordinating Test team members and Development team
- Interacting with client-side people to solve issues and update status
- Actively take part in providing Analytics and Advanced Analytics Testing trainings in the company
To qualify for the role, you must have
- BE/BTech/MCA/M.Sc
- Overall 2 to 9 years of experience in Testing Data warehousing / Business Intelligence solutions, minimum 2 years of experience in Testing BI & DWH technologies and Analytics applications.
- Experience in Bigdata testing with Hadoop/Spark framework and exposure to predictive analytics testing.
- Very good understanding of business intelligence concepts, architecture & building blocks in areas ETL processing, Datawarehouse, dashboards and analytics.
- Experience in cloud AWS/Azure infrastructure testing is desirable.
- Knowledge on python data processing is desirable.
- Testing experience in more than one of these areas- Data Quality, ETL, OLAP, Reports
- Good working experience with SQL server or Oracle database and proficiency with SQL scripting.
- Experience in backend Testing of Enterprise Applications/ Systems built on different platforms including Microsoft .Net and Sharepoint technologies
- Experience in ETL Testing using commercial ETL tools is desirable. Knowledge/ experience in SSRS, Spotfire (SQL Server Reporting Services) and SSIS is desirable.
- Experience/ Knowledge in Data Transformation Projects, database design concepts & white-box testing is desirable.
Ideally, you ll also have
- Able to contribute as an individual contributor and when required Lead a small Team
- Able to create Test Strategy & Test Plan for Testing BI & DWH applications/ solutions that are moderate to complex / high risk Systems
- Design Test Cases, Test Data and perform Test Execution & Reporting. Should be able to perform Test Management for small Projects as and when required
- Participate in Defect Triaging and track the defects for resolution/ conclusion
- Experience/ exposure to Test Automation and scripting experience in perl & shell is desirable
- Experience with Test Management and Defect Management tools preferably HP ALM
- Good communication skills (both written & verbal)
- Good understanding of SDLC, test process in particular
- Good analytical & problem solving or troubleshooting skills
- Good understanding of Project Life Cycle and Test Life Cycle. Exposure to CMMi and Process improvement Frameworks is a plus. Should have excellent communication skills & should be able to articulate concisely & clearly
- Should be ready to do an individual contributor as well as Team Leader role
