Nirban Bhowmick

813-***-****

adisnc@r.postjobfree.com

ETL/Informatica Developer

Summary:

Around 8 years of professional experience in Data Warehouse, Relational Database and System Integration. Proficiency in gathering and analyzing user requirements and translating them into business solutions.

Six Plus (6+) years of strong experience in development and design of ETL (Extract, Transform and Loading data ) methodology for supporting data transformations and processing ETL Solutions using Informatica Power Center (9.x/8.x/7.x).

Extensively worked on Informatica Designer Components - Source Analyzer, target Designer, Transformations Developer, Mapplet and Mapping Designer.

Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star, Snowflake Schemas.

Experience in, performance tuning of informatica mappings

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, DTS and SSIS services.

Experience working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling

Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.

Experience in integration of various data sources like Oracle, SQL Server, Teradata and flat files into staging area.

Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, and Triggers.

Proficient in using pmcmd and pmrep commands

Used Teradata Utilities like fast load, multi load and fast export.

Performed data validation by Unit testing, integration testing and System Testing.

Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Excellent analytical skills. Exhibits great ability to grasp newer technologies. Effective team player with excellent communication skills. Self starter, result oriented team player with an ability to manage multiple tasks simultaneously.

Technical Skills:

Data Warehousing

Informatica Power Center 9.5.1/9.0.1/8.6/8.1/7x, Informatica server 2008, Power Mart 6.2/5.x/4.7, Power Exchange, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Datamart, Data cleansing, Data Profiling, OLAP, OLTP, Mapplet, Transformations, Autosys, Control M, Maestro, SQL*Loader, Control Center, Oracle 10g,Toad 8.6, PL/SQL,

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERwin4.5/4.0, Oracle Designer, Visio.

Business Analysis/Data Analysis

Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Project, MS Access, MS Office, Visio

Databases

Oracle 11g/10g/9ixMS SQL Server 2012/2008/2005, Sybase ASE 12/12.5.3, MS Access

Languages

SQL, T-SQL, PL/SQL, C, UNIX Shell Scripting

Environment

Unix clones: - HP-UX10/9, Sun Solaris /8/7/2.6/2.5, AS/400, LINUX, Windows95/98/2000/XP, WinNT4.0

WORK EXPERIENCE:

Client: T-RowePrice, Owings Mills, MD MAY'2019 to PRESENT

Role: ETL/Informatica Developer

Responsibilities

Created mappings and sessions to implement technical enhancements for data

Data Loads to warehouse by extracting data from sources like Oracle and Delimited Flat files.

Involved in standardization of Data like of changing a reference data set to a new standard.

Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created mappings, mapping configuration tasks and task flows with Intelligent Informatica Cloud (IICS) and Infomatica Power Center (10.1.1 & 9.6.1)

Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.

Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages Oracle.

Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.

Working with Business Intelligence Markup Language (Biml) Script to ease and automate SSIS development.

Developed complex SQL queries to validate data integrity using SQL Server while simultaneously working with customer XML.

Design and develop quality integration workflows between multiple applications utilizing Informatica tools.

Analyzed the business requirements and functional specifications.

Provide production support and solve complex integrations issues.

Worked in Production Support Environment as well as QA /TEST environments using Quality Center tool for projects, work orders, maintenance requests, bug fixes, enhancements, data changes.

Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Used TFS, VSTS and GIT for version control.

Work closely with the teams to ensure architectural integrity related to integrations activities.

Collaborate with business stakeholders for UAT and Quality Assurance for unit/technical testing.

Provide leadership and technical guidance within the integrations and specifically Informatica landscape.

Work alongside team members to architect, design and develop quality deliverables.

Built mappings using Informatica Data Quality and export them as Mapplet to Informatica Power Center to read JSON format files.

Created various workflows to read .JSON files and loaded into staging tables and then to respective Dimension and Fact tables.

Created QA and PROD change requests using Service Now too to move the code to QA and PROD respectively.

Drive results and leverage past experiences to improve the environment and related processes.

Foster a spirit of teamwork, coach and mentor junior staff.

Communicate regularly with other managers, the director, line of business leads and other designated contacts within the organization.

Report on the status of development, quality, operations, and system performance to management.

Troubleshooting, diagnostics & performance tuning in databasecost-based optimizer mode.

Enhanced the performance of the procedures by creating suitable global and local indexes.

Environment: Informatica Power Center 10.1.1/9.6.1, Intelligent Informatica Cloud Services (IICS), Toad, Oracle SQL Developer, SQL Server Management Studio (SSMS), JIRA, Service Now, Visual Studio Team Services (VSTS), GIT HUB. AIX, Windows NT/XP, XML file sources, ERWIN 7, Data Marts, MS Visio, COGNOS, Teradata V 14.0, PL/SQL, SSIS, Data Modeling, DB2, SQL Server 2012, UNIX Shell Scripting, Business Intelligence Markup Language (Biml), Agile Methodology, Autosys, REMEDY.

