SUMMARY

• Eight years of Experience in Project Life cycle activities on Development, Implementation, and Maintenance of Data Warehouse and Data Integration Applications
• Expertise in design and development of medium to high complexity ETL mappings to support large data volume movement using Informatica Power Center 9.5.1 9.6.1/9.1/8.x/7.x.
• Extensive experience wif ETL tools Informatica Power Center/Power Mart 9.5/9.1/8.6/7.1/6.1 Power Exchange 8.6.1/8.1/7.1 in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, configuring teh Informatica Server and scheduling teh Workflows and sessions
• Four years of experience working wif Informatica Power Exchange.
• Expertise in integration of various data sources like SQL Server 2012/2008, Oracle 11g/10g/9i, Teradata 13/12/V2r5, XML, Flat files, DB2 9.8/10.1 using ETL Tools.
• Strong Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner, sorter transformations.
• Solid experience in implementing SCD TYPE me and TYPE II, working wif Mapping Parameters and Variables.
• Expertise in creating mapping Parameters, Variables and Reusable Tasks (Sessions, Command, Email).
• Implemented Pre - Session and Post-Session shell scripting to run workflows using pmcmd command.
• Understanding and Implementation experience on Informatica CDC (Change Data Capture)
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Extensive experience in database languages SQL and PL/SQL which includes writing Triggers, Stored Procedures, Functions, Views and Cursors
• Worked on teh migration of code from one environment to another and also worked on all phases of deployment.
• Experience in implementing teh Informatica best practices throughout teh development cycle.
• Experience wif Informatica Advanced Techniques - Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings and sessions
• Expert in SQL*Loader data loading wif Data Warehousing experiences
• Expertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflow batches using Informatica scheduler, Control-M, DAC and shell scripting.
• Development and Testing of Data warehouses using ETL Logic
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments
• Involved in Technical Documentation, Unit test, Integration test, UAT and writing teh test plan.
• Excellent team player and self-starter wif good ability to work independently and possess good analytical, problem solving and logical skills.
• Excellent interpersonal and communication skills, and good experience in working wif senior level management, business associates and developers across multiple disciplines.
• Designed and developed ETL solutions from Teradata tools.
• Tested and managed ETL workflows for XML and Teradata sources.
• Designed and developed current Oracle applications for Teradata programs.
• Experience in architecting teh load andmaintenance of Data Warehouses inTeradataand Oracle.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6/7.1/6.1, Power Exchange 8.6.1/8.1/7.1, Reporting Tools OBIEE, SQL Server Reporting Services

Data Modeling: ERWIN r7/r4/r3.5 & VISIO 2003/2007/2010.

Databases: SQL Server 2012/2008, Oracle 11g/10g/9i, Teradata 13/12/V2r5, DB2 9.8/10.1

DB & Other Tools: TOAD 9x/8.6/7.6, SQL * Plus, SQL*Loader SQL Developer

Programming: C#, .Net, SQL, PL/SQL, UNIX Shell Scripting

Scheduling Tools: Informatica Scheduler, Control M, Tidal, Autosys

Office Applications: MS-Office 97/2007/2010/2013, Excel

Operating System: UNIX, Windows Server 2012/2008/2003, Windows 8/ 7/Vista/XP/2003/98.

PROFESSIONAL EXPERIENCE

Confidential, Tennessee

Sr. ETL informatica Developer

Responsibilities:

• Analysis of teh specifications provided by teh clients.
• Design of teh ETL mappings as per teh Users requirement.
• Used various transformations like Source Qualifier, Expression, filter, Aggregator, Lookup and SQL stored procedures.
• Was involved in Unix Shell scripting.
• Created transformations, sessions and workflows.
• Scheduling of teh Informatica workflows and sessions.
• Extracted data from various sources like Flat Files, SQL server 2008, Oracle 11g, and relational databases.
• Written complex SQL queries for reconciling teh loaded data

Environment: Informatica Power Center 9.5/9.1, Informatica Power Exchange 8.6, Oracle 11i/10g, SQL server 2008, Flat Files, SQL,, PL/SQL, Erwin r 7, Control M, TOAD, UNIX Shell Scripting, Windows XP

Confidential, Virginia

Sr. ETL Informatica Developer

Responsibilities:

