SUMMARY:

• Overall 7 years of Information Technology experience in Data Warehousing and ETL process using Informatica Power Center 9.x/8. x.
• Extensively worked on Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse and Data Mart using Informatica and SSIS.
• Designed and developed ETL Architecture to load data from various sources like DB2 UDB, Oracle 11g/10g/9g, SQL Server 2010, Flat files, XML files, Netezza,Sybase, and Teradata.
• Worked with different query tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus.
• Working Knowledge in Data Analyzer tools like Informatica Power Exchange.
• Experience inlife cycle of ETLusing Informatica Power Center 9.6/8.x/7.x, client tools - Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
• Good Understanding in Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, Ralph Kimball Approach, OLAP, fact and dimension tables modeling of data.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experienced In working with various Scheduling tools like AutoSys, Control-Mand Informatica Scheduler.
• Implemented Slowly changing dimension types (I, II) methodologies for accessing the full history of accounts and transaction information.
• Experience in developing complex mappings using varied transformations like Unconnected and Connected lookups, Active Lookups, Expression, Filter, Source Qualifier, Union, Router, Aggregator, Sorter, Rank, Joiner, Normalizer and Update Strategy transformations.
• Implemented performance tuning techniques at Informatica objects and Database level.
• Implemented the command line commands like pmcmd and infacmd to perform tasks from any machine in the Power Center environment.
• Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
• Involved in the Unit testing, System integration testing and UAT using Quality Center.
• Worked on Business Analytical Reporting using BI Tools like Business Objects and Cognos 7.0.
• Experience in integration of various Operational Data Source (ODS) s with Multiple Relational Databases like Oracle, SQL Server, Teradata and Worked on integrating data from flat files like fixed width and delimited.
• Involved in the Performance/ Query tuning. Generation /interpretation of explain plans and tuning and optimization SQL to improve performance.
• Experience in implementation of transformations, shell Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model using Erwin.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Self-motivated and able to work as a member of a team.
• Excellent team work spirit and capable of learning new technologies and concepts.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.x, 9.x, 8.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server), SSIS

Databases: Teradata, Oracle11g/10g/9i, MS SQL Server 2012/2008/2005/ 2000, Netezza, MS Access 2010/2003/2000, DB 2

Programming: SQL, PL/SQL, UNIX Shell Scripting

Scheduling Tools: Control-M, AutoSys

Operating System: Unix, Linux, Windows 8/7/XP

Methodologies: Rational Unified Process (RUP), Waterfall, Spiral, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Portage, Michigan

Senior ETL/Informatica Developer

Responsibilities:

• Involved in requirements gathering, analysis and implementation of the data warehouse.
• Implemented delete detectionon real-time data for operational real-time reporting purposes using Informatica Mappings and Staging tables.
• Involved in Data Modeling the Dimensional and FACT tables E-R relationship.
• Used various Informatica transformations like Aggregator, Joiner, Filter, and Sorter to improve the ETL performance.
• Created Informatica mappings to transform source data and load it to target tables.
• Used Informatica parameter variables and mapping variables to generate Dimensional keys and FACT keys for different source systems.
• Effectively used Informatica’s BULK loading and parallelism strategy to improve the ETL data loads.
• Added complex logic for Metrics calculations through Stored Procedures and used Informatica stored procedure transformations to load data.
• Designed and developed Staging and Error tables to identify and isolate duplicates and unusable data from legacy systems through Informatica ETL data loads.
• Developed Scheduled and Monitored InformaticaETL data extraction/load from legacy source to Operational Data Sources and then processed to Data Marts.
• Provided 24*7 support for Production Migration.
• Implemented Custom and Dimensional hierarchies through Informatica ETL load process.
• Involved in various Test cycles and debugged errors with in ETLTransformations using Informatica Debugger.
• Implemented Slowly Changing Dimensions of Type 2 and Type 3 and stored historical data in Data Marts through Informatica Mappings.
• Developed reusable transformations and mapplets maximize the ETL load performance.
• Implemented parallelism and dynamic caching at Informatica session level to reduce the load durations.
• Used Informatica Update/Insert/Reject strategy to re-route the data to different FACT tables.
• Developed complex Stored Procedures for automation of ETLprocess and data capture from Oracle EBS to ODS and DM tables.
• Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings.
• Used pmrep and pmcmd Informatica commands to schedule and monitor data loads.
• Used event wait/raise and Decision tasks to schedule data loads in a timely manner.
• Implemented pre-sql and post-sql tasks to handle other data processing requirements.

