Summary:

• 7 years of experience in SQL, PL/SQL, Informatica ETL, UNIX Shell Script programming.
• Experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Insurance and Utility Industries.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Extensively worked with large Databases in Production environments.
• Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 9.1/8.6.1/8.1/7.1/6.2/6.1.
• Possess expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus.
• Strong with PL/SQL back-end programming - Database Triggers, Packages, Stored Procedures, Functions, DB links, Materialized views and Management of Schema Objects on Windows UNIX Platforms.
• Extensively involved in SQL Coding, Query Level Performance Tuning, Troubleshooting, Debugging and fixing the code.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files, COBOL and XML files. Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Extensively worked on Data Services proactively and iteratively collaborate in the profiling and cleansing of data across the heterogeneous sources.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experienced in creating Sessions, Workflows and Worklets by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer using Informatica
• Transformations used: Remote Procedure, Connected Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters, Sequence Generator.
• Experienced in identifying Business Requirements, Technical Requirements, Database Design, Troubleshooting and Writing Interfaces between various applications
• Experience of Onsite Offshore Model.
• Excellent communication and interpersonal skills. Versatile team player with proven problem solving skills, user interface UI work and motivated to learn more and good inter-personal skills. Ability to meet deadlines and work under pressure.

Technical Skills

Employment Details

Confidential

Oracle Apps BI

Description:

Confidential technology corporations is a global provider of professional technical and management support services to a broad range of markets, including transportation, facilities, environmental, energy, water and government.

Key Responsibilities:

• Design ETL workflows developed in Informatica to extract data from Oracle Applications to ODS and data warehouse DW Create and execute unit, functional and integrated testing.
• Scheduling the jobs ETL Workflows and define the dependencies.
• Performance tuned all the sessions to run faster within the allowed time window by using pushing major aggregations to backend database, using filters/routers at appropriate places, persistent caches, cache partitions, pipeline partitions, sql overrides with oracle analytical functions etc.
• Optimize performance requests and Write all technical documentation.
• Participate in project lifecycle activities including quality reviews for development, unit testing, testing and release.
• Identify and highlight risks to Technical Architect/Distinguished Technical Architect and suggest corrective actions.
• Guide and mentor the team of 6 people in technical and functional areas, helping them in complex issues and Ensure that the deliverables were delivered on time.

Senior Informatica Developer

Confidential

Description:

Confidential largest regulated electric delivery business and the sixth largest in the Confidential. It supplies electricity to approximately 7.5 million consumers in a service area of over 400 communities in east, west and north-central Texas, including Dallas, Fort Worth, Midland, Odessa, Killeen, Waco, Wichita Falls and Tyler. It was formerly known as TXU Electric Delivery and TU Electric.

Key Responsibilities:

• Created Informatica mappings with SQL procedures/functions to build business rules to load data. Transformations used were Source qualifier, Aggregators, Connected Unconnected lookups, Expression, Filters, Sequence and Router.
• Developed Technical Design Documents for implementation.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files Fixed Width and Excel files to staging database and from staging to the target Oracle database.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica Power Center.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager
• Monitored the status of Workflows/Worklets/Sessions in Task view mode using Workflow Monitor.
• Involved in Unix Shell Scripts for automation of ETL process
• Involved in End-to-End development from OLTP systems to creation of Data Marts.
• Exclusively worked on the transformations like Aggregator to get monthly, quarterly, Yearly Billing aggregations, Connected unconnected lookups get the customer ids from other tables and also used SQL override to filter the data, Route the unpaid bills.
• Implemented various optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Developed mapping to load the data in slowly changing dimension SCD .
• Used informatica debugger tool to debug the mappings.
• Created Oracle Stored Procedure to implement complex business logic for better performance.
• Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
• Error Handling: Handled in Informatica Mappings sessions and also through Validation Scripts

Informatica Developer

Description:

Confidential is one of the largest insurance and investment companies based in the Confidential The Hartford is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans.

Key Responsibilities:

• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations Developer.
• Created mappings using Informatica Designer to build business rules to load data.
• Created dimensions and fact tables for the project. Creating Test cases for Unit Test to check the data quality.
• Designed business models that use large amounts of data to find solutions to business questions for customers and other stake holders
• Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying PL/SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Developed UNIX scripts to automate the load process to be in synch system
• Migration of customer implementation to production from pre-production after testing the setup
• Supporting day to day business related to Secure File Transfer.
• Plan, schedule and execution of Business Continuity Plan for Cyclone TRACE run services project.

Key Responsibilities:

• Developed PL/SQL Packages, Stored Procedures, Functions, Indexes, SQL scripts for the implementation of complex business requirements in the Operational Database
• Created complex mappings for fact and dimension tables using the various transformations that involved implementation of Business Logic to load data from multiple sources into Operational Data Store and then load Data Warehouse for historical storage
• Used Rapid SQL to write complex queries against Oracle databases, validated warehouse data with Operational Databases to make sure import ran correctly.
• Created various Views for extracting the daily data for loading into the Data Warehouse for historical backup.
• Extensively used Router, Lookup, Aggregator, Expression, Update Strategy Normalizer transformation.
• Developed mappings to load Fact and Dimension tables, for Type 1 and Type 2 dimensions and Incremental loading and unit tested the mappings.
• Coordinate and develop all documentation related to ETL design and development.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and setup email delivery after execution.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Involved in migrating the mappings and workflows from Development to Testing environments.