Keywords
Skills
Datasatge, Qualitystage, Informatica, Informatica Data Quality along with unix shell scripting on both AIX/LINUX/HP-UNIX, Teradata, DB2, Dash DB, Oracle, MySql, Service now, HPSM, TWS, Rundeck, ControlM, Autosys, Hadoop, Apache Hive and Oozie
Project history
Career HistoryIBM India Pvt Ltd, India
Senior Technical Services
Project Name: Digital Insights Platform
Project Type: Internal
Environment: BigData,Linux
Duration: August 9th 2018 – September 30th 2018
Summary: Did Data Ingestion POC from flat files using DIP.
Resposibilities:
Duration : Nov ’17 to August 08th 2018
Client Name : Schlumberger
Domain : Oil and gas
Team size : 6
Environment : Informatica IDQ , Microsoft SQL server
Role : Offshore Module Lead
Summary:
Schlumberger is the world's leading provider of technology for reservoir characterization, drilling, production, and processing to the oil and gas industry, Schlumberger supplies the industry's most comprehensive range of products and services.
IBM and Schlumberger have been collaboratively reviewing the current processes to perform the data profiling, cleansing and conversions in support of the 1st three releases of the ITT SAP Program.
The objective of the Data Profiling and Data Cleansing work stream is to implement an approach that will more tightly integrate the data cleansing and data conversion activities. The project works in Agile model.
Roles and responsibilities.
Project Title:IBM – DF i2i Data Integration Development
Client: Chevron
Duration: 14th Jan 2017 to 2nd Nov 2017
Role: Senior Software ETL Developer
Environment: IBM Information Server v11.5,Teradata,HP-Unix
Description: Chevron Exploration & Production or E&P. Involves operations in searching for underground or underwater oil and gas fields and drilling exploratory wells and at the same time, operating the wells that recover to re-direct the crude oil or raw natural gas to the surface.
It’s all about WELLS
• Where to locate them
• How deep and how far to drill them
• How to design, construct, operate and manage them.
Exploration - The exploration sector involves obtaining a lease and permission to drill.
Drilling - Drilling is physically creating the “borehole” in the ground that will eventually become an oil or gas well. This work is done by rig contractors and service companies in the Oilfield Services business sector.
Production - The production sector of the upstream segment maximizes recovery of petroleum from subsurface reservoirs. Production brings the oil to the surface.
Responsibilities:
• Independently handled the Staging & Integration jobs, developed sequencers for the project.
• Handled special characters in datastage as well as in Teradata level.
• Worked on Teradta Sql and Load methodologies.
• Worked on administration related activities/guidance for the modules.
• Created the unix scipts for SFTP file extraction,archiving and triggered the datastage sequencers.
• Created the generic scripts for datastage project backups.
• Created generic jobs for Staging and Integration Jobs.
• Understand the design documents developed the Dimensions and facts jobs based on that.
• Understand the flow of process from top to bottom.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
Project#3
Project Title : Human Resources Management System
Client : Genpact
Duration : 9th May 2016 to 31st Dec 2016
Role : Senior Software ETL Developer
Environment : IBM Information Server v11.5,DASH DB,UNIX Shell Scripting
Description: Source data extraction from the defined data views created in the OHRMS source system.Source data extraction from the defined csv files provided by source systems Taleo, Hubble, EFMS, IPerform and Cheers.Loading of staging tables with source data.Integration of master and transactional data from Taleo, Hubble, OHRMS, EFMS, IPerform and Cheers.Transformations on the source data to load the SynerG BI and Analytics solution and provide an integrated view of the Hiring and O&S data for business reporting.
Responsibilities:
• Independently handled the Onboarding and BGC Module for the project.
• Worked on administration related activities/guidance for both HR and FP&A modules.
• Created the unix scipts for SFTP file extraction,archiving and triggered the datastage sequencers.
• Created the generic scripts for datastage project backups.
• Understand the design documents developed the Dimensions and facts jobs based on that.
• Understand the flow of process from top to bottom.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
.
06/2014 - 04/2016
Wipro Technologies, India
Senior Software Engineer
Project#1
Project Title : SMDM (STXales & Marketing Datamart) and BEACONDM
(Development,Production,Enhancement)
Client : Allergan
Duration : Jan 2016 to April 2016
Role : Module Lead
Environment : IBM Information Server v8.1,Oracle 11g, UNIX Shell Scripting
Description: Sales And Marketing Data Mart (SMDM) helps management to analyse phyiscian profile, sales allocation, account profile, calls details and RX data. SMDM sources data from CM, ASPIRE, AMS, and SAP/BW applications.
CM provides accounts and physician data, BW provides COPA direct sales and SAP accents data, AMS provides allocation data, and ASPIRE provides call data to the SMDM.
BEACONDM sources data from BEACON compliance related Business Process Management system. The purpose of this data mart is to provide an efficient reporting and analysis platform for compliance reporting and analysis; as well as operational reporting for Sales department.
BEACONDM sources data from BEACON, SMDM, CM, MDM and AERO applications.
Responsibilities:
• Monitor the daily, monthly and weekly jobs and reports which happen to process over the night time in PST.
• Check whether all the jobs / reports are starting and completing on time.
• If not, analyze the reason and fix it with the help of source systems.
• Coordinate with all the source systems for successful completion of the whole night load.
• Monitor the BO reports.
Project#2
Project Title : FCA / CMB ADI / Firefly
(Development)
Client : HSBC
Duration : Aug 2015 to Dec 2015.
Role : ETL Developer
Environment : IBM Information Server v8.1/ v11.3, Teradata 10,Control M 7.0,UNIX Shell Scripting
Description: In FCA project it contains two modules of accounts and transactions where I did transaction level by implementing history processing and loaded the data. In CMB ADI project the inbound files that are coming from mainframe need to extract and did SCD operation on target files for every day transactions that should be used by further transformations and in outbound jobs.
In Firefly project is to be started and implemented the shell scripts for filelist script, file validation and for file appending.
Responsibilities:
• Understand the design documents developed the jobs
• Used Generic Historic processing jobs to develop SCD using database
• Designed SCD based on the file’s this I took as challenge
• Writing unix shell scripts to easy the business logic without implementing many jobs
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Designed Sequencer to automate the jobs.
• Preparing Unit test cases and test case documents.
Project#3
Project Title : SLRP
(Development)
Client : HSBC
Duration : Nov 2014 to Aug 2015.
Role : ETL Developer
Environment : IBM Information Server v8.1, Teradata 10,Control M 7.0,UNIX Shell Scripting
Description: (Supervisory Liquidity Reporting Project ) It contains 3 phases, inbound, transformations, out-bound. In response to the Financial services authority findings following the SLRP in March 2012, HBEU Asset and Liability Management setup a project ,at the request of the HSBC Bank board, to conduct a general analysis into how the deposit base might behave under a stressed scenario.
The data analysis will support customer segmentation and their product date to understand how deposit balances across these products behave using a score card. This analysis will also help to identify data attributes believed to be the key drivers of behavior in line with existing and proposed liquidity regulation.
The project will be split into retail and wholesale sections in assessing the stickiness of deposits across all bands in the HSBC specific or market wide liquidity stress event. Output from the scoring will be for internal consumption by Senior Management. Date for all customers of HSBC, First Direct, Marks and Spencer’s and all segments- Retail,Commercial,GB&M and Private Bank in the UK is to be used as part of this project.
Responsibilities:
• Understand the design documents developed the jobs based on that.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Designed Sequencer to automate the jobs.
• Preparing Unit test cases and test case documents.
• Developing & Scheduling the jobs in Contol M.
• Gathering the status and providing it to onsite co-ordinator
Project#4
Project Title : GDM
(Development,Supporting)
Client : HSBC
Duration : July 2014 to Nov 2014.
Role : ETL Developer
Environment : IBM Information Server v8.1, Oracle 10g, Teradata 10,Control M 7.0
Description: (Global Deliverable Management) It contains 9 processes as Deposits,Loans,Cards,customers,Application,Contact,Investment,Insurance,channel for 4 regions SGH,MYH,IN,TWM.It contains 2 sub areas namely Demand Deposit, Term Deposit.
Responsibilities:
• Understand the design documents developed the jobs based on that.
• Understand the flow of process from top to bottom.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Scheduling the jobs in Contol M.
• Worked in Production support , handling QC defects regularly.
• Gathering the status and providing it to onsite co-ordinator.
11/2011 - 06/2014
Bodhtree Consulting Ltd, India
Associate Consultant
Project Title : TIAA–CREF
(Dev,Migration from Informatica v7.1.5 to IBM Information Server v 8.1)
Client : TIAA–CREF,US.
Duration : September, 11 to June 2014.
Role : ETL Developer
Environment : IBM Information Server v8.1, Informatica Power Center v7.1.5, Oracle 10g, Teradata 7.2, MS SQL Server 2000, Citrix.
Description: Teachers Insurance and Annuity Association – College Retirement Equities Fund (TIAA–CREF) is a Fortune 100 Financials services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. TIAA–CREF
serves 3.7 million active and retired employees participating at more than 15,000 institutions and has $453 billion in combined assets under management.
The aim of the project is to replace the existing ETL system, which is there in Informatica v7.1.5 with the IBM Information Server v8.1. The base line for the development of the datastage jobs is the existing Informatica mappings.
Responsibilities:
• Worked on various TIAA applications such as RMW, Siebel, FAO & Externalization, CRDM, AODM, PGWA, CSI, EXP-AG, FIF, Proxy, TDA& CCS
• Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.
• Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica ETL tool.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Scheduling, Monitoring and Debugging of Informatica Sessions and Workflows in Auto sys Scheduler.
• The Objective is to extract data stored in different databases such as Oracle 9i, SQL server, Flat files and to load data into staging tables first and then into Oracle.
• Involved in Peer reviews of the Informatica Mappings and UTC Documents.
• Involved in performance tuning by optimizing the sources, targets, mappings.
• Preparation of Low Level Design for the mappings created.
• Prepared Unit test cases.
• The Objective is to extract data stored in different databases such as Oracle 9i, Flat files and to load data into staging tables first and then into Oracle.
• The Informatica mappings with in those batches would then populate the staging tables.
• Designing Datastage jobs based on the understanding of informatica jobs
• Developing the Datastage jobs by taking the informatica mapping as reference.
• Involved in creating different types of functionality’s and equivalents to meet informatica logic
• Performance tuning datastage jobs.
• Preparing Unit test cases and test case documents.
• Peer review of the developed datastage jobs.
• Promoting jobs to other environments.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Co-ordinating work with the other team members.
• Gathering the status and providing it to onsite co-ordinator.
12/2009 - 10/2011
Elixircare SofTech Pvt Ltd, India
Software Engineer
Project#1
Project Title : IBM-Cardinal Health
(Migration from Informatica v7.1.5 to IBM Information Server v 8.1)
Client : Cardinal Health Inc,US.
Duration : April, 10 to September, 11.
Role : ETL Developer
Environment : IBM Information Server v8.1, Informatica Power Center v7.1.5, Oracle 10g, Teradata 7.2, MS SQL Server 2000, Citrix.
Description:
The aim of the project is to replace the existing ETL system, which is there in Informatica v7.1.5 with the IBM Information Server v8.1. The base line for the development of the datastage jobs is the existing Informatica mappings.
Responsibilities:
• Analyzed the Informatica mappings and created an equivalent Data stage jobs, containers wherever applicable.
• Developed the data stage equivalent jobs for the various modules.
• Handle some many datatype , connector and logical issues .
• Testing, Reviewing the jobs.
• Prepared Unit Test cases, maintaining Code Review Documents etc as per the standards
• Handling different types of data types and resolving different types of special characters.
• Using of scd-1 & 2 and involved in performance of jobs through the nodes and the partition techniques.
• Involved in creating different types of functionality’s and equivalents to meet informatica logic.
• Designed Sequencer to automate the jobs.
• Involved in usage of Connectors rather than Enterprise stages.
• Implementing the Rank Transformation and Vertical pivot logic in the Transformer.
• Involved in usage of Range-lookup, Dynamic-Lookup and Sparse Lookup.
• Involved in DRF Creation for Control-M.
• Having good idea on Control-M Scheduling.
Project#2
Project : IBM_Consip
Client : IBM_Consip phase1 and phase2, Italy
Environment : Data Stage 8.1, Informatica 8.1, Oracle 9i/10g,
Windows XP, IBM AIX & Sun Solaris
Role : ETL developer
Duration : Dec-2009 to March 2010
Description:
Consip, ministry project even though it is a private law company, operates in the market exclusively with the function of “service organization” on behalf of the Public Administration of Italy. The control functions over Consip, including its corporate aspects, are exercised by the Ministry of the Economy and Finance, which determines its mission and strategic objectives, as well as the relevant implementation modalities; a further control over financial management is exercised by the Consip.
The Existing system available in the Informatica flows for data warehousing environment and all the flows are running under the Oracle9.1 Database. We are developing the code to buil a strong DSS system.
Consip phase2: In this phase final core load jobs are designed and taken care about
format of reporting layer and error conformation tables data marts like
DMA.
Responsibilities:
• Responsible for developing the Datastage Jobs.
• Query resolution and problem solving
• Interacting with Developers for assisting them in the identification, simulation, resolving and tracking of problems events.
• Involved in UT and SIT.
Senior Technical Services
Project Name: Digital Insights Platform
Project Type: Internal
Environment: BigData,Linux
Duration: August 9th 2018 – September 30th 2018
Summary: Did Data Ingestion POC from flat files using DIP.
Resposibilities:
- Did Data Ingestion POC from flat files using DIP.
- Verified the metadata databases/tables are created and available in MySQL and Hive
- Inserted the metadata for MLB game log from the SQL files to metadata tables in Data_services
- Created HDFS path as the base location for raw data.
- Copy data from the edge node to HDFS.
- Created and publish external Hive table in Raw Temp.
- Created target table in Raw Zone and publish data in the Raw Zone.
- Created conformed zone data view and publish data in the conformed zone.
Duration : Nov ’17 to August 08th 2018
Client Name : Schlumberger
Domain : Oil and gas
Team size : 6
Environment : Informatica IDQ , Microsoft SQL server
Role : Offshore Module Lead
Summary:
Schlumberger is the world's leading provider of technology for reservoir characterization, drilling, production, and processing to the oil and gas industry, Schlumberger supplies the industry's most comprehensive range of products and services.
IBM and Schlumberger have been collaboratively reviewing the current processes to perform the data profiling, cleansing and conversions in support of the 1st three releases of the ITT SAP Program.
The objective of the Data Profiling and Data Cleansing work stream is to implement an approach that will more tightly integrate the data cleansing and data conversion activities. The project works in Agile model.
Roles and responsibilities.
- Creation of Basic and Advance profiling and score carding and Code development.
- Code review.
- Onsite – Offshore coordination.
- Code migrations to higher environments.
- Mock support
Project Title:IBM – DF i2i Data Integration Development
Client: Chevron
Duration: 14th Jan 2017 to 2nd Nov 2017
Role: Senior Software ETL Developer
Environment: IBM Information Server v11.5,Teradata,HP-Unix
Description: Chevron Exploration & Production or E&P. Involves operations in searching for underground or underwater oil and gas fields and drilling exploratory wells and at the same time, operating the wells that recover to re-direct the crude oil or raw natural gas to the surface.
It’s all about WELLS
• Where to locate them
• How deep and how far to drill them
• How to design, construct, operate and manage them.
Exploration - The exploration sector involves obtaining a lease and permission to drill.
Drilling - Drilling is physically creating the “borehole” in the ground that will eventually become an oil or gas well. This work is done by rig contractors and service companies in the Oilfield Services business sector.
Production - The production sector of the upstream segment maximizes recovery of petroleum from subsurface reservoirs. Production brings the oil to the surface.
Responsibilities:
• Independently handled the Staging & Integration jobs, developed sequencers for the project.
• Handled special characters in datastage as well as in Teradata level.
• Worked on Teradta Sql and Load methodologies.
• Worked on administration related activities/guidance for the modules.
• Created the unix scipts for SFTP file extraction,archiving and triggered the datastage sequencers.
• Created the generic scripts for datastage project backups.
• Created generic jobs for Staging and Integration Jobs.
• Understand the design documents developed the Dimensions and facts jobs based on that.
• Understand the flow of process from top to bottom.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
Project#3
Project Title : Human Resources Management System
Client : Genpact
Duration : 9th May 2016 to 31st Dec 2016
Role : Senior Software ETL Developer
Environment : IBM Information Server v11.5,DASH DB,UNIX Shell Scripting
Description: Source data extraction from the defined data views created in the OHRMS source system.Source data extraction from the defined csv files provided by source systems Taleo, Hubble, EFMS, IPerform and Cheers.Loading of staging tables with source data.Integration of master and transactional data from Taleo, Hubble, OHRMS, EFMS, IPerform and Cheers.Transformations on the source data to load the SynerG BI and Analytics solution and provide an integrated view of the Hiring and O&S data for business reporting.
Responsibilities:
• Independently handled the Onboarding and BGC Module for the project.
• Worked on administration related activities/guidance for both HR and FP&A modules.
• Created the unix scipts for SFTP file extraction,archiving and triggered the datastage sequencers.
• Created the generic scripts for datastage project backups.
• Understand the design documents developed the Dimensions and facts jobs based on that.
• Understand the flow of process from top to bottom.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
.
06/2014 - 04/2016
Wipro Technologies, India
Senior Software Engineer
Project#1
Project Title : SMDM (STXales & Marketing Datamart) and BEACONDM
(Development,Production,Enhancement)
Client : Allergan
Duration : Jan 2016 to April 2016
Role : Module Lead
Environment : IBM Information Server v8.1,Oracle 11g, UNIX Shell Scripting
Description: Sales And Marketing Data Mart (SMDM) helps management to analyse phyiscian profile, sales allocation, account profile, calls details and RX data. SMDM sources data from CM, ASPIRE, AMS, and SAP/BW applications.
CM provides accounts and physician data, BW provides COPA direct sales and SAP accents data, AMS provides allocation data, and ASPIRE provides call data to the SMDM.
BEACONDM sources data from BEACON compliance related Business Process Management system. The purpose of this data mart is to provide an efficient reporting and analysis platform for compliance reporting and analysis; as well as operational reporting for Sales department.
BEACONDM sources data from BEACON, SMDM, CM, MDM and AERO applications.
Responsibilities:
• Monitor the daily, monthly and weekly jobs and reports which happen to process over the night time in PST.
• Check whether all the jobs / reports are starting and completing on time.
• If not, analyze the reason and fix it with the help of source systems.
• Coordinate with all the source systems for successful completion of the whole night load.
• Monitor the BO reports.
Project#2
Project Title : FCA / CMB ADI / Firefly
(Development)
Client : HSBC
Duration : Aug 2015 to Dec 2015.
Role : ETL Developer
Environment : IBM Information Server v8.1/ v11.3, Teradata 10,Control M 7.0,UNIX Shell Scripting
Description: In FCA project it contains two modules of accounts and transactions where I did transaction level by implementing history processing and loaded the data. In CMB ADI project the inbound files that are coming from mainframe need to extract and did SCD operation on target files for every day transactions that should be used by further transformations and in outbound jobs.
In Firefly project is to be started and implemented the shell scripts for filelist script, file validation and for file appending.
Responsibilities:
• Understand the design documents developed the jobs
• Used Generic Historic processing jobs to develop SCD using database
• Designed SCD based on the file’s this I took as challenge
• Writing unix shell scripts to easy the business logic without implementing many jobs
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Designed Sequencer to automate the jobs.
• Preparing Unit test cases and test case documents.
Project#3
Project Title : SLRP
(Development)
Client : HSBC
Duration : Nov 2014 to Aug 2015.
Role : ETL Developer
Environment : IBM Information Server v8.1, Teradata 10,Control M 7.0,UNIX Shell Scripting
Description: (Supervisory Liquidity Reporting Project ) It contains 3 phases, inbound, transformations, out-bound. In response to the Financial services authority findings following the SLRP in March 2012, HBEU Asset and Liability Management setup a project ,at the request of the HSBC Bank board, to conduct a general analysis into how the deposit base might behave under a stressed scenario.
The data analysis will support customer segmentation and their product date to understand how deposit balances across these products behave using a score card. This analysis will also help to identify data attributes believed to be the key drivers of behavior in line with existing and proposed liquidity regulation.
The project will be split into retail and wholesale sections in assessing the stickiness of deposits across all bands in the HSBC specific or market wide liquidity stress event. Output from the scoring will be for internal consumption by Senior Management. Date for all customers of HSBC, First Direct, Marks and Spencer’s and all segments- Retail,Commercial,GB&M and Private Bank in the UK is to be used as part of this project.
Responsibilities:
• Understand the design documents developed the jobs based on that.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Designed Sequencer to automate the jobs.
• Preparing Unit test cases and test case documents.
• Developing & Scheduling the jobs in Contol M.
• Gathering the status and providing it to onsite co-ordinator
Project#4
Project Title : GDM
(Development,Supporting)
Client : HSBC
Duration : July 2014 to Nov 2014.
Role : ETL Developer
Environment : IBM Information Server v8.1, Oracle 10g, Teradata 10,Control M 7.0
Description: (Global Deliverable Management) It contains 9 processes as Deposits,Loans,Cards,customers,Application,Contact,Investment,Insurance,channel for 4 regions SGH,MYH,IN,TWM.It contains 2 sub areas namely Demand Deposit, Term Deposit.
Responsibilities:
• Understand the design documents developed the jobs based on that.
• Understand the flow of process from top to bottom.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Scheduling the jobs in Contol M.
• Worked in Production support , handling QC defects regularly.
• Gathering the status and providing it to onsite co-ordinator.
11/2011 - 06/2014
Bodhtree Consulting Ltd, India
Associate Consultant
Project Title : TIAA–CREF
(Dev,Migration from Informatica v7.1.5 to IBM Information Server v 8.1)
Client : TIAA–CREF,US.
Duration : September, 11 to June 2014.
Role : ETL Developer
Environment : IBM Information Server v8.1, Informatica Power Center v7.1.5, Oracle 10g, Teradata 7.2, MS SQL Server 2000, Citrix.
Description: Teachers Insurance and Annuity Association – College Retirement Equities Fund (TIAA–CREF) is a Fortune 100 Financials services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. TIAA–CREF
serves 3.7 million active and retired employees participating at more than 15,000 institutions and has $453 billion in combined assets under management.
The aim of the project is to replace the existing ETL system, which is there in Informatica v7.1.5 with the IBM Information Server v8.1. The base line for the development of the datastage jobs is the existing Informatica mappings.
Responsibilities:
• Worked on various TIAA applications such as RMW, Siebel, FAO & Externalization, CRDM, AODM, PGWA, CSI, EXP-AG, FIF, Proxy, TDA& CCS
• Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.
• Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica ETL tool.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Scheduling, Monitoring and Debugging of Informatica Sessions and Workflows in Auto sys Scheduler.
• The Objective is to extract data stored in different databases such as Oracle 9i, SQL server, Flat files and to load data into staging tables first and then into Oracle.
• Involved in Peer reviews of the Informatica Mappings and UTC Documents.
• Involved in performance tuning by optimizing the sources, targets, mappings.
• Preparation of Low Level Design for the mappings created.
• Prepared Unit test cases.
• The Objective is to extract data stored in different databases such as Oracle 9i, Flat files and to load data into staging tables first and then into Oracle.
• The Informatica mappings with in those batches would then populate the staging tables.
• Designing Datastage jobs based on the understanding of informatica jobs
• Developing the Datastage jobs by taking the informatica mapping as reference.
• Involved in creating different types of functionality’s and equivalents to meet informatica logic
• Performance tuning datastage jobs.
• Preparing Unit test cases and test case documents.
• Peer review of the developed datastage jobs.
• Promoting jobs to other environments.
• Supporting the QA testing, fixing and retesting the defects in SIT.
• Supporting UAT, Fixing and retesting the defects raised in UAT.
• Co-ordinating work with the other team members.
• Gathering the status and providing it to onsite co-ordinator.
12/2009 - 10/2011
Elixircare SofTech Pvt Ltd, India
Software Engineer
Project#1
Project Title : IBM-Cardinal Health
(Migration from Informatica v7.1.5 to IBM Information Server v 8.1)
Client : Cardinal Health Inc,US.
Duration : April, 10 to September, 11.
Role : ETL Developer
Environment : IBM Information Server v8.1, Informatica Power Center v7.1.5, Oracle 10g, Teradata 7.2, MS SQL Server 2000, Citrix.
Description:
The aim of the project is to replace the existing ETL system, which is there in Informatica v7.1.5 with the IBM Information Server v8.1. The base line for the development of the datastage jobs is the existing Informatica mappings.
Responsibilities:
• Analyzed the Informatica mappings and created an equivalent Data stage jobs, containers wherever applicable.
• Developed the data stage equivalent jobs for the various modules.
• Handle some many datatype , connector and logical issues .
• Testing, Reviewing the jobs.
• Prepared Unit Test cases, maintaining Code Review Documents etc as per the standards
• Handling different types of data types and resolving different types of special characters.
• Using of scd-1 & 2 and involved in performance of jobs through the nodes and the partition techniques.
• Involved in creating different types of functionality’s and equivalents to meet informatica logic.
• Designed Sequencer to automate the jobs.
• Involved in usage of Connectors rather than Enterprise stages.
• Implementing the Rank Transformation and Vertical pivot logic in the Transformer.
• Involved in usage of Range-lookup, Dynamic-Lookup and Sparse Lookup.
• Involved in DRF Creation for Control-M.
• Having good idea on Control-M Scheduling.
Project#2
Project : IBM_Consip
Client : IBM_Consip phase1 and phase2, Italy
Environment : Data Stage 8.1, Informatica 8.1, Oracle 9i/10g,
Windows XP, IBM AIX & Sun Solaris
Role : ETL developer
Duration : Dec-2009 to March 2010
Description:
Consip, ministry project even though it is a private law company, operates in the market exclusively with the function of “service organization” on behalf of the Public Administration of Italy. The control functions over Consip, including its corporate aspects, are exercised by the Ministry of the Economy and Finance, which determines its mission and strategic objectives, as well as the relevant implementation modalities; a further control over financial management is exercised by the Consip.
The Existing system available in the Informatica flows for data warehousing environment and all the flows are running under the Oracle9.1 Database. We are developing the code to buil a strong DSS system.
Consip phase2: In this phase final core load jobs are designed and taken care about
format of reporting layer and error conformation tables data marts like
DMA.
Responsibilities:
• Responsible for developing the Datastage Jobs.
• Query resolution and problem solving
• Interacting with Developers for assisting them in the identification, simulation, resolving and tracking of problems events.
• Involved in UT and SIT.
Local Availability
Only available in these countries:
India
Based on dicussion per daily 1-3 hrs
