SUMMARY

• Software Engineer wif over 8 years of successful professional experience in development areas of Information Technology.
• Excellent Knowledge of Data Warehousing.
• Certified Informatica developer (Power Center)
• Expertise and experience in the following areas - ETL design, ETL Performance tuning.
• Extensive experience in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center 9.x/8.x/7.x/6.x in Windows and UNIX environment
• Developed complex mappings using Informatica Power Center Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Develop mappings using SalesForce-CRM Transformations in Informatica - Lookup, Self-lookup and various transformations available wif Informatica-SalesForce CRM plug-in.
• Experience in developing complex Mapplets, re-usable Tasks, re-usable mappings and Slowly Changing Dimensions technique (Type me, II, III using InformaticaPowerCenter).
• Used UNIX shell scripting, FTP, file management.
• Data modeling experience using Dimensional Data modelling, Star Schema & Snow Flake Schema, Fact & Dimension tables, Physical &logical data modeling.
• Good Knowledge on Dataintegration & Erwin tool.
• Good understanding of Business/Functional/technical requirements and compliance rules.
• Day-to-dayresponsibilitiesincludereviewingsystemdocumentation, identifyingdevelopmentobjectives, developing/updatingchangerequests, fixes, defects, andexecutingfunctionalandregressionInformatica batch testing.
• Experience in work allocation, status tracking and Coordinating wif teams to keep them focused on the deliverables
• Experience in functional, performance, integration, regression testing, Verification and Validations.
• Develop test cases from requirements, execute, raise defects and coordinate wif cross functional or off shore team and updating the defect status.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions and validations based on design specifications for unit testing, system testing.
• Effective communication and presentation skills
• Excellent problem solving skills wif a strong technical background and good interpersonal skills.
• Good Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS) and OLAP, ETL tools, product development and Reports Generation.
• Intelligent Gathering of Business requirements to map legacy and other sources to integrate into the Warehouse.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.X/8.X/7.x, (Repository Manager, Designer, Workflow Monitor, Workflow Manager), Informatica Power Exchange 8.x,DV0

Databases: Oracle 8i/9i/10g/11g, MS-Access,DB2, SQL Server 2008/2005/2000, Teradata

Operating Systems: Windows 95/98/2000/NT/XP, UNIX (Linux) and MS DOS.

Languages: SQL, PL/SQL,UNIX Shell, T-SQL, C/C++

Internet Technologies: HTML, DHTML, XML.

Other Tools: SQL*Loader, SQL *Plus, PL-SQL Developer

BI Tools: Cognos, Business Objects Xi r3.1/r2/6.5.1/5.1

Modeling Tools: Erwin, Visio, ER Studio

Scheduling Tools: Autosys, Control M.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Informatica Developer

Responsibilities:

• Worked wif Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Involved in creating Logical and Physical Data Models and creating Star Schema models.
• Assisted in designing Star Schema to design dimension and fact tables.
• Involved in developing star schema model for target database using ERWIN Data modeling
• Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
• Evaluates the integration of various data sources like Oracle, SAP BW, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies.
• Created Complex mappings using Unconnected and connected Lookups, Aggregator, Router, Filter and java transformations for populating target table in efficient manner.
• Created Informatica Power Center Mapplets for reusable business logic.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Informatica Power Exchange, in conjunction wif Power Center, to extract, transform and apply the Captured Change Data(CDC) to target tables or files
• Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applied data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ
• Used Informatica Data Explorer (IDE) to identify data duplication, understand the quality of data and report generation.
• Involved in migration of the maps from Informatica Data Quality (IDQ) to Informatica Power Center.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database
• Developed JIL script for the new Autosys jobs
• Worked on batch processing and file transfer protocols.
• Developed Informatica test case documents and specification documents wif standards to be followed across all the mappings
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica PowerCenter 9.1/9.6, PowerExchange, Informatica DataQuality (IDQ), PL/SQL, Oracle 11g, SQL Server, Teradata, SAP BW, Flat files, XML files, Windows Server 2003, UNIX, Autosys, ERWIN, Toad, Business Objects Xi r3.1.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Understanding client requirements by analyzing business/ETL requirements for initial load and sync of data into various objects of SalesForce application during team discussions.
• Analyzing object model of Sales Force.com
• Creating high/low-level ETL specifications and designing ETL components based on business requirements
• Development of Informatica Mappings to move and synch large amount of data into Salesforce.com
• Creating SQL Scripts based on the requirement.
• Scheduling of Informatica sessions for automation of loads.
• Providing time estimates for various tasks involved in design, development and unit-testing phases.
• Reviewing of tasks accomplished by team members and performing Code reviews.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations
• To implement the business logic and to load the data incrementally
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations
• Used various transformations like Filter, Expression, Sequence Generator, Updatestrategy.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process using Control M auto scheduling tool.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Developed UNIX shell scripts to move source files to archive directory.
• Used Informatica power connect to connect external Data bases.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Environment: Informatica Power Center 8.1.3, DataMart’s, Oracle 9i, Data Stage, SSIS, SQL *Loader, Windows 2000, DB2, Teradata, Sybase, MS VISIO, MS Access, SSRS, Cognos, UNIX, Putty, Control M.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Analysis of business data and ETL requirements.
• Analyzing the data model and ETL flow.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development of Informatica Mappings to load data into the Data Warehouse.
• Writing SQL Scripts based on the requirement.
• Scheduling of Informatica sessions for automation of loads.
• Performance tuning of long running programs in Informatica.
• Updating of ETL Specification, Test Case and Reporting Metadata Documents after testing in various environments (Development, QA and Production)
• Scheduling and monitoring team tasks.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Creating the functions and few rules for having a good data quality.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto data warehouse
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run wif the logic embedded in the mappings.
• Involved in Migration of mappings, sessions, worklets & workflows from Informatica 7.1 to Informatica 8.1

