PROFESSIONAL SUMMARY:

• Over 6 years of Information Technology experience: Extensive experience in design, development, and implementations of robust technology systems, with specialized expertise in Data Warehousing solutions building Enterprise Data Warehouses and Data Marts.
• Advanced level of technical proficiency coupled with refined business acumen demonstrated by repeated success in the analysis, design and implementation of innovative Data Warehousing and BI solutions that directly promote business growth. Able to understand business and technical requirements quickly; Excellent communications skills and work ethics
• Able to work independently
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Experienced in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
• Well versed in UNIX shell scripting.
• Strong ETL experience of using Informatica 9.6.1/9.5.1/9.1/9.0/8.6.1/8.5/8.1/7. 1PowerCenter Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplets Designer, Repository manager, Workflow Manager/Monitor.
• Developed complex mappings using Informatica PowerCenter Transformations - Lookup Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Having strong hands on experience in extraction of the data from various source systems like DB2, Oracle, My Sql, Flat Files, SFDC, XML and Teradata.
• Co-innovate with product development on new in-memory Enterprise data management (EDM) solutions.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Provided Architectural Road Map, direction and work packets for ETL needs.
• Created detail ETL Standards documents for Design, Development, Release Management and Production Support.
• Experience in Understanding Data Warehouse Design & Model.
• Extensively worked on Mainframe/Unix and Informatica environments to invoke Teradata Utilities and file handlings
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILLS:

Operating Systems: Windows 10/7/ XP/ NT/2000, UNIX, and LINUX

Database: Oracle 11g/10g/9i, MySQL, MS SQL Server, MS Access.

Programming languages: SQL, PL/SQL, UNIX Shell Script, ANSI C, C++, XML, HTML.

Tools: Toad, Oracle SQL Developer, PLSQL, SQL, Informatica PowerCenter10.x/9.5, Informatica Power Exchange, Informatica Data Quality and Informatica Cloud

Reporting: Oracle reports 10g/9i, MS Access

Others: OOAD Methodology, Data Structures, RDBMS Concepts

PROFESSIONAL EXPERIENCE:

Confidential, St.Louis, MO

Informatica Developer

Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, SQL, Router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

Environment: Informatica Power Center 10.X, Oracle 10g, Teradata, Delimited Flat Files, SQL developer, UNIX Shell Programming.

Confidential, Austin, TX

Informatica Developer

Responsibilities:

• Managed customer support cases on a daily basis, including verifying cases, isolating and diagnosing the problem, and resolving the issue.
• Participated in problem escalation and call prevention projects to help customers and other technical specialists increase their efficiency with our products.
• Acquired specialized knowledge in specific Informatica Products.
• Liaised with Engineering and QA teams on technical discussions as required to ensure tracking and resolution of Change Requests.
• Reviewed business procedures and processes to improve Quality of service.
• Troubleshooting areas of poor performance and identified effective solutions to resolve issues both in the immediate future and for the longer term.
• Approaching complex technical issues with varying perceptions and making use of opportunities to create and implement productivity tools.
• Continuously enhanced knowledge through s and e-learning courses on Informatica products.
• Provided regular reports for management that measure the effectiveness of the technical support function.
• Debugged the code and providing instrumented builds and fixes for the issues reported by customers.
• Troubleshooting complex technical problems and worked with the customer and Informatica development to resolve technical roadblocks.
• Provided tuning guidelines for performance issues.

Environment: Informatica Power Center 10.X, Oracle11g, UNIX, Windows XP, Oracle PL/SQL,MS-Office.

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts like PMS and DEA.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Designed, Developed and Tested ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter.
• Responsible for database schema design, integration testing and other projects.

Environment: Informatica Power Center 9.6/10.x, Oracle 9i, Autosys, SQL, PL/SQL, Cognos, Unix AIX and windows XP.

Confidential

Jr. ETL Developer

Responsibilities:

• Involved in Project Analysis and documenting the dev requirements.
• Worked with ETL Architects, Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements using Informatica 7.1.1., and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.
• Wrote triggers and packages by using PL/SQL for giving security privileges.

Environment: Informatica Power Center 7.1.1, Oracle, SQL, PL/SQL, UNIX, Erwin, Windows NT.