PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Information Technology with System Analysis, Design, Development, Maintenance, and Implementation.
• Experience in various stages of System Development Life Cycle (SDLC) and its approaches likeAgile.
• Strong understanding of OLTP and OLAP and Data warehousing and ETL process using Informatica Power Center (IPC) 10.x/ 9.6.x/9.1/8.6.
• Extensive experience in Installation and Configuration of InformaticaMDMHub, Cleanse and Match Server.
• High exposure onMDMHub configurations - Data modeling for System Sources, Data Mappings from landing table to staging tables, setting data validation configuration, Match and Merge rules, Hierarchy Manager.
• Exposure in Dimensional Data Modeling based on Ralph Kimball and Bill Inman methodologies and designing Star Schema, Snowflake schema with Fact and Dimensions.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Strong experience in integration of various data sources like Oracle, MS SQL Server, DB2 and Flat Files, XML Files.
• Excellent experience with Informatica tools like Repository Manager, Workflow Manager & Power center Designer and Workflow Monitor.
• Excellent exposure into Informatica Installation, Configuration and Administration.
• Good experience with migrating code to different environments using Import, Export and deployment groups.
• Designed and developed complex ETL mappings using Source Qualifier, Application source Qualifier, XML Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator transformation.
• Excellent experience in implementing slowly changing dimensions (SCD1,SCD2 and SCD3) in data warehouse
• Participated in requirement gathering and preparation of High level and Low level Designs throughout the Software Development Life Cycle. Very good in understanding theMDMrequirements from the business in achieving the BVT (Best Version of Truth) Record and publish to the downstream applications
• Expertise in developing Mappings and Mapplets, Sessions, Workflows, Work lets and Tasks using Informatica and Creating Parallel and sequential jobs and parameter files.
• Proficiency in writing SQL Quires in various relational databases like Oracle, SQL Server and DB2.
• Excellent experience with creating DDL, DML scripts and functions and procedures, packages.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers and SQL performance tuning.
• Created UNIX shell scripts to run the Informatica workflows control the ETL flow and manage source files.
• Extensively used Informatica Commands PMCMD, PMREP, INFACMD and INFASETUP to run Informatica sessions, aborting sessions and working on repository management.
• Strong with relational database design concepts.

TECHNICAL SKILLS:

BI Tools: OBIEE, Tableau

ETL Tools: Informatica Power Center 9.x/8x(Workflow Manager, Workflow Monitor, Source Analyser, Mapping Designer, Mapplet Designer, Transformation developer), Informatica MDM, DWH

Scheduling Tools: Control-M, Autosys

Languages: C, C++,Java, SQL, PL/SQL, Ruby

RDBMS: Oracle 11g/10g, DB2, Teradata 14/13, SQL Server, Exadata

Tools: /Utilities: Toad, Perl, UNIX Shell

Operating Systems: Windows, UNIX, Linux

Web Technologies: HTML, CSS, XML, JAVA SCRIPT

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

ETL/Informatica MDM Developer

Responsibilities:

• Created transformations like Expression, Lookup, Joiner, Rank, Update strategy and Source Qualifier, Filter, Router using the mapping designer.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements.
• Extracted Data from FACETS Database.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target files in efficient manner.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using various components like, Parameter files & Variable.
• Configure Informatica Data Services to populated data in IDD usingMDMand ODS database. IDS Services also available for custom applications
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Worked on different data sources like facets, Medco, tasks included cleansing the data, providing the claims data coming from facets into a flat file in the desired format.
• Scheduled the tasks using ESP scheduler.
• Written Unit test scripts to test the developed mappings.
• Writing User-Exits and External Java Code to callMDMJobs.
• CallingMDMJobs through Batch Files (with Java Code) for scheduling.
• Developed Mapplets and rules using expression, labeler and standardize transformations using IDQ.
• Deployed code from IDQ to power center.
• Created complex mappings using Unconnected and Connected lookup Transformations.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.
• Implemented slowly changing dimensions Type 1 and Type 2 for change data capture.
• Extensively worked with Teradata Fast load utility to load huge tables for initial loads and truncate and load.
• Worked with Teradata multi load utility for insert, update or incremental loads.
• Used Teradata BTEQ for writing scripts in Teradata database.

Environment: Informatica power center 9.x, Informatica MDM 10.x, IDQ 9x, Oracle 11g, SQL, Teradata 14, Facets, Auto sys, Unix/Linux.

Confidential, San Francisco, CA

