SUMMARY

• 8 Years of IT experience including Data Warehouse Design, Analysis, Architecture, Dimension Modeling, Business Intelligence strategy, Development, Testing, Implementation, Training and Documentation.
• Expertise in entire life cycle of DWH with project scope, Analysis, requirements gathering, data modeling, ETL Design, development, Unit / System testing and production support.
• Strong ETL experience of using Informatica 9.6.1/9.5.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Repository manager, Workflow Manager/Monitor.
• Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Having strong hands on experience in extraction of the data from various source systems like DB2, Oracle, My Sql, Flat Files, SFDC, XML and Teradata.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Good knowledge in Informatica Data Quality (IDQ).
• Experience in Understanding Data Warehouse Design & Model.
• Acquired experience with full life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
• Extensive experience in developing Stored Procedures, Packages, Functions, Views and Triggers, Complex SQL queries and Oracle PL/SQL.
• Proficiency in data warehousing techniques for Change Data Capture, Data Cleansing, slowly changing dimensions’ types (1 and 2).
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Solid analytical and dynamic troubleshooting skills.
• Self-motivated and enjoy working in a technically challenging environment.
• Experience in work allocation, status tracking and Coordinating with teams to keep them focused on the deliverables.
• Expertise in using both Agile & Waterfall Methodologies effectively.

TECHNICAL SKILLS

Operating System: Windows (2000/NT/XP/vista/7), Unix/Linux, DOS.

ETL tools: Informatica Power Center 9.6.1/9.5.1/8.6.1/7.1.1

Databases: Oracle 8i/9i/10g/11g, DB2, Teradata, MySql, SFDC.

Languages: SQL, PL/SQL, UNIX, Shell Scripts, JAVA, XML.

Modeling: Dimensional Data Modeling, Erwin, Star - Snow Flake Schema.

Reporting Tools: Cognos, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, IL

Sr. Informatica ETL Developer / Analyst

Responsibilities:

• Involved in Walk-through meetings with Business Analysts to understand the Mapping Document.
• Strong Understanding logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• 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.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• High proficiency with Power Center and involved in utilizing Informatica product effectively to move Mainframe DB2 and flat-file data to oracle.
• Create ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Performance tuning of the Informatica mappings using various options available in Informatica.
• Performance tuning using Informatica partitioning.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Written UNIX Shell Scripts for various purposes in the project.
• Managed Change control implementation and coordinating daily, monthly releases. Extensively used debugger to test the logic implemented in the mappings.

Environment: Informatica Power Center 9.5.1/9.6.1 , Oracle 10g/9i, DB2, Tableau, Toad, Unix.

Confidential, DALLAS, TEXAS

Sr. Informatica ETL Developer

Responsibilities:

• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all the source applications.
• Involved in Requirement analysis in support of Data Warehousing efforts.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Worked with source databases like Oracle, SQL Server and Flat Files.
• Extensively worked with Teradata utilities BTEQ, F-Load, M-load & TPT to load data in to ware house.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Created complex mappings using Unconnected and Connected Lookup Transformations.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Worked extensively with update strategy transformation for implementing inserts and updates.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if there are any abnormalities.
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Involved in production support when required.
• Monitored workflows and session using Power Center workflows monitor.
• Used Informatica Scheduler for scheduling the workflows.
• Provided 24*7 supports for Production environment for Extraction, Loading and transformation of data by remote monitoring.
• Monitoring the Extraction and loading processes of data and Involved in writing UNIX shell scripting for automating the jobs.

Environment: Informatica Power Center 9.1.1, Oracle, Sql server, My Sql, Flat Files, Teradata 12, Cognos, Unix AIX and Windows XP.

Confidential, Pittsburgh, PA

ETL Informatica Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Reviewing the data model and ETL flow with Modelers & Architects.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development of Informatica Mappings as per the requirement in STM to load data into the Data Warehouse.
• Writing SQL Scripts based on the requirement.
• Scheduling of Informatica sessions for testing automation of loads.
• Performance tuning of long running jobs in Informatica.
• Updating of ETL Specification, Test Case and Reporting Metadata Documents after testing in various environments (Development, QA and Production)
• Creating the functions and few rules for having a good data quality.
• Extracted the data from the Flat Files, Oracle and My Sql into staging area and populated in to data warehouse which is DB2.
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in Migration & Testing of mappings, sessions, worklets and workflows from Informatica 7.1 to Informatica 8.6.1 and make sure all the environment is upgraded properly.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.

Environment: Informatica Power Center 7.1/8.1.1/8.6.1 , Oracle 9i, Sybase, SQL, PL/SQL, Cognos, Unix AIX and windows XP.

Confidential

ETL Developer

Responsibilities:

• Developed Informatica mappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule Workflows and Worklets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded Database triggers, functions and Stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, created database structures, objects and their modification as and when needed.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.

Environment: Informatica Power Center 8.1.1, Oracle 8i, SQL, PL/SQL, UNIX (AXI), Erwin, Toad.

Confidential

Jr. ETL Developer

Responsibilities:

• Involved in Project Analysis and documenting the dev requirements.
• Worked with ETL Architects, Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements using Informatica 7.1.1., and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.
• Wrote triggers and packages by using PL/SQL for giving security privileges.

Environment: Informatica Power Center 7.1.1, Oracle, SQL, PL/SQL, UNIX, Erwin, Windows NT.