SUMMARY

• Over 8 years of IT experience Design, Development, Implementation and Maintenance of Data warehouse applications as Developer.
• Experience in designing, development and support of data warehouse applications using Informatica Power Center 9.x/8.x/ 7.x and knowledge of IDQ.
• Basic Informatica administration such as creating users, privileges, optimizing server settings, bring up the services that are down, deployment groups, creating folders, etc.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, COBOL files, VSAM, IBM DB2 UDB, Excel, Oracle, Sybase, MS SQL Server, Netezza and Teradata.
• Strong knowledge in RDBMS concepts such as indexes, procedures, PL/SQL blocks, views, materialized views, cursors, triggers, table partitioning, database partitioning, etc.
• Experience in Performance tuning ETL processes at the mappings, sessions and database level.
• Extensive domain knowledge in Banking, Insurance, Health care, Payroll and Financial.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling, Slowly Changing Dimensions and data ware housing concepts.
• Experience in using teradata load utilities (FASTLOAD, MULTILOAD and TPUMP) to load huge volumes of data to teradata RDBMS. Used BTEQ scripts.
• Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schemas.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, designing various mappings, developing mappings, unit testing, integration testing, regression testing and UAT in development.
• Experience in Scheduling the Scripts using Autosys Scheduler.
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
• Extensive experience in UNIX shell scripting (Ksh/Csh), Job scheduling.
• Exceptional problem solving and sound decision making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.
• As a team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Erwin 7.2/4.0,Normalization, De-normalization and MS Visio

Databases: Oracle 11g,10g/9i, MS SQL Server 2008/2005/2000 , MS Access, IBM DB2, Teradata, Sybase, Netezza, etc.

Programming: SQL, PL/SQL, C, C++, SQL*Loader, Unix, HTML

Other Tools: SQL Developer, SQL*Plus, TOAD, Excel, Word, TIDAL, Autosys, Apeex data loader, SQL assistant, etc.

Operating Systems: UNIX, Windows (XP, NT/ 95/98/2000/2003 ).

Reporting Tools: MS SQL Server Reporting services 2005/2008, Business Objects XI, OBIEE, etc.

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Designed Sources to Targets mapping from primarily Flat files to target databases using Informatica Power Center.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Used transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Stored Procedure, Sequence Generator and Joiner extensively to create complex mappings and mapplets.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed and developed reusable Transformations for ETL using Informatica Power Center.
• Worked on data profiling using Trillium, and identified various types of issues in data
• Created various documents including high-level design documents, mapping documents and knowledge transfer documents.
• Extensively used PL/SQL procedures for balancing tables.
• Designed and implemented Exception Remediation process for handling error records coming from the source
• Identified process bottlenecks and implemented performance tuning at mapping and session levels
• Worked with DBAs to make the daily loads run much faster by tuning different aspects of the load jobs
• Used Debugger to troubleshoot cause of failures, invalid results, if any, after running a process.
• Wrote complex SQL queries in order to perform unit testing for validating output data.
• Worked with Autosys team to implement real-time scheduling for transactional ETL processes designed for batch loading.
• Worked with QA team to find and fix bugs in mappings.
• Used versioning and labeling options in power center to keep track of mapping and workflow changes and used deployment groups to deploy changes from one environment to another.
• Developed mappings for other Informatica ETL based projects.
• Performed knowledge transfer to the production support team.

Environment: Informatica Power Center 9.1/8.6, oracle 11g, TOAD, Windows, Erwin, Autosys,Oracle 11g, SQL server 2005/2008.

Confidential

Sr. Informatica Consultant/DW Core Support

Responsibilities:

• Responsible for activities related to the development, support, implementation of ETL processes for large scale data warehouse using Informatica Power Center.
• Involved in on-site Production Support and change management team and was responsible for smooth onshore-offshore co-ordination, change/release management, user interaction and production support.
• Worked on Informatica DVO (Data Validation Option) tool is used to compare the data before and after the Informatica upgrade.
• Acted as a mentor to for junior developers on Informatica and guiding the project’s use of ‘Best Practices’ for Informatica and ETL processes
• WrotePL/SQL, shell, SQL, and Informaticascripts as needed.
• Created shell scripts and updated the scripts as per the requirement, Developed them for inbound and outbound of the data on servers.
• Worked on time to time enhancements, bug fixes, performance tuning of the existing mappings.
• Maintained large data sets, combined data from various sources in varying formats to createSAS data sets and/or ASCII files.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Implemented various ad-hoc requests based on the business requirement using ETL and making the necessary changes to the OLAP report queries using OBIEE.
• Responsible in conducting weekly status meetings with the client in absence of manager.
• Provided 24/7 production support.
• Created Master Data hub to support reporting needs.

Environment: Informatica Power Center 8.1/8.6, Red Hat Enterprise Linux Server release 5.3, Oracle 10g, SQL server 2005/2008, TOAD, SAS 9.2, OBIEE 10.1, and DVO Client.

Confidential

Informatica Developer

Responsibilities:

• Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator etc.
• Extensively used Xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as our main source type was XML Files.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Extensively utilized the Debugger utility to test the mappings.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Worked on Power Exchange Change Data Capture has been done for data updates.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.
• Defined Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Validated XSD using XML Spy.
• Used CONTROL M Tool to schedule Informatica jobs
• Extracted data from Sybase source system and loaded into Teradata Data Mart.
• Experience in using Teradata load utilities (FASTLOAD, MULTILOAD and TPUMP) to load huge volumes of data to Teradata RDBMS.

Environment: Informatica Power Center 8.1/8.6, Power Exchange, Oracle 10g, Linux, UNIX Sell Scripting, Windows XP, Sybase, Aqua Studio, Teradata.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in Business Analysis and requirement gathering.
• Designed the mappings between sources to operational staging targets.
• Used Informatica Power Center as an ETL tool for building the data warehouse.
• Employed the Aggregator, Sequencer and Joiner transformations in the population of the data.
• Data transformed from SQL Server databases and loaded into an Oracle database.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 7.3, SQL Server 7.0, Oracle 10g

Confidential

Informatica Developer

Responsibilities:

• Gathered business scope and technical requirements
• Implemented Star Schema and Snow Flake schema for the data warehouse.
• Designing and development of data warehouse environment.
• Translated Business processes into Informatica Mappings for building Data marts.
• Importing various Sources, Targets, and Transformations using Informatica Power Center
• Responsible for Logical & Physical modeling as per business requirements.
• Developed various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Stored procedure Transformations, Expressions and Sequence Generator for loading the data into target Data Mart.
• Modified the existing mappings and created the new ones based on specification documents.
• Usage of Aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensive.
• Developed various reusable transformations using the Transformation Developer in the Informatica Power Center Designer.
• Implemented the Slowly Changing Dimensions as per the requirement.
• Debugging & Performance Tuning of the Informatica mappings and sessions.
• Tuned the Session Parameters to increase the efficiency of the sessions in Workflow Manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, PL/SQL, Autosys