SUMMARY

• 7+ years extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power Center 9, 8.6.1/ 7.x
• Experience in the Implementation of full lifecycle in Data warehouse, Operational Data Store (ODS) and Business Data marts with Dimensional modeling techniques Star Schema and Snow flake Schema using Kimball and Inmon methodologies.
• Strong experience in ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Expert in Informatica MDM where data Cleansing, De - duping and Address correction were performed.
• Worked on Exception Handling Mappings for Data Quality and Data Validation.
• Experienced in designing ETL procedures and strategies to extract data from heterogeneous source systems like Oracle 11g/10g, SQL Server 2012/2008R2/2005, DB2 10, Flat files, XML, SAP R/3 etc.
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Expert in Informatica Metadata Manager, IDE, IDQ and Metadata Exchange exhaustively to maintain and document metadata.
• Expert in ER Data Modeling tools like Erwin, ER-Studio and Visio in developing Fact & Dimensional tables, Logical and Physical models.
• Evaluate and recommend new database software, utilities, and tools and set the strategy for implementing new technologies.
• Strong experience in understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
• Expert in documentation and Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9, 8.x/7.x, DVO, IDE, IDQ, MDM, DAC

Reporting Tools: Informatica Data Analyzer, OBIEE, Cognos

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

Database: Oracle 11g/10g/9i, SQL Server, DB2, Oracle EBS 11i/12, Greeplum

Database GUI Tools: TOAD, SVN, Agile, Jira

Web Development: HTML, XML

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Script, Perl Scripts

Job Scheduling Tools: Autosys, Control M, Tidal

PROFESSIONAL EXPERIENCE

Confidential, TX

Informatica Developer

Responsibilities:

• Worked on power center tools including Designer/Repository, Workflow Manager/Monitor.
• Involved in gathering business requirements, analysis, development and testing and production support of client application.
• Develop ETL templates, standards, processes & procedures for loading information into data warehousing systems and for ensuring reliability of information loaded.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Worked on extracting data from various sources like Oracle,MS Access and Flat files.
• Experienced in design of Greeplum Database Tables according to the Informatica needs.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Extensively used SQL Override function in Source Qualifier Transformation.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Extensively worked various type of functions in MDM.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Developed complex Unix Shell Scripting for loading the data into Confidential systems.
• Responsible for Performance in Informatica PowerCenter at the Confidential Level, Source level, Mapping Level, Session Level, and System Level.
• Experience in using Data Warehouse Administration Console (DAC 10.1.3.4) for scheduling and executing Incremental ETL loads.
• Created SHELL SCRIPTS for generic use.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Data validation between two different environments using tool DVO.
• Worked on custom and standard model in Informatica MM (Meta Data Management).

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, DVO, IDQ, Workflow Monitor), SQL Server, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files, Oracle SQL Developer, Tidal, Informatica MDM, DAC, OBIEE 10.1.3.4/10.1.3.3 , DB2, Greeplum.

Confidential, San Antonio, TX

ETL Developer /Informatica Developer

Responsibilities:

• Worked on power center tools including Designer/Repository, Workflow Manager/Monitor.
• Involved in gathering business requirements, analysis, development and testing and production support of client application.
• Involved in creating high level design documents, functional specification documents and change requirement documents.
• Worked on Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and SQL Server.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica.
• Extracting, Scrubbing and Transforming data from Flat Files, Oracle, SQL Server, DB2,Teradata and then loading into Oracle database using Informatica.
• Experience in Administering DAC 10.1.3.4 and Informatica 9.0.1.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Tracked production issues and provided application support in case of job failures.
• Involved in handling the production tickets and resolve them in timely manner
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Cleansed the data using MDM technique.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem trouble shooting.
• Assist less experienced peers and provide technical guidance
• Extensively worked with Joiner Transformation to join the heterogeneous sources.
• Worked on Informatica IDE and IDQ.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, DVO, IDQ, IDE, Workflow Monitor), SQL Server, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files, Oracle SQL Developer, SAP ABAP, Tidal, DAC, Unix, DB2, SQL Loader.

Confidential, NJ

Informatica/ ETL Developer

Responsibilities:

• Worked with Power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively worked with both Connected and Un-Connected Lookups.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Worked with reusable objects like Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Extensively used SQL Override function in Source Qualifier Transformation.
• Deployed the Informatica code and worked on code merge between two difference development teams.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Worked with Agile method.
• Involved in monitoring and maintenance of the Unix Server performance.
• Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.
• Performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed jobs into the production environment.
• Responsible for Unit Testing of Mappings and Workflows.
• Attended daily status call with internal team and weekly calls with client and updated the status report.
• Worked on extracting data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access and Flat files.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, IDE, IDQ), SQL Server, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files, SQL Developer, Oracle EBS 11i.

Confidential, MN

ETL/Informatica Developer

Responsibilities:

• Experience on working with complete Software Development Life Cycle of the application.
• Involved in writing Unix and Perl scripts for data parsing, manipulation and updating.
• Handled production related issues and tickets for resolving them in time.
• Worked with Client tools like Designer, Workflow Manager, Workflow Monitor, and Manager.
• Responsible for migrate the workflows from development to production environment.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Involved in creating database tables, views, triggers.
• Responsible for migrating from Development to staging and to Production (deployments).
• Designed for populating Tables for one time load and Incremental loads.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Teradata, UDB, UNIX, Oracle 10g, Mainframes (DB2, VSAM Files, Sequential Files).

Confidential

Oracle Developer

Responsibilities:

• Involved in Analysis, Database Design, Coding, and Implementation.
• Loaded data into multiple tables using SQL Loader.
• Used extensively PL/SQL to develop packages, stored procedure, functions and triggers.
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, Confidential -source matrix. et
• Used different joins, sub-query and nested query in SQL query for reports.
• Implemented the technical and functional aspects of the project.
• Interacted with user for problems faced and providing necessary technical support by fixing\ the bugs.

Environment: Oracle, MS SQL Server2003, PL/SQL, Windows NT, Oracle 9i, UNIX and windows 2000.