Informatica senior ETL developer
Resume:
SUBHA BRATA PATI
E-Mail:- **************.***@*****.***
Phone:-+91-808*******
Objective:
Seeking a challenging environment that encourages continuous learning and provide exposure to new technology and ideas.
Experience Summary:
Working as an Informatica senior developer/team lead in Capgemini India pvt. ltd, Pune. Having 6.11 years of total experience involved all phases like requirement gathering, analysis, design, development of ETL mappings.
Currently working in Informatica 9.1 version.
Handling a team of 5 members.
Developed Informatica 9.1 Fact,aggregates,dimensions using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator,joiner etc.
Involved in running recon tool for sending daily report to onsite coordinators.
Created and Applied Labels, Queries and Deployment Group to move code from one repository to other.
Designed the batch jobs using TIDAL/UC4 scheduler application.
Involved in data warehouse COE for various testing and providing training.
Creation of Unix scripts as per requirement.
Strong in concepts related to Oracle SQL & PL/SQL(OCA Developer certified).
Good knowledge in Netezza scripting.
Performed Release management activities.
Knowledge on informatica installation/administration.
Good knowledge in Data warehousing concepts.
Having Good communication & written skills.
Good Domain Knowledge in Banking and Securities.
Good knowledge in telecom services like VAS.
Focused, hardworking, self-motivated and an effective team player.
Worked with xml sources and targets in Informatica.
Worked with ebcdic files in Informatica using powerexchange.
IELTS overall score of 7.0(Dec 2015).
Software exposure:-
Data Base : Oracle 9i,10g,11g, Netezza 6.0, Teradata
Tools known : Informatica powercenter 9.1, Informatica power exchange.
Scheduling Tools : Tidal, Control m 6.2, UC4
Operating Systems : Windows xp, Windows 7, UNIX
Professional Experience:
Organization- Capgemini India Pvt ltd
1.Client: Barclays PLC
Description:
Barclays is a British multinational banking and financial services company head quartered in London. It is a universal bank with operations in retail, wholesale and investment banking, as well as wealth management, mortgage lending and credit cards. It has multiple sources of data in various formats which gets passed through a layer called BEM(Barclays enterprise middleware) and then data is passed to various downstream systems. All validations is done in BEM layer.
Duration: Oct 2012 to till date
Responsibility:
Discussion with BA for new IRD document to understand the requirements for the module and create query log.
Creation of Low level design document and get it reviewed by the client.
Explaining the data model and requirements to the team and coordination with team and client for coding status.
Individual level coding and code review for the team.
Explaining code to the testing team and deployment of code to next environments.
Part of Barclays innovation team for developing reusable unix scripts.
Organization- Cognizant technologies
2.Client: J P morgan chase UK
Description:
J.P. Morgan is one of the world's leading global investment banks, with one of the most extensive client bases in the world. The users are interested with the onboarding data that happens in JPMC chase. Multiple applications which are now migrating to data marts where reporting is done directly on OLTP systems.
Duration: May 2012 to Sep 2012.
Responsibility:
Understanding the requirement document and conceptual data modeling.
Understanding the existing application and the reporting done. Set up review with client and creating the physical data model.
Creation of Informatica mappings.
Review of informatica codes with architecture team from JPMC.
Peer review of the codes.
Release management activities
Creation of Unix scripts as per client requirement as a part of JPMC innovation team.
3.Client: Time warner Cable USA
Description:
Objective of Order Management Reporting Phase 1 is to pull Digital Home Phone orders data from OMSe Mirror and to build a data mart for providing Analytical Reports to Business users.
Duration: 1st Oct 2011 to Aril 2012.
Responsibility:
Understanding the requirement document and creating the logical data model.
Set up review with client and creating the physical data model.
Creation of Informatica mappings required for staging area.
ETL coding through Netezza scripting.
Scheduling of the ETL codes though tidal scheduler.
Release management activities.
4.Client: Kpn Telecom Netherlands
Description: Kpn Telecom is one of the leading telecom service provider in germany and one of the biggest client of cognizant.
Kpn provides VAS services apart from normal calling services and have a huge number of customers subscribing to different packages in their services.
Duration: 1st July 2011 to 30th Sep 2011.
Responsibility:
Requirement Analysis through business model and functional model.
Developed Informatica 8.6 Fact and Dimensions mappings Type-I & Type-II using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc.
Involved in designing of upcoming releases to be done.
Giving support to the scheduled job runs.
Developed test cases and unit testing, conducting peer reviews of all my mappings
Creation of Unix scripts as per requirement.
Organization Name: Wipro Technologies
5.Client: Credit-Suisse USA.
Description: Credit Suisse is one of the leading Investment Bank, and one of the biggest Client of Wipro Technologies.
Excalibur – Expense Calculation and Integrated Business Reporting.
Excalibur is an end to end automated platform that supports the expense lifecycle, Independently verify third-party Brokerage, Clearing and Exchange (BC&E) expenses.
Allocate BC&E expenses using an activity-based model. Provide a global repository for trade, expense and rate data that can be accessed by various business areas and made available to existing financial systems.
Duration: 17th Aug 2009 to June 2011.
Responsibility:
Requirement Analysis through business model and functional model.
Involved in writing High level design (HLD) and low level design (LLD) documents for Informatica components during the design phase.
Developed Informatica 8.6 Fact and Dimensions mappings Type-I & Type-II using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc.
Improved Performance by selecting all Dimension LKP cache as persistent and reused those caches for Fact loads.
Implemented a logic by which the incremental load is handled in all the mappings.
•Done error handling while designing Fact mappings
•Helping informatica support team for any job failures for quick retreival.
•Designed the Control M jobs and set the dependency between them.
•Created the deployment group and queries for code movement
•Created and applied Label to move the code from one environment to other
•Handled release to QA.
•Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
Effectively involved in test data preparation and code review.
Effectively worked in Recon tool for sending reconciliation data every day after daily batch to onsite coordinators. If data mismatch occurs between source and BI side then making appropriate debugging on it till all data gets matched.
6.
Organization Name: One97 Comm. Pvt. Ltd.
It is a leading Value Added Service Provider for mobile & Landline Operators. Its Client includes Airtel, IDEA, HFCL, and International Firms like Roshan, watania.
Duration: 19th Jan 2009 to 19th July 2009
Functions: Networking, Programming Paradigm, DBMS, Data Analysis, Business Statistical Interpretation.
Software Platforms: Contaerra, PEC- IVR under Linux OS
Client AirCel
IVR Platform Contaerra & PEC
Description Develop various Interactive or non interactive promotional
Out dialer (auto dialer) as per requirement of client
Responsibility Design IVR and Database.
Running daily batch and checking for logs generated using sql queries.
Sending daily reports to client.
Client interaction as a representative of one97 communication pvt.ltd.
Certifications:
OCA certified (Developer) from oracle.
Netezza(Developer) certified from IBM.
Trainings:
Attended 1 week’s internal training on Data ware house Basics and Informatica (power center 8.6)
Attended 1 week’s internal training on Data ware house Basics and Cognos 8.1.
Educational Qualifications:
Examination
Specialisation
School/
College
Board/
University
Year of passing
%
B.Tech
Electrical &Electronics engineering
Silicon institute of technology,
Bhubaneswar
BPUT
2008
7.86
(CGPA)
+2
Science
Guru-Nanak
Public School,
Sambalpur
C.B.S.E
2003
72
10th
Kendriya
Vidyalaya,
Sambalpur
C.B.S.E
2001
70
Personal Profile:-
Date of Birth :23rd September, 1986
Sex :Male
Nationality : Indian
Category :General
Marital status :Single
Languages Known :English, Hindi,Oriya.
Permanent Address:- S/o Satyabrata pati
Plot No:- R3/G2
J.M.Colony, End Of Lane-4th
PO:-Budharaja, Sambalpur
Orissa. Pin:-768004
Declarations:
I hereby declare that all the statements made above are true and correct to the best of my knowledge and belief.
Date:
Place: Signature: Subha brata pati
Contact this candidate