SUMMARY

• Over 7 years of experience in data warehousing fields like design, development and testing and analysis and Development and design of ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2.
• Extensive experience in using Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Experience working on various database systems like oracle10g/9i/8i, Sql Server, DB2 and Flat files, XML files and Excel files into Data warehouse and Data Mart.
• Experience in identifying performance issues in existing mappings by debugging mappings and analyzing the data flow and evaluating transformation.
• Extensive Experience in using Informatica Power Center transformations like Filter, Router, Expression, Source qualifier, Lookup, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer and XML Source Qualifier.
• Experience in developing complex mappings with Custom transformations, XML Sources.
• Experience in using power exchange for the change data capture.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts and necessary Test plans for successful execution of data loading process.
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Experience using Data Warehouse Appliances such as Netezza for data warehousing,business intelligence and Error free Data integration.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin.
• Good knowledge in SQL tuning using Hints, Materialized Views.
• Experience in SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Worked on ETL development projects with multiple team members, providing mentoring, technical assistance, troubleshooting and alternative development deployment of the new Telematics capabilities.
• Experience with industry Software development methodologies like Waterfall, Agile within the software development life cycle.
• Good understanding of Business Intelligence tools like Business Objects, Cognos.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x (Power Center/Power Mart/Power Exchange)

Data Modeling: Erwin 4.x/3.5

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2, MySQL

OLAP Tools: Cognos 7.0/6.0, Business Objects XI R2, SSRS, SSAS

Languages: T - SQL, PL/SQL, Perl, Unix Shell Script, Java, COBOL, XML

Tools: Toad, SQL* Loader, Autosys, TWS(Tivoli)

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

Sr. Informatica Developer

Responsibilities:

• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Worked on Informatica Power center 9.5 Tool - Mapping Designer, Workflow Manager, Repository Manager, and Workflow Monitor.
• Involved in design of Dimension Models, Star Schemas.
• Clear understanding of Business Intelligence and Data Warehousing Concepts.
• Experience in mapping techniques for Type 1 and Type 2 slowly changing dimensions.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
• Used Power Exchange for the Change Data Capture on the source tables.
• Involved in performance tuning of the mapping to reduce the load time
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Performed Code Reviews, Creation of CR, Design Control M job schedules, Production deployment planning.
• Work with production support groups to define and implement incident management procedures
• Created and managed the triggers for the smooth flow of data from the Source tables to unboxing tables. Implemented ETL process using UNIX shell script.
• Developed control files, Stored Procedures to manipulate and load the data into Oracle database using SQL Loader.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Involved in performance tuning using Explain Plan, analyzing Schema's, Tables and Indexes.
• Customized the solution by using partition tables, index views.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Used Informatica DVO for unit testing and data validation purposes.
• Used HPQuality Center to execute and document unit test cases and results.
• Involved in performance and integration testing of ETL jobs and prepared documentation.
• Served as liaison between offshore developers and end users in translating business requirements to technical designs and applications.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.0.1, CDC, MDM, Informatica DVO,Control M scheduler, Unix, Putty, Oracle 10g, PL/SQL, Greenplum, Toad, Erwin 4.0 Data Modeler, Cognos, HP Quality Center.

Confidential, Bloomington, IL

Informatica developer

Responsibilities:

• Analyzed and extracted source data coming from different sources like Flat Files and Oracle.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse.
• Developed number of simple to complex Mappings, Mapplets and Reusable Transformations for different types of tests in Customer information, Monthly and Yearly Loading of Data.
• Used Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions and Batches.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL.
• Wrote complex SQL scripts on SQ to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets for better performance.
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Created Mappings, Mapplets and Transformations, which remove any duplicate records in source.
• Implemented efficient and effective performance tuning procedures, Performed benchmarking, and these sessions were used to set a baseline to measure improvements against.
• Used Calculations, Variables, Break points, Drill down, Slice and Dice and Alerts for creating Business Objects reports.
• Involved in Unix Shell Scripts for automation of ETL process.
• Creating Informatica Development Standards.
• Implemented Change Data Capture by tracking the changes in critical fields required by the user.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Extensive use of Persistent cache to reduce session processing time.
• Modified the shell/Perl scripts as per the business requirements.

Environment: Informatica PC 9.1, Oracle 10g, Windows XP, Toad for Oracle, SQL Assistant for Teradata.

Confidential, Greenwood Village, CO

ETL Informatica Developer

Responsibilities:

• Responsible for design and development of Clinical Data Warehouse project leveraging Informatica Power Center ETL tool.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet, and Transformation Developer.
• Experience using ERWIN 4.0 in Data modeling.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
• Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Expertise working with Informatica Power Exchange for Netezza using Event-driven Data Integration with the Change Data Capture (CDC) Option
• Involved in design phase of logical and physical data model using Erwin 4.0.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Data quality checking and interacting with the business analysts.
• Created shell script for archiving files and trigger files.
• Responsible for Unit Testing and helped with User Acceptance Testing.
• Scheduling Informatica jobs and implementing dependencies if necessary.
• Responsible for Hypercare Support for Interfaces.

Environment: Informatica Power center 8.6/8.1, Informatica Power Exchange, Oracle10g, SQL Server 2008, Erwin 4.0, Unix scripting, Business Objects, Toad 8.6.

Confidential, Baton Rouge, LA

Informatica Developer

Responsibilities:

• Responsible for analysis, design and development of Enterprise Data Warehouse.
• Responsible for the Design of the Target Data Warehouse Entity.
• Developed complex Informatica mappings & tuned them for better performance.
• Performed Source partitioning to improve session performance.
• Extensively used connected and unconnected lookup transformations.
• Created Oracle stored procedures, functions and triggers using PL/SQL.
• Analyze the system, meeting with end users and business units to define the requirements.
• Involved in design phase of logical and physical data model using ERwin 4.0.
• Involved in designing STAR Schema for the business processes.
• Extracted the data from Oracle, Flat files and loaded them into Data Warehouse.
• Wrote SQL Queries, Stored Procedures, Functions and Shell Scripts.
• Was responsible for Optimization of the Query Performance and Session Performance.
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Unit testing of individual modules and their integration testing.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Debugged and sorted out the errors and problems encountered in the production environment.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL, PL/SQL, SQL* Loader, UNIX Shell Scripting, UNIX AIX.

Confidential

ETL Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access.
• Involved in developing source to target mappings and scheduling Informatica sessions
• Implemented the Incremental loading of Dimension and Fact tables.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve issues in Production database of OLAP and OLTP systems.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Develop, test and implement break/fix change tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.
• Developed the document of the complete ETL process.

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2, UNIX Shell Script.

Confidential

Data Warehouse Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows and Sessions to move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Developed Unix Shell scripts for maintaining Files.
• Designed and created an Autosys job plan to schedule our processes.
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
• Develop, test and implement break/fix change tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.

Environment: Informatica 6.22/7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 8i (SQL/PLSQL), MS Access 2006, Win 2000, Autosys, MS Excel 2006, UNIX, UNIX Shell Script.