Damanjit Singh

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

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

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

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.