PROFESSIONAL SUMMARY:

• 8+ Years of Experience as Senior ETL Developer with extensive experience in all phases of development life cycle across multiple domains, including banking, insurance and healthcare.
• Three years of experience performing business analysis duties under a PMO from a developer perspective, which includes analyzing data, gathering requirements, forecasting the deliverables and translating requirements to technical personnel.
• Develop Informatica mappings from source to target loading from BODI to TP.
• Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un - connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Tuned Informatica mappings to improve the execution time by applying suitable partitioning mechanisms and tuning individual transformations inside the mapping.
• Good Knowledge on Database architecture of OLTP and OLAP applications, Data Analysis.
• Worked with wide variety of sources like Relational Databases, Flat Files, Mainframes, XML files and Scheduling tools like Control-M, Auto sys and Informatica Scheduler.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes) and UNIX Shell scripting.
• Created detailed Technical Specification Documents for data warehouse and ETL processes.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.x/9.5/8.6.x/8.5.x., Informatica Power Exchange, ILM Work Bench, Informatica IDQ 9.6.0

Data Modeling: Star Schema, Snowflake Schema, Erwin 4.0, Dimension Data Modeling.

Databases: Oracle11g/10g/9i, SQL Server 2012/2008/2005/2000, IBM DB2, Teradata 13.1/V2R5, V2R6,MS Access

Scheduling Tools: Control-M, CA7 Scheduler, Autosys, Informatica Scheduler.

Reporting Tools: Crystal Reports, Business Objects XI R2/XI 3.3, OBIEE 11g R1 (11.1.5).

Programming: SQL, PL/SQL, Transact SQL, HTML, DHTML, XML, C, C++, Shell

Operating Systems: Windows 7/XP/NT/95/98/2000, UNIX and LINUX

Other Tools: SQL*Plus, Toad, SQL Navigator, Putty, WINSCP, MS-Office, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. ETL Informatica developer

Technical Environment: Informatica Power Center 9.1, Power Exchange, Mainframes, PL/SQL, DB2, Shell Scripting-UNIX, CA7 scheduler, Toad, Informatica Native Scheduler

Responsibilities:

• Worked with Business and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Involved in creating Logical and Physical Data Models and creating Star Schema models.
• Worked on Informatica Analyst tool in IDQ
• Assisted in designing Star Schema to design dimension and fact tables.
• Involved in developing star schema model for target database using ERWIN Data modeling.
• Utilized Informatica Data Quality (IDQ) to create Profiles and complete initial data profiling and Ad hoc profiling.
• Executed strategy, architecture, design and implement Data Masking using Informatica ILM tools
• Created Scorecards in IDQ Developer and Analyst to identify the trend of the quality of data
• Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).Created events and tasks in the work flows using workflow manager.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views and Sequences.
• Daily production supports for the scheduled job and provide the resolution related to failed job and fixed them.
• Created Stored Procedures, Functions and Indexes Using Oracle.
• Worked on batch processing and file transfer protocols.
• Performance tuning of the workflow which are taking time.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Creation of technical documents.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Confidential, NY

Informatica ETL Prod Support

Technical Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g, TOAD 10.1 for Oracle, DB2, Flat Files, PL/SQL, OBIEE 11g, ERWIN, Windows 2000, UNIX PERL scripting, Autosys

Responsibilities:

• Designed, developed and documented the ETL (Extract, Transformation and Load) strategy to populate the Data Mart from the various source systems.
• Worked on ly Informatica 8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in design and development of complex ETL mappings.
• Implemented partitioning and bulk loads for loading large volume of data.
• Based on the requirements, used various transformations like Source Qualifier, Normalize, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, Mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Performance tuning by session partitions, dynamic cache memory and index cache.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Created Stored Procedures in PL/SQL.
• Created UNIX Shell scripts to automate the process.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts.
• Played a key role in all the testing phases and responsible for production support as well.

Confidential, MI

Informatica Developer

Technical Environment: Informatica Power Center 8.x, ETL, Oracle 9i, SQL Server2000, MS Access, SQL, PL/SQL, Windows

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center 8.5.x tool.
• Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
• Optimized mappings, sessions/tasks, source and target databases as part of the performance tuning.
• Designed ETL Mappings and Workflows using power center designer and workflow manager.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Developed various Mappings, Mapplets and Transformations for data marts and Data warehouse.
• Used Shell Scripting to automate the loading process.
• Used VBA Macro excels to compare data to show proof of concept for Unit testing.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I and II changes in slowly changing dimension tables.
• Used command line program pmcmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed processes to extract, transform and load data to the Data Mart.
• Performed impact analysis, remedial actions and documented on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Confidential, TX

Jr. ETL Informatica Developer

Technical Environment: NT Informatica Power Center 8.6.x, ETL, SQL Server2000, MS Access, SQL

Responsibilities:

• Involved in design and development of complex ETL mappings.
• Implemented partitioning and bulk loads for loading large volume of data.
• Based on the requirements, used various transformations like Source Qualifier, Normalize, Expression, Filter, Router, Update Strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplet, Worklets and reusable transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Performance tuning by session partitions, dynamic cache memory and index cache.
• Developed Informatica SCD type-I, Type-II mappings.
• Extensively used almost all of the transformations of Informatica including Complex Lookups, Stored Procedures, Update Strategy, mapplets and others.
• Implemented Update Strategies, Incremental Loads, Data Capture and Incremental Aggregation.
• Created Stored Procedures in PL/SQL.
• Created UNIX Shell Scripts to automate the process.
• Developed documentation for all the routines (mappings, sessions and workflows).
• Involved in scheduling the workflows through Autosys Job Scheduler using UNIX scripts.
• Played a key role in all the testing phases and responsible for production support as well.
• Technical Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g, TOAD 10.1 for Oracle, DB2, Flat Files, PL/SQL, OBIEE 11g, ERWIN, Windows 2000, UNIX PERL scripting, Autosys