SUMMARY

• 6.5 years of IT experience in the business requirement analysis, design, coding, development, testing and implementation of Data Warehouse/Data marts using ETL - tools like Informatica PowerCenter.
• Executed project in Financial, Banking, Telecom and Hospitability domains.
• Strong skills in data analysis, data requirement analysis and Data Mapping for ETL processes.
• Experience in Informatica PowerCenter (9.x,8.x) tools like Designer, Repository Manager, Workflow Manager and Workflow Monitor in developing ETL-code.
• Commendable experience in developing complex mappings using transformations like Lookups, Router, Aggregator, Sorter, Joiner, Filter and Update Strategy.
• Extensive understanding of Dimensional Data Modeling, Dataware house concepts and designing Star schemas & Snowflake Schemas for OLAP Systems.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3.
• Experience in trouble shooting bottlenecks and implementing performance tuning at various levels such as Source, Target, Mapping and Session in ETL Process.
• Strong Knowledge in ETL design document and mapping sheet creation.
• Very good experience on RDBS databases like Oracle 10g,11g.
• Excellent programming skills on PLSQL concepts like stored procedures, functions, triggeres, views etc.
• Creating and managing SQL queries, SQL tuning for efficient execution.
• Extensively worked on performance tuning areas of SQL.
• Experience in creating UNIX-shell scripts.
• Involved in implementing telecom billing operations by using Kenan FX product and IECCM tool.
• Experience in coding using PRO*C.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Having good experience as team lead and led the team with team size 3-5.

TECHNICAL SKILLS

Databases: Oracle 10g/11g

Oracle Tools: TOAD, SQL*PLUS,SQL Developer, SQL*Loader

ETL Tools: Informatica 9.x/8.x

Other Tools: IECCM, NDB

Data Modeling: ERWIN

Telecom Billing Solutions: Kenan FX, EBPP Intense

Programming Skills: SQL, PLSQL, Pro*C

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

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

Sr. ETL developer/Lead

Responsibilities:

• Working withclient to identify and understandrequirements which is provided through ISD’s (Integration Specific document) and translating them into ETL code.
• Interacting with the business users by conducting meetings with the clients in requirements analysis phase.
• Preparing design documents like HLD (High level design) and TDD (Technical detail design) documents.
• Preparing data mapping sheets (Source to Target mapping).
• Meeting with clients for HLD, TTD and ETL code walk through and approvals.
• Using Power Center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager for ETL code development.
• Most of the transformations used were Source Qualifier, Aggregators, Connected & Unconnected Lookups, Filters & Normalizer.
• Written SQL overrides in source Qualifier according to business requirements.
• Performance tuning,identifyingandresolving performance Bottlenecks sources, targets, mappings and sessions to provide maximum efficiency and performance and to complete within the SLA time.
• Creating deployment checklist and getting all the objects migrated to test environment.
• Preparing release notes and release handover meetings with QA team.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Coordinating with offshore team for the joint development efforts.
• Participating in daily defect triage meetings with QA team and fixing the defects.
• Participating in daily stand-up meetings and updating overall development status to project leadership.
• Worked with DBA's to design and build the Staging/Target databases.

Environment: Informatica PowerCenter 9.5.1 Oracle 11g, UNIX, SQL, PLSQL, TOAD, SQL Developer

Confidential, Plantation, FL

Sr. ETL Developer

Responsibilities:

• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL) using Informatica.
• Involved in business users meeting to understand the business requirements.
• Created HLD and LLD documents according to the requirement.
• Used Informatica Power Center 9.1 for (ETL) extraction, transformation and loading data from heterogeneous source systems like flat files, oracle database into target database.
• Extensively developed various Mappings, which performed Extraction, Transformation and Loading of Source data into OLAP schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner, Sorter, Union, Rank etc.
• Extensively used Re-usable Objects like Mapplets, Transformations.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Designed implementation of SCD type 2.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Scheduled the Jobs by using Informatica scheduler.
• Validated data using Informatica IDQ.
• CreatingHigh Level Design and Detailed Designin the Design phase.
• Coded PLSQL scripts like stored procedures, functions, triggers, indexes, views.
• Involved in SQL tuning by implementing explain plans and optimizing query execution using hints.

Environment: Informatica PowerCenter 9.1, Informatica IDQ, Oracle, UNIX, SQL, PLSQLSQL *PLUS

Confidential, Miami, FL

Sr. ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Developed the mappings using needed transformations in Informatica tool according to technical specifications.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Excellent understanding of Star Schema modeling, Snowflake modeling.
• Created sessions and workflows for the source to staging data flow and staging to Target loading
• Involved in Unit Testing and Resolution of various Bottlenecks that came across.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Created mapping using parameter file to determine inputs to the parameters.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.
• Designed and developed Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL, PLSQL, SQL *PLUS,TOAD,ERWIN

Confidential

ETL developer

Responsibilities:

• Resolving Incidents, requests and change requests.
• Communicated with business customers to discuss the issues and requirements.
• Modified existing mappings for enhancements of new business requirements.
• Identified problems in existing production data and developed one time scripts to correct them.
• Extensively used different types of transformations, mappings and built workflows.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Wrote some complex Oracle Stored Procedures and functions.
• Implementation and up gradation of the billing system for all the local markets.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• Coordinating with the team and interacting with the client for implementation of deliverable.
• Proactively interacting with clients in understanding the requirements and fixing the issues.
• Played key role in performance improvement activities like query tuning.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in implementing billing change request operations by using Kenan FX product and IECCM tool.
• Involved in coding of customer bill display format using PRO*C.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL, PLSQL, UNIX, PRO*C, Kenan FX, IECCM

Confidential

ETL developer

Responsibilities:

• As a Team member involved in extracting the data from Oracle database, transforming and loading data into Oracle target according to client requirements using Informatica PowerCenter.
• Involved in Unit and integration testing of the mappings.
• Created and scheduled workflows and scripts to run on various predefined intervals.
• Used transformations like Aggregator, Filter, Router, Sequence Generator, Update Strategy, Rank, Expression and lookup (connected and unconnected) while transforming Data according to the business logic.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator etc. In mappings to perform the ETL process.
• Worked extensively on fixing invalid Mappings, and performing Unit and Integration Testing.
• Understanding existing business model and customer requirements.
• Performed Informatica code testing, debugging and documentation.

Environment: s: Informatica PowerCenter 8.1, SQL, PL/SQL, UNIX Shell Script, Oracle & SQL Server