SUMMARY

• Over 7 years of experience in IT industry in the design, development, implementation, testing and maintenance in Data Warehouse and Client Server environments.
• 5+ years of ETL Data warehousing experience using Informatica Power center 9.x/7.x(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations Designer Repository Manager, Workflow Manager and Workflow Monitor).
• Experience in developing Informatica mappings, mapplets, sessions, workflows.
• Worked on tuning of Informatica mappings/sessions.
• Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and loading of data from multiple sources to Data Warehouse.
• Experience in developing Unix Scripts.
• Worked with every phase of Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Strong working experience in the Data Analysis, Design, Development, Implementation and testing of Data Warehousing using ETL tool Informatica power center.
• Excellent Working Knowledge on multiple Platforms like HP - UX, Windows 7 / XP
• Worked with heterogeneous databases like Oracle, DB2, SQL Server, MS-Access etc
• Good Experience with Business Users to analyze the business process and make necessary changes to schema objects to scatter their BI needs.
• Good communication and inter personal skills.

TECHNICAL SKILLS

Operating Systems: Windows 95/ 98/NT/2000, XP, UNIX, Sun Solaris

Languages: C, SQL, PL/SQL

Databases: DB2, MS-Access, Oracle, SQL, TOAD

Domain Knowledge: Health Insurance, Transport, Communications

ETL: Informatica Power Center

BI: Business Objects, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. ETL/Informatica Developer

Responsibilities:

• Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Analyzed business and systems specifications and developed logic flowcharts.
• Coordinated and worked with the offshore team for development and involved all phases from requirement gathering, design, development, testing and Production deployment.
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, and Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Implemented bulk load method with SQL Loader for loading history data to staging area.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Executed Multi load scripts for daily batch jobs.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Defined UNIX Batch scripts for automation of execution of Informatica workflows and used UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• Involved Working on Functional testing, Integration/ System testing, Regression testing and User Acceptance Testing.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Snapshot, Tables, Constraints, Views, Indexes, Sequences.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts and test cases for manual testing.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g/11g, UNIX, Shell Scripts, TOAD 10.6, Control-M 6.4, ERwin 7.3. HP Quality Center 10.0..

Confidential, Seattle, WA

ETL Developer

Responsibilities:

• Work closely with Plan team to analyze the requirements, perform gap analysis, and convert the business requirements to technical specification in from Informatica point of view
• Extracted data from wide variety of data Sources like Legacy Systems, Flat files, Relational Databases.
• Interacted actively with Business Users and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc
• Extensively used Re-usable Objects like Mapplets and Transformations in the Mappings.
• Worked with pmcmd to interact with Informatica Server from command mode.
• Created parameter files, mapping variables to enhance the ETL performance.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Develop and migrate code, track and support the projects in all project life cycle.
• Worked on ETL support issues extensively to fix the production issues.
• Tuned sources, targets, mappings and sessions to improve the performance of data load into SQL server database.
• Tested all Mappings, Sessions and Workflows for Data accuracy.
• Created deployment groups and deployed workflow from one environment to other.
• Worked with Backend testing, writing complex SQL queries to verify the transactions and business logic.
• Worked with some administration tasks like creating a user, assigning the privileges and creating integration services using admin console.
• Involved in implementing the Hot Fix 14 for the server and client and tested the application.
• Involved in testing the Informatica mappings using the test data and upgraded the QA Test Plans.
• Testing and validating the data on target data system and fixed the error codes on target data.

Environment: Informatica Power Center 8.6.1/9.x, Oracle 10g, SQL server 2005 &2008, PL/SQL, SQL*Plus, Windows NT, Unix Shell Scripting, Erwin 4.

Confidential, Portland, OR

Informatica Developer

Responsibilities:

• Worked withInformaticaPower Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Coordinated with Business system analyst (BSA) to understand and gather the requirements.
• Accordingly, Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Responsibilities included designing and developing complexInformaticamappings including Type-II slowly changing dimensions.
• Involved in writing the Technical Requirements Document, Mapping Documents, and Low Level Design Documents.
• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, and Sequence Generator, Stored Procedure, Expression, Filter and Rank transformations.
• The Mapping Designer module used for ETL tasks to upload the data from various centers with data in different source systems to build Data Marts.
• Created Informatica parameter files with workflows and sessions.
• Extensively used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables.
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance.
• Categorized different alerts and exception types to be built from User’s Data Validation list and built mappings to generate exceptions and alerts accordingly.
• Tested the target data against source system tables.
• Used Command task to move the parameter files to the desired position at the start of the session.
• Worked with pre-session and post-session sql and stored procedures
• Worked with Performance tuning of the Mappings, Sessions and SQL Queries Optimization.
• Coordination with OBIEE Team regarding the reporting data for Answers and BI Publisher reports and also for the Dashboard Designs.
• Involved in requesting input forms and creating log-in Windows for users to input the feeds.
• Performed Validations and Worked on Merqury Quality center tool for defect resolution.
• Performed Informatica Code Migration across environments.
• Documentation of ETL extracts developed using the Informatica extract tool.
• Created UNIX scripts for file transfers, to remove unwanted characters from source files, update the Time dimension table which was maintained for reporting purposes.
• Involved in maintaining the Data model, creating and granting the privileges for read and write operations
• Testing and validating the data on target data system and fixed the error codes on target data.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL server 2005, Teradata, Informatica power exchange, PL/SQL, SQL*Plus, TOAD, ERwin 4.0, Windows NT, Shell Scripting, HP UNIX 10.2.

Confidential

Informatica/ETL Consultant

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a STAR SCHEMA.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in creating and maintaining various database objects like SQL Joins, synonyms and aggregate conditions and worked on various databases and their connectivity from various parts of the Source Systems.
• Involved in extracting the data from the Flat Files and other RDMS databases into staging area and pro-actively involved in Storage of data.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment and development.
• Prepare DR plan and recovery process for GDW application.
• Monitoring all the environments regularly and provided 24x7 production support for Informatica/Hyperion.
• Create RTM, Document process and transfer knowledge.

Environment: Informatica Power Center 5.1, ETL, Oracle 9i, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, SQL Server 2000, Windows Server 2000.

Confidential

DW Informatica Developer

Responsibilities:

• Designed Parameter driven Informatica mappings and sessions for extracting, cleansing, transforming and loading the data from the Complex Flat Files into the data warehouse
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression
• Joiner, Sequence Generator, Router for creating complex business logic in ETL
• Developed logic using sequence generator transformation to replace missing keys and create unique keys
• Created worklets and workflows in the workflow manager to synchronize OLAP system with OLTP system with the logic to run set of tasks at the scheduled times
• Used Repository Manager to migrate Informatica mappings across the development, test and production environments
• Involved in extensive performance tuning by determining bottlenecks at targets, sources, mappings, sessions.
• Extensively used PL/SQL for creating views, stored procedure, and indexes on the tables.
• Involved in error checking and testing of ETL procedures and programs in Informatica session log.
• Developed Component documentation for every product designed.

Environment: Informatica 7.1, SQL Server 2005, IDQ, SQL Navigator, Visio, Windows XP, SunOS 5.6.