Senior Etl Tester

Must Have: ETL Testing, Python/Pyspark for automation and SQL (advance SQL)

Skills and attributes for success

• 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 SQLs 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