• Worked wif business analysts for requirement gathering, business analysis, and translated teh business requirements into technical specifications to build teh Enterprise data warehouse.
• Analyzed teh system for teh functionality required as per teh requirements and created System Requirement Specification document (Functional Requirement Document).
• Involved in teh development of teh conceptual, logical and physical data model of teh star schema using ERWIN
• Used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed and developed daily audit and daily/weekly reconcile process ensuring teh data quality of teh Data warehouse.
• Extracted data from various sources like Flat Files, SQL server 2008, Oracle 11g, and relational databases
• Developed various mappings using Mapping Designer and worked wif Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Administrating User Privileges, Groups and Folders which includes creation, update and deletion.
• Migration of New and Changed Informatica objects across teh environments using Folder to Folder and Deployment Group methods.
• Used SCD2 to populate teh data in a generic way. Single mapping is used to load multiple tables data
• Involved in teh development of Data Mart and populating teh data marts using Informatica.
• Written SQL override queries in source analyzer to customize mappings
• Developed UNIX shell scripts using PMCMD utility and scheduled ETL loads using ControlM.
• Identified performance issues in existing sources, targets and mappings by analyzing teh data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in teh administration of teh Informatica Repository and also in teh design and architecture of multiple repositories to support multiple application development areas.
• Involved in coding of teh Business Rules through PL/SQL using teh Functions, Cursors and Stored Procedures

Environment: Informatica Power Center 9.5/9.1, Informatica Power Exchange 8.6, Oracle 11i/10g, SQL server 2008, Flat Files, SQL,, PL/SQL, Erwin r 7, Control M, TOAD, UNIX Shell Scripting, Windows XP

Confidential, CA

Sr. informatica

Responsibilities:

• Responsible for requirement gathering, data Analysis, user meetings, discussing teh issues to resolved and translated teh user inputs into ETL design documents.
• Worked wif Informatica power center 8.5 tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Developed Informatica mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Involved in making teh changes to teh existing data models to accommodate teh new requirements.
• Responsible for fine tuning teh ETL code and sessions which include fine tuning lookup overrides and SQL override queries, implementing teh Delta logic (Change data Capture) to speed up teh session runs.
• Responsible for Optimizing teh ETL loads and also redesigning ETL Interfaces which were not providing teh accurate data for teh business.
• Worked wif mapping parameters and variables, session parameters, pmcmd commands, email tasks.
• Responsible for fixing PLSQL procedures for getting teh accurate data.
• Worked wif SQL override, Lookup override, Lookup caches, Index and Data caches while designing teh mappings Worked wif TOAD SQL*Loader for loading teh data from external files into RDBMS tables.
• Fine-tuned teh SQL queries using Explain Plan and Tkprof.
• Handled Informatica administration work like migrating teh code, creation of users, creating folders, Worked wif Shortcuts across shared and non-shared folders
• Written Autosys Jil scripts for scheduling teh workflows.
• Responsible for reconciliation of teh loaded data to see whether it is according to teh business needs
• Created and executed unit test plans based on system and validation requirements.Worked closely wif Business during teh testing phase and fixed bugs dat were reported.

ETL Tools: Informatica Power Center, Programming: VB, Java, C, Pro*C, SQL/SQR, PLSQL, C++

Confidential, OR

ETL Informatica Developer

Responsibilities:

• Worked in a Data Migration team to convert teh data from Legacy Systems and load into SAP.
• Extensively used Informatica Power Center and Informatica Power Exchange to extract teh data from Legacy Mainframes and transform teh data according to requirements and load into Staging area which tan loaded into flat files which feed teh SAP system.
• Worked wif various Informatica functions for Data Cleansing for detecting and correcting inaccurate records.
• Analyzed all teh critical and high priority defects and fully responsible for fixing it in DEV, QA and Production environments.
• Written complex SQL queries for reconciling teh loaded data.
• Responsible for designing teh documents, Unit test plans and system integration test plans.

Environment: Informatica 8.1.1, Mainframes, Oracle 10 g, SAP

Confidential, Portland, OR

ETL Developer

Responsibilities:

• Created teh mappings according to teh design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.
• Fine-tuned teh ETL designs to provide maximum efficiency and performance.
• Implemented Error handling logic to capture teh invalid data.
• Responsible for designing teh documents, Unit test plans and system integration test plans.

Environment: Informatica 9.5.1/ 8.1.1/7.1.3, Oracle 9i, PLSQL, HP UNIX.