SUMMARY

• 7 years of experience in Information Technology with a strong background in Data warehousing and Data Extraction using Informatica Power Center 9.x/8.x/7.x as ETL Tool.
• 2 year experience as SQL developer with good knowledge of Oracle SQL/PL/SQL.
• Strong experience in ETL and Data Warehousing using Informatica Power Center clients Designer, Repository Manager, Workflow Manger and Workflow Monitor.
• Extensively worked on Informatica Designer Components such as Source Analyzer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools such as Task Developer, Workflows &Worklet Designer.
• Experience in creating Re - Usable Transformations, Mapplets, and Mappings.
• Good Experience on Managing, Scheduling, and Monitoring of Informatica Workflows.
• Extensively worked on Informatica Power Center Transformations but not limited to such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Experience in performing ETL procedures to load data from heterogeneous sources like Oracle 9i/10g, DB2, Flat Files, XML Files, Teradata, MS SQL Server and MS Access into Data Warehouse using Informatica Power Center.
• Expertise in Slowly Changing Dimensions (type1, type2, type3).
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience working in Oracle8i/9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Strong knowledge of Mapping Variables and Parameters to perform Incremental Load, SQL Transformation using Query and Script mode.
• Excellent in Data Analysis, Data Requirement Analysis and Data Mapping for ETL Process.
• Experience in identifying Performance Bottlenecks and Tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Strong in Data Warehousing methodologies of Star /Snow Flake.
• Experience in troubleshooting the mappings by using Debugger.
• Experienced in Installation, Configuration, and Administration ofInformatica Power Centeron Client/Server environment.
• Good working knowledge of UNIX shell scripting.
• Good practice of working under Agile/Scrum methodologies.
• Excellent skill set of analytical problem solving, documentation, communication and presentation.
• Outstanding interpersonal skills with proficiency to work in a team as well as self. Creative, adaptive and result-oriented professional with avidness to learn new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/8.5.1/8.1.1/ 7.1.3

Database Tools: Oracle 11g/10g/9i, Toad, SQL Server 2008/2005

Reporting Tools: OBIEE, Business Objects

Data Analysis: Data Design/Analysis, Business Analysis, User Requirement Gathering/Analysis

Programming: SQL, PL/SQL, C, C++, C#, JAVA, .NET, UNIX Shell Scripting, XML, HTML

Operating Systems: Windows 95/98/NT/XP/2000, UNIX

Process/Technologies: SDLC, Waterfall, Agile, Scrum

Additional Tools: MS Office, Apace Open Office, MS Visio, Wordpress

PROFESSIONAL EXPERIENCE

Confidential, Enfield, CT

Sr. ETL Informatica Developer

Responsibilities:

• Excellent understanding of Informatica PowerCenter Client- Repository, Designer, Workflow and Monitor
• Designing end to end the ETL mapping using the Teradata as source and target.
• Used various transformations Aggregator, Expressions, Filters, Sorter, Sequence Generator, Joiner, and Router.
• Work with Unconnected as well as Connected Look Ups.
• Developed efficient PL/SQL query for Source Qualifier using When-Case, Inner Join, Outer Join, Complex Conditions
• Active interaction with business team for gathering the business requirements.
• Followed complete SDLC process and worked under Agile methodology.
• Data Validation and Cleansing for Performance Tuning of the ETL workflow.
• Implemented the FTP process for flat files as sources and target
• Efficient detecting and fixing the ETL defects within timeframe and deploying the ETL jobs in various testing environment.
• Designed the UNIX scripts for automatically triggering the ETL jobs.
• Used Tivoli Work Scheduler for scheduling the jobs setting the frequency and dependencies.

Environment: Informatica, Teradata, Oracle, Unix, TWS, ERwin, OBIEE

Confidential - Charlotte, NC

