SUMMARY

• Over 7+ years of IT experience in analysis, design, development and implementation of Data warehouses, data marts using Informatica Power Center with Oracle, MS SQL server, DB2 and Teradata databases.
• Strong expertise using Informatica Power Center Client tools - Designer, Repository manager, Workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Experience with Informatica Server Manager to create sessions and workflows to run with the logic embedded in the mappings.
• Experience in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client, Server and having exposure to FTP and Release Management.
• Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.
• Expertise in taking backups, recovery of workflows, sessions and mappings from repositories.
• Experience in dimensional modeling to design star schema databases.
• Experience in document process and training team members by creating and maintaining technical documentation, deployment diagrams and checklists.
• Experience in Data warehouse OLAP reporting using Business Objects.
• Experience in DVO data validation by creating complex views against the target data.
• Good working skills in writing PL/SQL, SQL, Database Triggers and Oracle SQL query tuning concepts.
• Experience with writing daily batch jobs using UNIX shell scripts, and developing complex UNIX Shell Scripts for automation of ETL.
• Expert in Unit Testing, Integration testing and Performance Testing.
• Worked with different SDLC Environments Agile, Iterative, Water Fall Methodologies.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills.
• Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center (Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor)

RDBMS: Oracle, Teradata, IBM DB2, MS SQL Server, Sybase, My SQL, MS Access

Business Intelligence: OBIEE, Cognos, Business Objects XI

Programming Languages: SQL, PL/SQL, C,UNIX Shell Scripting.

Operating Systems: Windows 7, Win NT 4.0, Sun Solaris, UNIX, LINUX, and MS-DOS

Software Packages: Rally, Jira, MS-Office, PowerPoint, Word, Excel, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto CA

Informatica Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings.
• 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.
• Involved in POC of Informatica Metadata Manager and prepared a handy document for the ETL team.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, Teradata, MS Access, 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 Un connected Lookup transformations.
• Extensively worked with various lookup caches like Static, Dynamic, and Persistent Cache.
• Developed Re usable Transformations, and Re Usable 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 File.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively worked with joiner functions like normal, full outer, master outer and detail outer in the joiner transformation.
• Used Update Strategy DD 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 Error handling and Troubleshooting in all environment.
• Innovative design for Change Data Capture of huge amounts of Customers and Customer Accounts every business day.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Environment: Windows 2000, Oracle 10g, SQL Plus, PL/SQL IBM AIX 5.2, Informatica 9.1

Confidential, Windsor, CT

Informatica Developer / Prod support

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server & flat files.
• Performed Data Integration for the data from the heterogenous sources and used the best methods for achieving the queriable data.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event Wait, E-mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges using Informatica Repository Manager.
• Working DVO data validation tool to validate the data accurately.
• Was responsible for the version control and up-gradation.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system.
• This led to better session performance.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers and Stored Procedures in the server side.
• Involved in creation of Classes, Objects and Universes for reporting purpose using Business Objects Designer.
• Wrote UNIX Shell Scripts and pmcmd command line utility for automating Batches and Sessions using ESP Workload manager.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 9.0.1, Oracle, TOAD, DB2, Flat Files, PL/SQL, ERWIN 7.3 Data Modeling tool, Windows server 2008 r2, UNIX shell scripting.

Confidential, MA

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• 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.
• Loaded the data from different vendors to claims data mart.
• Involved in data modeling to implement star schema database.
• Involved in understanding the business requirement, identifying the grains, designing the fact tables with key performance indicators and establishing the relations between the dimensions.
• Worked on loading data at different levels Stage, ODS, Warehouse.
• Used Informatica to load data into Stage and ODS and created Oracle packages to load the data from ODS to warehouse.
• Also created complex Oracle packages, procedures, cursors, triggers to load the data into warehouse.
• Extensive use of partitioning and indexing for high performance of query retrievals.
• Building the ETL architecture for Source to Target mapping to load data into Data warehouse.
• Worked on transformations like filter, router, connected lookup and unconnected lookup, update strategy, expression etc.
• Worked on performance tuning of existing mappings.
• Extensively used reusable transformations, mapplets and worklets to reuse in them globally.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Responsible for the Dimensional Modeling and populating the business rules using mappings.
• Created adhoc reports for the business when ever asked.
• Responsible for performance tuning on tables having high volume of data (Terabytes) by partitioning the tables and indexing for user retrieval.
• Loading huge vendor flat files into data warehouse every day using Informatica and oracle packages.
• Created complex sql to test the data.
• Loaded data into targets using slowly changing dimensions type 2.
• Used sqlplus for spooling the huge tables to file’s for the end user’s.
• Implemented Explain Plan and SQL Trace for improving the performance of SQL queries.
• Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process
• Involved in applying patches and updates to the server.
• Loading SAP R3 data through Informatica and using power connect to connect to SAP.
• Was responsible for the version control and up-gradation.
• Extensively used scripts for data cleansing and data loading.
• Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design (Star Schema) and maintenance.
• Extensively used Workflow manager to create and schedule various Workflows and Worklets.
• Created Universe in Buisness objects in Designer.
• Developed various types of reports like Simple, Drill down Report, Cross Tab reports.
• On time delivery of all kinds of Adhoc reports with excellent performance.
• Worked in unit testing each workflow and then testing after all the workflows are run in a batch process.
• Designed and developed UNIX scripts as a Wrapper script as well as to implement Code.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Designed and developed Informatica mappings for data loads.
• Performed Development, Test and Production mapping migration using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Tuned the Informatica Repository and Mappings for optimum performance.

