PROFESSIONAL SUMMARY:

• With 7+ years of extensive IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems.
• Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Physical and Logical Data Modeling, Dimensions, Facts and Star, Snow flake Schemas.
• Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers.
• Experience in integration of various data sources like Oracle, SQL Server, Teradata, DB2, XML and Flat files into staging area.
• Extensively worked on Informatica Client Tools - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer, Task Developer, Workflow Monitor.
• Vast experience in designing and developing complex mappings from varied transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Normalizer etc.
• Expertise in Query Analyzing, performance tuning of Informatica mappings.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Performed data validation by Unit testing, integration testing and System Testing.
• Experience in administering Informatica server activities like creating, scheduling and managing sessions.
• Created UNIX scripts for parsing and modifying data and experience in using AUTOSYS/ CONTROL M job scheduler for automation of UNIX shell scripts and batch scheduling.
• Excellent interpersonal and communication skills and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Good Project Coordination skills, onsite coordination and offshore team management.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1, 8.6.1/8.5/8.1.1, Informatica Power Exchange 9.5,Informatica Power Connect

Databases: Oracle 11i/10g/9i/8i, SQL Server 2008 R 2/2008/2005/2000, Teradata, Sybase, DB2

Languages: SQL, T-SQL, PL/SQL, C, UNIX Shell Scripting.

Operating Systems: UNIX, Windows 7/VISTA/XP/2003, Linux, HP-UNIX, IBM AIX.

Business Intelligence Tools: Cognos Report Studio, SSRS.

Scheduling Tools: Autosys, Control-M.

DB Tools: SQL Server Management Studio, TOAD, SQL Navigator, SQL *Plus, SQL * Loader, RedGate SQL Dependency Tracker

Data Modeling Tools: Erwin 4.5

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with Business Analyst Team to gather business requirements.
• Study the relation at the source systems and Perform Data Analysis of various data source systems.
• Generate XML files defining dependencies between objects of different databases using Red Gate SQL Dependency Tracker Software.
• Designed data models and created tables and other objects as per the data models.
• Generated Cognos reports in XML format from Cognos Report Studio.
• Converted SSRS Report Definition Language (RDL) reports to XML files and loaded them into staging area.
• Performed design and development of Informatica mappings.
• Data Migration from various source systems like Flat files and XML files and loaded them into SQL Server databases for easy access of the data to business users.
• Extensively used transformations like Expression, Router, Joiner, Aggregator, Look up, Filter and Update Strategy.
• Fined tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance.
• Used debugger to test the mapping and fixed the bugs.
• Effective implementation of Mapping/Session/Workflow Parameters and Variables in mappings and workflows.
• Implemented Pre-Session and Post-Sessions Processes.
• Use DOS Commands/Scripts for automation of RDL to XML file conversion before session run.
• Optimize performance of Informatica sessions and SQL queries.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Implemented effective strategy for error handling.
• Performed Unit testing and Code review.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better performance.
• Documented designed data Models and SQL queries for ease of access to business analyst team.

Environment: Informatica Power Center 9.5, SQL Server 2008 R2,Redgate Dependency Tracker, Cognos Report Studio, SQL server Management Studio,.

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with Business Analyst Team to gather business requirements.
• Study the relation at the source systems.
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Worked with SAP team coordinating with SAP programs and Interfaces.
• Involved in design and development reviews of Informatica.
• Extracted data from different data sources like SQL Server, Flat files and loaded them into staging and into SAP.
• Extensively used transformations like Expression, Router, Joiner, Aggregator, Look up, Filter and Update Strategy.
• Used Application SQ and SAP BAPI transformation to load data into SAP system, using Informatica Power Exchange.
• Updated data in tables in accordance with SAP system based on Informatica Error logs and SAP error messages.
• Designed, Developed and implemented data reconciliation logic.
• Fined tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance
• Used Parameters and Variables in mappings and workflows.
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Perform QA and Code review for my code and other developer’s code.
• Optimized the performance of Informatica sessions and SQL queries.
• Maintained coding standard document, Technical document and Code review Documents.
• Authored the Informatica coding standard document.
• Authored the Unit testing and Code Review standard documents.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.5, SQL Server 2008 R2, SQL, XML, Flat Files, SQL server Management Studio, TOAD 9.6, SAP logon.

Confidential