Sr. Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Analysis of production issues and designed the detailed solution.
• Performed performance tuning at functional and map level for better production performance.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.
• Used Debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Used various transformations like expression, transaction control, aggregator, Router, Unconnected Lookup, Filter, and Sorter.
• Worked on slowly changing dimensions.
• Created new mapping design using various tools in Informatica designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Involved in extracting the data from flat files and relational databases into staging area.
• Prepared Technical design documents and test cases and also performed unit testing.
• Used DB2 as source system.
• Extensively worked on SQL server.
• Implementation of Scrum methodologies/ SDLC framework to support the efficient development of project.

Environment: Informatica Power Center 9.1,Oracle 11g, SQL Server, PL/SQL, Flat Files, DB2, OBIEE, Erwin, Scrum.

Confidential - Madison, WI

Sr. Informatica Developer

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica Power Center to extract, transform and load data from various source systems to staging and target Data warehouse.
• Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in batch process.
• Created fact and dimension tables based on specifications provided by managers using Star Schema.
• Designed and created complex source to target mappings using various transformations like Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail of the workflow.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Written UNIX scripts to transfer the data from operational data sources to the target warehouse.
• Developed PL/SQL procedures, functions, triggers for processing business logic in the database. Wrote optimized SQL queries for data retrieval from the source database.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shells scripts.
• Monitoring the session logs to check the progress of the data load.
• Working with an Agile, Scrum methodologies to ensure the delivery of high quality work.
• Involved in different Team review meetings.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, UNIX shell scripts, OBIEE Analytics 7.8.4, TOAD, windows XP, ERwin 4.X.

Confidential - Reston, VA

Informatica Developer

Responsibilities:

• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Normalizer, Union, Connected and Unconnected Lookups, Filters, Sequence, Router and Update Strategy.
• Created and monitored sessions and batches using Server Manager to load data into the target database.
• Worked on the Pricing Files which are fed from the Internal Group or from External Middle Office Group via FTP Processes.
• Worked with Mainframes (DB2 (UDB), Copy book, VSAM files, Sequential files), and Oracle.
• Implemented Slowly Changing Dimensions (SCDs: Type 1, Type 2 & Type 3).
• Involved in fixing invalid Mappings, testing of Stored Procedures and Testing of Informatica Sessions, Batches and the Target Data.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Involved in the development of Informatica mappings and used Informatica partitioning (parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities) for performance tuning thereby reducing the load time.
• Used PMCMD command to interact with Informatica server from command mode and to create backups, copy, and delete repositories.
• Used utilities to load and export data into the databases and maintain them.
• Used Autosys Scheduling Tool to schedule UNIX shell scripts, PL/SQL scripts, Informatica jobs and automated the entire process.

Environment: Informatica 9.1/8.6, Oracle 10g/11g, SQL Server, ERwin, TOAD, UNIX, Autosys, MS Visio

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Co-ordinated with the client and collected the requirements from the users.
• Processed the flow of data from source system to data warehouse and used Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer for defining Source and Target definitions.
• Developed Type2 &Type3 slowly changing dimension mapping in various project requirements.
• Developed complex mappings using transformations like Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc.
• Prepared automated job scheduling process with Autosys scheduler.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed override SQL statements in Source Qualifier and Lookups to suit extraction of desired data from desired region.
• Created mapping parameters and variables in Informatica to handle the incremental date logic using parameter file to connect to various environments with ease of change.
• Identified the bottleneck and fine-tuned Source, Targets, Mappings, Transformations and sessions for better performance.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Interacted with OBIEE Analyst to assist him in Understanding the Source and Target System.
• Involved in on call support to resolve the production issues during the implementations.
• Wrote different kinds of UNIX shell scripts to handle File process, SFTP, validation and ETL controls.
• Managed and coordinated with onshore/offshore teams.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 9.1, Oracle 11g, Siebel, PL/SQL,UNIX Shell Scripts, Autosys, OBIEE, TOAD, windows XP, ERwin 4.X.

Confidential - Chicago, IL

