SUMMARY:

• Having 7+ years professional experience in IT industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation including but not limited to Databases, Reporting, Data Warehouse and ETL Design Applications .
• Worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Have an extensively worked in Data Warehousing by using Informatica Power Mart and Power Center.
• Worked on ETL Informatica transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings .
• Experienced in scheduling of UNIX shell scripts and Informatica workflows.
• Proficiency in ORACLE, SAS, Teradata, Teradata Utilities, BTEQ, Teradata SQL Assistant, SQL, PL/SQL, MS Access, MS Excel on UNIX and Windows platforms.
• Experience in populating the data warehouse tables using SQL*Loader, TPUMP, MULTILOAD, FASTLOAD, Oracle Packages, Stored procedures, Stored functions.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, views, materialized views, Cursors at database level using SQL, PL/SQL for Oracle 9i/10g/11g.
• Hands on experience in creating the End to End lineage for key business elements using the Informatica Metadata Manager .
• Knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in writing/debugging/enhancing UNIX Shell Scripts.
• Good work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Hands on experience on Oracle Data Integrator (ODI) as business intelligence tool, for real time data integration.
• Experience in using the Informatica command line utilities to execute or control sessions, tasks, workflows and deployment groups in non-windows environments.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills .

TECHNICAL SKILLS:

Operating Systems: Windows 9X/2000/XP/NT, MS-Dos, HP-UX, IBM AIX 4.3/4.2,Sun Solaris, Unix/Linux.

ETL Tools: Informatica Power Center 9.6/9.5/9.0/8.6/8.5/8.1.1/7.1.2/6.1 / 6. x, Informatica Power Exchange 7.x/8.x, Informatica PowerConnect, Data stage 7.5.x, IDQ, Informatica Analyst

Tools: UNIX Shell Scripts, Visual Basic, T-SQL, PL/SQL, TOAD, Corntab, Autosys, Informatica Scheduler, MDM, Perl Scripting, Teradata SQL Assistance, SQL *Loader, PLSQL Developer, SQL Navigator, MS Office,ILM, Active Batch, SSRS, cognos.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Teradata 13/12/V2R4/V2R5, MS SQL Server 2012/2008/2005/2000, SSIS/SSRS, MS Access, PL/SQL, UDB DB2 8.1,Sybase 12.0/11.x

Database utilities: SQL *plus, Stored procedures, Functions, Exception handling.

Data Modeling tool/ Methodology: MSVisio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inman Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

Reporting Tools: Business Objects XI r2/r 1/6.5/6.1/5.1, Cognos, SSRS(SQL Reporting Services)

PROFESSIONAL EXPERIENCE:

Confidential,

Minneapolis, MN

Senior Informatica Developer

Responsibilities:

• Responsibilities include designing the documents, which is based on the requirement specifications.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Loaded data in to the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
• Implemented CDC for mappings so as to capture the changes and preserve history .
• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked with Teradata utilities ( Fload/Mload/BETQ) to load files into Teradata tables
• Building the Transformation rules for a data model.
• Perform unit testing at various levels of the ETL.
• Analyzed the business requirements and functional specifications.
• Used Informatica Power Center tool for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Using Informatica PowerCenter created mappings to transform the data according to the business rules.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Hands On experience creating, converting oracle scripts (SQL, PL/SQL) to TERADATA scripts.
• Configure rules for power center operations team, no file monitoring, process not started, reject records and long running jobs.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ .
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions.
• Developed complex mapping using Informatica PowerCenter tool .
• Involved in performance tuning and query optimization.
• Used SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed and implemented the UNIX shell script for the start and stop procedures of the session.

Environment:: Informatica Power Center 9.6.1, Data Quality (IDQ), Oracle 11g, SQL Server 2012, MS Access 2010, Teradata, SQL*Loader, UNIX, Winscp, Putty, Erwin 7.2, SQL, PL/SQL

Confidential, Minneapolis MN

Informatica Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse .
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations .
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in TERADATA
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of TERADATA.
• Created numerous scripts with TERADATA utilities BTEQ, MLOAD and FLOAD
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Implemented CDC for mappings so as to capture the changes and preserve history.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Extensively worked on migrations and Conversions with legacy systems data in SQR Production Reporting.
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Performed Data Encryption on user data and client data for maintaining consistency and security.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Developed ETL’s for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various ETL scripts.
• Automated the entire processes using UNIX shell scripts .
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution .
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications. Technical solutions and supporting deliverables will be constructed to enable Well Care clients to accomplish their business objectives.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• Provided Tier l support duties for Informatica Production Support, bKeep the Production Support team management informed of any issues or concerns. New development and support task responsibilities .

Environment: Informatica Power Center 8.6.1/8.1.3, IDQ, Teradata, Oracle 10g, SQR, OBIEE, ODI, ETL, SQL Assistant and Administrator, XML, UNIX Shell Scripting.

Confidential, Horsham, PA

Informatica developer

Responsibilities:

• Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Implemented CDC for mappings so as to capture the changes and preserve history.
• Extensively used PL/SQL programming procedures, packages to implement business rules.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Workflow Manager.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions
• Created and used reusable Mapplets and transformations .
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Developed pre-session, post-session routines and batch execution routines.

Environment: Informatica Power Center 9.1/9.5,IDQ, Oracle 10g, SQL server 2005/2000, SQR, XML, Windows, UNIX and PL/SQL Developer

Confidential, Washington DC

Informatica Developer

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to integrate different interfaces with Exigen.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Extensively used Informatica to load data from Oracle9 and flat files into the target Oracle 10g database.
• Used various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy and Stored Procedures.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow .
• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to extract, translate and load data from flat files to warehouse data base.
• Used Debugger to validate mappings and also to obtain troubleshooting information about data by inserting Breakpoints.
• Extensively used Variables, Break points, and Sorted inputs.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Created UNIX shell scripting and automation of scheduling processes.
• Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables using query tool TOAD.

Environment: Informatica Power Center 9.1/8.6, ETL, PL/SQL Developer, Oracle 10g, UNIX, Microsoft SQL Server, TOAD.

Confidential, New York

Informatica/ETL Consultant

Responsibilities:

• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Used Mappings, Sessions, Workflows from Development to Test
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a STAR SCHEMA.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in creating and maintaining various database objects like SQL Joins, synonyms and aggregate conditions and worked on various databases and their connectivity from various parts of the Source Systems.
• Involved in extracting the data from the Flat Files and other RDMS databases into staging area and pro-actively involved in Storage of data .
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Worked on Informatica Power Center tools - Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment and development.
• Prepare DR plan and recovery process for GDW application.
• Monitoring all the environments regularly and provided 24x7 production support for Informatica/Hyperion.
• Create RTM, Document process and transfer knowledge.

Environment: Informatica Power Center 8.6, ETL, Oracle 10g/9i, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2000, Windows Server 2000.