SUMMARY

• Professional experience of over 7+ years in the field of Enterprise DataWarehousing, Data Integration and Data/code Migration.
• Experience in all the phases of Data Warehouse life cycle involving Requirement analysis, Design, Coding, Testing and Deployment.
• Expert in Database skills using SQL, PL/SQL Developer for debugging applications.
• Experience in writing stored procedures and functions (PL/SQL).
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Extensively worked on various different ETL mappings, analysis and documentation of OLAP reports requirements.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling such as Star Schema and Snow Flake Schema.
• Extensive experience with informatica powercenter 9.0.1/7.x/6.x
• Extensive experience in Extraction, Transformation and Loading from various sources into Datawarehouses and marts using informatica power center(Repository manager, Designer, workflow manager, workflow monitor).
• Experience in writing various ETL procedures in order to load data from different sources like Oracle 10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Worked on flatfiles both of delimited and fixed length.
• Implemented different Slowly changing dimensions(SCD) using Informatica.
• Designed and developed various complex mappings such as Filter, Router, Connected and Unconnected lookups, update strategy, sorter, Aggregator and Joiner.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensive experience in writing UNIX scripts and also automation of the ETL processes using UNIX shell scripting.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Worked on performance tuning, identifying and resolving various performance bottlenecks at various levels like sources, mapping and sessions.
• Involved in Unit testing, system testing to check whether the data loads in to target are accurate.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Experience in designing exception handling procedures to identify, record and report errors.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure with Analytical and Technical aptitude with the ability to solve complex problems.
• Can also work very well in a team as well as independently under minimum supervision.
• Excellent written and oral communication, interpersonal skills and presentation skills.
• Experience in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5.1/9.1/8. x/7.x (PowerCenter)

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams.

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

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader

Query Languages: SQL, PL/SQL, C, C++, UNIX Shell Script, Visual Basic

Job Scheduling Tools: lsfadmin, Crontab, Control-M

Operating Systems: UNIX, Windows NT/2000/2003/XP/Vista/7, MS-DOS

Others: IDQ, MDM.

PROFESSIONAL EXPERIENCE

Confidential, Chicago,IL

ETL Informatica Developer

Responsibilities:

• Worked on 9.5.1 version of informatica in Confidential AMI Project.
• Worked on handling large amount of data usually in millions per day.
• Confidential is a utilities project where we handle live data which usually come in millions depending on number of customers.
• We have designed a system which accepts the requests based on certain flags and created a extract for handling such requests.
• The customers data will be stored in a dimension table and a fact table will be incrementally loaded.
• Worked with dynamic sql transformation which involves lot of joins on fact and dimension tables.
• Used pre sql of source qualifier which involves handling many sql queries.
• Worked on Mapping and workflow variables and also how to use the mapping variables in workflow and viceversa.
• Used lot of functions like set variable function in order to assign the incoming values to mapping variables.
• Created mappings in such a way where we connect all the mappings using mapping and workflow variables which are part of a single workflow.
• Used pre session success varable assignment and also post session success variable assignment at non reusable session task in order to pass the workflow varibales to mapping andf vice versa.
• Created unix scripts inorder to schedule or unscheduled athe workflows based on requirement.
• Created concurrent workflow which will be called form a different workflow using command task.
• Worked on continuous scheduling of informatica workflow.
• Used decision task, assignment task, email task based on requirement.
• Created parameter files at workflow level and also merged both of the parameter files used at workflow and session level.
• Created unit test cases and also documented all of them .
• Used lookup transformation where I wrote a lookup override in order to divide the comma separated values into multiple rows by using CONNECT clause in oracle.
• Used oracle minus queries in order to compare the data between two schemas.
• Create a mapplet which can be reused across two mappings and functions to give a differentoutput based on incoming data.
• Used transactional control transformation in order to generate dynamic files at mapping level.
• Also we used an approach to calculate the dynamic files by dividing with timestamp at session level.
• Worked on performance tunning where we increase the throughput by switching from Sql transformation and using the same query in source qualifier.
• Used parallel hint clause for increasing performance which divides across 16 cpus to run a oracle query which has multiple joins.
• Worked on informatica dynamic partitions which can be used for loading large amount of history data.
• Worked on calling the same workflow multiple times until a condition is satisfied which is handled in Unix script.
• Involved in code migration from development to integration testing, Staging and finally to Production Environment.
• Also, prepared documentation required to migrate all the objects across different environments.

Environment: Informatica Power Center 9.5.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, windows XP

Confidential, OH

ETL INFORMATICA DEVELOPER

Responsibilities:

• Understanding the business rules provided to design and develop mapping for the ETL.
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load in Oracle warehouse.
• Involved in working with different sources like Flatfiles(both delimited and fixed width), Oracle and XML.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Created Source to Target Mapping Documents as per requirement.
• Responsible for working with DBA in order to calculate the estimated space required for each Source System depending on the requirement.
• Involved in working with 4-5 Source Systems in order to load them to build EDW environment.
• Used UNIX environment in order to run the batches where the jobs are grouped based on the requirement.
• Involved in basic testing required before migrating the objects to QA/UAT environment.
• Performed testing both in UNIX and also ORACLE level based on requirement. Also provided production support by monitoring the processes running daily
• Involved in performing Reconciliation based on the Source and Target.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Datasets.
• Implemented SED2 using Effective dates concept as per requirement.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues, Troubleshootingof Informatica Mappings, evaluating current logic for tuning possibilities.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Responsible for creating production support documentation.
• Coordinate with business team, get the requirements from them and then coordinate with the team to get the work done, keeping timeline in mind.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, windows XP..

Confidential, Owings Mill, MD

Sr. Informatica Production Support

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules and also involved in analyzing the sources to load in oracle Warehouse.
• Generated E-R diagrams based on the actual values and also relationships held in the source data.
• Prepared ETL specifications in order to help develop mapping.
• Worked with Power center designer tools in developing mappings and mapplets to extract and load the data from flat files, oracle in to oracle database.
• Implemented code using various Informatica Transformations like UNION, Expression, Aggregator, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer, since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Used Informatica Power Center Workflow manager to create sessions, batches to run the mappings daily, biweekly based on the business requirements.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.

Environment: Informatica Power Center 9.1/8.6, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Toad.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Interacted with Business Analysts in order to gather the requirements.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Worked with Power Center Designer tools in developing mappings to extract and load the data from XML files into different FlatFile formats
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed and Developed mappings by using Lookup, Expression, Filter, Update Strategy, Aggregator, Router, transformations to implement requirement logics while coding a Mapping.
• Developed error handling & data quality checks in Informatica mappings.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.

Environment: Informatica Power Center 8.1, Oracle, Flat files, Shell.

Confidential

Jr. Informatica Developer

Responsibilities:

• Involved from initial stage of the requirement gathering to understand business requirements subjected to business.
• Created new mappings and also modifications in already existing mappings as per the new business rules.
• Analyzed the business requirements and suggested changes to the design accordingly.
• Prepared ETL Specifications to help in developing various mappings.
• Used different transformations such as Expression, Source Qualifier, Lookup, Filter, Update Strategy, aggregate, Router, Sequence generator and Joiner in order to create mappings.
• Created sessions and Workflows for the mappings.
• Documented the mapping process and the process that can be used in order to facilitate future development.
• Interacted with user for his requirements and also involved in various document preparation such as integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Involved in performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 9, Oracle 11g, TIVOLI