ETL Informatica Developer

Responsibilities:

• Used Informatica 8.6 to extract, transform and load data from multiple input sources like Oracle/ SQL Server, Flat files into Oracle 10 g database.
• Worked on Source Analyzer, Warehouse Designer, Mapping, Mapplet Designer and Transformations, Repository Manager, Workflow Manager and Workflow Monitor.
• Used most of the transformations such as the Source Qualifiers, Lookup, Routers, Aggregators, Union, Sequence Generators, Expression, etc.; as per the business requirement.
• Used Workflow Manager for creating and maintaining the Sessions. Also used Workflow Monitor to Monitor Edit, Schedule, Copy, Aborts and Delete sessions.
• Extensively worked on UNIX environment to run the Informatica workflows.
• Peer-reviews for the code changes and highly involved in regression testing the changes/fixes implemented.
• Used Autosys for scheduling Informatica Jobs.
• Worked extensively in implementing SCD’s (Type 1 and Type 2).
• Involved in creating /testing stored procedures and also fixing and debugging invalid mappings.
• Involved in the development of Informatica mappings and used Informatica partitioning (parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities) for performance tuning thereby reducing the load time.

Environment: Informatica 8.6, Oracle 10g, TOAD

Confidential - Birmingham, AL

ETL Developer

Responsibilities:

• Analyzed business process and developed ETL procedures to move data from various source systems to target systems.
• Created mappings in Power Center Designer using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Developed reusable transformation objects to reduce the development time.
• Developed and designed Data Marts using Star Schema.
• Implemented Slowly Changing Dimensions of Type 1 & Type 2.
• Worked on developing mappings and mapplets to extract and load the data from Oracle and Flat files
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Implemented Push down query optimization to optimize the queries.
• Developed sessions using Informatica Workflow Manager.
• Created Parameter files for imparting flexible runs of workflows based on the changes in variable values.
• Implemented performance tuning of mappings, transformations and sessions to optimize session performance.
• Developed PL/SQL procedures to update the database and to perform calculations.
• Worked with SQL*Loader to load data into the warehouse.
• Created various tasks such as email task, Event wait and Event Raise tasks in the workflow manager.
• Used Debugger to troubleshoot the mappings.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting.
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.
• Assisted the other ETL Developers in resolving complex scenarios.
• Involved in different Team review meetings.

Environment: Informatica Power Center 7.1, Oracle 10g, Toad 7.6, Autosys, PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, UNIX 2.6, UNIX Shell Scripting

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with management for requirements gathering.
• Created database objects such astables, views, indexes, sequencesusing Oracle 10g.
• Developed PL/SQLstored procedures,functionsandpackagesin Oracle 10g.
• Wrotecomplex SQL queriesto retrieve information from the databases depending on the requirement.
• Optimizedandtuned PL/SQLsubprograms to reduce the loading process.
• Developed pre and post SQL scripts.
• Developed Shell Scripts, PL/SQL procedures, for creating /dropping of table and indexes of performance for pre and post session management
• Created data model, logical design, and physical design of the database.
• Used file handling in Oracle to read and write into files associated with the modules.
• Trapped errors such asINVALID CURSOR,VALUE ERRORusingexceptionhandler.
• Developedrow level and statement level triggersfor auditing tables in PL/SQL.
• Analyzed and CreatedPartitionson the tables to improve the performance
• ImplementedPL/SQLscripts in accordance with the necessary business rules and requirements.
• Created Primary key, Foreign key, Indexes, Rules and Check constraints for the tables in Oracle 10g.
• Worked on day-to-day technical issues on Forms, Reports and PL/SQL.
• Used SQL* Loader to upload bulk data into database from external files.
• Implemented various customized Oracle reports using different techniques in Oracle PL/SQL.

Environment: Oracle 10g, SQL, PL/SQL Developer, UNIX Shell scripting, MS SQL Server, Windows2000