SAMIKET
CHAKRABORTY
ETL DEVELOPER/ARCHITECT/TEAM LEAD
Phone: +91-993*******
LinkedIn: linkedin.com/in/samiket-chakraborty-53755654 Email: ******************@*****.***
PROFILE
9+ years experienced Informatica ETL (Extraction,
Transformation, and Loading) Developer with a
proven track record of designing, testing, and
debugging new & existing ETL along with extensive
hands-on design and development experience,
across variety of sources, layouts, character sets, platforms. Demonstrates the capability of figuring out the business requirements, assessing data
situation and perform data modelling, and
collaborating with the cross-functional teams to
design a data warehousing system to meet
business needs. Exceptional mapping and
workflow analysis, design, creation or refinement
for performance tuning and processing efficiency.
KEY SKILLS
ETL Development
Data Analysis
Data Warehousing Designing
Data Extraction
Data Integration
Product & Program Troubleshooting
Data Modeling
Code Troubleshooting
CERTIFICATIONS
Oracle Certified Associate in PL/SQL Developer
Oracle Certified Professional in PL/SQL Developer
ITIL Foundation Certification
Microsoft Certified - Azure Fundamentals
TECHNOLOGY/TOOLS
Informatica PowerCenter 9.x, 10.x
SQL & PL/SQL: Oracle 10g, SQL Server
SQL Scripting: Netezza, Teradata, AWS Redshift
Toad, Oracle SQL Developer
Tivoli Scheduler
Unix Scripting, Putty, Winscp, Filezilla
Pro*C
SyncSort
WORK EXPERIENCE
Mindtree Technical Lead
June 2021–Present
ANZ Bank Domain: Banking Senior ETL Achitect and Lead
Extensively worked on understanding the business requirements by interacting with customers’ subject matter expert (SME), data modeling, and ETL structure.
Involving in the analysis, requirements gathering and documentation of functional & technical specifications.
Developing high-level technical design specifications and low-level specifications based on business requirements.
Designing data mappings, workflows, and sessions to extract data from Oracle DB and source files from various source systems.
Involved in the migration of Informatica objects in all phases (dev, int and prd) of the project and trained developers to maintain system when in production. Cognizant Technology Solutions Associate-Projects
Nov 2015–May 2021
Mercury Insurance Domain: Insurance Senior ETL Developer and Lead
Gathered business and technical requirements from clients for maintenance tasks.
Prepared technical design documents for each enhancement and maintenance releases.
Involved as primary offshore ETL developer during the analysis, planning, design, development, and implementation stages of various projects using Informatica PowerCenter.
Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
Involved in building the logical and physical models for dimensional modeling projects. American Automobile Association Domain: Insurance ETL Developer
Designing data mappings, workflows, and sessions to extract data from various source files to capture event related to emails.
Tata Consultancy Solutions Systems Engineer
Mar 2012–Nov 2015
Johnson & Johnson Domain: Insurance ETL Developer
Designing and developing mappings to incorporate the existing SQL code logic into Informatica using transformations like source qualifier, sorter, aggregator, expression, joiner, dynamic lookup and connected and unconnected lookups, filters, sequence, router and update strategy to load data into SQL server from Teradata and Oracle databases.
Deployed Informatica code objects in all phases (dev, int and prd) of the project. EDUCATION
HALDIA INSTITUTE OF TECHNOLOGY, West Bengal, India 2007 - 2011
Bachelor of Technology in Information Technology
Cumulative GPA: 8.28/10
REFERENCES
Swarnali Mitra, Project Manager, Cognizant Technology Solutions Phone: +91-987*******
Sristi Chakraborty, Project Manager, Tata Consultancy Services Phone: +91-983*******
0
10
English Hindi Bengali
LANGUAGES KNOWN
Speaking Reading Writing