Somendra Nath Mukherjee

¨ Builds Data architecture to implement test data management strategies leveraging Data Integration, Data Quality, and Data Governance for various stakeholders across portfolio.
¨ Defined best practices to setup and configure TDM environments.

¨ Architect custom solutions to overcome the Informatica limitations while processing mainframe datasets.
¨ Ability to administers the Informatica system and upgrade to new releases.
¨ Integration & Automation of TDM processes with DevOps tools such as TeamCity & CAWLA.

¨ Deployed and managed cloud infrastructure on Azure using Terraform, GitHub Actions and Jenkins pipelines to ensure smooth deployment processes.

¨Develop scalable data pipelines using Azure Databricks and Apache Spark technologies.

¨Implement data lake solutions leveraging Delta Lake for efficient data storage.

¨ Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.

¨ Analysis and Management of Test Data to be used for Testing across the flow.

¨ Involved in complex query preparation to pull data from production to qa environment and to generate test data for functional, regression and E2E testing.

¨ Conducting Functional, regression and E2E to ensure defect free release.

¨ Defect Reporting and Metric Analysis.

¨ Testing of Post production change requests and emergency fixes.

¨ Web Service testing using Soap UI.

¨ Created and executed both load and functional tests for web services.

¨ Analyzed recorded and modified client-server traffic using an HTTP monitor.

¨ Developed Test Automation Script using Java, Selenium WebDriver and TestNG to perform sanity testing on every deployment performed in QA Environment.

¨ Developed a Hybrid Framework using Page Object and Data-Driven Model on top of TestNG and Selenium WebDriver for test automation.

¨ Automated Test Cases using Groovy programming in SOAPUI and used assertions for verification.