Environment: Oracle 10G, Informatica 8.6.1 (Repository Manager, Admin Console, Designer, Workflow Manager, Workflow Monitor),Power Connect, SAP R3Toad, Sql Navigator, Sql Plus, Erwin 4.0, PL/SQL, Windows XP professional, Erwin 3.5.2, AIX, Shell Scripting.

Confidential, Simi Valley, CA

Informatica ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Repository Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle, DB2, XML, QCARE, Flat files) and worked on developing ETL mappings.
• Good experience in installation of informatica Power Exchange.
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily and monthly basis.
• Implemented mapping level optimization with best route possible without compromising with business requirements.
• Created Sessions, reusable worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Worked on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting.
• Generated XML files to deliver to Thompson Reuters.
• Performed Data profiling for data quality purposes.
• Proven Accountability including professional documentation, and weekly status report.
• Performed Quantitative and Qualitative Data Testing.
• Documented flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and created metadata documents for the Reports and the mappings developed and Unit test scenario documentation for the mentioned.

Environment: Informatica Power Exchange, Power Center 8.6.1, DB2, Oracle, UNIX, Win XP Pro, TOAD, Autosys, Thompson Advantage Suite.

Confidential, Minneapolis, MN

Informatica and Data Warehouse Developer

Responsibilities:

• Managed the entire “ETL process” involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load the data from various source systems like Oracle, Teradata, and Sybase into the Oracle target database.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Involved in quality assurance of data, automation of processes.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Identified and tracked the slowly changing dimensions Type 1 and Type 2 (for change data capture), heterogeneous Sources and determined the hierarchies in dimensions.
• Used Task developer in the Workflow manager to define sessions.
• Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Performed Repository Administration tasks like Creating repositories, users, assigning groups and their privileges, creating backups and recovery using Informatica Repository Manager.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Connection management and scheduling of jobs to be run in the batch process
• Generated detailed reports from the data marts using Business Objects.

Environment: Informatica Power Center 8.6.1, Business Objects, Oracle 9i, DB2, SQL/PLSQL, dynamic SQL, UNIX Shell Programming, Erwin 4.0, UNIX (IBM - AIX), and Windows NT.

Confidential, CT

Informatica Developer

Responsibilities:

• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor
• Involved in requirements gathering for ETL work.
• Created High level and Low level Technical Design Documents.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and Relational database systems.
• Worked with the Business Analysis team during the functional design and technical design phases.
• Used Informatica PowerCenter 8.6.1 for extracting Oracle, flat files for Data Extraction involved in the development of Informatica mappings and also tuned them for better performance.
• Extracted data from different Data marts and loaded into Data Warehouse.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, and Update Strategy & Sequence Generator.
• Used SQL, PL/SQL to validate the Data going in to the Data Warehouse.
• Worked along with the DBA to resolve performance and tuning issues.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Used debugging tools to resolve problems.
• Extensively worked with the QA team to get the system testing done successfully.
• Created Task Session, Email and Workflow to execute the mappings.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Created Unix Scripts for running the jobs and Error handling.

Environment: Informatica Power Center 8.6.1,, Oracle, DB2, Autosys,, SQL, PL/SQL, MS Office, Windows XP, UNIX Shell Scripts.

Confidential

ETL Developer

Responsibilities:

• Interacted with end-users to identify and transform the business requirements into logical and technical requirements.
• Worked with source databases like Oracle, SQL Server and Flat Files.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup (connected and unconnected), Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Developed Mapplets to implement business rules using complex logic.
• Used Informatica Repository Manager to create Repositories, User Groups and Users based on their roles.
• Converted the PL/SQL Procedures and SQL*Loader scripts to Informatica mappings.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Developed UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs.
• Used Informatica Designer to create complex mappings using different transformations to move data to multiple databases.
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server manager.
• Used Debugger to check the errors in mapping.
• Generated UNIX shell scripts for automating daily load processes.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: - Informatica PowerCenter 7.1, Oracle 9i, SQL, PL/SQL, SQL*LOADER, UNIX (Sun Solaris, Confidential -UX, AIX), MS SQL Server, TOAD, Windows 2000, MVS, OS/390, XML.