SUMMARY

• 8+ years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing and testing.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x.Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Extensively used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Developmental experience on Windows 2000/2003/2005/ XP, UNIX platforms.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Resourceful, creative problem - solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions.Exceptional problem solving and sound decision making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/8.x/7.x, Power Exchange 9.x/8.x.

Business Intelligence: Business Objects 4.0/4.1.

Programming Languages: UNIX, Shell scripting, SQL, PL/SQL.C, C++

Databases: MS SQL 2012, Oracle 11g/10g/9i, SQL Server

Platforms: Windows 98/NT/XP/2003/2005/VISTA/7/2008, UNIX

Web Technologies: HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, OKLAHOMA CITY, OK

Responsibilities:

• Work with project managers, business solution analysts, DBA's to achieve business and functional requirements.
• Developed PL/SQL Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Design and development of CDC process using time-stamping method and Implemented SCD methodology including Type 2 to keep track of historical data.
• Using complex SQL to query the database and involved in SQL optimization of existing queries.
• Extensively involved in writing Oracle PL/SQL Stored Procedures/Functions and to create the necessary indexes and work tables for performing the ETL process.
• Developed Stored Procedures using iterative processing with loop, CASE statement process flow, exception handling, records, collection, DML operations, data retrieval using cursor /ref cursor and BULK COLLECT / FORALL, collections, database triggers etc.
• Involved in performance improvement for the transaction load process and optimized the existing SQL queries for performance improvement. Apart from that used the analytical functions, collection, BULK Collect /FORALL and other method to enhance the performance.
• Extensively developed Informatica mappings, mapplets and workflows.
• Created and monitored workflows and task using Informatica Power Center Workflow Manager.
• Performing code migrations as part of weekly/Monthly Change request releases.
• Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Using Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents.

Environment: Informatica PowerCenter 9.6, Oracle 11g, PL/SQL, SQL Developer, SQL Data Modeler, Windows Server 2008, AIX

Confidential, HUNTSVILLE, AL

Informatica Developer

Responsibilities:

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Developed custom data transformation (structured/unstructured data) process using Item field content master data transformation tool.
• Worked on Informatica Power Center tool - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Developed PL/SQL stored procedures for Informatica mappings.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for management reporting.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Providing technical support and troubleshooting issues for business users.
• Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.
• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

Environment: Informatica PowerCenter 9.0, Power Exchange 9.0, Erwin 4.1, EDI, Autosys r11.0 oracle 10g, PL/SQL, SQL,, XML, SQL Server 2005, Windows 2003, Unix.

Confidential, TAMPA, FL

ETL Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Extensively used TOAD to analyze data and fix errors and develop.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica Power center 8.6.1, Oracle 10g, SQL Server 2005, ERWIN 4.2, TOAD, UNIX (AIX), Windows XP

Confidential

ETL Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Extracted data from different sources like SQL server 2005, flat files and loaded into oracle DWH.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Responsible for writing SQL queries, stored procedures, views, triggers.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Created test cases and completed unit, integration and system tests for Data warehouse.

Environment: Informatica PowerCenter 8.1.1, oracle, Flat files, SQL server 2005, SQL, PL/SQL, Windows 2003.

Confidential

Software Engineer Trainee / ETL Developer

Responsibilities:

• Created packages based on the requirement’s
• Understanding the ETL specifications and build the ETL applications like Mappings on daily basis
• Performed validation testing and prepared validation reports.
• Performed tests and validate all data flows and prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
• Documented all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.

Environment: Informatica PowerCenter 8.1.1, SQL Server 2008, Windows XP.