PROFILE:

• 6+ years of IT Experience
• 6+ years of Informatica Developer Experience.

SUMMARY:

• 6 years of IT experience in designing, developing, testing and maintaining ETL methodology for supporting data transformations and processing using Informatica Power Center 8.6.1/ 9.5.1/9.6.1.
• Proficient in all phases of the Software development lifecycle (SDLC).
• Data profiling and Data Validation based on the business and functional requirements.
• Extensive experience in Finance, Insurance and Healthcare Industries.
• Proficient in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Good understanding of data modeling concepts like Star - Schema, Snow Flake schema, ER modeling.
• Implemented all types of Slowly Changing Dimensions.
• Experience in Extraction/Transformation/Loading of data to Data Mart/Data Warehouse from various sources such as Flat files, Relational Databases, XMLs using Informatica Power Center Repository Manager, Designer, Server Manager, Workflow Manager, Workflow Monitor.
• Involved in Performance Tuning, identifying and resolving performance bottlenecks in various levels such as sources, targets, mapping, sessions.
• Experience in basic Informatica administration like creating folder, users, assigning privileges.
• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.

TECHNICAL SKILLS:

ETL: Informatica Power Center 8.x,9.5.1/9.1

Databases: Oracle 11g/10g/9i/8i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005, SybaseIQ

Data Modeling Tools: Erwin, MS Visio

Database Tools: Toad, SQL Developer, Embarcadero

Languages: SQL, PL/SQL, XML, XSD, Unix shell scripting

BI Tools: Qlikview, Business Objects

Other Tools: Putty, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, TN

Informatica Developer

Responsibilities:

• Interacted with End-users along with Business Analysts for gathering Business Requirements
• Worked with Business Analyst, ETL Lead and BI developers in analyzing requirements and Strategizing the Data Warehouse processes
• Worked with ETL Lead and Data Modelers in designing Dimensional model.
• Created Technical Design documents, Source/Target Matrices based on the Business Requirements
• Assisted ETL Lead in enhancing the Naming Conventions, ETL strategies and Best Practices for DW environment
• Worked on extracting data from different sources Oracle database, XML files and flat files.
• Extensively worked on various transformations like Source Qualifier, Expression, Aggregator, Joiner, Lookups (Connected/Unconnected), Update Strategy, Union, Stored Procedure, Router and Filter Transformations to implement complex business logic.
• Created Mapplets, Reusable Transformations, Reusable Sessions/Email/Command Tasks to increase the code reusability and maintenance
• Developed complex mappings to load Slowly Changing Dimensions Type-I and Type II, Fact tables
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions
• Involved in performance tuning of sources, targets, mappings and sessions by identifying bottlenecks
• Used Informatica Workflow Manager to create workflows, database connections and sessions to run the mappings.
• Created Shell Scripts to Run Informatica Workflows on the command line
• Unit tested the code and closely worked with testing team members in resolving the defects.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, XML, XSD, Sybase IQ, Red Hat Linux, PuTTY, Embarcadero, Erwin, Autosys, Qlikview

Confidential, Fairfax, VA

Informatica Developer

Responsibilities:

• Analyzing business requirements, designing and writing technical specifications to design or develop ETL processes.
• Developed Informatica technical mapping document to pull data from different Source systems and integrate.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Loading Data to the Interface tables from multiple data sources such as Oracle, SQL server, XMLs and flat files.
• Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables, Summary tables.
• Extracted, Transformed and Loaded the data from Oracle enterprise data warehouse to target database. Also worked on creating mappings to load data into target database from OLTP Databases (Oracle and SQL Server) and other sources like Flat files, XML files.
• Designing the target warehouse using Star Schema.
• Creating mappings to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Filter and Router transformations, Union transformations, etc.
• Involved in Implementing performance tuning of sources, targets, mappings and sessions by identifying bottlenecks
• Performed unit testing and documented the results.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Creating sessions for execution of mappings using workflow manager.
• Developing Mapplets using corresponding Source, Targets and Transformations.

Environment: Informatica 9.1, Oracle, SQL Server, Linux, TOAD, MS Visio.

Confidential, Abbott Park, IL

Informatica Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Worked on Informatica Power Center - Source Analyzer, Target Designer, Mapping Designer & Mapplets, and Transformation Developer, Repository Manager, Workflow Manager and Workflow Monitor.
• Participated in Informatica Administrative tasks such as - adding users, granting user privileges, creating roles, creating different folders, adding repositories, taking backups and restoring repositories.
• Worked closely with ETL Lead and Data Modelers in converting Business Requirements into Technical Specifications.
• Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables.
• Used transformations like Expression, Lookup, Filter, Router, SQL, Union, Sequence Generator, Joiner, Aggregator, Sorter, Stored Procedure, Update Strategy
• Followed Informatica Best Practices and Naming Conventions while developing the mappings, sessions and workflows.
• Unit tested the code and closely worked with testing team members in resolving the defects.

Environment: Informatica PowerCenter 9.1/8.6.1, Informatica Data Quality 9.1, Oracle 11g, RedHat Linux, PuTTY, Toad 9.0

Confidential

ETL Developer

Responsibilities:

• Worked closely with the Applications Development and Project Management teams for coordination, scheduling and implementation.
• Created different transformations for loading the data into targets - Source Qualifier, Joiner, Router, Update Strategy, Lookup, Rank, Expression, Aggregator and Sequence Generator.
• Involved in data modeling of relational and dimensional databases
• Created reusable transformations and Mapplets to use the transformation logic in multiple mappings.
• Used Repository manager to create and manage folders
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Involved in scheduling the workflows through workflow manager.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Scheduling and Loading data process and monitoring the ETL Process.
• Using Workflow Manager for Creating, Validating, Testing and running the workflow and Sessions and scheduling them to run at specified time.

Environment: Informatica PowerCenter 8.6.1, Workflow Manager, Workflow Monitor, Designer, Repository Manager, Repository Server Administration Console, Business Objects 6.0, ERwin 4.1, TOAD, Oracle, PL/SQL, UNIX