Summary
Overview
Work History
Education
Skills
Websites
Technical And Administrative Skills
Timeline
Generic

Sandeepan Mukherjee

Iselin,NJ

Summary

  • Over 10+ years of IT experience in System Analysis, Design Development, Implementation, Risk Analysis, Technical Documentation & Testing involving Databases and Data Warehouse Applications in Pharmaceutical, Insurance, Health care, E-commerce & other domains.
  • Over 8+ years of experience in Extraction, Transformation, and Loading (ETL) using Informatica Power Center, Informatica Intelligent Cloud Services (IICS) and SSIS (SQL Server Integration).
  • Designed the Informatica Workflows, Mappings, creation of Sessions, and experience in creating complex mappings using various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Update Strategy, and XML Transformations.
  • Involved in preparing material and training Business users Implemented slowly changing Dimensions (SCD, Both Type 1 & 2).
  • Tuned the performance of mappings by following Informatica best practices and applied several methods to get the best performance by decreasing the run time of workflows.
  • Strong SQL development skills including writing dynamic queries, sub-queries, and complex joins for generating Stored Procedures, functions, Triggers, Functions, Views, and Cursors using PL/SQL in a UNIX environment.
  • Experience in Designing, Reporting, Analysis, Data -warehousing, Databases, Business Intelligence, and Data Visualization skills using Tableau, and Power BI to predict business outcomes using Agile, Waterfall Environments and usage of JIRA.

Overview

13
13
years of professional experience

Work History

Sr. ETL Developer

Hewlett Packard Enterprise
Frisco, TX
09.2023 - 12.2023
  • Involved in translating the business requirements to technical requirements
  • Teaming up with enterprise information quality & governance office and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and the quality of the data
  • Working on various Informatica Power Center components like designer, workflow manager, workflow monitor, and repository manager
  • Extracting data from various heterogeneous sources like Oracle, flat files, SAP, etc
  • Designed and implemented regression test suite to test policy and transaction processing in bulk using PL/SQL, Unix/Shell scripts
  • Worked with static and dynamic caches for the better throughput of sessions containing Rank, Lookup, Joiner, and aggregator transformations
  • Optimize session-level performance by processing parallel data using partitioning methods like pass-through, round-robin, and key range.

Sr. ETL Developer

Sanofi Pasteur
Swiftwater, PA
11.2019 - 07.2023
  • Designed and developed ETL mappings primarily using Informatica PowerCenter 10, PL/SQL, and Unix Scripts
  • Designed, developed and maintained ETL mappings using Informatica Intelligent Cloud Services (IICS) data integration processes using the appropriate data load technique, including Pushdown Optimization for performance optimization
  • Analyzed the impact of changes on existing ETL/ELT processes and systems
  • Analyzed cost-effectiveness and feasibility
  • Debugged and tuned data integration processes to analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshooting and recommended improvements and alternate methodologies
  • Designed, developed and maintained Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts.

Sr. ETL Developer

Nationwide Mutual Insurance Company
Columbus, OH
10.2017 - 10.2019
  • Conducted data analysis of the source feeds from various systems like NAPS, FPS, SA, HV and other system of records to bring in data related to Policy, customer, quotes, claims, billing etc
  • Create source to target mapping documents by reviewing functional and non-functional requirements
  • Worked on Power Center client tools to perform ETL to extract, transform and load data from Oracle, SQL Server, and flat files to HP ex-stream
  • Created various transformations such as aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations
  • Created and Monitored Workflows using Workflow Manager and Workflow Monitor
  • Involved in Unit Testing & Integration testing of the mappings.

ETL/BI Developer

State of CA- Department of Developmental Services (DDD)
Sacramento, CA
02.2017 - 07.2017
  • Interacted actively with Business Analysts on Mapping documents and Design process for various Sources and Targets
  • Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server
  • Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages
  • Developed SSIS ETL packages using data warehouse architecture model by creating fact and dimension tables
  • Used various Transformations such as For loop container, For Each loop container, execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow
  • Data management and data processing solutions using SSIS, including Error Handling and Slowly Changing Dimensions.

ETL/BI Developer

Microsoft Corporation
Redmond, WA
12.2015 - 11.2016
  • Worked on different tabular models such related to devices such as Xbox, Surface and other Microsoft devices
  • Used SSIS to create ETL packages to validate, extract, transform and load data-to-data warehouse databases, data mart databases
  • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016/2014 by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
  • Created Pivots for the excel reports and used Power View to show the data as per requirement
  • Linked Power BI reports to SharePoint and maintained the reports.

ETL/BI Developer

Roche Diagnostics Corporation
Indianapolis, IN
06.2015 - 11.2015
  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business
  • Designed ETL specification documents for all the projects
  • Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source
  • Applied business logic to load the data into Global Data Warehouse
  • In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server, DTS, SSIS, SSAS and SSRS
  • Experienced in Extraction, Transformation and Loading (ETL) process using MS-SSIS, DTS application tools.

Transaction Risk Analyst (TRMS)

Amazon.com
Hyderabad, TS, India
05.2011 - 12.2013
  • Investigated complex transactions using various tools to eliminate fraudulent activity, reduce bad debt and enhanced quality and customer experience across Amazon NA, Amazon EU and other subsidiary marketplaces
  • Involved in data analysis, design, development, test data preparation, unit and integration testing, Preparation of Test cases and Test Results
  • Coordinated with the client, Business and Operations team on development
  • Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic, and transformation as per the requirement
  • Acquire data from primary or secondary data sources and maintain databases/data systems.

Education

Master of Science (Information System Security) -

University of the Cumberland's

Master of Science (Information System Technologies) -

Wilmington University

Bachelor of Technology (Mechanical Engineering) -

Malla Reddy Engineering College

Skills

  • Performance Tuning
  • Scripting Languages
  • Version control systems
  • Agile development methodologies
  • Data Modeling
  • Data Validation
  • Business Intelligence
  • Data Warehousing
  • Data Migration
  • Data Mapping
  • Programming Languages: PL-SQL, T-SQL
  • Databases: Oracle, Microsoft SQL Server, Teradata, DB2
  • Source and Version Control: Git, GitHub
  • Requirements Gathering
  • Dashboard creation
  • Software Development Tools: JIRA, Confluence
  • Unit test plans

Technical And Administrative Skills

Informatica Power Center 10,9.0, 8.6/8.5/8.1, IICS, SSIS, Oracle 11g/10g/, MS SQL Server 2016, SSIS, SSRS WinSCP, Control-M, Putty, GIT, SVN, MS-Visio, Tableau, Power BI

Timeline

Sr. ETL Developer

Hewlett Packard Enterprise
09.2023 - 12.2023

Sr. ETL Developer

Sanofi Pasteur
11.2019 - 07.2023

Sr. ETL Developer

Nationwide Mutual Insurance Company
10.2017 - 10.2019

ETL/BI Developer

State of CA- Department of Developmental Services (DDD)
02.2017 - 07.2017

ETL/BI Developer

Microsoft Corporation
12.2015 - 11.2016

ETL/BI Developer

Roche Diagnostics Corporation
06.2015 - 11.2015

Transaction Risk Analyst (TRMS)

Amazon.com
05.2011 - 12.2013

Master of Science (Information System Security) -

University of the Cumberland's

Master of Science (Information System Technologies) -

Wilmington University

Bachelor of Technology (Mechanical Engineering) -

Malla Reddy Engineering College

Similar Profiles

CREATE PROFILE
Sandeepan Mukherjee