Sr. Informatica Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Worked with Data architect team and involved in data modeling, according to changes in the model worked on changes in the Informatica.
• Designed and developed Informatica Mappings based on the business requirements.
• Extracted Data from different Source Systems like SQL Server, Oracle database, Fixed Width and DelimitedFlat files and XML files.
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used various transformations like Source Qualifier, Router, Normalizer, Expression, lookup, and Filter.
• Performed Data Transformations using joiner, Aggregator, Update strategy and used XML Source Qualifier for handling XML data.
• Used mapping parameters and variables.
• Creating sessions, worklets and workflows for carrying out test loads.
• Used Pre/Post Session commands extensively using DOS commands/scripts.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Implemented effective strategy for error handling.
• Designed/Created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis.
• Performed the performance evaluation of the ETLs for full load cycle.
• Responsible for Unit testing, System testing.
• Created test cases for carrying out unit testing and part of functional testing.
• Experienced in optimizing the SQL queries to improve the performance.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting.
• Translated the business processes into Informatica mappings for building the ODS.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better performance.

Environment: Informatica Power Center 9.5, SQL Server 2008 R2, Oracle, UNIX Shell Scripting, SQL, PL/SQL, XML, Flat Files, Microsoft SQL server Management Studio, TOAD 9.6, Autosys.

Confidential

Sr. Informatica Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements.
• Extracted Data from different Source Systems like Oracle, SQL Server and Flat files.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different types of transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer.
• Performed Data Transformations using joiner, Aggregator, Update strategy.
• Used mapping parameters and variables.
• Creating sessions, worklets and workflows for carrying out test loads.
• Created the Deployment groups to move the workflows from one environment to the other.
• Designed/Created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis.
• Performed the performance evaluation of the ETLs for full load cycle.
• Use of Agile methods within my team, implementing code versioning and improving documentation.
• Responsible for Unit testing, system and integration testing.
• Experienced in optimizing the SQL queries to improve the performance.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better performance. Used Autosys to schedule session runs.
• Created test cases for carrying out unit testing and part of functional testing.

Environment: Informatica Power Center 9.1/8.6, Oracle 11i/10g, SQL Server 2008, Sybase 11.0, Teradata, UNIX Shell Scripting, SQL, PL/SQL, XML, Flat Files, TOAD 9.6, SQL Loader, Autosys.

Confidential, Pleasanton, CA

Informatica Developer

Responsibilities:

• Analyzed source data and involved in gathering business requirements from the end users.
• Informatica Power Center is used to extract, transform and load data from different Operational data sources like Oracle, DB2 and flat file.
• Coordinating with source systems owners and involved in day-to-day ETL progress monitoring. Also involved in Data warehouse Target schema design (star schema) and maintenance.
• Worked on delimited flat file sources.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database Using e.g. Source Qualifier, Joiner Transformation, Update Strategy, Lookup Transformation, Rank transformation, Expressions, Aggregator, and Sequence Generator.
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations and Mapplets confirming to the business rules.
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email.
• Data Enhancements and deliverables done to QA Environment Successfully.
• Automated Informatica flow of loading data by using Autosys scheduler.
• Followed Software Development Life Cycle process.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Designed reusable transformations and Mapplets to be re used with various mappings.
• Performing Unit, Integration and Regression testing and preparing Test Cases for the same.
• Defined roles and responsibilities within the team and reviewing deliverables.

Environment: Informatica Power Center 8.5 (Repository Manager, Designer Tools like Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow Manager, Workflow Monitor), DB2 8.0, Oracle 10g, SQL, UNIX Shell Scripting, Autosys.

Confidential

ETL Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in Logical and Physical Data Modeling (relational and multi-dimensional) using ERWIN
• Developed end-to-end ETL processes for Trade Management Data Mart Using Informatica.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Used Joiner, Aggregator, Expression, Router, Sequence Generator, Update Strategy and Lookup Transformation to manipulate data related to customers.
• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Developed and tested all the Informatica Data mappings, sessions and workflows involving several Tasks.
• Analyzed various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.

Environment: Informatica Power Center 8.1.1/7.1, Power Exchange, Erwin, Oracle 9i, DB2, XML,SQL, TSQL, MS SQL Server 2005, Toad, Teradata, UNIX.

Confidential

ETL Developer

Responsibilities:

• As a part of 3-member team, was involved in design, development and Implementation of the module.
• Worked with ETL tool Informatica to create mappings and workflows and Transformations.
• Configured Repository Manager, created folders and managed objects in repository Manager for Informatica.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Used Filter, Router, Aggregator, Lookup, Expression and Update Strategy transformations whenever required in the mapping.
• Involved in creation of sessions and scheduling of sessions.
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.
• Improved the performance of long running jobs by updating the SQL statements and creating indexes.

Environment: Oracle8i, Informatica 6.1(Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow designer, Workflow Monitor) windows XP, SQL.