Sonal

m1551sonal@[Link]

Professional Summary

 Around 10+ years of IT experience in the ETL/BI Testing, QA testing, Data Warehouse Testing, Database Testing and Data
Management, Data Governance, Data Analysis, Data Quality, Data integration, Data Validation, Data Migration implementa-
tion of Business Intelligence solutions using Quality Assurance
 Solid Back End Testing experience by writing and executing SQL Queries
 Responsible for Database (SQL) testing, performing functional, system, testing for major Power BI Gateway releases.
 Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC)
with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
 Worked with technologies like WSDL, SOAP, SOAP UI, XML, XPath and Web Services
 Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
 Hands on experience in using Autosys scheduling.
 Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory
 Worked in Agile team testing the application in Scrum methodology
 Written SQL scripts to test the mappings and extensively used Cognos for report generation
 Having strong knowledge on implementing quality techniques using Informatica Data Quality
 Extraction of test data from tables and loading of data into oracle tables using SQL.
 Creation of test data and Automation of test cases for system and analyzing bug tracking reports
 Automated and scheduled the Informatica jobs using UNIX Shell Scripting
 Experience in UNIX shell scripting and configuring Cron-jobs for ETL Loads
 Expert in connecting multiple data sources in Power BI to implement working reports.
 Implemented QA processes and methodologies focusing on data quality assurance using IDQ.
 Performed UI and API testing using Cypress and created from framework from the scratch.
 Extensively strong on databases including Oracle, MS SQL Server, and Teradata
 Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
 Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing,
Regression Testing and Acceptance Testing
Technical Skills:
Languages: SQL, PL/SQL, C JavaScript, Shell Scripting
Databases: Oracle, MS SQL Server, MS Access, Teradata, DB2, Informix
Reporting Tools: Business Objects, Cognos, Crystal Reports, MicroStrategy, SSRS
Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy
Operating Systems: Windows, UNIX
Tools: MS-Office suite (Word, Excel, Project and Outlook)
Testing Tools: Quality Center, Quick Test Professional, Performance Center,
ETL Tools: Informatica, DataStage, Ab Initio, SSIS

Professional Experience:
Invesco, California May 2022 to Till Date
Lead ETL/QA Tester

Environment using Informatica, snowflake, Airflow DAGS, data validation, CI/CD, UAT, KPI, Api, Agile/Scrum, data pipelines, SQL
Server, UNIX.S

Responsibilities:

 Prepared test data based on data mapping document.

 Prepared the guides for UAT & Production readiness for entire Manual testing efforts
 Provided Reports for Rest API testing.
 Tested many features in an agile environment using.
 Experience in Azure snowflake
 Experienced in creating directed acyclic graphs (DAGs) to orchestrate complex data pipelines for ETL processes.
 Extensive experience with KPIs, Performance measurement, and quality controls for testing teams.
 Have experience testing REST API with applications using SOAP UI and Postman
Sonal
m1551sonal@[Link]

 Strong experience in Business and Enterprise Data warehouse analysis.

 Use of Airflow tool to automate the ETL process.
 Validating Airflow DAGS
 Involved in Test Planning, Test Data Management, Defect Management.
 Expertise Shell Scripting experience on UNIX, Linux and Windows environment
 Good understanding of data flow in the different modules of Oracle Application.
 Created and tracked Bugs using Azure DevOps using best practices
 Involved in the coordination of UAT cycles and coordination of users.
 Created Snowflake test plan and test strategy
 Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.
 Ensured that the mappings are correct and Conducted data validation testing
 Defined SLA metrics and KPI standards for in-house and SAAS applications.
 Wrote data conversion and data migration scripts for ETL process
 Extensively used Informatica power center for extraction, transformation and power loading process.
 Creating and uploading test cases, test plan cycle and defects in JIRA.
 Identify business rules for data migration and Perform data validations
 Testing of Spark, Big Query, Airflow DAGs and Kafka streaming
 Written several complex SQL queries for testing Tableau Reports
 Responsible for Test Data Management for Data Generation, Data Sub-setting, Data Masking
 Promoted Unix/Informatica application releases from testing to QA and UAT environments.
 Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.

Albertsons, California Dec 2021 to May 2022

Lead ETL/QA ester

Environment: Jira, power bi, Informatica, Airflow DAGS, snowflake, data validation, KPI, QTP/UFT, Agile, SQL Server, data pipelines,
UI, UNIX.

