SUMMARY

• 8 years of ETL Design and development experience using Informatica Power Center 9.x/8.x, Informatica Data Quality(IDQ) 9.x and Informatica Cloud
• Proficient in Design and Development of process required to extract, Transform, Load data to the data warehouse using Informatica Power Center 9.x/8.x/7.x
• Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimension tables, Physical and logical data modeling, OLAP and Report delivery methodologies
• Have knowledge on Informatica 9.x architecture and have good admin knowledge like configuring various services, taking back up, restoring Backups and user level operations.
• Good experience in Production Support, Identifying root causes, Trouble shooting and Submitting Change Control
• Experience in working with Web Service Hub (WSH) and running the WSH workflow using tryit and SOAPUI
• Strong Experience in using Informatica Data Quality (IDQ) tool for discovery and cleansing, Duplication Analysis and data standardization using Profiling techniques, Address Validator, Standardizer, Labeler, Parser and etc. transformations to maintain quality of data.
• Building a process in IDQ for cleansing and migrating global customer data from different source systems
• Have experience in integrating various Data Sources like Oracle, Amazon Redshift and Sales Force using Informatica Cloud
• Working knowledge on Oracle 11g, SQL Server, Teradata, Netezza, DB2, MY SQL, Paraccel and UNIX shell scripting
• Proficient in writing Oracle complex/analytical queries and PL SQL code
• Have Experience on Teradata Utility scripts like BTEQ, FastLoad, MultiLoad and FastExport to load data from various source systems to Teradata.
• Strong experience on Teradata Parallel Transporter (TPT) to extract or loads data using system operators
• Strong experience in working with UNIX Shell Script to automate the processes used in ETL, Archiving the Source/Target files, Purging the different directories in the environment.
• Strong ETL experience in using Informatica Power Center client tools such as Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager in executing simple, medium and complex logics with minimum transformations with best performance.
• Extensively worked on creating mappings using various transformations including advanced transformations like XML, Normalizer, SQL, Transaction Control etc
• Extensively worked on creation of Informatica mappings, mapplets, sessions, worklets, Workflows, parameter files, Mapping parameters and Mapping variables.
• Extensively used variable ports to have looping logics as per Business requirement.
• Expertise in developing slowly Changing Dimensions mappings Type1, Type2 and Type3 and loading the enterprise data warehouse with incremental loads.
• Have experience in merging multiple data marts into single data mart as per automation process to reduce ETL process and DB load as well.
• Involved in Unit Test Case, Integration Test, User Acceptance Test (UAT)
• Have knowledge in developing Oracle BI Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer).
• Have knowledge in building Interactive Reports / Dashboard with drill - down capabilities
• Extensive experience using database tool such as TOAD, SQL Developer, SQL Server Management Studio and WIN SQL.
• Strong experience in creating Domains, Relationships, Indexes, Templates, Forward/Reverse Engineering, etc using Erwin Data Modeler
• Strong understanding of Software Development Life Cycle (SDLC) and Enterprise Architecture Framework, Agile and Waterfall Methodologies.
• Experience with coordinating and leading onsite-offshore development
• Excellent team player with very good communication skills and leadership qualities.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.x/8.x, Informatica Data Quality 9.xInformatica Cloud

BI: OBIEE 11g/10g

Scheduling Tools: Informatica workflow scheduler, DAC, AutoSys

Database Languages: Oracle, SQL Server, MY SQL, Teradata, Netezza, PADB, Redshift

Programming: SQL, UNIX Shell Scripting, PL SQL, XML, Java

Data Modeling: ERwin

Applications Tools: Toad, SQL Developer, WIN SCP, WIN SQL, Putty

Operating Systems: Windows XP, 7

PROFESSIONAL EXPERIENCE

Confidential, Sterling, VA

Sr. Informatica Consultant

Responsibilities:

• Working with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Designed ETL architecture and architecture documents
• Defined and implemented ETL development standards and procedures
• Leading the ETL Development and production support team of 5 members for new and existing ETL code changes
• Working on Informatica Data Quality (IDQ) tool for data quality profiling, data enrichment and standardization.
• Extensively worked with Informatica Developer (IDQ) - Expression, Match, Standardizer, Address Validator, Labeler, Key Generator, etc to maintain the quality of information and make recommendations for improvements.
• Migrated IDQ mappings to Informatica Power Center to schedule the jobs within the Power Center client tools.
• Creating Connections, Task flows and Schedule information for the Informatica Cloud Data Synchronization/Replication tasks
• Working on Informatica Cloud to integrate the various data Source like Oracle, Amazon Redshift and Sales force
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from various heterogeneous sources like Oracle, SQL Server, MY SQL, Flat Files, etc and loaded into Data Marts (Oracle, Teradata, Paraccel) using Informatica
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Created mappings using pushdown optimization to achieve good performance in loading data into Oracle and Teradata.
• Working on Teradata Utility scripts like BTEQ, FastLoad and MultiLoad to load data from various source systems to Teradata.
• Working on Teradata Parallel Transporter (TPT) to extract or loads data using system operators
• Involved in system testing, performance and System Integration testing stages of the project
• Worked with DBA to set up the DEV and QA environment and various users and roles
• Identified long running jobs and implemented various performance tuning techniques to mitigate the bottlenecks
• Creating standards for column names, table/view names and organizing DB objects. Followed standards at each and every level to accomplish accurate results. This includes Informatica standards, Code walkthroughs, migration check list etc
• 24x7 production support for jobs running in the production environment.

