SUMMARY

• Informatica Certified Professional Data Integration Developer.
• Over 9+ years of IT experience in Analysis, Design, Development, Implementation and Support of Relational Database (OLTP), Data Warehousing Systems (OLAP) and Data Marts in Pharmacy, Insurance, Financial, Healthcare, Retail and Banking sectors.
• Extensive experience in using Informatica PowerCenter 9.6/9.5/9.1/8.6.1/8.5/8.1/7. x/6.x/5.x., Power Exchange, Power Mart 5.x/4.x, Informatica Data Analyzer (Reporting Tool).
• Extensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools - Informatica Server, Repository Server.
• Experience in designing/developing complex mapping using transformations Connected and Unconnected Lookup, Source Qualifier, Joiner, Expression, Filter, Sorter, Aggregator, Router, Update Strategy, Rank, Stored Procedure, Sequence generator, Normalizer, HTTP transformation and Web Service Consumer Transformation.
• Extensively used Informatica Power Exchange to extract data from Web Services and Enterprise Applications.
• Extensive experience in developing Workflows, Worklets, sessions and tasks to TEMPeffectively manage the Load and PMCMD to create, schedule and control workflows, tasks, and sessions.
• Strong experience using Erwin, Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling slowly Changing Dimensions.
• Good knowledge of designing Entity Relationship and Data Flow Diagram for Business processes. Strong understanding of data modeling and dimensional modeling concepts like Slowly Changing Dimensions.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle11g/10g/9i, MS SQL Server, DB2, COBOL files and Flat File( fixed width, delimited ), into the staging area of ODS, Data Warehouse or Data Mart.
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Specialized in Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception Handling using TOAD, SQL*PLUS and PL/SQL.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments and experience in error handling and problem fixing in Informatica.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using Auto Sys scheduler and Involved in migration/conversion of ETL processes from development to production environment.
• Worked closely with offshore team by halping them to understand the requirements and co-ordinate with them to meet the deadlines.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to QA and from QA to production.
• Lead the team and worked with many types of team structures (Includes onsite/offshore model with large teams) for different projects.
• Excellent understanding of Software Development Life Cycle (SDLC).
• Strong technical background, and posses excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6.1/8.5/8.1/7. x/6.x, Power Mart 5.1/4.7.2, Informatica Data Analyzer 9.1, Power Exchange 8, Informatica Data Quality, Source Analyzer, Mapping Designer, Workflow Manager, Workflow Monitor, Slowly Changing Dimensions, Data Cleansing, Data Quality, Data Mart, OLAP, OLTP, Web services, API, Messaging Queues

RDBMS: Oracle 11g/10g/9i/8i, IBM-DB2, MS SQL Server 2008/2005/2000, Teradata, MS Access 7/2000, Netezza

Data Modeling Tools: Erwin 7.x/ 4.2/3.x, Microsoft Visio

Programming Languages: SQL, PL/SQL, TSQL, C, C++

Web Tools: HTML, DHTML, XML, JSON, CSS, Java Script

Other Tools & Utilities: TOAD, SQL* Plus, Auto Sys

Scripting Languages: UNIX Shell Scripting, Perl Scripting

Operating Systems: Windows 2000/2003/NT/XP, UNIX (Sun Solaris, AIX), LINUX

PROFESSIONAL EXPERIENCE

Confidential, Kalamazoo, MI

Informatica/ETL Lead

Responsibilities:

• Involved with business analysts to understand the business requirement specifications and implemented the ETL jobs using Informatica Power Center to create conceptual, logical and physical data models and deployed the solutions that maximize the consistency and usability of data.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Participated in discussions with Team Members and Technical Manager regarding any technical and Business Requirement issues to bridge the gap between user needs and tool functionalities.
• Extensively used Informatica PowerCenter 9.6/9.5 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Worked in various types of transformation like Lookup, Update Strategy, Joiner, Filter, Aggregation, Rank, Router and XML Source Qualifier to extract the data from multiple source systems like Oracle, SQL Server and .csv files.
• Involved in loading the data from Source Files/Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Developed Informatica SCD type-I, Type-II and Type III mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Extracted data from web services using Informatica Power Exchange.
• Coded 200+ mappings in dis project.
• Worked in production support to fix global service center tickets.
• Coded Operational data store by extracting data from Confidential transactional source systems such are SAP, SQL LIMS, Labware v5, GLIMS, Manugistics, MAPS, Global QTS and RCS/Insight Systems to provide Center of Excellence view for business and downstream applications.
• Extensively worked with XML and JSON files using PowerCenter.
• Extensively used HTTP and Web Service Consumer Transformations to call web services.
• Used Erwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development
• Developed Unit test plans for every mapping developed and executed the test plans.
• ETL mapping Documents for every mapping and Data Migration document has been developed for smooth transfer of project from development to testing environment and tan to production environment.
• Worked with offshore team by halping them to understand the requirements and co-ordinate with them to meet the deadlines.
• Responsible for moving the mappings and sessions from development repository to production repository and provided 24/7 production support.

Environment: Informatica Power Center 9.6/9.5/9.1.0/8.6.1, Informatica Power Exchange 8.X, Informatica Data Quality, Oracle 11g, DB2, SQL Server, Toad 9.6.1, Flat Files, XML Files, JSON Files, API Calls, WSDL, Erwin 7.3, MS Visio, Windows 2000, UNIX AIX, Shell Scripting, SQL, PL/SQL, SAP BO, SharePoint, PDOCS, Informatica Scheduler, Track Wise.

