Post Job Free
Sign in

Etl Developer Sql

Location:
Kolkata, West Bengal, India
Posted:
March 24, 2022

Contact this candidate

Resume:

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



Contact this candidate