Environment: Informatica Power Center 9.1, Power Exchange, Oracle 11g, PL/SQL (Stored Procedures), OBIEE, UNIX.

Confidential, Wallingford, Connecticut

Senior ETL/Informatica Developer

Responsibilities:

• Analyzed the Business requirements and documented the technical specification documents.
• Provide level 1 support for the production jobs and monitored them. Ensure that the ETL jobs get completed as per SLA.
• Implemented various performance tuning techniques at Informatica and Data base level.
• Used SQL and Advanced SQL queries to test huge volumes of data onOracle 11gandSQL Server 2008.
• Used Informatica Power center/Power Exchange to extract/transform and load into different systems involving Oracle, SQL server, XML, Flat files, MQ, AS400.
• Developed ETL mappings for Type 1 SCD and Type 2 SCD requirements.
• Implemented various performance tuning techniques on Sources, Targets, Mappings and Workflows.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs.
• Supported the QA resources in SIT and UAT testing phases.
• Using InformaticaPower center9.1to make the changes to the existing ETL mappings in each of the environments.
• Involved in the migration ofInformatica8.6workflowsintoInformatica9.1version.
• WrotePL/SQLprocedures which are called fromStored Proceduretransformation to perform database actions such as truncate the target before load, delete records based on a condition and rename the tables.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using Informatica Power Centre.
• Develop the Shell scripts to automate the finance billing file.
• Responsible for Detail design of each interface.
• Worked closely with theETLSSISDevelopers to explain the complex Data Transformation using Logic.
• Assisted with implementation/upgrade of AutoSys, troubleshoot errors, and documentation/procedures.
• Developed SDE mappings to load large amount of data from different sources to staging area, SID mappings for load the data from staging area to target system.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Created various Oracle database SQL, PL/SQL objects like Indexes, stored procedures, views and functions for Data Import/Export.
• Have RDBMS concepts experience in Oracle, Oracle PL/SQL, SQL*Plus, SQL*Loader, DB2 8.0/7.0,Netezza, MS SQL Server.
• Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
• Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).

Environment: Informatica Power Center 9.1, MS SQL server 2012, Oracle 11g/10g, Toad, PL/SQL (Stored Procedures), AutoSys, Erwin, CSV files, Unix Shell scripting, Windows XP.

Confidential, Plano, Texas

Informatica Developer

Responsibilities:

• Involved in creating Informatica mappings in uploading the Data files into the Staging tables and then finally into Data Warehouse system.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target and Transformation objects.
• Extracted data from Flat files, AS400 sources and loaded in to Oracle staging and target tables applying business rules as per the requirement.
• Developed Complex mappings to feed Data warehouse & Data marts by extensively using Informatica Mappings, Mapplets, and Transformations like Lookup, Filter, Router, Expression, Aggregator, Joiner, Stored Procedure and Update Strategy.
• Created Informatica mappings with PL/SQL Procedures / Functions/triggers to build business rules to load data.
• Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables.
• Created different reusable tasks like email tasks to send email and command tasks to create, rename and delete files.
• Scheduled and ran Workflows for Extraction, loading processes and monitored the Workflows using Workflow Monitor.
• Implemented Performance tuning technique and Optimization of mappings for better performance and efficiency.
• Provide remedial measures to the production issues or process failure.
• Troubleshoot problems by checking Sessions and Error Logs. Also, used Debugger for complex problem troubleshooting.
• Modified /Created parameter files in development, test and production environments using UNIX.
• Developed unit test scripts and test cases for unit testing and system testing.
• Involved in production deployments of the projects.

Environment: Informatica Power Center 8.6.1, TOAD, Oracle 10g, UNIX, PL/SQL, SQL Server, MS-Office Tools, Tables and Flat Files, Unix Shell scripting.

Confidential, Auburn Hills, MI

Senior Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6.1.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader,SQL Developer, AutoSys, Flat files, UNIX, Windows 2000