Informatica/ETL developer. Skills: Informatica Power Center,Oracle SQL

Paul Charugundla

Email: ***********.**@*****.***

Cell# 732-***-****

Profile

* **** ***** ** ***** IT Experience

* **** ***** ** *********** Experience

Summary

ETL: Around 9 plus years of experience in Data Warehousing & Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.5.1/8.5.1/8.1.5/7.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), Informatica Data Analyzer, OLTP, OLAP, IMS Rx Data (Xponent, Xponent Plantrak, Plan Trak, Rx Data), Autosys, IDQ

Databases: Around 9 plus years of experience using Oracle SQL, PL/SQL, SQL*Plus,

Education: Bachelors in Engineering.

Technical Skills:

Hardware / Platforms

Windows 7 Professional/98/XP/NT/2000, Sun Solaris, HP-UX, Linux

ETL Tools

Informatica 7.1.3/8.1.5/8.5.1/8.6.1/9.5.1, IDQ, IDE, Informatica developer for data quality.

Programming Languages

C, SQL, PL/SQL, Shell Scripting

Databases

Oracle 8i/9i/10g,11g SQL Server 2000/2005/2008, Teradata, Greenplum.

Others

Toad,PL/SQL Developer

Professional Experience:

MUFG Union Bank N.A, CA Sep’10-Jun’17

Sr. Software Engineer

The Mitsubishi UFJ Financial Group (MUFG) is one of the world’s leading financial groups, which provides a range of corporate, commercial, and retail banking services, as well as wealth management solutions in the United States. The purpose of the project is to create a data mart for regulatory reporting.

Project 1 (RWA): Jan’13-Jun’17

Responsibilities:

Worked with Business analysts on requirements, business analysis, Coding, debugging, implementation, testing of solutions, and project coordination.

Worked on investigating, analyzing and providing the resolution for production issues.

Worked on helping Business users on post implementation related reviews/tasks.

Delivered all tasks in time with no delay, through all phases from development to post implementations.

Worked on documentation to help Business users on Production process, helped Business users on providing the files in the required format.

Provided the work efforts for any enhancements/changes.

Performed impact analysis for any changes, upstream application system changes.

Created different transformations for loading the data into target database using e.g. Source Qualifier, Update Strategy, Lookup transformation, Expressions, Sequence Generator etc.

Worked on creating unit test cases in line with test plan.

Worked extensively on Unit testing, integration testing of ETL mappings

Used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.

Created sessions to move data at specific intervals & on demand using Workflow Manager.

Worked on Production support, and resolving the Production issues.

Worked with Informatica to load data from flat files to target database.

Processed data using various tasks (session, command, etc.) and managed database connections.

Worked on Autosys for Scheduling workflows.

Created migration document and worked with ETL admin, DBA to coordinate code migrations.

Created oracle stored procedures and cursors.

Worked and took responsibility of creating Change management (CM) tickets and worked on the needed documentation and ensuring all the approvals are in place for Production deployment.

Project 2 (IDQ): Sep’10-Jan’13

The purpose of the Data Integrity Basel II project was to create a data quality repository to capture data quality with a numeric score and to track data quality issues back to the source system as necessary.

Worked on creating mappings in Informatica developer and using them as part of power center mappings by exporting them as mapplets.

Worked on IDE and IDQ

Worked with Business analysts on requirements, business analysis, testing and project coordination.

Created different transformations for loading the data into target database using e.g. Source Qualifier, Update Strategy, Lookup transformation, Expressions, Sequence Generator etc.

Worked on Unit testing, integration testing of ETL mappings.

Used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.

Created implementation/migration document and worked with ETL admin, DBA to coordinate code migrations.

Worked on HP service Centre for change management and incident management tasks.

Environment: Informatica Power Center 8.6.1,9.5.1(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow Monitor, Worklet Designer, Task Developer), Informatica Data Quality 8.5, Informatica Developer 9.5, Oracle 11g, SQL Server 2008, Green plum, Shell Programming, PL/SQL, Toad 10, Flat Files, Linux.

AMGEN, CA Mar’09-Sep’10

ETL Delivery Lead

Amgen is a leading human therapeutics company in the biotechnology industry and pioneered the development of novel products based on advances in recombinant DNA and molecular biology. The purpose of the project is to create EDC Forecasting and Tracking Data mart, that integrates, organizes and makes available information from multiple source systems in order to enable operational reporting and ad hoc analysis of business process.

Project 1:

Responsibilities:

Created different transformations for loading the data into target database using e.g. Source Qualifier, Update Strategy, Lookup transformation, Expressions, Sequence Generator e.t.c.

Worked on Unit testing, integration testing of ETL mappings

Using versioning capabilities of Informatica performed check in check out of objects.

Used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.

Created sessions to move data at specific intervals & on demand using Workflow Manager.

Worked on Production support.

Worked with Informatica to load data from flat files to target database.

