SUMMARY

• Around 7+ years of total IT experience in Software Application Development, Maintenance, Enhancements, Support, Testing, Reverse Engineering encompassing a wide range of skill set roles and responsibilities.
• 7+ years of experience in ETL using Informatica Power Center 9.1/8.6
• Expert in providing high level design and low level design for the business requirements
• Expert in Data Warehousing, Data Mining, Enterprise Data Integration, Data Management and Governance & Real Time Data Analytics.
• Ability to manage multiple projects simultaneously and meet project deadlines. With exposure to all phases of data warehousing life cycle.
• Working Experience under Data Migration and Data Integration projects.
• Extensively worked in designing and developing complex ETL mappings using Informatica Power Center 9.1/8.6/8.1/7.1 ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.1/8.6/8.1/7.1 (Repository Manager, Designer, Workflow manager, Workflow Monitor)
• Experience in Performance Tuning of sources, targets, sessions and existing mappings, identifying and resolving performance bottlenecks at various stages.
• Worked extensively for writing SQL, PL/SQL queries and stored procedures in Oracle/Teradata.
• Experience in development of UNIX shell scripts for pre - processing data, automation of job scheduling and scheduling Workflows.
• Experience in production support activities and batch maintenance.
• Experience in RDBMS concepts such as Teradata 14/13, DB2, Oracle 11g/10g/9i, PL/SQL, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.1/8.6/8.1/7.1 , Designer, Repository Manager, Workflow Manager & Workflow Monitor

DBMS: Oracle 11g/10g/9i, Teradata 14/13,DB 2 9.5/9.1/8.1

Programming Languages: Unix Shell Scripting, PL/SQL, XML

Other tools: Toad for Oracle, Toad for DB2, Putty, Filezilla FTP client

Scheduling tools: ESP Scheduler, Tivoli Maestro Scheduler

Domain knowledge: Healthcare, Financial, Insurance and Telecom

Operating System: UNIX, AIX, Windows 7/XP/2003

PROFESSIONAL EXPERIENCE

Confidential, FL

Senior Application Developer

Responsibilities:

• Working with Data Analysts to understand the requirements
• Worked with the project leads/SMEs in analyzing system requirements and specifications and translating those requirements into ETL designs.
• Provide technical leadership to other members of the development team and project managers in a positive manner to deliver on-time and above standard applications.
• Participating in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated and lead research and development efforts (proof of concept, prototypes), as subject matter experts, with new technologies.
• Implementing ETL standards and Best Practices while naming Maps and processes.
• Creating Workflows and used various tasks like Email, Control, Decision and Session in the workflow manager.
• Worked on Data Migration Project to add new source of feed to Data Warehouse.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, normalizer and sequence generator.
• Exposure to Teradata utilities for MLOAD, Fast Load, MultiLoad, Fast Export. Understanding of the Teradata Parallel Transporter.
• Working with Informatica Power Center client tools like Source Analyzer, Warehouse Designer and Mapping designer.
• Developed new ETL mappings according to the requirements using Informatica PowerCenter9.1
• Involved in creating Workflows, Worklets and Configured Sessions, Debugging code, testing and validated data after processes are run in development according to business Rules.
• Assisted QA Team to fix and find solutions for the production issues.
• Working closely with all team members to resolve the technical issues and business related questions.
• Involved in automating the Informatica process by using Unix Shell Script.

Environment: Informatica Power Center 9.5, Teradata 14, Unix

Confidential, Fort Wayne, IN .

Application Developer

Responsibilities:

• Responsible for Monitoring and tracking the critical daily applications
• Responsible for closing user tickets and incidents.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Responsible for requirements gathering from the Business users.
• Responsible for reloads of Informatica applications data in production.
• Responsible for fixing Informatica workflow failures.
• Worked on Performance tuning of Informatica designs and mappings.
• Worked on Data Integration project so as to provide unified view of the data. The data loads will update OLTP Database.
• Worked on Informatica upgrade from 8.6 to 9.1
• Extensively developed Low level Designs (Mapping Documents) by understanding different source systems.
• Developed complex Informatica mappings, sessions and workflows.
• Preparation of impact analysis based on data analysis of source and target systems.
• Generated completion messages and status reports using Workflow Manager.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, normalizer and sequence generator.
• Created reusable mapplets and reusable transformations.
• Created and performed Unit tests over Informatica code.
• Responsible for providing daily status report for all Informatica applications to customer.

Environment: Informatica Power Center 9.1, Oracle 10g, Teradata 13, IBM DB2 V8x, UNIX, Windows XP.

Confidential, Rochester, Minnesota

Informatica Consultant

Responsibilities:

• Designed and developed the data transformations for source system data extraction, data staging, movement and aggregation, information and analytics delivery and data quality handling, system testing and performance tuning.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, and Look up, Update Strategy, Sequence Generator, Rank, and Aggregator transformation.
• Worked on Dimensional modeling to design and develop STAR schemas, Identifying Fact and Dimension Tables.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager. Extensively worked with Power Connect to import sources from external systems like ERP.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Responsible for performance tuning on targets, sources, mappings and sessions to get maximum efficiency. Extensively used Informatica debugger to resolve the issues.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Implemented effective date range mapping (Slowly Changing dimension type) methodology for accessing the full history of accounts and transaction information.
• Developed SQL/PLSQL scripts for Automated testing by the testing system. Created partitions and SQL Override in source qualifier for better performance.
• Translation of Business processes into Informatica mappings for building Data marts.
• Performed job scheduling using UNIX CRON and AUTOSYS.

Environment: Informatica PowerCenter 7.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Oracle 10g, Business Objects 6.x, SQL Server, UNIX, Windows NT, TOAD, Autosys, ER-win 4.0, Netezza

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database. Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Supporting (includes Development & Support) all AREVA T&D applications which uses Informatica to migrate data to/from SAP, CRM (Sales force), XML file, AREVA T&D DWH (using files/tables)
• Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse. Updated the table without using Update Strategy improving session performance
• Worked on different tasks in Workflow Manager like Sessions, Decision, E-mail, Command, Worklets .Used sending attachment functionality to the user using session post email property.

Environment: Informatica Power Center 7.0 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 10g, TOAD, UNIX, Flat Files, Citrix, Filezilla