SUMMARY:

• 7+ years of IT experience with emphasis on ETL process, Business Intelligence, Business requirement analysis, Data warehousing, Data Migration, Data modeling, Data integration and Data Migration.
• Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Power Center.
• Strong knowledge of Data Warehousing SDLC and architecture of ETL, reporting and multiple BI tools.
• In depth understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementation of Data warehousing using Windows and UNIX.
• SDLC: 6 years of IT experience in system analysis, design, coding and testing.
• Extensive experience in the Data Warehousing implementations for various domains like Pharmaceutical, Insurance and Networking Equipment.
• Databases: 6 years of experience using Oracle, MS SQL Server, SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Experience with Data Cleansing, Data Profiling, Data analysis, UNIX Shell Scripting.
• Database / ETL Performance Tuning: Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views. Performance Tuning of Informatica Mappings and workflows.
• Data Modeling: 6 years of Dimensional Data Modeling experience using MS Visio, Erwin, Data marts, OLAP, OLTP, FACT & Dimensions tables, Physical & Logical data modeling.
• ETL: 6 years of Data Warehousing experience using Informatica Power Center, Power Mart, Power Connect for SAP/Siebel/DB2, Power Exchange, Data mart, IMS Rx Data (Plantrak, Xponent Plantrak).
• Excellent communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.1/8.6/7.1.1 , Power Mart 6.2/5.x, PowerConnect, Power Analyzer, ETL, Data Mining, Data mart, Talend, OLAP, OLTP, IMS Rx Data, Clinical Data understanding.

BI & Reporting: Cognos Series 10.1/8.0, Business Objects 6.5, Crystal Reports xi/6.x, Cognos Power Play, and Cognos ReportNet 1.1., SQL Server, SSRS and Tableau.

Data Cleansing: Trillium 13.5/7.6

CRM: Siebel 8.0 ( ePharma)

Data Modeling: Erwin 4.5/4.0, ER Diagrams, Dimensional Data Modeling (Star Schema, Snowflake Schema, FACT and Dimensions Tables), MS Visio, Logical, Physical and Relational Modeling.

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2008, SQL Navigator, SQL*Loader, DB2, MS Access

Environment: UNIX, Linux, Windows 2003/2000/XP/98/7.

Others: UNICA 8.6/6.x,XML, PERL, Java, PVCS, Unix Shell Scripting, SQL, PL/SQL, Transact SQL, SQL*Plus, HTML, DHTML, TOAD, C, TIDAL Scheduler, Maestro Scheduler, Edit Plus.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in gathering of business scope and technical requirements and technical specifications of Campaign Management.
• Involved in all phases of software development life cycle (SDLC).
• Developed complex mappings inInformaticato load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Proposed, defined and obtained Data Integration Strategy using open - source Talend Data Integration for Data Movement and ETL integration
• Fine-tuned existing Informatica mappings for performance optimization.
• Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.1
• Involved in capturing slowly changing dimensions of all varieties including type-I, type-II and type-III.
• Extensively used ETL to load data from flat files,XML files and Oracle database.
• Analyzed existing system and developed business documentation on changes required.
• Made adjustments in Data Model andSQLscripts to create and alter tables.
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Involved in the Unit testing and System testing of the processes.
• Handled the migration process from development, test and production environments.

Environment: Informatica 9.1, Oracle 10g, PL/SQL, UNIX scripts, XML, Cognos 10.1, Trillium 13.5, Unica 8.6, Tidal Scheduler

Confidential

Sr. ETL Developer

Responsibilities:

• Interacted with the Business Users to analyze the Business Requirements and transform the business requirements into the technical requirements.
• Developed database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling using ERWIN.
• Worked on PowerCenter Tools like Designer, Workflow Manager, Workflow Monitor and repository Manager.
• Extracted data from various heterogeneous sources like Oracle and Flat Files
• Extensively used various active Transformations, passive transformation and Mapplets.
• Responsible for Data Cleansing and Data Validation using Expression Transformation and Lookup Transformation.
• Folder migrations from PowerCenter 8.6.1 to PowerCenter 9.1
• Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1
• Analyzed business process workflows and developed ETL procedures to move data from various source systems to target systems.
• Created PL/SQL procedures to transform data from staging to Data Warehouse Fact and summary tables.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Stored Procedure Transformations.
• Created various UNIX Shell scripts for automation of events, File Validation, File Archiving.
• Developed scripts using PMCMD command to run the Workflows, Sessions from UNIX environment which are called in Maestro scheduler.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings on the development server.
• Involved in Testing, Debugging, Data Validation and Performance Tuning of ETL process, help develop optimum solutions for data warehouse deliverables.

Environment: Informatica 9.1, Oracle 10g, PL/SQL, Cognos 10.1,Flat files, XML Files, Erwin, PVCS.

Confidential

ETL Developer

Responsibilities:

• Acquired Business requirements and designed technical design documents and wrote technical specifications of CDW.
• Enhanced the existing data model to accommodate new business requirements.
• Worked extensively on developed complex mappings and workflows inInformaticato load the data from disparate sources using various transformations.
• Developed change request document based on understanding of existing system and changes requested by business users.
• For ETL processes used numerous INFORMATICA transformations like Source Qualifier, Normalizer, Expression, Filter, Rank and Router transformations, Aggregate, Update Strategy, Look up (connected and unconnected), Sequence Generator, and Joiner.
• Created mapplets, reusable transformations and reusable sessions to aid new objects to be quickly created and updated.
• Used parameters and variables in mappings, workflows and sessions.
• Responsible for performance optimization of existing Informatica processes and PL/SQL procedures.
• Implemented the dimensional model by using slowly changing dimensions.
• Extensively used ETL to load data from flat files,Oracle database.
• Made adjustments in Data Model andSQLscripts to create and alter tables.
• Responsible for creating UNIX scripts/wrapper scripts for automating and scheduling of the ETL processes and monitored the daily jobs.
• Tested the application by unit testing and performed end to end test of the application using system integration testing and designed and prepared unit test cases/system test cases.

Environment: Informatica 8.6, Oracle 10g, PL/SQL, Cognos 10.1, UNIX scripts, XML.

Confidential

ETL Developer

Responsibilities:

• Identified business rules for data migration, parsing high-level design spec to simple ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed mapping document, which is a guideline to ETL coding.
• Loading the Data from Flat Files and Oracle tables into the staging area using Informatica Power Center 7.1
• Worked on Informatica Power Center 7.1 tool - Source analyzer, warehouse designer, mapping designer, workflow manager, mapplets, and reusable transformations.
• Optimized query performance, session performance and reliability.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformations.
• Used data base objects like materialized view, sequence generators, parallel partitioning and stored procedures for accomplishing the complex logical situations.
• Handled the migration process from development, test and production environments.
• Used Perl database modules for error checking and logging of data loads and Perl scripts to send emails with attachments of erroneous records to support team.
• Tuning the mappings for optimum performance, dependencies and batch design.
• Scheduled and ran extraction and load process and monitored sessions using Informatica workflow manager.
• Created the batch design and scheduled the batches to run under the window time.
• Designed slowly changing dimension strategy for the warehouse.

Environment: Informatica 7.1, Oracle 9i, PL/SQL, UNIX, BO 6.5, Perl script, Unica 6.x, Maestro Scheduler.