SUMMARY

• Over 7 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Strong experience withInformatica tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository.
• Designed and developedcomplex mappings tomovedata from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, and Update Strategy from varied transformation logics in Informatica.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Extensive experience in Programming, Database design, development and Data Warehousing using Informatica, PLSQL for Extraction, Transformation, Loading (ETL) of data from multiple database sources for medium to large enterprise data warehouses
• Experience in Dimensional Data modeling, Fact & Dimensions tables and Physical & Logical data modeling using Erwin.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle and SQL Server Databases.
• Informatica Data Quality helps make data quality improvement and standardizing on a single platform that provides a centralized set of reusable rules and tools for managing data quality across any project
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 and SCD3. Implemented the complex business rules by creating reusable transformations and Mappings / Maplets.
• Extensively used Informatica Client tools - Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Maplet Designer and Mapping Designer), Repository Manager, Server Manager, Repository Server Administration Console, Workflow Manager and Workflow Monitor.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.
• Experience in debugging and performance tuning of targets, sources, mappings and Sessions. Experience Migrating code from previous Informatica version to upgraded version

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1, 8.6, 8.1, 8.5, 7.1Databases Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008

Tools: /Utilities: SQL*Plus, SQL Developer, Putty.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Operating Systems: UNIX, Windows 95/98/2000, XP, Windows Server 2003, Linux

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Used Informatica Designer to create complex mappings using different transformations.
• Created analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes usingInformatica PowerCenter
• Worked oncomplex mappings, mapplets and workflowto meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used ETL to transfer and extract data from source files (Flat files) and load the data into the target database.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule. Developed complex jobs to load data from multiple source systems like Oracle 10g, flat files, XML files to data mart in Oracle database.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.
• Involved in Unix Shell Scripts for automation of ETL process.
• Created Talend Development Standards. This document describes the general guidelines for Talend developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Responsible for creating fact, lookup, dimension, staging tables and other database objects like views, stored procedure, function, indexes, constraints
• Implemented Error handling in Talend to validate the data Integrity and data completeness for the data from the Flat File.
• Worked on slowly changing dimensions type 1 and type 2 for populating dimension tables as per mapping rules specifies.
• 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.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• 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.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on SQL queries and tuned them to improve performance.
• Worked with SSIS followed by Informatica to get the data from SQL server database.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g,MS SQL Server, UNIX, Windows.

Confidential, Phoenix AZ

Informatica Developer

Responsibilities:

• Responsible fordeveloping, support and maintenance for the ETL(Extract, Transform and Load) processes usingInformatica PowerCenter
• DevelopMappings and Workflowsto generate staging files.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Extensively designed Data mapping using filters, Expression, Update Strategy Transformations in Power Center Designer.
• Created target load order group mappings and scheduled them for Daily Loads.
• Extensively used UNIX commands within Informatica for Pre Session and Post Session Data Loading Process.
• Extensive use of Informatica metadata manager for data lineage and where-used analysis, metadata browsing, metadata reporting & metadata document.
• Used Mapping designer and Mapplets to generate different mappings for different loads
• Used the PL/SQL procedures for data extraction, transformation and loading
• Performance Tuning of sources, targets, mappings and SQL queries in transformations
• Used SQL Loader for loading data into table structures
• Created various transformations like Joiner, Aggregate, Expression, Filter, update Strategy
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Performed various SQL queries for business analysts.
• Created multiple Mapplets. Workflows, Tasks, database connections using Workflow Manager
• Responsibilities include creating the sessions and scheduling the sessions.
• Extracted the datafrom Oracle, CSV and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance. Understanding the Functional Requirements.

Environment: Informatica, Oracle 9i, Teradata, SQL Assistant, MLOAD, FASTLOAD, TUMP, FASTLOAD, PL/SQL, SQL Loader, Windows, UNIX

Confidential, San diego, CA

Data Analyst/ Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data Migration.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Developed various medium and complex mappings for Loading Data in to Target tables Using Informatica.
• Implemented Complex logic, Error Handling logic
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files
• Designed and implemented Audit control and Exception control strategies
• Provided solutions for various performance bottle necks in Informatica Mappings
• Designed and Developed Autosys jil scripts to Schedule Informatica workflows
• Developed various shell scripts using Korn Shell to Integrate various components
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process
• Involved in Unit testing, System Integration testing, User Acceptance Testing
• Source systems data from the distributed environment was extracted, transformed and loaded into the Data warehouse database using Informatica.
• Extracted Data from flat files and various relational databases to Teradata & Oracle Data warehouse Database.
• Created mappings using various Transformations like Aggregator, Expression, Filter, Router, Joiner, Lookup, Update strategy, Source Qualifier, Sequence generator, Stored Procedure and Normalizer.
• Developed various Mappings & Mapplets to load data from various sources using different Transformations.
• Used MLOAD, TPUMP, and FASTLOAD to load data to Teradata across various areas such as staging, EDW and data marts.
• Utilized Push down optimization in Informatica
• Performed various update strategies using Lookup and Update Strategy transformations.
• Creating Stored Procedures to populate sample data and carrying out test load.
• Loaded data from flat files and XML files to temporary tables in Oracle database using SQL*Loader. Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings Coded PL/SQL scripts.

Environment: Oracle 9i, Informatica Power Center, UNIX, Windows 2000, SQL*Loader, Teradata, SQL Assistant, MLOAD, FASTLOAD, TUMP, FASTLOAD, SQL, PL/SQL

Confidential

Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Environment: Informatica Power Center 8.1, Oracle 9i/10g, PL/SQL, SQL*Loader, Teradata, Shell scripts, MS SQL Server 2000, ODBC.

Confidential

Informatica Developer

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in workflow manager and monitored the results using workflow monitor.

Environment: Informatica Power Center 8.1, Teradata, Oracle 10g, Flatfile, UNIX scripting, Windows XP Professional, Hyperion

Confidential

Informatica Developer

Responsibilities:

• Extensively used ETL to load data from Flat Files, Teradata.
• Involved in Requirement Gathering and Business Analysis
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, sequence generator, joiner.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created, launched & scheduled sessions.

Environment: Informatica Power Center 8.1, Oracle 9i/10g, PL/SQL, SQL*Loader, Teradata, Shell scripts, MS SQL Server 2000, ODBC