Trideep Ghosh

TG Tech Lead at Tech Mahindra

trideepbca15@gmail.com | +91-8886596277| Male, 31

PROFESONAL SUMMARY

7+ Years of experience in finance and

telecom domain as ETL Data Engineer • 7+ Years of experienced in Informatica PowerCenter along with
(Tech Lead). PowerExchange, Teradata, SQL server, DB2, Unix tools like Putty
Well versed with development & WinSCP FTP client.
methodologies (SDLC and Agile) with • Side by side having 6 Years of experience on monitoring tool
Informatica PC and Cloud, Snowflake, experiences with CA Workstation, and 1+ year on IBM TWS
Teradata, SQL server, Oracle, Unix &
• 4+ Years of experience in Snowflake like snowsql, snowpipe
little bit of Python Scripting. Strong
interpersonal communication skills • 1+ Years of experience in Oracle, Vertica, Azure data lake,
and quickly adaptive to new container, and server storage
technologies. • 4+ Years of end-to-end experience in different type of migrations (cloud
and on-prem environment)
EDUCATION
WORK EXPERIENCE
10TH • 2007 • SAINTHIA HIGH
SCHOOL / WBBSE: Secured 64%
April’ 22 – Till date with Tech Mahindra Pvt. Ltd.
12TH • 2009 • SAINTHIA HIGH
➢ Position: Tech Lead
SCHOOL / WBCHSE: Secured
68.8% ➢ Client: Telecom Client (AT&T)
DITA (CS) • 2012•YOUTH ENHANCEMENT• DATABASE MIGRATION & AUTOMATIONS •
COMPUTER CENTER: Passed out APR 2022 – Till Date
with 78% • Working on 70+ IBM TWS ECDW, EDW applications
BCA • 2015•DURGAPUR optimization with Teradata, Vertica and Snowflake server’s
SOCIETY OF MANAGEMENT query
SCIENCE / WBUT: Passed out • Worked on different transformations available in informatica like
with 7.9 CGPA Aggregator, Joiner, Source Qualifier, Normalizer, Router,
MCA• 2019•Gandhi Institute of Filter, Update Strategy, Lookup etc.
Technology and Management / • Working on multiple cloud applications for data file load to
GITAM University: Passed out
Azure data container along with Snowflake query
with 7.3 CGPA
• Worked on Teradata to Snowflake migration along with
TECHNICAL SKILLS Informatica Power Canter 10.4 to cloud deployments
• Created end-to-end workflow design to solve the SLA meet
ETL TOOLS: Informatica issues along with Teradata utility (MLOAD, TPUMP,
PowerCenter 9.5.1/9.6.1/10.1/10.4
Fastload)
DATABASES: Teradata 17, Vertica,
• Worked on 20+ permanent fix issue for Snowflake data load in
MS SQL Server’12, Snowflake, Oracle
cloud application like flat file data load with .CSV, .XML, .TXT,
SOFTWARE LANGUAGES: SQL
.DAT
SCHEDULING TOOLS: CA
• Organized and provided multiple KT sessions on Teradata,
Workstation (ESP), IBM TWS
SQL Server & Informatica to current team members
OTHER TOOLS: PowerExchange
• Worked on regular patch deployment and review with Teradata
Navigator, FTP Client, puTTy,
17 and Oracle servers
WinSCP, Mainframe Endevor,
• Managed and automated AOTS and JIRA ticket for daily failure
Ticketing Tool: Remedy,
Jira, AOTS notifications and analysis
DB TOOLS: SQL Developer, • Helped monitoring team to understand data analytics with IBM
Teradata SQL Assistant TWS, Snowflake cloud, Azure data lake and Teradata
MICROSOFT TOOLS: MS Office, • Fixed Teradata performance issue by analysing CPU I/O load,
MS Outlook AMP Skewed ID optimizations, Indexing on existing queries
OPERATING SYSTEM: UNIX, • Automated daily delivery report for client using UNIX scripting
• ETL performance tuning techniques for schedule improvement
Windows 2007, XP, 10
through SQL Server query, store procedures and process flow
BASIC KNOWLEDGE: UNIX
Shell Scripting, Mainframe
UPGRADING/INTERESTED ON OTHER WORK EXPERIENCE (Cont.)
SKILLS:
Azure Cloud, Snowflake March’ 16 – April’ 22 with Accenture Solutions Pvt. Ltd.
HOBBIES & INTERESTS ➢ Position: Application Development Senior Analyst

