SUMMARY:

• 14+ years of IT experience of which 8 Years in the Analysis, Design, Development Of Data Warehousing and ETL Processes using Informatica Power Center 9.x/8.x/7.x/6.x and 6+ years as an Oracle Developer.
• Expertise in implementing complex business rules by creating robust Mappings, Transformations, Workflows using Informatica Power Center.
• Extensive experience in ETL Process with client side technologies like Erwin, Informatica powercenter, Unix, Oracle SQL PL/SQL, Toad, SqlServer, FTP.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
• Strong background in Data warehousing concepts and experience in implementing dimensional Modeling concepts (StarSchema, Snowflakes Schema).
• Experience in designing/developing complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup and Update Strategy.
• Excellent experience in creating reusable and non - reusable tasks such as Session,Command,Email, Event wait /raise,timer,assignment etc & configuring them in workflow using workflow managaer.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Extensive Experience on Performance tuning to optimize cycle run time by identifying bottle necks which exists at database level or at informatica level or at network level, once bottlenecks were identified respective tuning measures were implemented to improve production cycle performance.
• Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Developed complex mappings like Slowly Changing Dimensions Type1 and Type2, Incremental Loading.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies.
• Robust Knowledge of ETL Process, Dimensional Data Modeling, Slowly Changing Dimensions and data warehouse concepts, Software quality procedures, standards and project documentation.
• Worked extensively in various stages of SDLC like design, development, testing (QA, UAT, and Regression) and production support.
• Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Excellent Experience in Unix Shell Scripting to write parameterized shell scripts to run sessions & batches.
• Worked with cross-functional teams such as QA, DBA teams to deploy code from development to QA and from QA to Production server.

TECHNICAL SKILLS:

Operating System: WINDOWS 98/2000/NT/XP, IBM-AIX 5.3, HP UX, Linux.7.1/7.2/8.

Language: SQL, PL/SQL, C, C++, JAVA, Shell(bash,ksh), HTML, COBOL, Control -M Scripts.

RDBMS: ORACLE 8i/9i/10g/11, DB2/AIX 64 8.2.3/9.5.3, Sybase, MS SQL Server

ETL Tools: Informatica Power Center 9.6.1 (Designer, Repository Manager, Workflow Manager and Workflow Monitor) / 8.6.1/8.1.1/7.1.2

DataModel Tools: ERWin 4.1, Microsoft Visio.

Database Tools: Toad 7.6/9/10g, PL/SQL Developer, SQL*Loader, SQL plus.

GUI: Developer10g, Visual Basic 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Sr. Informatica Developer

Responsibilities:

• Design and develop ETL process using Informatica tool to load data from wide range of sources such as Flat Files and Oracle Database.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• As an Informatica Developer, Develop various mappings & mapplets to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalizer, Aggregator, Joiner, SQL transformations, XML Transformation in the mapping.
• Use connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Extract files and manually transferred to Informatica server using FTP scripts developed using Unix.
• Worked on different OLTP data sources such as SQL Server and Flat files for data extraction.
• Implemented Type II slowly changing dimensions using date-time stamping.
• As an Informatica Developer, created reusable transformations and mapplets to reuse while creating ETL mappings.
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Extensively developed Oracle PL/SQL stored procedures using TOAD to implement different business logics and perform backend testing to verify the transactions and business logic.
• Created and tested UNIX shell scripts to automate SQL scripts and stored procedures.
• Extract data from DB2 database for ETL processing.

Environment: Informatica Power Center 9.6.1, Oracle 11g, PL/SQL, SQL Server, UNIX Scripting.

Confidential, Louisville, KY

Sr. Informatica Developer

Responsibilities:

• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• As an Informatica Developer, created new mappings and mapplets and also tuned them for better performance.
• Involved checking and comparing data between Source files and database.
• Responsible for preparing Unit testing and Migration Documents.
• Involved in analyzing, defining, and documenting data requirements by interacting with the users.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• As an Informatica Developer, developed mappings in Informatica to load the data from various sources like people soft, SAP into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Defined Target Load Order Plan for loading data into Target Tables.
• Used shell scripts for post session operations.
• Extensively used XML transformations and work flow instances.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Extensively worked in the performance tuning on Informatica mappings.

Environment: Informatica Power Center 9.5.1, Oracle 11g, SQL Server, Toad, UNIX Shell Scripting, Flat Files.

Confidential, Denver, CO

Sr. Informatica/ ETL Developer

Responsibilities:

