SUMMARY:

• More than 8 years of IT experience in Data Warehousing technology using Informatica PowerCenter, PowerExchange, Data Quality and different types of RDBMS databases like Oracle, SQL Server, Tera Data, DB2, Sybase, etc.
• 3 plus years of experience of real - time CDC (change data capture) design, development and implementation using Informatica PowerExchange 9.x/8. x.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production support
• Extensive experience in Informatica (9.X, 8.X) applications. Designed and developed the Workflows, Worklets, Mappings and Sessions.
• Interacted with end-users and functional analysts to identify and develop Business Requirement Document(BRD) and transform it into technical requirements.
• Worked on documentation of Design requirements, Test data, Data movement schema and Mapping between application
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Updated Strategy) from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Proficiency in data warehousing techniques for Staging area design, data cleansing, error handling, audit login, surrogate key assignment and real-time change data capture (CDC).
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Experience in integration of various data sources like Oracle, DB2, Flat Files, MQ series and XML Files into ODS.
• Conducted Unit tests, Integration tests and Customer Acceptance tests.
• Expertise in OLTP/OLAP system study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Production support experience. Extensive understanding of Production issues and Data issues.
• Experience in using the Informatica command line utilities like pmcmd, pmrep server and pmrep agent to execute or control sessions, tasks and workflows in non-windows environments.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Experience in UNIX shell scripting and configuring Cron jobs for Informatica job scheduling, backup of repository and folder.
• Excellent communication skills, ability to communicate effectively with different levels of management, strong analytical problem solving skills.
• Onsite - Offshore Co-ordination.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter/PowerExchange 9.x/8.x, Informatica DQ 9.6

Databases: Oracle 11g/10g, MS SQL Server 7.0/2000, DB2, Teradata 15/13/V2R5

DB Tools: SQL* Plus, SQL* Loader, TOAD

Environment: Sun Solaris, UNIX, WINDOWS XP/2000/NT

Languages: SQL, PL/SQL, XML, UNIX

Drafting Tools: Visio, Rational Rose, Erwin, UML.

Development Tools: Microsoft Visual Studio, Dream Weaver.

Office Suits: MS Word, MS Power Point, MS Excel, MS Access.

Scripting Language: Java Script, VB Script and UNIX Shell Scripting

Other Tools: Rally, Crucible, Fisheye, SVN, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Informatica Developer

Responsibilities:

• Converted business requirement into technical documents - Business Requirement Document, explained business requirements in terms of technology to develops.
• Developed Data Flow Diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every mappings in a session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle incremental loading of dimension tables, fact tables.
• Created Registration, DataMap, Restart Token in PowerExchange to read real time as well as batch mode data processing.
• Worked on IDQ address doctor, standardizer, expectation, consolidation, match, profiling and score card.
• Created many IDQ mapplet for data cleansing, error logging, correcting data and finding duplicates.
• Worked on IDQ applications, data services, parametrizing and tuning of codes.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2, XML files.
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ, MLOAD and TPUMP scripts.
• Worked on debugging and troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on performance tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, Index Cache, Data Cache and incremental aggregation.
• Worked on complex Informatica Mappings for Household dimension, Multi valued dimension and Point in time dimension.
• Utilized Quality Center 9 web based test management tool to keep track of all the releases, requirements, test plans, labs and defects.
• Extensively worked on Integration testing and User Acceptance Testing(UAT). Reviewed UAT with business users.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.
• Utilized Autosys to schedule all the jobs, created JIL scripts and closely worked with the production team.

Confidential, MN

Informatica Developer

Tools: Informatica Power Center Designer 9.1, Oralcle 11g, SQL*Loader, SQL, PL/SQL, Shell script, Visio, Test Director 7.x, Meta Data

Responsibilities:

• Worked on enhancement and version upgrade projects in Informatica 9.1, Web methods and cloud. Extensively worked on Debugging, root cause analysis and fixing defects with testing team for Production Informatica applications used Test Director 7.x to track all the defects.
• Worked on Performance tuning like increasing index, data caches for lookup & aggregation transformation and having verbose performance log for testing purpose.
• Automated ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Participated in change control reviews to code changes that go into production, used Comparison utility tool by Informatica to compare the code.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Configure the current data flows/ lineage in the Informatica Metadata Manager using available connectors or as custom resources
• Worked extensively in Production support environment. Extensive understanding of production and data issues.
• Worked on Oracle Pl/SQL and developed Function, Procedure, Package & trigger and Tuned many codes.
• Coordinated onsite and offshore team and represent ETL team in scrum call.
• Maintained 99% of uptime of ETL silver, gold and platinum servers during quarter close.
• Resolved high severity production issues relating to Platinum applications.
• Worked extensively in product support 24x7 in war rooms/command center and on call during quarter close.
• Worked on middleware and ETL support process integration and knowledge transfer for various healthcare applications.
• Developed shell scripts for automating system maintenance issues saving 1 hour per month of cycle time.
• Identified and documented all the critical information of the design so that future users are facilitated.
• Participated in knowledge transfer of new applications in Informatica, Web methods and IBM crosswords application.

Confidential, Mount Laurel, NJ

DW Developer

Tools and Technologies used: Informatica PowerCenter/ PowerExchange 8.6, Autosys, Oracle 11g, Toad, SQL *Loader, SQL, PL/SQL, UNIX, Shell script, VISIO, Quality Center 9, TeraData V2R6.

Responsibilities:

• Analyzed relationships of Flat Files and to extract the Analyzed the systems met with end users and business units in order to define the requirements
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Developed data Mappings between source systems and warehouse components.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Developed shell scripts to monitor and maintain all Informatica Files.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Responsible to tune ETL procedures and STAR Schema to optimize load and query performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Developed Interfaces using UNIX Shell Script to automate the bulk load and update processes.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.