Noorin Fatima
Data Assurance Lead
Bengaluru
Summary
Experienced IT professional with over 11+ years of expertise in ETL processes, data engineering, and analytics, with proficiency in Azure Service, Databricks, PySpark, SQL, PL/SQL, and Power BI. Skilled in designing high-performance ETL pipelines, automating testing processes, and creating Power BI dashboards, I thrive on delivering innovative, data-driven solutions across diverse domains like Oil & Gas, Hospitality, Telecom, and Retail. Proven track record of driving results, including the development of robust data quality checks for daily ingestion using PySpark and Azure, and collaborating with senior architects to implement scalable solutions. I excel at integrating Agile methodologies into projects, ensuring timely deliverables and seamless communication with stakeholders. An analytical thinker with a hands-on approach, I have led initiatives to improve data integrity, and enhance reporting, consistently aligning with business goals. My ability to adapt to complex challenges, guide teams, and foster collaboration makes me an asset in any organization. Passionate about leveraging technology to unlock new opportunities and improve efficiencies, I am always eager to learn, grow, and contribute to transformative projects. Experienced with quality assurance processes and leading QA teams. Utilizes advanced testing methodologies to ensure product integrity. Track record of identifying critical issues and implementing effective solutions.
Overview
12
12
years of professional experience
10
10
Certifications
4
4
Languages
Work History
Lead Quality Assurance Specialist
Shell India Market PVT. LTD
09.2022 - Current
- Currently serving as a project ETL Lead, managing and mentoring a team of 11 members with a focus on quality deliverables and efficient task allocation.
- Extensive experience in gathering and analyzing requirements through collaboration with cross-functional teams, including source teams, business analysts, data engineers, and business stakeholders.
- Spearheading solutions for new feature implementation and process enhancement while conducting detailed risk and impact analyses.
- Designed and developed a reusable, automated test suite to validate data completeness and accuracy across various source systems within similar target architectures.
- Automated pipelines in Azure Data Factory, integrating SFTP sources with Azure Data Lake Storage (ADLS), ensuring seamless data processing.
- Proficient in system testing, integration testing, end-to-end testing, regression testing, and smoke/sanity testing across multiple iterations and sprints.
- Actively participating in planning, grooming, and estimation sessions to ensure team alignment and successful project execution.
- Delivering project overviews and task assignments to the team, providing guidance, and reviewing work to maintain quality within estimated timelines.
- Reduced software bugs by thorough identification and documentation of issues in the development phase.
- Optimized test automation frameworks, leading to a more efficient and effective testing process.
- Participated in agile development sprints as an active member of Scrum teams, contributing insights from a QA perspective throughout each sprint cycle.
Quality Assurance Specialist
Accenture Solution PVT LTD
Bengaluru
06.2021 - 08.2022
- Worked in gathering requirement and creating Test approach, Test Plan, Test Scenarios, Test cases, Test results, and maintain Test deliverables in SharePoint, VSTS
- Acquired knowledge on ADF, ADLS and Databricks and shared the same with the team.
- Worked on ETL process to ensure if ADF jobs are working as per requirement, validated if data stored in ADLS meets business rules and logic
- Validated data loaded in azure platform through Databricks using pyspark and sparksql.
- Performed system testing, integration testing, end to end testing, Regression Testing, smoke/sanity testing in various iteration/sprints.
- Provided UAT support by validating UAT scenarios provided and shared results with respective team.
- Created an automated script to validate data flow from source to target by passing few parameters which proved to be a time saving one.
- Provided Estimation on behalf of QA team for all the QA work
- Provided Team with overview of the project and assigned work and helped team to carry out respective task within estimated time
- Provided Testing demo to respective stakeholders.
- Used VSTS for storing, maintaining the test repository, bug tracking and reporting.
- Participated in regular scrum calls, project status meetings and QA status meetings and also helped in providing estimate for each resource
- Created test closure Report to ensure testing phase is successfully completed with the business exit criteria for the project.
- Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
- Optimized test automation frameworks, leading to a more efficient and effective testing process.
- Managed multiple projects simultaneously, prioritizing tasks effectively to achieve project goals on schedule.
- Mentored junior QA specialists, fostering a culture of continuous learning and professional growth.
Senior Software Engineer
Wipro
04.2019 - 06.2021
- Joined account as one of the first resource for a Migration project. The project was to migrate existing ELT process from SAS platform to Azure platform. During the process acquired understanding of the project by connecting to different stakeholders and gathered knowledge on azure platform (ADF, ADLS and Databricks).
- Worked in gathering requirement and creating Test approach, Test Plan, Test Scenarios, Test cases, Test results, and maintain Test deliverables in SharePoint, VSTS
- Acquired knowledge on ADF, ADLS and Databricks and shared the same with the team.
- Worked on ETL process to ensure if ADF jobs are working as per requirement, validated if data stored in ADLS meets business rules and logic
- Validated data loaded in azure platform through Databricks using pyspark and sparksql.
- Performed system testing, integration testing, end to end testing, Regression Testing, smoke/sanity testing in various iteration/sprints.
- Provided UAT support by validating UAT scenarios provided and shared results with respective team.
- Created an automated script to validate data flow from source to target by passing few parameters which proved to be a time saving one.
- Provided Estimation on behalf of QA team for all the QA work
- Provided Team with overview of the project and assigned work and helped team to carry out respective task within estimated time
- Provided Testing demo to respective stakeholders.
- Used VSTS for storing, maintaining the test repository, bug tracking and reporting.
- Participated in regular scrum calls, project status meetings and QA status meetings and also helped in providing estimate for each resource
- Created test closure Report to ensure testing phase is successfully completed with the business exit criteria for the project.
- Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
Software Engineer
Tangoe India Softek Service Pvt Ltd
10.2018 - 03.2019
- Working as an ETL Tester for Telecom Expense Management Domain.
- Understand the requirements, create SQL Queries to validate E2E data flow in the target tables.
- Running the jobs/Workflows for ETL process and Extract files from Tables and load to different application and validate.
- Support UAT testing.
Senior Software Engineer
Accenture Solution Pvt Ltd
01.2014 - 07.2018
- Exposure to work on Datawarehouse and other down steam applications containing Reservations,Sales,customer relation details.
- Interacted with developers, business & management teams to understand the various project\business requirements and analysis the requirements to prepare Test Approach, Test Plans, Test Scenarios ,Test cases and Testing Strategies for Data Warehousing Application ensuring accurate coverage of requirements and business processes.
- Performed system testing, integration testing, end to end testing, Regression Testing,smoke/sanity testing in various iteration/sprints.
- Provided UAT support.
- Created SQL queries to validate E2E data flow between source and target data warehouse tables(dimension and facts) and files and various downstream applications(e.g: reports) .To endure data model, Data quality,correct data aggregations, duplicate and null values check, truncated values and ensuring data loaded as per the requirement .
- Tested a number of complex PL/SQL procedures, ETL mappings, mapplets and reusable transformations for daily/monthly data loads.
- Developed PL/SQL procedure to compare and count data between different databases
- Validated BI reports data and cosmetic of the reports: Dashboards, Cube based report, FFSQL based reports (grids and graph).
- Used HP Quality Centre (ALM), JIRA for storing, maintaining the test repository, bug tracking and reporting.
- Participated in regular scrum calls, project status meetings and QA status meetings and also helped in providing estimate for each resource.
- Created test closure Report to ensure testing phase is successfully completed with the business exit criteria for the project.
- Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
- Monitoring and assigning work to fellow resources and send consolidated status report to all the stakeholders.
Education
B-Tech - Electronics and Communication Engineering
West Bengal University of Technology
01.2013
12th - Science stream
Ramanuj Gupta Jr. College
Silchar, Assam10th - undefined
Silchar Collegiate School
Silchar, Assam01.2007
Skills
ETL Tools: Informatica 91/961, Azure (ADF, ADB and ADLS)
BI Tools: MicroStrategy 9/10, Power BI
Database: Oracle, SQL Server, Azure SQL
undefinedCertification
ISTQB Foundation and Test Analyst Certified.
Interests
Cooking, Listening to Music
Timeline
Lead Quality Assurance Specialist
Shell India Market PVT. LTD
09.2022 - Current
Quality Assurance Specialist
Accenture Solution PVT LTD
06.2021 - 08.2022
Senior Software Engineer
Wipro
04.2019 - 06.2021
Software Engineer
Tangoe India Softek Service Pvt Ltd
10.2018 - 03.2019
Senior Software Engineer
Accenture Solution Pvt Ltd
01.2014 - 07.2018
10th - undefined
Silchar Collegiate School
B-Tech - Electronics and Communication Engineering
West Bengal University of Technology
12th - Science stream
Ramanuj Gupta Jr. College
Similar Profiles
Nandhini C RNandhini C R
Distribution & Scheduling Support - T&S at Shell India Market Pvt LtdDistribution & Scheduling Support - T&S at Shell India Market Pvt Ltd
Surya Theja SreekakulamSurya Theja Sreekakulam
SAC Solution Architecture at Shell India Market PVT LTDSAC Solution Architecture at Shell India Market PVT LTD
Naseer AnjumNaseer Anjum
Senior security and compliance advisor at Shell India Market Pvt LtdSenior security and compliance advisor at Shell India Market Pvt Ltd
Vishnu Putri SVishnu Putri S
Secondary French Teacher at Ebenezer International SchoolSecondary French Teacher at Ebenezer International School
Shruthi NandakumarShruthi Nandakumar
Senior Research Fellow at Defence Reasearch & Development OrganisationSenior Research Fellow at Defence Reasearch & Development Organisation