- 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)
- Coordinate testing efforts with cross-functional teams, including ETL developers, data engineers, business analysts, and project managers, to ensure testing aligns with project timelines and objectives
- Establish and enforce data quality standards, data profiling, and data cleansing procedures to maintain high-quality data.
- Delivery of Testing needs for BI & DWH Projects.
- Perform unstructured data / big data testing both in on-premise and cloud platform.
- Thorough understanding of Requirements and provide feedback on the requirements.
- 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 Manager/ Lead for Test Sign off/ Closure
- Provide support in Project meetings/ calls with Client for status reporting.
- Provide inputs on Test Metrics to Test Manager/ 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 in order to resolve the issues
- Interacting with client-side people to solve issues and update status
- Able to lead team across geographies
- 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 5-8 years of experience in Testing Data warehousing / Business Intelligence solutions, minimum 3 years of experience in Testing BI & DWH technologies and Analytics applications.
- Strong in Data warehouse testing - ETL and BI and having exposure to the reporting tools such as Cognos/PowerBI/Tableau/Qlik etc
- Exposure to one or more ETL tools such as Informatica, SSIS, SAP Data services, AWS Glue, Azure Data factory
- Strong SQL skills with experience in writing complex data validation SQL s on databases like Oracle/ SQL Server/ Teradata / Snowflake/Postgres/Redshift
- Proficiency in data services of any leading cloud providers like AWS, Azure, GCP and thorough knowledge on data platforms like Databricks, Azure synapse
- Validate data integrity and consistency across various stages of ETL pipelines.
- Experience in master data management (MDM) is added advantage
- Working experience with python data processing is desirable.
- Work with cross-functional teams to ensure that ETL solutions meet business needs and quality standards.
- Experience in Bigdata testing with Hadoop/Spark framework and exposure to predictive analytics testing is desirable
Ideally, you ll also have
- Experience in Performance & Load Testing for backend systems is preferred. Exposure to Performance Tuning (Tuning concepts - indexes, segments, partitions, query tuning) of database systems would be an added advantage.
- Experience/ exposure to Test Automation and scripting experience in perl & shell is desirable
- Experience with Test Management and Defect Management tools preferably HP ALM
- 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
- 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
