Anugya Dubey

Background

About Anugya Dubey

Total 9 years of IT experience, including 2+ years of experience as ETL Test Lead and 6+ years ETL Tester, with the strong focus on the Logistics, Telecom and Banking domain. • Currently playing the role of ETL Test Lead along side business Analyst. • Extensive experience in ETL/Data warehouse backend testing and BI report testing using databases like Snowflake, SQL Server, and Hive and BI tool like Power BI. • Experience in leading and managing testing team working in offshore model, distributing/gathering tasks and providing status updates to stakeholders in scrum meetings. • Strong understanding of DWH concepts, Fact tables, Dimension tables, Star schema, Snowflake schema, ETL designs. • Delivery of Testing needs for Cloud Projects. • Worked as cloud tester in Azure (ADF, Azure Synapse, Azure Databricks) • Responsible for preparing the test artifacts like QA test plan, Test strategy, daily status report, test sign off, test case, using complex SQL queries to validate transformation logic. • Experience in data migration project from on-premises to cloud(Azure) platform. • Automated tasks with Python, reducing regression time. • Strong DWH testing experience within Waterfall and Agile environment. • Developed and maintained CI/CD pipelines using tools like GitLab CI to automate build, test, and deployment processes. • Experience in data analysis, data profiling, data cleansing and data mapping for ETL processes. Creating FRD or mapping sheets with SQL transformations, user stories in an Agile environment. • Collaborate with stakeholders, business users, and upstream users to resolve issues, provide information for clarification, and updating confluence as needed. • Client Engagement for end-to-end project delivery. • Managing and collaborating with Business and Technology Team.