ETL/Informatica MDM Developer

Responsibilities:

• Involved in extracting the data from the Flat Files and Siebel data into staging area.
• Developed several Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings.
• DevelopMDMSIF web services for real time out bound operations from internal and the external applications
• Installed Jobs Application server and Configured InformaticaMDM10.1.
• Extensively usedInformaticaClient tools - Power Center, Work flow Manager, Work flow Monitor and Repository Manager.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, XML, XSD's, Flat Files.
• Developed complex mapping usingInformaticaPower Center tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Exposure in configuringInformaticaMDMHub server, cleanse server and Address Doctor5 in Development, QA.
• Configured the Landing Tables, mappings, staging tables, Base objects, relationships, Lookups, queries, packages, query groups, Batch groups.
• Scheduling the batch jobs.
• Defined the Trust and Validation rules.
• Worked on data cleansing and standardization using the cleanse functions inInformaticaMDM.
• Took ownership for populating and validating lookup tables associated to data model.
• Ran batch jobs for customer, contacts, material, vendor, customer material domains cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Monitored and improved query performance by creating views, indexes, hints and sub queries.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency inInformaticausing Event Wait Task, Command Wait.
• Created and scheduled Sessions, Jobs were scheduled in DAC based on demand, run on time and run only once.

Environment: Informatica Power center 9.x, Informatica MDM 9.x, Teradata 13, Oracle 10g, PL/SQL, Siebel, Oracle DAC, and SQL Server 2008.

Confidential, Canton, MA

ETL/Informatica Developer

Responsibilities:

• Used Informatica Power Center for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Created Informatica maps using various transformations like XML, HTTP transformation, Source Qualifier, Expression, Look up, Store procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
• Provide solution approach for Hard Delete Detection (HDD), providing knowledge transition for Data Steward for new functionality in InformaticaMDM10.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• Performance tuned and optimized various complex SQL queries.
• Created Pre/Post Session and SQL commands in sessions and mappings on the target instance.
• Responsible for Performance tuning at various levels during the development.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets for better performance.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Responsible for migrating the workflows from development to production environment.
• Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
• Managed post production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power center 9.5/8.6.1, Informatica MDM 9.x, Oracle 10g, SQL server 2008, LINUX, LSF (Job scheduling), UNIX, SAS Enterprise guide and MS Visual studio (TFS) for version control, IDQ, Toad, RDBMS, Teradata.

Confidential, Beaverton, Oregon

ETL/Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various Mappings & Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping. Also developed Error Processing to capture the error records and loads them into Message Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Provided production support including error handling and validation of mappings.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.

Environment: Informatica 8.6, UNIX, Windows, Informatica Multi domain, Oracle 10g, PL/SQL, MSSQL 2008R2, SQL, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer

Confidential, Mount Laurel, NJ

ETL / Informatica Developer

Responsibilities:

• Involved from initial stage of requirement gathering, to understand the Business Requirements and Business Rules Subjected to Business.
• Generated Entity-Relationship diagrams based on actual values and relationships held in source data.
• Prepared ETL Specifications to help develop mapping.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, Oracle into Oracle database.
• Implemented code using various Informatica Transformations like Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developedmappings/Reusable Objects/Mappletsby using mapping designer, transformation developer and mapplet designer, since different data type conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations suchas Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• UsedInformatica Power Center Workflow managerto create sessions, batches to run the mappings.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad 9.5, Delimited Flat Files, Crystal Reports, UNIX Shell Programming, PL/SQL, and Erwin.

Confidential

Oracle Developer

Responsibilities:

• Implemented triggers and Stored Procedures as per the design and development related requirements of the project.
• Written stored procedure to refresh the materialized views.
• Created PL/SQL stored procedures, function, packages, Cursor, Ref Cursor and Triggers for the system.
• Tuning the SQL queries to increase the performance.
• Created the shell scripts for automation.
• Created the Indexes and constraints to increase the performance of the system.
• Created the shell scripts to run the procedures and to create the reports and cleansing the data.
• Scheduling the scripts using UNIX corn job.
• Implemented oracle utility called SQL loaded to load data.
• Worked extensively in ORACLE and PL/SQL creating objects like tables, views, synonyms, triggers, stored procedures, functions and packages.
• Creating, maintaining multiple database environments for Development, Testing etc.

Environment: Oracle 9i, UNIX, SQL, PL/SQL, SQL Developer, TOAD, Putty, WINSCP.