Responsibilities:

 Migrating an entire oracle database to Big Query and using of power bi for reporting.
 Have experience in validating the business transformations by writing complex SQL queries.
 Executing and validating the source and the target files.
 Experience in implementing and tracking testing Key Performance Indicators (KPI).
 Designed and executed the Automation Test Scripts using WebDriver and Junit.
 Tested the ETL DataStage and other ETL Processes (Data Warehouse Testing).
 Used T-SQL for Querying the SQL Server database for data validation and data conditioning
 Involved and experience in working with both agile and waterfall methodologies.
 Publishing Power BI reports on dashboards in Power BI server
 Using Azure test plan to run test cases from test suite.
 Data pipelines running on Google Cloud Platform (GCP) to ensure data accuracy, integrity, and consistency.
 Skilled in configuring Airflow DAGs to schedule and monitor ETL jobs, ensuring optimal performance and reliability.
 Involved creation of extended dimension modeling tables in snowflake
 Involved in ETL processes using Ab Initio and Informatica Power Center.
 Developed Test cases for the data warehouse in Teradata System
 Good working experience in Oracle, Unix Shell Scripting
 Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
 Tested the ETL DataStage and other ETL Processes (Data Warehouse Testing).
 Applied test automation framework on CI/CD process.
 Participated in testing, produced KPI 's which regulate the business processes in our company
 Performed UI, Web Services (API) and database application testing.
 Experienced in testing Expertise in ETL Verification, Power BI reports.
 Providing feedback and recommendations for optimizing ETL processes, data pipelines, and data quality.
 Developed test plans, test cases and test scripts for data validation testing.
 Wrote and edited test cases in TestRail web-based test management system
Sonal
m1551sonal@[Link]

 Managed and executed the test process, using Agile Methodology.

 Competent in defining tasks within Airflow DAGs, including data extraction, transformation, and loading tasks.
 Involved in backend testing using SQL Queries in Teradata data base.
 Performed web service, API testing by using Postman and Soap UI.
 Developed test scripts and Regression Testing.

Baxter Health, Chicago, IL Jan 2021 to Dec 2021

ETL/Data QA SQL Tester

Environment: Informatica, UNIX, BI, CI/CD, SAP HANA, AWS, Azure, Jira, API, QTP/UFT, Agile

Responsibilities:

 Prepared test data based on data mapping document.

 Have experience in validating the business transformations by writing complex SQL queries.
 Involved in ETL process testing using Informatica ETL tool.
 Testing OBIEE Reports and dashboards functionality
 Worked on DevOps tool Chef in provisioning AWS machines.
 Created bugs using JIRA as a result of regression, cross browser and backend testing
 Onsite/offshore coordination on daily bases.
 Validate the business functionality using UAT Testing
 Tested whether the reports developed in Tableau is as per company standards.
 Tested ad hoc and canned reports for Business objects
 Expert in creating multiple kinds of Report in Power BI and presented them using Story Points.
 Coordinating data movement and validation with third party vendors.
 Tested data migration to ensure that integrity of data was not compromised
 Involved in Teradata SQL Development, Unit Testing and Performance Tuning
 Managed and executed the test process, using Agile Methodology.
 Involved in web services testing using SOAP UI, validated request and response XML.
 Strong Informatica and data loading experience
 Experience in testing of ETL solutions on AWS environment.
 Created UNIX scripts for file transfer and file manipulation
 Tested the Tableau reports and compare the data in database
 Good Experience in Testing ETL Packages which are developed in Talend and Informatica
 Actively participate in production deployment check-out activities and communication.

Bravo Health, Baltimore, MD Oct 2018 to Dec 2020

ETL BI SQL Tester

Environment: Informatica, Power Bi, SQL, PL/SQL, API, UAT, HIPPA, UNIX, Autosys, QTP/UFT, Jira, MS Excel, Agile, XML, XSD, XSLT,
XML Spy

Responsibilities:

 Created complex SQL queries for querying data against different data bases for data verification process.
 Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
 Tested new Data migration tool used in the mapping of data to new system.
 Data migration of raw data to excel documents for clients
 Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
 Written extensive UNIX Shell scripting for error logging, cleanup, data archiving& job scheduling
 Tested Business Objects reports and Web Intelligence reports
 Knowledge of HL7 standards and HIPPA regulations
 Develop the GDPR method for data anonymization.
 Tested Power BI reports and dashboards from multiple data sources using data blending.
 Interacted with several Investment banks to support UAT testing for them
