Download PDF

Summary

6.9 years of total IT experience with 5.1 years relevant experience in design, development and execution of data integration and ETL solutions using Informatica PowerCenter tools and Oracle PL/SQL

Professional Summary

  • 6.9 years of total IT experience and relevant 5.1 years of experience in design and development of ETL and data integration solutions using Informatica PowerCenter tools 
  • Knowledge on creating functional and technical design documents, LLD, HLD, deployment sheets etc. 
  • Good experience in extracting, transforming and loading data from Oracle database, flat files, XML files and other data sources into data warehouse facts and dimension tables and Siebel CRM applications 
  • Expertise in developing mappings for Extraction, Transformation and load of source data into target schema using various transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, lookup, Rank, Joiner, Expression, Stored Procedure, SQL, and update strategy to meet the business logic 
  • Designed workflow, sessions and tasks, scheduling workflows and configuring Email tasks for jobs, good knowledge on troubleshooting and debugging of failed jobs 
  • Good experience in performance tunings at mapping & session level as well as at the database level to increase the data throughput and overall performance 
  • Trained on Oracle Data Integrator 12c, basic understanding of data warehouse concepts, dimensional modeling, star and snow flake schemas and business intelligence 

Work History

Mar 2016Sep 2017

ETL Developer

Computer Science Corporation

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements 
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting 
  • UAT Support has been done to resolve the ongoing issues and troubleshoot the problems 
  • Involved in performance tuning at mapping and session levels. Used relational SQL wherever possible to minimize the data transfer over the network 
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections 
  • Designed mappings & workflows with many session and used informatica scheduler to schedule jobs 
  • Used transformations such as filter, Joiner, Router, Update Strategy, Expression, Aggregator etc. to transform the data before loading into the data mart 
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews 
  • Identified problems in existing production data and developed one-time scripts to correct them 
  • Fixed the invalid mappings and troubleshoot the technical problems of the database 
Mar 2014Jan 2016

Siebel EIM Data Migration Developer

Capgemini India Pvt. Ltd.

Responsibilities:

  • Detailed critical analysis of functional design document and designing the technical design document for Customer entity (Accounts, Contacts & Addresses) 
  • Writing complex transformation using PL/SQL scripts, packages and procedures, materialized view and other database objects 
  • Automating the complete execution of code transformation and EIM jobs using shell scripts. 
  • Migrated around 5 million Accounts along with their details, Contact-Account association, and Account-Address association and setting its primaries in production environment and other SIT, UAT, Dev environments 
  • Migrating legacy customer data in Siebel UCM application, populating SDH and Best version tables for master entities through EIM and BDM jobs 
  • Formulating business and technical reconciliation scenarios, preparing and reviewing technical design documents, drafting of detailed EIM mapping sheets, planning, preparing and executing deployment documents and run sheets 
Nov 2010Mar 2014

Systems Engineer

Tata Consultancy Services

Responsibilities:

  • Understanding the functional design document and preparing detailed technical design document for identifying sources and targets, types of transformations required, deployment methods etc. 
  • Extracted data from Siebel CRM tables and flat files as sources, transformed using various powerCenter transformations and loaded into the Siebel EIM tables as targets as a one-time task 
  • Loaded EIM tables data into Siebel base tables through EIM jobs 
  • Worked extensively on Mapping Designer, Workflow Manager and Workflow monitor tools 
  • Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy and Router 
  • Developed and executed Workflows and monitored the results using workflow monitor 
  • Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows. 
  • Prepared SQL Queries to validate the data in both source and target databases. 
  • Configured and optimized configuration (IFB) files to run EIM job for data load 
  • Created CTL file for SQL Loader to load the some of the data received from External system into the EIM Interface tables for further EIM processing 
  • Implemented EIM best practices in mapping Siebel data with external data through EIM tables, coding standards and develop the application considering performance impacts
Feb 2010Jun 2010

Internship

Tata Consultancy Services

Tasks Undertaken:

  • Usage of Mastercraft IDE tool to generate java code through Q++ scripts
  • Learnt Q++ Language (a TCS internal programming language)
  • Usage of utilities like SQL developer, Toad, WinSCP, PuTTY etc..

Education

Jul 2007Jun 2010

Master of Computer Applications (MCA)

Jamia Millia Islamia University

Distinction with 78%

Specializations:

  • Programming languages like C, C++, Core Java
  • Oracle database 10g (DBMS)
  • Computer Networks, Operating Systems, Business data processing
  • Artificial Intelligence and Machine learning
Jun 2003May 2006

Bachelor of Science (B.Sc) Mathematics

Ranchi University

Honors in Mathematics, 1st division with 68%

Skills

Informatica PowerCenter
  • Experience in creating mappings, sessions, workflows and designing transformations
Siebel EIM
  • Experience in design, implementation and testing of Siebel CRM v8.0/8.1 Applications, understanding the architecture, scope and functionality with specialization in Siebel EIM data migration.
Oracle PL/SQL
  • Expertise in Oracle 10g/11g, using SQL Loader, writing PL/SQL packages and procedures and creating other database objects

Trainings

Jan 2011Jan 2011

Informatica PowerCenter 9.1.0

Tata Consultancy Services

Completed in-org training in Informatica PowerCenter 9.1.0

May 2017Jun 2017

Oracle Data Integrator 12c

Oracle University

OnDemand training completed in ODI 12c latest version

Sep 2014Oct 2014

Oracle Sales Cloud R8 Implementation

Oracle Corporation
  • 5 days intensive Oracle Partner Training completed for Oracle Sales Cloud R8 Implementation
  • Training included practicals (Lab) in Administration and Simplified UI applications
  • One month self-training and practise in Oracle provided environments

Strengths

  • Good oral, written & presentation skills
  • A high tolerance of stress and enjoys responsibilities
  • Quick learner with good grasping ability

Personal Details

Date of Birth:               30th August 1986

Address:                         E-49/1, Second Floor, Shaheen Bagh, Abul Fazal Part-II, Okhla, New Delhi-110025

Marital Status:            Married

Nationality:                  Indian

Passport No:                M5139193, Valid till 01/2025