Processed data using various tasks (session, command, event-wait etc.) and managed database connections and scheduled workflows.

Developed shell scripts to FTP files.

Created migration document and worked with ETL admin to coordinate code migrations.

Created oracle stored procedures, cursors, and sequence generators.

Co-ordinated off-shore team.

Worked on Webservices Consumer Transformation.

Environment: Informatica Power Center 7.1.4(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow Monitor, Worklet Designer, Task Developer), Oracle 10g, Shell Programming, PL/SQL, Toad 8.6, Flat Files, Sun Solaris 5.9.

Project 2:

The purpose of the project was to stage data from different sources to Enterprise Data Warehouse.

Responsibilities:

Created different transformations for loading the data into target database using e.g. Source Qualifier, Update Strategy, Lookup transformation, Expressions, Sequence Generator e.t.c.

Worked on Unit testing, integration testing of ETL mappings.

Created sessions to move data at specific intervals & on demand using Workflow Manager.

Used TPT Load utility to load data into Teradata.

Environment: Informatica Power Center 8.6.1(Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Worklet Designer, Task Developer), Oracle 10g, Flat files, Teradata 12, Teradata SQL Assistant 12, Windows Server 2003 R2.

ViPS (GDIT Company), MD Sep’08-Dec’08

Informatica/BODQ Developer

ViPS® is a leading provider of healthcare data management, analytics, decision support, process automation and related information technology solutions that help governmental and commercial healthcare payers improve patient outcomes, enhance market position and reduce costs. The purpose of the project was to validate whether the data that is coming in is according to Business rules or not and to create a summary of the Incoming Files using Informatica.

Responsibilities:

Worked with Business analysts for requirement gathering, business analysis.

Created different transformations for loading the data into target database using e.g. Source Qualifier, Update Strategy, Lookup transformation, Expressions, Sequence Generator.

Worked on issues with migration from development to testing.

Worked on Unit testing, integration testing of ETL mappings

Created session tasks, worklets and workflows to execute the mappings

Using versioning capabilities of Informatica performed check in check out of objects.

Used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.

Worked on various BODQ transforms like Reader, Writer, Formatter, USA_Reg_Address_Cleanse, Filter e.t.c.

Designed and developed Dataflow and Data model for the Project.

Environment: Informatica Power Center 8.6(Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow Monitor, Worklet Designer), Business Objects Data Quality XI R2 11.7, Data Quality Project Architect, Python Scripting, SQL Server 2005, Flat files, Excel, Windows Server 2003 R2

Sepracor Inc, MA Nov’07-Mar’08

Informatica Developer

Sepracor Inc. is a research-based pharmaceutical company dedicated to treating and preventing human disease by discovering, developing, and commercializing innovative pharmaceutical products that are directed toward serving unmet medical needs. The Purpose of the project was to create a Data Mart for the Sales & Marketing team for the Sales Analysis of their Products.

Responsibilities:

Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.

Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.

Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

Created sessions to move data at specific intervals & on demand using Workflow Manager.

Created session tasks, worklets and workflows to execute the mappings.

Worked on issues with migration from development to testing.

Worked on Unit testing, integration testing of ETL mappings.

Developed scripts to perform both unit as well as system integration testing.

Involved in Production support.

Worked on Data Analyzer.

Populating fact and dimension tables with power center slowly changing dimension wizard model, maintain history of the dimension tables.

Using versioning capabilities of Informatica performed check in check out of objects.

Used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.

Environment: Informatica Power Center 8.5.1/7.1.3(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor, Worklet Designer), Informatica Data Analyzer, PL/SQL, Oracle 10g, Shell Programming, Toad, Excel, Unix scripting, Sun Solaris, Flat files, IMS RX Data, MicroStrategy.

Hewlett Packard, TX Jan’07-May’07

DW/Informatica Developer

HP is a technology company that offers complete technology product portfolio which includes offering consumers a wide range of products and services from digital photography to digital entertainment and from computing to home printing. The purpose of the project was to create a Data mart for the entire sales employee.

Responsibilities:

Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.

Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.

Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

Attended Design phase meetings and conference meetings

Extensively worked with Informatica tool - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, and Transformation developer.

Extensively worked with Informatica to load data from flat files to target databases.

Created sessions to move data at specific intervals & on demand using Workflow Manager.

Worked on issues with migration from development to testing.

Created shared folders, local and global shortcuts to reuse metadata.

Processed data using threads and various tasks (session, command etc.) and managed database connections and scheduled workflows.

Performance tuning of mappings, transformations and sessions to optimize session performance.

Environment: Informatica Power Center 8.1.5/7.1(Repository Manager, Designer, Workflow Monitor, Workflow Manager), ETL, Flat files, Oracle 10g/9i, PL/SQL, Business Objects 6.5, Maestro, Shell Programming, SQL * Loader, Toad, Excel, Unix scripting, HP-UX.

Contact this candidate