Sonal
m1551sonal@[Link]

 Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
 Prepared reusable function in QTP/UFT to use across the automation scripts.
 Tested the functionality and performance of web services using SOAP UI.
 Worked on issues with migration from development to testing
 worked on burned down chart and burned up chart in Jira
 Involved in recording change requests on the Change Requests.
 Followed the HIPAA implementation guides for preparing the EDI files.
 Created data-driven tests in SOAP UI Pro using the Data Source feature.
 Involved in various testing phases like Integration Testing, System Testing.
 Developed complex queries to test the reports developed.
 wrote SQL queries against Snowflake
 Effectively tracked and reported bugs using Jira
 Involved in testing the XML files and checked whether data is parsed and loaded to staging table
 Tested the data and data integrity among various sources and targets.

Bank of America, Charlotte, NC Mar 2016 to Sep 2018

ETL BI SQL Tester

Environment: Informatica, XML, XSLT, XPath, XQuery, UAT, SQL Server, Business Objects, Jira, Oracle, PL/SQL

Responsibilities:
 Involved in understanding Logical and Physical Data model using Erwin Tool
 Prepared the guides for UAT& Production readiness for entire ETL testing efforts.
 Validate the business functionality using UAT Testing
 Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
 Worked with business analyst and developers in setting up test data
 Executed test cases and logged defects using JIRA.
 Participate in planning and execution of QA/UAT testing.
 Has testing experience in Informatica Power Center and Data Stage application.
 Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
 Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
 Used T-SQL for Querying the SQL Server database for data validation and data conditioning
 Involvement extensively in User Acceptance Testing (UAT).
 Tested the Business Objects Web I Reports are created and deployed through Info View
 Used SQL tools to run SQL queries and validate the data loaded in to the target tables
 Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
 Involved in user training sessions and assisting in UAT (User Acceptance Testing)
 Monitored the workflow transformations in Informatica work flow monitor
 Preparing manual test cases and test data for Scenarios
 Experience in User Acceptance Testing (UAT) of various web / client server applications.
 Performed end-to-end testing of applications and coordinated with other teams.
 Created and executed Test scripts for system validation and user acceptance testing (UAT)
 Created ETL execution scripts for automating jobs
 Involved in extensive DATA validation using SQL queries and back-end testing

Citizens Bank, Providence, RI Sep 2015 to Feb 2016

ETL Tester

Environment: Informatica, Business Objects, SQL, SQL Server, PERL, UAT, XML, XSLT, XML Spy, UNIX, Shell Scripting, QTP, Quality
Center

Responsibilities:
 Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for docu-
menting functional requirements and supplementary requirements in Quality Center
 Created test data for testing specific Membership functionality
Sonal
m1551sonal@[Link]

 Analyzed SQL code to ensure Business Objects queries the correct data from the database
 Used PERL for automating all the types of modules at a time
 Promoted Unix/Informatica application releases from testing to QA and UAT environments.
 Worked with PERL control structures & Regular Expressions for substitutions based on matches
 Extraction of test data from tables and loading of data into SQL tables
 Used PERL for automating all the types of modules at a time
 Involved in ETL processes using Ab Initio and Informatica Power Center.
 Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
 Validating the data passed to downstream systems
 Worked with data validation, constraints, source to target row counts
 Developed automated Test Scripts using QTP
 Involved in completing data testing before the UAT.
 Used data conversion to Protect the data and prevent data loss
 Created macros to automate the process of refreshing the data in MS Access
 Prepared a UAT, UI, Functional, and Final Regression Testing Plan and tested.
 Provided technical support and coaching to team members about functionality of MS Access
 Worked with Data Extraction, Transformation and Loading (ETL)
 Involved in testing the UI applications
 Used Quality Center to track and report system defects
 Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Soft Sol, Hyderabad, India Jun 2013 to Jun 2014

ETL Tester

Environment: PERL, UNIX Shell Scripting, Oracle, Informatica Power QTP, Cognos, SQL Server, Windows, TOAD, PL/SQL

Responsibilities:
 Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
 Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL
mapping document
 Written complex SQL queries for querying data against different data bases for data verification process
 Performed UAT testing
 Designed the data flow diagrams using VISIO
 Prepared the Test Plan and Testing Strategies for Data Warehousing Application
 Preparation of technical specifications and Source to Target mappings
 Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
 Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
 Written several complex SQL queries for validating Cognos Reports
 Worked with business team to test the reports developed in Cognos
 Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
 Extensively used Informatica power center for extraction, transformation and loading process
 Creating test cases for ETL mappings and design documents for production support
 Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
 Scheduling and automating jobs to be run in a batch process
 Effectively communicate testing activities and findings in oral and written formats
 Reported bugs and tracked defects using Test Director