SUMMARY

• Seven years of experience in the design, development and testing of Data Warehousing applications involving ETL Tools like - Informatica Power Center 9.1/9.0/8.6.
• Extensive experience with ETL tool Informatica in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets and scheduling Workflows, Sessions.
• Expertise in Data Modeling, Business Process Analysis, post production support, debugging and performance tuning of sources, targets, mappings, sessions and SQL’s.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Expertise in creating mapplets and reusable transformations in Informatica.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Migrating data mapping to production and monitoring, troubleshooting and restarting batch processes using Informatica Power Center.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Netezza Relational Tables and xml targets.
• Developed Slowly Changing Dimension Mappings of type I, type II and type III.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Worked with PMCMD to schedule the Informatica jobs using basic UNIX Shell Scripting.
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.
• Excellent in project management, presentation, organization and mentoring skills with proven ability in business analysis, applications programming and trouble shooting.
• Worked under extremely tight deadlines.
• Experienced in working with Windows Vista/XP/2000/NT/98/2K /2003 servers/Unix Operating Systems.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.1/9.X/8.6.1/8.X and IDQ 8.6

Languages: C, C++, SQL, PL/SQL

Scripting Languages: UNIX shells scripting

Databases: Oracle 11g/10g, Microsoft SQL Server 2008, NETEZZA

Scheduling Tools: AutoSys

Data Modeling: ERWIN 4.5, Data Mart

Methodologies: Star Schema, Dimensional modeling, SCD tables

Reporting Tools: Business objects XI R2

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

Database Utilities/ Other tools: TOAD, SQL Developer, SQL * Plus, SQL loader

PROFESSIONAL EXPERIENCE

Confidential, Harleysville, PA

Sr Informatica Developer

RESPONSIBILITIES:

• Worked on the complete project lifecycle.
• Reported directly to the Director of IT Operations.
• Coordinated efforts within the company to align development, QA etc.
• Coordinated effort between Confidential, parent company Nationwide Insurance and third party LexisNexis.
• Worked to Business Analysts and Data communication team at LexisNexis to formulate project specifications and determine requirements and availability of data.
• Worked extensively with flat-files and SQL sources.
• Interacted with Architects and DBA’s to determine a sustainable source for data contribution.
• Developed almost all SQL queries and Informatica mappings for the project.
• Used most transformations such as SQ, Aggregator, Joiner, Expressions etc.
• Worked on logic to extract missing data from different sources if it was needed in the final contribution file.
• Wrote logic to parse and transform hundreds of fields into specified formats.
• Documented all new processes, known issues and information for knowledge transfer and maintenance.
• Identified process bottlenecks and implemented performance tuning at mapping and session levels and SQL query level.
• Worked independently on unit testing and worked with QA for data validation.
• Worked with two data communication teams within Harleysville and Nationwide to formulate method of delivery to of flat files to LexisNexis and return of error logs to Harleysville.
• Conducted status meeting and technical discussions with various stakeholders.

ENVIRONMENT: Informatica PowerCenter 9.1, SQL Server 2008, Microsoft SQL Server Management, UNIX Shell Scripting, TOAD, TFS, Flat Files, Microsoft Windows 7, Visual Basic

Confidential, Richmond, VA

Sr ETL Informatica Developer

RESPONSIBILITIES:

• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Extensively used Informatica Client tools - Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Netezza Relational Tables and xml targets.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Developed PL/SQL scripts and stored procedures for database updates and to create the necessary indexes in the target tables.
• Good experience working with SQL in extracting the data from source systems and loading the data onto the target tables.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Experienced in Troubleshooting and Performance Tuning of sessions.
• Experience in ETL design documentation, reviewing designs and mappings to ensure compliance to standards and processes.

ENVIRONMENT: Informatica Power Center 9.1, 9.x, Flat Files, Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer, Windows XP, SQL Server 2008, Netezza, Unix.

Confidential, CHICAGO, IL

Informatica Consultant

RESPONSIBILITIES:

• Analysis of the specifications.
• Work with JDA technical SME's and BI tech lead to understand ETL needs.
• Drive / lead complete SDLC for the ETL development effort for sourcing data from JDA Oracle database into Teradata EDW for BI reporting.
• Extracting Data from source to target using Informatica Mappings.
• Transforming the data from flat files to oracle database using SQL Loader
• Writing of PL/SQL triggers, procedures and packages.
• Involved in creating and designing mappings and mapplets using Informatica Source analyzer, Target designer, Transformation designer and Mapplet designer
• Created and developed numerous mappings using Expression, Router, Joiner, Lookup, Update Strategy, Stored Procedure and other transformations.
• Database Performance tuning.
• Worked on different active and passive transformations and involved in generating, modifying and processing the data
• Designing and Development of multi dimensional Star Schema
• Data Quality Analysis to determine cleansing requirements
• Preparing Source to Target mappings document.
• Created different parameter files and started sessions using these parameter files. Session parameters, mapping parameters, and variables are changed at run time.
• Tuning the performance of mappings and sessions.
• Involved in Scheduling the ETL Jobs
• Involved in Unit Testing.

ENVIRONMENT: Informatica 9.0, MS SQL Server, Oracle 10g, TOAD, Business Objects XI R2, Shell Scripts.

Confidential

Software Engineer

RESPONSIBILITES:

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Created new mappings and updated old mappings according to changes in Business logic.
• Used ETL (Informatica) to load data from sources like Oracle database and Flat Files.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status. Used Debugger to troubleshoot the mappings
• Developed mappings using different transformations. Created various Mapplets in designer using Informatica Power Center Mapplet Designer.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in Unit and System testing of developed mapping.
• Optimizing Query Performance, Session Performance.
• Defined Target Load Order Plan for loading data into Target Tables.
• Involved in creating desktop intelligence and web intelligence reports.

ENVIRONMENT: Informatica Power Center 8.X, Windows NT, PL/SQL, Excel, SQL Server 2000, Erwin.

Confidential

Oracle Developer

Responsibilities:

• Developed Procedures, functions, packages and Triggers for enforcing the business rules using PL/SQL.
• Designed the user interface screens using Oracle Forms 4.5 and generated reports using D2K reports 2.5.
• Developed Program Libraries for storing of Procedures that were used frequently in the System and user security package, integration and user acceptance testing. Prepared technical documentation and user specifications.
• Involved in creation of Schema Objects like indexes views, and stored procedures. Involved in the Analysis of how the purchase order process is organized.
• Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Identifying integrity constraints for tables.
• Involved in writing the Triggers which internally calls procedures and functions.
• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Involved in documenting the entire process.
• Involved in Implementation and Testing phases of the system.

ENVIRONMENT: Windows 98, UNIX, Oracle 8.X, PL/SQL, SQL *Plus Reporting, SQL *Loader, Forms & Reports, LINUX