SUMMARY:

• Goodknowledge in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table.
• Six Plus 6 years' experience in Relational Databases like Oracle, MS SQL Server, MS Access, SQL,TOAD, SQL Plus, Linux, UNIX.
• Directly responsible for the Extraction, Transformation Loading of data from multiple sources into Data Warehouse.
• Created mappings using different transformations like Expression, Aggregator, Lookup, Router, Update strategy, Filter and Stored Procedure transformations to extract and integrate the data from different databases and files.
• Skilled in Stored Procedures, Functions, Oracle Performance Tuning, Indexes, Functions, and Packages, and VLDB.
• Experience in writing UNIX shell scripts calling Informatica pre/post session operations.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mappings.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs.
• Quick learner and adaptive to new and challenging technological environments.
• Excellent Interpersonal Skills with the ability to work independently and with the team

SKILLS SUMMARY:

Data Warehousing : PowerCenter 8.6/8.1/8.0/7.1.4/7.1.3/7.1.2/7.1.1/7.0,Repository Admin Console, Power Exchange Navigator, Information Lifecycle Management ILM

ETL : Repository, Informatica Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Star Schema, Snowflake Schema, Data Warehouse, Data Mart, FACT tables, Dimension tables.

Data Modeling : Relational Modeling, Dimensional Modeling Star Schema, Snow-Flake, FACT, Dimensions , Entities, Attributes, OLAP, OLTP, Cardinality, ER Diagrams, Erwin 4.2/4.0/3.5.5/3.5.2

Databases : Oracle 10g/9i/8i/7.x, T-SQL, MS SQL Server 2000/7.0/6.5, Sybase, DB2 UDB 8.0/7.0/6.0, MS Access 7.0/2000, IMS Data, SQL, PL/SQL

Database Tools : SQL, SQL Plus, Toad, PL/SQL Developer

Data Masking : ILM

Environment : UNIX Sun Solaris, HP, Linux , Windows 2003/2000/XP/98

Others : Microsoft Word, Microsoft Excel, Outlook

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. ETL Informatica Developer

Responsibilities:

• Worked closely with Subject Matter Experts, application owners and end users to get detailed working aspects of their respective apps and masking requirements
• Implemented various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Sequence Generator, and Router etc.
• Worked on different databases and flat files such as Oracle, DB2, VSAM, mainframe flat files
• Worked with DBA's for performance tuning and to get privileges on different tables in different environments.
• Developed Mapplets and created mappings in a pipeline structureto implement reusable transformational logic
• Developed Worklets to run multiple sessions
• Used parameters and variables at different levelslike mappings and sessions
• Used Debugger to fix errors in the mappings and to check the data flow
• Executed workflows using pmcmd command
• Developed workflows with sequential and parallel sessions
• Unit tested the code to check if the target is loaded properly
• Migrated repository objects, services and scripts from development to production environment
• Created UNIX Scripts and environment files to run batch jobs
• Created technical documents for end user - Instruction Manuals for the solution provided.
• Provided training to Junior Informatica Developers on SQL and Informatica

Environment:Informatica 9.0.1, Oracle 11g, DB2, Informatica ILM, Toad for Oracle and Toad for DB2, SQL Assistant, IBM AIX, Visio, Citrix Client, Informatica Power Exchange.

Confidential

Sr. ETL Developer/ Data Analyst

Responsibilities:

• Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
• Implemented Star Schema for De-normalizing data for faster data retrieval for Online Systems.
• Designed and Developed Mappings, sessions and workflows in Informatica.
• Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and Flat files.
• Designed and Deployed UNIX Shell Scripts.
• Designed and developed Informatica Mapping for data load and data cleansing
• Responsible for Pre and Post migration planning for the different Environment.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Performed impact analysis for systems and database modifications.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extracted data from Sales department to flat files and load the data to the target database.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Performed data validation, reconciliation and error handling in the load process.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.

Environment: Informatica Power Center 9.1/8.6.1, PL/SQL, Oracle 11g/10g, SQL Server, XML, Flat Files, Toad, SQL Developer, DAC Data warehousing Administrative Console , Shell Scripting.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, and Flat Files
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Look up, Update Strategy, Sequence Generator, Rank and Aggregator
• Extensively used LTRIM, RTRIM, ISNULL, ISDATE, TO DATE functions in Expression Transformation for data cleansing in the staging area.
• Extensively worked with Substr, Instr, Decode functions in the Expression Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Unconnected Lookup transformations
• Extensively worked with various lookup caches like Static, Dynamic, and Persistent Cache
• Developed Re-usable Transformations, and Reusable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Extensively worked with joiner functions like normal, full outer, master outer and detail outer in the joiner transformation.
• Used Update StrategyDD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Worked with Session Logs, and Workflow Logs for Errorhandling and Troubleshooting in all environments
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Responsible for Unit testing and Integrationtesting of mappings and workflows.

Environment:Informatica Power Center 8.6/8.1, Oracle 10g, SQL Server, DB2, Flat Files, Business Objects, UNIX AIX , Windows XP, Informatica Scheduler.

Confidential

ETL Informatica Developer

Responsibilities:

• Analyzed the Business Requirement Documents BRD and laid out the steps for the data extraction, business logic implementation loading into targets.
• Extensively worked with Informatica Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from different sources like Flat Files, Oracle in accordance with requirements and specifications.
• Creating mappings and different kind of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence, Stored Procedure and Update strategy. Created and used Reusable Transformations and Mapplets to improve maintainability of the mappings.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Involved in extensive Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
• Examined sessions, event, and error logs and analyzed for trouble shooting mappings and sessions.
• Used Stored Proceduresextensively.
• Performed Unit Testing and tuned the mappings for better performance.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.
• Developed UNIX shell scripts to create parameter files, and to executing Informaticaworkflows.
• Created Autosys JIL scripts, Parameter files and automated ETL process by scheduling the jobs using Autosys.

Environment: Informatica PowerCenter8.6 Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplets, Transformations, Workflow Manager, Workflow Monitor , UNIX, DB2, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in the Analysis, design and Modeling.
• Parsed the Functional specifications into a Technical document, which would provide an efficient platform for peers for development.
• Migrated data mappings to production and monitoring, troubleshooting and restarting batches.
• Developing UNIX shell scripts for data manipulation and process automation.
• Developed separate mappings for the Data Cleaning and Scrubbing and implementing the Data warehousing Standards.
• Implementing the complex business rules by creating transformations, filter, Expression, Lookup, Joiner, Sequence generator transformation.
• Performed Informatica server administration tasks such as stopping/starting Informatica Repository and Server processes, performing code migration from Dev to Test, backup and restoring of Informatica Repository, upgrades and security administration.
• Created Migration Documentation and Process Flow for mappings and sessions.

Environment: Informatica - Power Center 7.1/8.1,Oracle 10g, DB2,SQL Server, UNIX Shell Script, AutoSys, Business Objects, Erwin, Windows XP, Unix.

Confidential

Responsibilities:

• Business Requirements gathering and Analysis.
• Analyzing the source data coming from DB2 and working with business users and developers to develop the Model.
• Scheduled the workflows and sessions at specified frequency.
• Monitored the sessions using workflow monitor.
• Tuning the Informatica sessions and Mappings for optimum performance.

Environment: Informatica PowerCenter 6.2, DB2 8.0, Oracle 9i, SQL, PL/SQL, MS SQL Server 2005/2000, MS Access 2003, Windows NT 4.0