Environment: Informatica Power Center 9.x/8.x, IDQ 9.x, Informatica Cloud, Oracle 11g/10g, Teradata, SQL Server, Paraccel, Redshift, Toad, Win-Scp, Putty, WIN SQL, UNIX Shell Scripting

Confidential, Nashville, TN

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica 9.x/8.x ETL tool for data transfers from Legacy systems to Oracle warehouse.
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
• Worked closely with project management and assisted in ensuring timely and effective implementation.
• Created the test cases and assisted in UAT testing.
• Actively participated in code reviewing and assists to ensure developers follow the standards. Provide quality reviews for the work of other team members when required.
• Assist DBA and Architect to identify proper distribution keys for Netezza tables
• Used Informatica power center 9.x to Extract, Transform and Load data into Teradata Data Warehouse from various sources like Oracle and flat files
• Identify opportunities to improve processes and cost effectiveness.
• Worked as an ONCALL production specialist with primary and secondary duties.
• Analyzed and resolved the incidents raised by the application users on priority (low, medium and high) through JIRA.
• Modified and implemented the existing applications mappings, workflows, design documents and test cases as per the incident raised by users and internal Data issues.
• Coordinated with Technical product administration and Operations team in implementation of production break-fix, production error and production maintenance issues.
• Involved and completed new production applications Knowledge transfer and application turn over process as a part of Application management services.

Environment: Informatica Power Center 9.x/8.x, Informatica Data Quality, Oracle 11g, Netezza, PL/SQL, AutoSys, Toad, UNIX, SQL Server, Teradata SQL Assistant, Teradata external loaders (Tpump, Mload).

Confidential, San Jose, CA

Sr. Informatica Developer

Responsibilities:

• Creating high level architectural documents with data flows representing ETL processes among different applications
• Participating in business requirement discussions and documenting ETL Specifications(source to target documents)
• Designing dimensions and fact tables using Star and snowflake schemas in such a way that there are 2 phases, SDE and SIL, as per the BI standards at Informatica level.
• SDE - Source dependent Extraction, where the data gets extracted from different source systems to staging tables. This is the staging area.
• SIL- Source Independent loading, where the transformed data will be loaded into the final target tables.
• Creating source to target mapping documents.
• Creating DDL's, indexes, triggers, sequences and synonyms in Oracle 11g
• Creating Informatica mappings, workflows, mapplets, worklets and lookups
• Done the customization for OOTB mappings as per new requirements.
• Responsible for the delivery of ETL solution.
• Performance tuning of Informatica mappings and sessions.
• Working closely with project managers to provides estimates for ETL Development
• Participating in Daily stands and meetings to go over day to day tasks and status.
• Responsible for over design, development and implementation of ETL Solution to feed EDW table.
• Managing Informatica global objects source, target, lookup, mapplets & parameter files in shared environment.
• Creating ETL Standards, Deployment checklists and unit test plan templates
• At DAC level, we have scheduled the EP’s as per the client specifications after creating the tasks, assembling ‘subject areas’ and building the ‘Execution plans’.

Environment: Informatica 8.6.1, Oracle 10g/9i, SQL Developer, Win-Scp, Putty, Windows XP, UNIX Shell Scripting

Confidential, St. Louis, MO

Informatica Developer

Responsibilities:

• Developed Detailed Design documents based on business requirements.
• Designed and developed Informatica code to extract, transform and load data for the application as per the business requirements.
• Involved in the full development lifecycle from Requirements gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications.
• Identified long running jobs and implemented various performance tuning techniques to mitigate the bottlenecks.
• Worked with DBA’s to tune long running SQL queries.
• Designed and developed complex Informatica mappings including slowly changing dimension (Type 1, Type2).
• Developed reusable transformations, sessions and Mapplets.
• Worked with different source and target systems like flat file and relational tables.
• Used Variables and Parameters in Mappings, Workflows and Sessions.
• Created post-session and pre-session shell scripts and mail-notifications. Used various session tasks like Event wait, Timer, Decision and Control.
• At DAC level, we have scheduled the EP’s as per the requirement.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQL Developer, UNIX Shell Scripting, WIN-SCP, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Developed ETL mappings, transformations using Informatica Power Center.
• Developed ETL mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Involved into source code review, the mappings created by my team members.
• Prepared deployment document and assisted to deployment team while migration.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Mappings were designed to cater the slowly changing dimensions.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Involved extracting the sources from Oracle, flat file sources.
• Used Mapping Parameters and session parameters.
• Used Target Load Order for populating various targets within the same mapping.
• Implemented Slowly Changing Dimension Type 2 - Current Flag to maintain historical information.
• Tuned the mappings and involved in performance improvement phase.

Environment: Informatica Power Center 8.6.1, Oracle 9i, Windows XP, Toad, Win-Scp

Confidential

ETL Developer

Responsibilities:

• Involved in Business Analysis, requirements gathering from the Business Users and Technical document design of these requirements.
• Designed mapping documents and developed ETL mappings using Informatica.
• Designed and developed Informatica mappings to build business rules to load data.
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression and aggregation.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations, Mapplets using Designer module of Informatica.
• Involved in coding, testing in UAT.
• Created Workflow, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirements.
• Created reusable Worklets, mapplets and transformations.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations.
• Successfully loaded initial and incremental loads with best performance.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL Developer, WIN-SCP, Putty, Windows XP