SUMMARY

• Over 9 years of extensive IT experience in Design, analysis, development, testing, full cycle implementation, troubleshooting and production supporting of Data Warehousing(BI), Data Integration and Data Migration based applications using Informatica Power Center 9.5.1,9.1.1,8.6,7.X, Teradata, Oracle,UNIX as ETL tech lead.
• Expertise in designing and implementing ETL environments using traditional ETL strategies as well as tool Informatica Power Center 9.X, 8.X,7.X and Proficient in programming with UNIX, Shell Scripting and PL/SQL.
• Experience in creating Technical design, Impact analysis, Implementation release, Unit test, Environment Specifications, Root Cause Analysis, Process Management and Operation Support documentation.
• Very good experience using ETL and Data ware house tools to load/extract data, schedule jobs, troubleshoot and production operational support functions and Schedule jobs using Control - M, Crontab scheduler.
• Experience in the team working as On-site Coordinator and co-ordinate with Off-Shore team for resolving the technical issues in project level and customer related support.
• Good exposure to design, development, testing, debugging, implementation, documentation, production support and responsible for Production deployments.
• Excellent communication, customer facing skills, interpersonal skills and ability to work independently and as well as a team member.
• Extensively used Informatica PDO (Push down optimization) utility by using Teradata and Oracle data bases.
• Extensive understanding of Transactional and Dimensional Data Modeling, Data Ware house concepts and Designing Star schemas & Snowflake Schemas for OLAP Systems.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 (version, flag and time).
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process.
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Source Qualifier,SQL Stored procedure, Filter and Update Strategy.
• Expertise in data extraction from Flat Files (XML, excel, csv, fixed width, delimited, txt), Teradata and Oracle database.
• Good experience in handling terabytes of data and good at analyzing the data related issues.
• Created various tasks like sessions, and workflows in the workflow manager to test the mapping during development.
• Extensively worked on performance tuning areas. Good knowledge on partitions, indexes, table space related issues.
• Good in suggesting the performance tuning techniques to increase the data load through put.
• Strong understanding and hands on experience with Abinitio/Control-M tool.
• Strong knowledge on Informatica MDM and technically capable enough to work.
• Various Project/clients I worked so far in my career and related business domains.

TECHNICAL SKILLS

ETL/DW Tools: Informatica Power Center 9.5.1/9.1.0 /8. X,7.X, Informatica MDM, Ab Initio

DataModeling Tools and others: ER-Win, TOAD, Teradata sql assistant. Visio, Control-M

DBMS: Teradata 12/13, Oracle 11i, 10g/9i, MS Sql Server 2012.

Languages: SQL, PL/SQL, SQL*PLUS, C.

Operating Systems: Unix, MS Windows NT/95/98/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

ETL Tech lead

Environment: Informatica-Power Center 9.5.1/9.1.0 , Teradata 12, Oracle 11g, MS sql server, Control-M

Responsibilities:

• Analyze the existing system in Ab-Initio and customer requirements in different data marts.
• Prepared re-engineering design documents based on the existing semantic data marts.
• Prepared design documents for Stage and Integration layers based on data modeler’s inputs.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup (Connected & Un-Connected), Stored Procedure and Expression as per the business requirement.
• Extensively use Informatica PDO utility to increase the performance in the data load in DB level.
• Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Coordinating with offshore team and interacting with the client for implementation of deliverable.
• One to one interaction with the clients. Proactively interacting with clients in understanding the requirements and fixing the issues.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Worked with Teradata utilities like BTEQ, Fast Load, Multi Load and TPT streams.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Played key role in performance improvement activities like query tuning.
• Created Control-M jobs and automate the job schedules based on dependencies in Control-M.
• Responsible for code deployment to various higher environments like QA, UAT and PROD.

Confidential, Thousand Oaks, CA

Sr.ETL Developer

Environment: Informatica-Power Center 9.1/8.6, Oracle 10g

Responsibilities:

• ETL Design, Analyzing the requirements and creating Technical design specifications and mapping documents.
• Developing, Testing and Validating ETL mappings, Unix scripts.
• Development and Support of Applications CMA (Customer Master and Alignment), ODS, EDX, IMS and Wyeth.
• Used ETL to extract and load data from Oracle, Flat files, Excel sheets to oracle and flat files.
• Extensively used the Source Qualifier, Joiner, Sorter, Expression, Aggregator, Router, Sequence generator, Lookup transformations, Update strategy, filter, XML and Store Procedure Transformations.
• Monitoring Production Jobs,analyzing and resolving the environmental issues by coordinating with several teams that include Informatica admin team, and Oracle DBA Team. Escalating at proper time and resolving the problems well within time.
• Used session logs to debug sessions.
• Solving day-to-day incidents and tickets within SLA.
• Root-cause Analysis of Issues.
• Resolving issues raised by different owner groups based on the priority.
• Experience in Incident, Problem, Service Request and Change Management processes.
• Working with Daily, Weekly and Monthly operational activities.
• Created, modifying the UNIX scripts and modified the view as per requirement.
• Creating the Crontab UNIX jobs scheduling as per requirement.
• Handling Knowledge sharing sessions to Team Members.
• Effort Estimation of new enhancements.
• Development of new Units and carrying out testing and supporting UAT.
• Scheduling the workflows by using the workflow manger schedule option as per the requirement

Confidential, Boston, MA

ETL Developer

Environment: Informatica-Power Center 8.6, Oracle 10g

Responsibilities:

• Mainly involved in ETL developing.
• Involved in analysis, design, coding and creation of UTC and Unit Testing for the requirements.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Rank, Update strategy, Lookup, Sequence generator, union and Joiner.
• Implemented SCD, Upsert and Insert logic for loading the data.
• Involved Code review and Unit Testing.
• Developing and modifying changes in mappings according to business logic.
• Prepared Specification Documents.
• Involved in Unix scripts development.
• Interacting with the client daily to discuss the status of the project, clarify any queries regarding the functionality etc.
• Involved in debugging the mappings.
• Involved in the performance tuning.

Confidential, New Century, KS

ETL Developer

Environment: Informatica-Power Center 7.1.4, Oracle 9i, sql sever.

Responsibilities:

• Mainly involved in ETL developing.
• Used INFORMATICA as an ETL tool to extract data from source to target.
• Worked in various types of transformation like Lookup, Update Strategy, Joiner, Filter, Aggregation, Expression, Source qualifier, Sorter, Router, Sequence generator and stored procedure transformation of Informatica-7.1.4.
• Create and run the sessions in workflow manager.
• Implemented best performance strategies.
• Developed and executed the Unit Test Cases.
• Involved in Creating scripts to run workflows.

Confidential, North Carolina

ETL Developer

Environment: Informatica Power Center 8.1.1, Oracle 10g.

Responsibilities:

• Involved in documentation, Mainly involved in ETL developing, Used INFORMATICA as an ETL tool to extract data from source to target.
• Worked in various types of transformation like Lookup, Update Strategy, Joiner, Filter, Aggregation, Expression, Source qualifier, Sorter, Router, Sequence generator and stored procedure transformation of Informatica-8.1.1.
• Involved in creation of mapplets to extract the required data for essential business intelligence.
• Performance tuning, Create and run the sessions in workflow manager, Performed unit testing.