Environment: Informatica Power Center 8.6, Informatica PowerExchange, Oracle 11g, PL/SQL, SQL Server, Sybase, DB2, Teradata 13.10, XML files, Clear Case, Erwin, Micro strategy 9.3.0, Windows, WinSCP, UNIX.

Confidential, Bowie, MD

Informatica Developer

Responsibilities:

• Analysis of business data and ETL requirements.
• Analyzing the data model and ETL flow.
• Delegation of developmental tasks among the onshore and offshore team members.
• Analyzing the data model and ETL flow.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development of Informatica Mappings to load data into the Data Warehouse.
• Writing SQL scripts based on the requirement.
• Scheduling of Informatica sessions for automation of loads.
• Performance tuning of long running programs in Informatica.
• Review of tasks accomplished by team members.
• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL Solution using Informatica.
• Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
• Created data maps for Mainframes sources and Targets using Power Exchange
• Extensively used ETL to load data from wide range of source such as flat files, XML to Oracle
• Extensively used PL/SQL Procedures/Functions to build business rules.

Environment: Informatica Power Center 8.1.3, DataMart’s, Oracle 9i, Data Stage, SSIS, SQL *Loader, Windows 2000, DB2, Teradata, Sybase, MS VISIO, MS Access, SSRS, Cognos, UNIX, Putty, Control M.

Confidential

ETL Informatica Developer

Responsibilities:

• Analysis of business data and ETL requirements
• Developing various kinds of mappings using various transformations like Aggregator, Filter, Expression, Lookup, Update strategy, etc
• Optimizing the mapping to load the data in slowly changing dimension.
• Performance tuning of the mappings
• Checking the output wif the given specifications.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Involved in designing the procedures for getting the data from Flat files, Databases to Data Warehousing system.
• Created mappings wif PL/SQL procedures/functions to build business rules to load data.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Creating and running sessions and batches to load the data into the Target Database.

Environment: Informatica PowerCenter 7.1.3, PowerMart 5.0, SSIS, Teradata, Metadata Manager, UNIX, SQL Server, Flat Files, SQL Loader, MDX, Windows XP, Linux, Putty, WinSCP, Autosys

Confidential

ETL Developer

Responsibilities:

• Analysis of business data and ETL requirements
• Developing various kinds of mappings using various transformations like Aggregator, Filter, Expression, Lookup, Update strategy, etc
• Optimizing the mapping to load the data in slowly changing dimension.
• Performance tuning of the mappings
• Checking the output wif the given specifications.
• Prepare Business Test Cases and document Test Results for Business Cycles covering Procure to Pay and Order to Cash.
• Create Help Desk Calls and close them by providing solutions to the issues.
• Coordinate wif End Users and Oracle as and when required.
• Create Technical Assistance Request in Oracle Metalink when the support team cannot resolve issues.

Environment: Informatica Power Center 8.1.3, DataMart’s, Oracle 9i, Data Stage, SSIS, SQL *Loader, Windows 2000, DB2, Teradata, Sybase, MS VISIO, MS Access, SSRS, Cognos, UNIX, Putty, Control M.