• Involved interactively with the business units to understand the requirements and gather the feedback during the design, development and testing of solutions.
• Worked on various data sources such as Oracle, DB2 UDB and flat files.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings .
• Wrote SQL Queries as part of Data validation in the Target tables
• Created the Scripts to process the business logic from the Landing Zone to the Common Staging Area(CSA)
• Created the Email task notifications to notify the error messages and also used the command task to run the BTEQ scripts in the workflow monitor.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
• Having brief practical knowledge on Power Exchange Navigator, Power Exchange Bulk Data movement, power exchange change data capture.
• Created mapplets and reusable transformations.
• Creating sessions and batches to run with the logic embedded in the mappings using Informatica Power Center Workflow Manager.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Conducting debugging sessions and fixing invalid mappings.
• Designed and developed UNIX Scripts to automate the tasks.
• Used the different types of transformations in Informatica such as Source Qualifier, Look up, Router, Joiner, Union, Aggregator etc.
• Created necessary Repositories to handle the metadata in the ETL process.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Strong in UNIX Shell scripting . Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Control-M.
• Done the Unit testing after successfully loading the data into Landing Zone (LZ) area.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Flat Files, Toad, SQL, PL/SQL, UNIX Scripting.

Confidential, Alpharetta, GA

Sr. Informatica/ ETL Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project-coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Developed extraction mappings to load data from Source systems to ODS to Data Warehouse.
• Developed joiner transformation for extracting data from multiple sources.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression,, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Fine-tuned Transformations and mappings for better performance. Involved in the process of design documentation of the Data Warehouse Dimensional Upgrades. Worked with analysts and data source systems experts to map requirements to ETL code.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Migrate Informatica objects and Database objects to Integration Environment and schedule using the Control
• Responsible for identifying and removing bottle necks, fine-tuning the Mappings and Sessions, SQL queries for improved performance.
• Worked closely with reporting team to generate various reports.

Environment: Informatica Power Center 9.1, SQL Server, Oracle, Toad, UNIX Shell Scripting, Flat Files, Control-M

Confidential, Pleasonton, CA

Informatica/ ETL Developer

Responsibilities:

• Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.
• Transformed business requirements into technical specification and then source-to-target mapping documents.
• Involved in Database design, entity relationship modeling and dimensional modeling using Star schema.
• Worked with Source Analyzer, Data Warehouse Designer, Repository Manager, Workflow monitor, Mapping Designer, Mapplet, and Transformation Developer in Informatica designer.
• ETL mappings were developed to perform tasks like validating file formats, business rules, database rules and statistical operations.
• Used Informatica Designer to create Reusable transformations to be used in Informatica mappings and Mapplets.
• Created test cases for the above projects in providing error free solution. Monitored Workflows and sessions using Workflow Monitor.
• Debug through Session logs and fix issues utilizing database for efficient transformation of data.
• Prepared Mapping documents, Data Migration documents, and other project related documents like mapping templates and VISIO diagrams.
• PL/SQL programming to create Oracle stored procedures and calling the procedures from Informatica sessions for data manipulation and error handling.
• Used shell scripts for automating the execution of maps.
• Used Metadata Manager to collect and link metadata from diverse relational databases, integration processes, and mainframe systems, into a central catalog.
• Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment.
• Develop technical documents in ease of improvements on existing code.
• Involved in data conversion, migration, integration quality profiling tasks.

Environment: Informatica Power Center 8.6, Oracle 10g, Sql, Plsql, UNIX, Informatica

Confidential, Sunnyvale, CA

Oracle Developer

Responsibilities:

• Involvement in this project started with detailed analysis of requirement.
• Writing database components using SQL/ TSQL / PLSQL in Oracle 9i .
• Also involved in writing complex queries and query optimization for existing and new queries.
• Data conversion and loading of flat files into Oracle 9i database received from legacy applications.
• Involved in Unit and Integration testing of system.
• Involved in deployment and support of system.

Environment: Oracle 10g, Oracle 10.1.2, Oracle Forms 5.0, Unix, Windows 2003 and Windows XP.

Confidential, San Jose, CA

Oracle Developer

Responsibilities:

• To support, maintenance and enhancement of system.
• Enhancing Premium Allocation process as per business rules.
• Running and monitoring premium allocation process for each month. In premium allocation process around 4.2 million policies premium was allocated to various heads such as claims, taxes, third party insurance etc.
• Involved in fine tuning of SQL / PLSQL queries to reduce time taken by premium allocation process.
• Generate reports for premium allocation process to use by business users to tally results with datawarehouse reports.
• Also, first point of contact for any queries and issues related to Premium Allocation process.

Environment: Oracle 9i, SQL, PLSQL, TOAD.

Confidential, Palo Alto, CA

Oracle Developer

Responsibilities:

• Involved in development, maintenance and support of systems.
• Mapping user requirements to the operation systems.
• Develop the various forms and reports in tools like Forms 6i and Reports 6i.
• Develop various database objects in Oracle 8i/ 9i using the tools like SQL Tool 1.4 and TOAD.
• Involved in unit testing, system integration testing of new enhancements.
• Involved in test plan management, preparation and execution of QA test plans.
• As a member of technical review group help the support team to resolve support tickets.

Environment: Oracle 8i/9i, SQL, Forms 6i, Forms 5.0, Reports 6i, Reports 5.0, Windows 2003