Client: Freddie Mac, McLean, VA JUN'2018 to APR'2019

Role: ETL/Informatica Developer

Responsibilities

Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.

Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.

Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents

Involved in Data Profiling using Informatica Data Explorer (IDE).

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.

Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.

Used Informatica to extract data from DB2, UDB, XML, Flat files and Excel files to load the data into the Teradata

Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.

Worked on Informatica Power Center tool – Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor

Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys.

Implemented dynamic SSIS package creation using Business Intelligence Markup Language (BIML).

Involved in UNIX shell scripting and configuring cron-jobs and Control M jobs for ETL Loads.

Worked Extensively on ETL process using SSIS packages.

Worked with data Extraction, Transformation and Loading data using BTEQ, Fast load, Multiload

Used the Teradata fast load/Multiload utilities to load data into tables

Implemented agile development methodology using XP, Scrum and Kanban/Continuous Flow.

Used Informatica command task to transfer the files to bridge server to send the file to third party vendor.

Took part in migration of jobs from UIT to SIT and to UAT

Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions

Involved in Informatica Code Migration across various Environments.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, Power Exchange 9.1, Teradata V 13.0, Fast load, Multiload, Teradata SQL Assistant, MS SQL Server 2012/2008, Data Marts, SQL, PL/SQL, Agile Methodology, T-SQL, SSIS, SQL*Plus, DB2, Data Modeling, TOAD, Erwin, UNIX Shell Scripting, Business Intelligence Markup Language (Biml), AIX, Shell Scripts, Autosys, Unix.

Client: St.ElizabethHospitals, Erlanger, KY SEP'2015 to MAY'2018

Role: ETL/Informatica Developer

Responsibilities:

Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.

Develop strategy for implementing data profiling, data quality, data cleansing and ETL metadata.

Migrated DTS packages to SSIS packages.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1.

Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager and accessing Mainframe DB2 and AS400 systems.

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.

Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.

Created jobs and job variable files for Teradata TPT and load using tbuild command from command line.

Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.

Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.

Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.

Worked on Power Exchange for change data capture (CDC).

Worked Extensively on ETL process using SSIS packages.

Executing DML, DDL and DCL commands as SQL queries.

Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.

Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.

Analysis and code development using Agile methodology.

Used mapping parameters and variables for pulling incremental loads from source

Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.

Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.

Environment: Informatica Power Center 9.1, IDQ, Oracle11gR2, DB2, SQL, PL/SQL, TERA DATA, UNIX shell scripting, Control-M and, TOAD 10.5.

Client: First City Financial Corporation, Waco, TX JAN'2014 to AUG'2015

Role: ETL Developer

Responsibilities:

Involved in Business analysis and requirements gathering.

Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.

Preparation of technical specifications and Source to Target mappings.

Extensively used Informatica power center for extraction, transformation and loading process.

Worked Extensively on ETL process using SSIS packages.

Extracted data from various sources like Oracle, flat files and DB2

Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.

Synchronization has been done between Informatica Metadata and data modeling diagrams.

Optimizing/Tuning mappings for better performance and efficiency.

Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.

Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.

Generated PL/SQL Triggers and Shell scripts for scheduling periodic load processes.

Implemented Agile/Scrum Development Methodology for quick solutions.

Configuring sessions in a batch and scheduling them through Autosys job scheduler.

Used workflow manager for session management, database connection management and scheduling of jobs.

Involved in production support.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Power Exchange 8.6, MS SQL Server 2008, UNIX(Sun Solaris5.8/AIX), SSRS, UltraEdit-32, Data Marts, Erwin Data Modeler 4.1, Agile Methodology, Teradata 13, FTP, MS-Excel, SSIS, Ms-Access, DB2, UNIX Shell Scripting, Data Modeling, PL/SQL, Autosys.

Client: CitiBank, Bangladesh APR'2012 to DEC'2013

Role: ETL Developer

Responsibilities:

Involved in gathering requirements from end users and involved in modifying data according to the requirement.

Worked with the end users to identify, create, and deliver reports according to requirements.

Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.

Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.

Created ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, Routers and XML etc.

Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.

Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD, SQL*PLUS and PL/SQL.

Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.

Created Data models for data warehouse development.

Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.

Worked with UNIX scripts for automation of ETL Jobs using Control-M Scheduler and Involved in migration/conversion of ETL processes from development to production environment.

Working experience using Push Down Optimization.

Did performance tune of Informatica components for daily and monthly incremental loading.

Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.

Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica Power Center 8.1.1, Oracle 10g, Windows 2000, Power Exchange 8.1, SSIS, PL/SQL, TOAD, SQL Server 2008, Data Modeling, UNIX Shell Scripting, Data Marts, DB2, Autosys, Agile Methodology, Erwin 4.0.

Education:

Bachelors in Electronics & Telecom Engineering, RUET, Bangladesh - 2010

Contact this candidate