SUMMARY

• Over 8 years of work experience in Information Technology asInformatica Developer with strong background in ETLData warehousing, ETLDesign, Databases and Master Data Management using InformaticaPower Center 9.x,8.x/ 7.x.
• Excellent knowledge on Business Analysis, Data Analysis, requirement gathering and creating Business Requirement Documents and Technical Specification Documents.
• Strong experience in Extraction, Transformation, Loading(ETL) data from various sources into Data Warehouses and Data Marts using InformaticaPowerCenter - Repository Manager, Designer, Workflow Manager, Workflow Monitor.
• Extensively worked on InformaticaDesigner Components - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer.
• Hands-on experience on using various transformations such as Expression, Filter, Router, Sorter, Union, Update Strategy, Aggregator, Sequence Generator, Joiner, Connected and Unconnected Lookup and so on.
• Good knowledge on advanced transformations such as Data Masking, Transaction Control, Connected and Unconnected Stored Procedures.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Expertise in OLTP/OLAP system analysis and strong skills on relational and Dimensional Data Modeling.
• Worked broadly with Slowly Changing Dimensions (SCD).
• Worked on target load order plan, pushdown optimization, constraint based loading and created mapplets and worklets when needed.
• Experience in Star schema, Snowflake schema, and excellent knowledge on Kimball and Inmon methodologies.
• Strong experience working with different RDBMS like Oracle, SQL Server, Teradata, DB2 and with different file systems like Flat Files and XML files both as Source and as well Target.
• Created Windows/UNIX scripts to run the Informaticaworkflows using PMCMD command and controlling the ETLflow.
• Extensively worked with Informaticaperformance tuning involving source level, target level and mapping level bottlenecks.
• Have good problem-solving, time management and communication skills and ability to work independently and cooperatively in a team and always open to learn new technologies and ideas from different team members/projects.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.1/8. x, Informatica Power Exchange 9.5.1, Informatica Data Quality 9.5(Developer, Analyst)

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

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

Operating Systems: UNIX, Windows 2000/2003/NT/XP, Linux, Sun Solaris, HP-UNIX, IBM AIX.

Business Intelligence Tools: COGNOS, Business Objects (BO).

DB Tools: TOAD, SQL * Plus, PL/SQL Developer, SQL * Loader, Fast Load. M Load

Web Technologies: HTML, XML

Data Modeling Tools: Erwin, Embcadero Studio

Other Tools: HP Quality center, WIN SCP, JIRA, MS-Office, Autosys, Tidal.

PROFESSIONAL EXPERIENCE

Confidential, Dearborn city, Michigan

Sr. Informatica ETL Developer

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Cleanse and Scrub the Data in uniform data type and format applyingMDMInformatica and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Primary activities include data analysis identifying and implementing data quality rules and finally linking rules includingAddress Doctorto Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
• Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.
• Created Queries Query Groups and packages in MDM Hub Console.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Analyzing / building Teradata EDW using Teradata ETL utilities and Informatica.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 9.1, PL/SQL, Oracle 11g, Erwin, Autosys, ERP, Ultra Edit, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos9.

Confidential, TEXAS

Sr. Informatica ETL Developer

Responsibilities:

• Created analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Extensively used Autosys for Scheduling and monitoring.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Responsible for Data quality analysis to determine cleansing requirements.
• Worked with several facets of the Informatica Power Center tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Responsible for team members' work assignment and tracking.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g/10g, DB2 7.1, SQL Server, UNIX (Sun Solaris5.8/AIX), Toad 10.0, SQL Developer 3.0, WinSCP, Putty, SFTP/FTP, XML Editor, MS-Excel, Ms-Access.

Confidential, AZ

ETL Developer

Responsibilities:

• Gathered business requirements, established functional specifications, translated them to design specifications.
• Data conversionsfrom different legacy systemsin accordance with thebusiness rules into the Oracle Application system.
• Worked closely with SME’s to convert the legacy data for assigned modules.
• Worked independently and in a team toconvert Item Costs, Price Lists, Quantity On-Hand and Sourcing rules and Assignment sets from various systems into the Oracle EBS interface tables.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, Mapplets, transformations, re-usable transformations.
• Written Complex SQL overrides for source qualifier and Lookups in mappings.
• Designed and developed validation scripts based on business rules to check the Quality of data loaded into EBS.
• Written ETL specifications for all the development tasks, to better evolve the ETL design.
• Worked with various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Used Informatica power center to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Build efficientSSISpackages for processing fact and dimension tableswithcomplex transforms and type1and type 2 changes.
• Performance tuning to ensure optimal session performance.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Used Erwin for data modeling and Dimensional Data Modeling.
• Designed and created logical & physical data models to support strategic business decisions.
• Designed, Developed, Reengineered and fine-tuned SQL queries and Oracle Stored Procedures and triggers.
• Involved in Designing data models for Data warehouse supporting data from multiple sources on real time.
• Worked with Netezza database to implement data cleanup, performance tuning techniques.

Environment: Informatica 8.5(Repository Manager, Repository Server Administration Console, Power Center Designer, Workflow Manager, Workflow Monitor), Power Analyzer 4.1, Erwin 4.0, COBOL, Oracle 10g, PL/SQL, Autosys, Windows 2000, DB2, Windows NT 4.0

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in analyzing the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Developed complex mapping using Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Update strategy.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance ofInformaticaSession by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Defined Target Load Order Plan for loading data into Target Tables.
• Implemented Slowly Changing Dimensions methodology and developed mappings to keep track of historical data
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in troubleshooting the loading failure cases, including database problems.
• Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing.

Environment: InformaticaPowerCenter7.1.1, Oracle 9i, MS SQL Server 2005, UNIX, PL/SQL, UNIX shell scripting, SQL*PLUS, SQL, TOAD, Reports, MS Excel, MS Access, Flat Files, XML.

Confidential

Oracle/ETL Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using Informatica into the database. Involved in Logical and Physical modeling of the drugs database.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target Oracle Data Warehouse database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Informatica Power Center 7.1, Oracle 8i, XML, SQL, PL/SQL, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 7.1.2, DB2 v8.0, SQL, Windows 2000, UNIX, SQL Server 2000, Oracle 8i, Flat files, SQL *Plus, Business Objects 5.1.6