Summary
Overview
Work History
Education
Skills
Timeline
Generic

Damanjit Singh

Hopkins,MN

Summary

Result Oriented and innovative ETL Test Engineer with almost 10 years for experience working in various industries. Involved in variety of data integration projects including but not limited to On premises to cloud migration, Source system upgrade, Data Warehouse and Operational Data Store implementation. Excellent leadership record of leading testing efforts in enterprise-wide development projects.

Overview

11
11
years of professional experience

Work History

ETL QA Analyst

Allianz Life Insurance Company Of North America
Minneapolis, MN
02.2018 - Current
  • Prepared and Executed Test Scripts for the mappings developed through Informatica and Azure Data Factory ETL tools.
  • Wrote complex SQL queries for source to target testing of Data Warehouse, Operational Data Store and date feeds to Enterprise Operation systems (SAP, Peoplesoft and Salesforce).
  • Web based services testing using Ready API.
  • Created CI pipelines in Azure Dev Ops to automate post deployment testing
  • Automated ETL testing using Query Surge tool.
  • Wrote scripts to execute workflows through batch job scheduling tools i.e. CA workload Automation
  • Worked closely with Enterprise QA Automation team to develop a framework for Test Data Management and seeding of data in source systems.
  • Facilitated End to End testing for business stakeholders.
  • Created Master test plan and review testing approach with Project Stake holders, Data Services team, Business Analyst to identify dependencies and make changes where it is necessary.

ETL Tester

Taylor Corporation
Minneapolis, MN
03.2016 - 02.2018
  • Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
  • Tested reports based on the statistical analysis of the data from various time frame and division using SQL Business Objects.
  • Worked with Data Conversion projects for testing data quality after migration.
  • Ensured Error logs and audit tables are generated and populated properly
  • Performed Web based services testing using Fiddler and Ready API. Facilitated Client Acceptance Testing on new implementations
  • Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Performed production reconciliation before the deployment of the developed application to the production systems to ensure that the data is being processed efficiently and to test the correctness of the data.

Associate Consultant, Technology

Magenic Technology
Minneapolis, MN
07.2014 - 03.2016
  • Build extract, transform and load (ETL) process to migrate data from multiple types of data sources (SQL Server, DB2, Oracle, Flat files etc.) to destination database Server using Informatica
  • Created and maintained data flow diagrams for existing and future ETL processes.
  • Involved in the Informatica up-gradation testing to make sure that the existing, updated and new workflows are working as expected when migrated to Informatica from Informatica 8.6. Created and documented the test plan for the same.
  • Created and maintained data flow diagrams for existing and future ETL processes.
  • Understood Business Requirement Document (BRD) and Data Mapping Document (DMD) and implement data transformation methodologies.

QA Analyst

Softech International
Minneapolis, MN
06.2013 - 07.2014

Involved in Testing of online booking engine for booking international and domestic tickets. This project uses SABRE’s proprietary software called Databahn to connect to their database and get the fares. The customers can research the fares, check the availability and then book the fares.

  • Writing and executing of test plans, test cases based on the business requirements of the web application.
  • Performed Functional, Integration, System and Regression Testing
  • Used Quality Center for writing and managing the test cases and reporting the bugs
  • Performed GUI and DB testing.

Education

Bachelor of Science - Computer Science

LIT
India

Skills

ETL Tools - Azure Data Factory, Informatica, Microsoft- SQL Server Integrated Services

API Testing - Ready API, Fiddler, Postman

Automation Testing - Selenium, Test Complete

Languages - SQL, Python, JavaScript, C#, HTML, XML, JSON

Defect/Test Management Tools - Quality Center, Test Rails, JIRA, Polarion, TFS

Databases - MS SQL Server, Snowflake, Oracle 9i/10g, IBM DB2

Schedulers - CA Workload Automation, Rundeck, Autosys

Timeline

ETL QA Analyst

Allianz Life Insurance Company Of North America
02.2018 - Current

ETL Tester

Taylor Corporation
03.2016 - 02.2018

Associate Consultant, Technology

Magenic Technology
07.2014 - 03.2016

QA Analyst

Softech International
06.2013 - 07.2014

Bachelor of Science - Computer Science

LIT
Damanjit Singh