PROFESSIONAL SUMMARY:

• Over 6 years of experience in Information Systems mainly focused on Data Modeling, Data Integration, Data dissemination and Data analysis.
• Expertise with Informatica's Product Suite, particularly PowerCenter and PowerExchange 9.1/8.x/7.x including ability to design and develop complex Informatica mappings, sessions, workflows and identify areas of optimizations
• Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Extensively worked on Repository Server Administration Console, Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Expertise in developing Database Schemas like Star Schema and Snowflake Schema using modeling tools like ERWIN.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence and Synonyms.
• Experience in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT Dimensions tables, Physical logical data modeling and de-normalization techniques.
• Experience with Data Extraction, Transformation and Loading from different data sources like DB2, Oracle ,MS SQL Server, Teradata etc. into a common analytical data model using Informatica Power Center 6x/7x/8.1/8.5/8.6.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, and Transformations Sessions, web focus and crystal reports, developed batch processes and ETL tools to update the accounts.
• Experienced in using parameter files, mapping parameters, mapping variables and session variables.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
• Experience with industry standard methodologies like Waterfall, Agile, and Scrum methodology within the Software Development Life Cycle.
• Expert in data warehousing techniques for Data cleansing, Surrogate key assignment, Slowly changing dimension phenomenon SCD , Change Data Capture CDC .
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Actively involved in Performance Tuning.
• Experience in implementing update strategies and incremental loads.
• Excellent team player and self-starter with good analytical, problem solving and logical skills.
• Believes in under promising and over delivering.

PROFESSIONAL EXPERINCE:

Confidential

Informatica/ETL Developer

Responsibilities:

• Gathered requirements and the functional specs provided by the data architects and Business analysts and created technical specs documents for all the mappings
• Developed logical and physical data models that capture current state/future state data definitions and data flows using Erwin.
• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Extracted data from various databases like legacy databases on Mainframe, oracle and SQL Server into the Oracle tables using Informatica Mappings and Sessions
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic. Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• 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.
• Worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed them and implemented performance tuning logic on targets, sources, mapping, sessions to provide maximum efficiency and performance.
• Developed PL/SQL stored procedures and triggers in SQL for various data cleansing activities.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
• Developed shell scripts and leveraged the use of scheduler, control-M to run jobs.

Environment: Informatica Powercenter9.5.1,TOAD,OracleSQL,PL/SQL, Oracle11g, SQL server 2012, Control M Scheduler.

Confidential

Informatica/ETL Developer

Responsibilities:

• Developed and maintained Schemas, views, packages and jobs for an Oracle data warehouse
• Helped to select and deploy business reporting tools and develop sales and finance reports against the data warehouse
• Monitored and tuned data warehouse queries, ETL and Oracle jobs to optimize performance
• Performed ad-hoc reporting against the data warehouse for tactical business needs
• Worked with business application groups to integrate enterprise application data into the warehouse
• Extensively used different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules.
• Involved in the Development of informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Used PMCMD command to schedule sessions and batches.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.

Environment: Informatica Power Centre 8.6 Oracle 11g, TOAD, SQL Server 2005

Confidential

Informatica/ETL Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema.
• Created ETL detail design document and ETL standards document.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Created necessary Repositories to handle the metadata in the ETL process
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals on demand using Server Manager
• Involved in designing ETL data load strategy for SCD type 2, Dimensions and Fact tables, ETL reject handling, ETL restart recovery logic.

Environment: Informatica Power Centre 8.6 Oracle 11g, TOAD, SQL

Confidential

Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2008, Excel, and Flat files and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing DimensionType 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Created various UNIX Shell Scripts for scheduling, data cleansing and loading process and used PMCMD in the shell scripts.

Environment: Informatica Power Centre 8.6 Oracle 11g, TOAD, SQL

Confidential

Informatica Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Centre 8.6 Oracle 11g, TOAD, SQL