Tamasjit Ghoshal

Experience

• 

  3AIP Services Pvt. Ltd.

  Feb 2021 - Jul 2021

  Trainee Patent Research Analyst
• 

  Mphasis

  Feb 2022 - now

  𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫-𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐫 | 𝐔𝐒 𝐁𝐚𝐧𝐤 𝐚𝐧𝐝 𝐒𝐭𝐨𝐜𝐤 𝐁𝐫𝐨𝐤𝐞𝐫 | 𝐀𝐮𝐠𝐮𝐬𝐭 2022 - 𝐍𝐨𝐯𝐞𝐦𝐛𝐞𝐫 2023𝐊𝐞𝐲 𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬:-Worked in end-to-end data migration projects, migrating petabytes of data from on-premise systems to Google Cloud Platform (GCP), enhancing data accessibility and security.-Implemented Python-driven ETL processes, reducing process time by 20% and increasing data loading speed by 10%.-Designed, maintained, and optimized intricate data pipelines on GCP, achieving a 25% improvement in data processing efficiency.-Engineered Google BigQuery for data warehousing, implementing advanced query optimizations and managing extensive datasets effectively.-Collaborated closely with Informatica Professional Services (IPS) to navigate the transition from on-premise Informatica Power Center to Informatica Cloud.-Automated data cleaning and validation processes with Python scripts, reducing manual efforts by 30% and improving data quality.-Rectified defects within stringent SLA timelines, maintaining an 85% resolution rate across diverse environments.-Facilitated the seamless migration of over 5000 workflows, ensuring flawless data transfer and minimizing disruptions to business operations.-Contributed to a 6 PB+ volume Data Migration project from legacy systems to Google Cloud for one of the largest US banks/brokers, including ETL migration from Informatica Power Center to IICS (Cloud).𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫 | 𝐔𝐒 𝐈𝐧𝐬𝐮𝐫𝐞𝐧𝐜𝐞 𝐂𝐨𝐦𝐩𝐚𝐧𝐲 | 𝐍𝐨𝐯𝐞𝐦𝐛𝐞𝐫 2023 - 𝐏𝐫𝐞𝐬𝐞𝐧𝐭-SQL automation using QuerySurge for data integrity across databases.-Designed Informatica workflows, reducing execution time by 15% with PySpark integration.-Managed testing processes in Jira, tracking defects and project progress efficiently.-Played a pivotal role in Informatica workflow design, execution, and troubleshooting.-Implemented SCD types and ensured data consistency across various sources. Show less

  • Software Engineer

    Apr 2023 - now

  • Associate Software Engineer

    Feb 2022 - Apr 2023