• Sketching, Playing games, ➢ Client: P&C Insurance Client (Liberty Mutual)

Travelling different places SAFECO PRODUCTION SUPPORT • PRODUCTION SUPPORT • JUNE 2016 -
and Playing games on free MAY 2017
time
• Maintain Enterprise Data Warehouse (EDW) and DataMarts
LANGUAGE PROFICIENCIES for a P&C Insurance Client
• Monitor over 500 daily ETL and Mainframe jobs, identify and resolve
• English, Hindi & Bengali bottlenecks, fix failures
• Tuning up a SQL or Teradata query on Informatica to get best
STRENGTHS balanced performance every time.
• Problem solving capability • Owner of DataMarts applications/schedule at Offshore and primary
paired with strong point of contact for the delivery/SLA related queries
communication skills • Performs data fixes, monitoring PROD & NON-PROD schedules and
• Cool headed and high attends Triage calls with respective Admins to resolve Jira
tolerance of stress and issues/tickets
enjoys responsibilities.
• Ready to learn new MAINTENANCE & ENHANCEMENT • DATABASE MIGRATION • JUNE 2017 -
technologies with good SEP 2017
grasping ability
• Worked on multiple Migration/Upgrade activities including
• Smart worker, organized and testing and validations of Enterprise Databases:
a team player
➢ Microsoft SQL Server to Physical DBaaS
➢ Teradata SQL assistant v15 to v17
➢ Teradata to Snowflake cloud
• Worked on ETL tools (Informatica in Place versions 9.5.1 to
9.6.1 to 10.1.1), validating objects, coming up & documenting
encountered issues and thereby modifying workflows accordingly

AUTOMATIONS & PERFORMANCE TUNING • OCT 2017 - DEC 2019

• Worked on data migration from SQL server to Snowflake for
70+ applications
• Fixed multiple Teradata recurring failures which saved close
to 40 hours per month thereby contributing to schedule
efficiency
• Worked on reducing the SQL server store procedure runtime of
business workflows by coming with innovative solutions and
alternatives which saved close to 15 hours per month
• Worked on multiple work requests/orders for automating regular
manual QA work and saved close to 50 hours of manual effort per
month
• Automated the holiday scheduling on CA WORKSTATION of
workflows consequently saving 6 hours per quarter

ETL DEVELOPER • JAN 2020 – MAR 2022

• Have a good working experience/understanding in analysing data
issues, design approach for data fixes, draft requirement
specification, design, enhance, unit test and deployment
• Developed multiple Informatica Power Center workflows for ETL
applications as per client requirements
• Co-ordinate with QAs, Business Analysts, Development team
and handle Client calls for pipelined bottlenecks, User
questions, weekly/monthly deck, dashboard presentation and
epics questionaries
ACHIEVEMENTS

• Adjudged Star Performer within Project on 2016

• Distinct Achiever within project on 2017
• Best Team Member and Performer within Project on 2019
• Star Performer within entire financial domain on 2020
• Received Accenture Excellence award (ACE award) on 2021
• Received Automation Ninja certification from Tech Mahindra on 2023
• Received PAT ON BACK award from Tech Mahindra on 2023

CO-CURRICULAR ACTIVITIES

• Youth Empowerment and Skills Workshop (YES+) Certification on August

2012.
• Certified by Mukesh Consulting Services for completing Minor Project and
Industrial Training on C#.NET (Windows Application) on 25th July, 2014.
• Certified by Mukesh Consulting Services for completing Major Project and
Industrial Training on ASP.NET (Web Application) on 31st March, 2015.
• As a part of Marketing & Communication wing, organized multiple relevant
activities engaging current team members, Rewards & Recognition session
and published monthly Newsletters
• As part of GPTW (Great Place to Work) wing, actively organized /
participated in multiple team events