SUMMARY

• 8 years of IT experience with extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization. Experience in working with Erwin and TOAD.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Strong experience in coding using SQL, Procedures/Functions, Triggers and Packages.
• Extensively used SQL to write Stored Procedures, Functions, Packages and Triggers.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Actively involved in Performance Tuning, Error Handling Product support on various Platforms.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 7.1.3/8.6.1 , 9.1.0 Informatica Power Exchange 8.6.1

Web/Apps Servers: IIS, Tomcat

Databases: Oracle 10g/11g/9i, SQL Server 2008/2005/2000

Programming Languages: PL/SQL, SQL*Loader, SQL* Plus, and TOAD UNIX Shell Scripting.

Operating Systems: UNIX (Linux, AIX, Solaris), Windows 2000/NT/XP/Vista

Tools: SQL Loader, TOAD, VISIO, Eclipse

Software Packages: Windows 8 / 7 / Vista / XP / Microsoft Office 365(Cloud), 2013, 2010, 2007

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Developed Re-Usable Transformations and Re-Usable Mapplets.
• Developed ETL mappings, transformations using Informatica Power center 9.1
• 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.
• Created Informatica complex mappings with PL/SQL procedures/functions to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.

Environment: Informatica power center 9 .1, PowerCenter 8.6, InformaticaPowerExchange 8.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor),SQL Server, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files, SQL Developer, and Windows 8 / 7 Professional.

Confidential, Raleigh, NC

Informatica 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.
• 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 SCD2.
• Responsible in developing the ETL logics and the data maps for loading the tables.
• Responsible for migrating from Development to staging and to Production (deployments).
• Designed for populating Tables for one time load and Incremental loads.
• 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.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• 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.
• Monitoring and tracking the applications as per the schedule run.

Environment: Informatica power center 9 .1, PowerCenter 8.6, InformaticaPowerExchange 8.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Teradata, UDB, UNIX, Oracle 10g.

Confidential

Database Developer

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed Confidential regular intervals of time.
• Modified existing forms, reports, and graphs as per the enhancement.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Moved data from one database to other database, Used SQL*Loader for data migration.

Environment: Informatica 6.2, Oracle 8i, TOAD, Windows NT

Confidential

Database Developer

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Moved data from one database to other database, Used SQL*Loader for data migration.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed Confidential regular intervals of time.
• Analyzed the business requirements and functional specifications.
• Understanding the requirements specification and use case documents.
• Creation of test plan, test strategy and test approach.
• Involved in Daily and Weekly Status meetings.
• Creation of Test Summary report, traceability Matrix, Test Script Index.
• Monitor the testing project in Quality Center and ensuring defects are being entered, tested, and closed.
• Analyzed, documented and maintained Test Results and Test Logs.

Environment: Informatica 6.2, Oracle 8i, TOAD, Windows NT