Confidential, Greensboro, NC

Sr. Informatica Developer

Responsibilities:

• Understood the Business point of view to implement coding using Informatica Power Center 9.1/8.6.1
• Extensively used Informatica Power Center 9.1/8.6.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL coding in an optimized manner.
• Involved in extraction, transformation of data from Hyperion Planning cube, flat files, and Oracle tables to Hyperion Essbase BSO and ASO cubes, Oracle tables.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Developed Informatica SCD Type-I and Type-II mappings.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• Created Perl Scripts and called in Pre session and Post session commands.
• By using Autosys, created the job which runs a Perl script, the script in turn runs the ‘PMCMD” command to run a workflow.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica PowerCenter 9.1.1/8.6.1, Oracle 11g, Hyperion Planning 9.3, Hyperion Essbase 9.3.3, Flat Files, TOAD, Autosys, Perl Scripting, Windows XP, UNIX

Confidential, Groton, CT

Sr. Informatica Developer

Responsibilities:

• Involved Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Extensively used Informatica PowerCenter 9.1.0 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Extracted data from multiple sources like Oracle RDBMS, XML files and flat files to load data into data warehouse built on Oracle.
• Created and Configured Workflows, Worklets and Sessions to load the data to target warehouse tables using Informatica Workflow Manager
• Developed Informatica SCD type-I, Type-II mappings.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing, Performance tuning of Oracle PL/SQL Scripts
• Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Designed UNIX Shell Scripts to automate Pre-Session and Post-Session Processes.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Strong in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like UC4 Automation tool.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to testing, testing to QA and from QA to production.

Environment: Informatica PowerCenter 9.1.0 (Designer, Workflow manager, Workflow monitor), Oracle 11g, XML Files, Flat Files, TOAD 9.7.2, PL/SQL, ERWIN 7.3, SQL* PLUS, Windows NT, UNIX Shell scripting, UC4 Automation Tool.

Confidential, Pittsburgh, PA

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Implemented weekly error tracking and correction process using Informatica.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II and Type III mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process
• Extensively used Informatica Data Analyzer to create reports relative to corporate business planning modules such are: Demand Manager, Demand Fulfillment, Master Planner and Material Allocator.
• Extensive hands on Schema design, XML import/export, Scheduling, System management using Data Analyzer.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 9.1(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor), Informatica Power Analyzer 9.1, ABPP Demand manager, ABPP Demand Fulfillment, ABPP factory Planner, ABPP Material Allocator, Oracle 11g/10g, Flat Files, TOAD 10.6 for Oracle, PL/SQL, ERWIN 7.3 Data Modeling tool, Windows 2000, UNIX PERL scripting, AutoSys, Informatica Scheduler.

Confidential, Bridgewater, NJ

Informatica Developer

Responsibilities:

• Identified the flow of information, analyzing the existing systems, evaluating alternatives and choosing the “most appropriate” alternative
• Developed mappings to extract data from Oracle, Flat files and load into Data Warehouse using the Mapping Designer
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Understood the Business point of view to implement coding using Informatica Power Center designer
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica Power Center designer and workflow manager.
• Migrate historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse
• Developed standards and procedures for transformation of data as it moves from source systems to the Data Warehouse
• Extensively used “pmcmd” commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Written Triggers, Stored Procedures for Complex mappings, Used Debugger in troubleshooting the existing mappings
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manage
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g, SSIS, Netezza 4.6, TOAD 9.7.2 for Oracle, Flat Files, PL/SQL, IDE, ERWIN 7.3 Data Modeling tool, Windows 2000, UNIX PERL scripting, AutoSys.

Confidential, Newark, NJ

Informatica Developer

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Created ER diagram of the data model using Erwin data modeler to transform business rules into logical model.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Lookup, Stored Procedure, Joiner, Update strategy, Expression and Aggregator transformations to pipeline data to Data Warehouse/Data Marts
• Handled slowly changing dimensions of Type1/Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Created Sessions and Batches to run Workflows.
• Responsible for writing unit test cases and performing the unit test.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.
• Involved in Production support and trained the other developers to handle issues.

Environment: Informatica PowerCenter 8.6.1/8.1.1 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Power Exchange, Oracle 11g, IBM DB2,MS SQL Server 2000, TOAD 9.7.2, Flat Files, Web Services, PL/SQL, ERWIN 7.3, SQL* PLUS, Windows NT, UNIX Shell scripting, Auto Sys 3.0

Confidential, Dallas, TX 

Informatica Developer

Responsibilities:

• Interacted closely with Business Users in the Requirements gathering phase.
• Worked with Data Architect in the logical and physical design of the data model.
• Documented the design by creating High-level design document and a Low-level design document.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier transformations.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Developed the sessions and workflows in the workflow Manager
• Created worklets when a group of sessions need to run multiple times
• Implemented Error Rejection process to load bad/invalid records into a separate reject table
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Responsible for UNIX shell scripts for backup and monitoring database
• Played a key role in all the testing phases and responsible for production support as well.

Environment: Informatica Power Center 8.1.1(Designer, Repository Manager, Workflow Manager, Oracle 10g, Teradata, UNIX Shell Scripting, XML, SQL Server 2000, windows XP, Sun Solaris 9, Visio, TOAD 9.1, SQL*Plus.