SUMMARY

• Having 8+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) in Informatica Power Center from various database sources.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Experience in Info rmatica (9.6,9.5,9.1,8.6 ) applications. Designed and developed the Workflows, Worklets, Mappings and Sessions.
• Expertise in performance tuning of SQL queries and Informatica mappings.
• Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Involved in Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner and Update Strategy) from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Experience in optimizing the mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Expertise in working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Expertise in OLTP/OLAP System Study, Analysis, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Adaptable and flexible to work in any kind of environment and desire to learn new technologies. Continuous learning to augment my skill set with opportunities to deliver my best.
• Excellent communication skills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x

Databases: Oracle, MS SQL Server, DB2, TeraData.

DB Tools: SQL*Plus, SQL* Loader, TOAD

Environment: UNIX, WINDOWS XP/2000/NT

Languages: C, C++, Java, SQL, PL/SQL, XML, UNIX

Development Tools: Microsoft Visual Studio

Office Suite: MS Word, MS Power Point, MS Excel, MS Access.

Scripting Languages: Java Script, VB Script and UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Hartford

Informatica Developer

Responsibilities:

• Worked as an Informatica/Data Warehouse Developer and was involved in business analysis, requirements gathering, transforming business requirements and creating source to target mapping and transformation documents.
• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using Informatica, PL/SQL and Unix Shell scripts.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
• Developed reusable transformations, mapplets, sessions, worklets to make Informatica code very modular and to reuse as required.
• Developed complex mappings using Informatica Power Center 9.6 to load the data from various sources like flat files, SQL Server, Oracle into the target Oracle Data Warehouse.
• Involved in Data Extraction, Staging, Transformation and Loading and worked with Oracle Application Integration.
• Major role in the complete Project Life Cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing logics and transformation as per the requirement and creating mappings and loading the data into different targets.
• Creating Informatica mappings for populating the data into dimension tables and fact tables from ODS tables.
• Extensively used various transformations like Expression, Lookup (Connected and Unconnected), Filter, Router, Aggregator, Update Strategy, Joiner, Sorter and Normalizer to attain the required business logic in the mappings.
• Implemented Slowly Changing Dimensions- Type I & II in different mappings as per the requirements.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Extensively worked on identifying performance bottlenecks and in the performance tuning of ETL Processes.
• Extensively worked in SQL, PL/SQL, Query performance tuning, created DDL scripts, created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Used Control-M scheduling tool for jobs schedule.
• Created sessions and batches. Used parameter files to pass variable values.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

Environment: Informatica Power Center 9.6.2 HF2, Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files, Control-M, Infogyx, Microsoft Office- MS Word, MS Excel.

Confidential, Florida

Informatica Developer

Responsibilities:

• Involved in complete software development life cycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
• Developed technical design documents (HLD and LLD) based on the functional requirements.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Creating and maintaining source-target mapping documents for ETL development team.
• Providing requirement specifications and guide the ETL team for development of the ETL jobs through Informatica ETL tool.
• Develop Mappings and Workflows to generate staging files.
• Used various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created multiple Mapplets, Workflows, Tasks, database connections using Workflow Manager.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Responsibilities include creating the sessions and scheduling the sessions.
• Worked on Work Load Manager for scheduling the jobs.
• Recovering the failed Sessions and Batches.
• Extracted the data from Oracle, DB2 and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Worked on optimizing and tuning the Oracle views and SQL's to improve the performance of batch and response time of data for users.
• Provided support during the system test, Product Integration Testing and UAT.
• Provided quick production fixes and proactively involved in fixing production support issues.
• Coordinate with Configuration management team in code deployments.

Environment: Informatica power center 9.5, Oracle 10g, DB2,Flat files, True comp Aruba, Work Load Manager, SQL Navigator 6.4, UNIX,SQL Developer

Confidential

Software Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Involved in parsing of XML documents to fetch the data from xml store in oracle tables.
• Implemented and reviewed the transformation logic in the ETL mappings according to the pre-defined ETL standards.
• Created Mappings, reusable transformations using Designer of Informatica PowerCenter Tool.
• Sophisticated transformations are implemented using Informatica features like Aggregator, Filter, Expression, Normalizer, Lookups, UPS and Source Qualifier and etc.
• Using Joiner transformation for extracting data from multiple sources.
• Implemented performance tuning logic on sources, mapping, sessions and targets in order to provide maximum efficiency and performance.
• Defined Target Load Order Plan for loading data into Target Tables.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Created error log table to capture the error messages, session load time.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Develop new and support existing ETL processes using the Informatica Tool.
• Performance tune databases and SQL statements in connection to ETL code as required
• Perform source system analysis as required.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows.

Confidential, Melbourne

Informatica Consultant

Responsibilities:

• Involved in Extraction, transformation, Loading and Implementation
• Worked on Informatica tool - Source Analyzer, Mapping Designer and Transformations.
• Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, oracle and loading to Oracle target database.
• Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Lookup to load the data
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Mapping Optimizations to ensure maximum Efficiency
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using current Flag.
• Created sessions to run the mappings and set the session parameters to improve the load performance.
• Design and development of mapping and Database management.
• We undergo discussion to understand the requirements.

Environment: Informatica power center 8.6, Oracle 10g, Flat files, SQLerver2000TOAD 9.5, UNIX.