Experienced Developer at Tata Consultancy Services Limited, specializing in Informatica MDM and ETL development. Skilled in data integration, SQL programming, and problem-solving, delivering accurate and efficient master data management solutions.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Developer
Tata Consultancy Services Limited
Kolkata
10.2021 - Current
Developer specializing in the Life Sciences and Health-Care domain, working with a US-based multinational Bio-pharmaceutical client.
Developed and documented technical designs and specifications for data extraction, transformation, and loading (ETL) processes, ensuring accuracy and efficiency in data workflows.
Analyzed data sources, performed data transformation, mapped datasets, and efficiently loaded data into target systems using Informatica PowerCenter and Hub Console, ensuring seamless data integration and accuracy.
Executed batch groups manually to perform data loads, including load jobs and stage jobs, using the Informatica Hub Console, ensuring efficient data processing and integrity.
Configured and onboarded new products and customers in the Informatica MDM. Designed and implemented robust ETL pipelines using Informatica PowerCenter to optimize data processing and workflow efficiency.
Conducted data analysis using SQL, and developed data quality rules with PL/SQL to create commercially viable master data for clients.
Actively involved in MDM Product, customer and territory Template automation in MDM.
Providing production support for the segment Territory, which has been migrated to Databricks as a part of transitioning from on-prem to SaaS migration. Monitoring DAGs in Airflow is important.
Worked on document creations like test case documents, approvals, change management for sprint deployment, pro-actively managed service request raised by users and provided resolution before the SLA.
Education
Master of Computer Applications - MCA
Jadavpur University
Kolkata
07-2021
Skills
Informatica MDM
Workflow design
Data migration
Problem solving
SQL programming
Data integration
Master data management
Informatica PowerCenter
ETL development
Certification
Informatica Master Data Management (MDM) Concepts by Udemy
Head of Digital Innovation, Manufacturing Business at Tata Consultancy Services LimitedHead of Digital Innovation, Manufacturing Business at Tata Consultancy Services Limited