SUMMARY

• Around 7 Years experience in Analysis, Design, Development, Testing, Implementation, Enhancement and support of BI applications including strong experience as a Data Warehouse Consultant in Data Warehousing (ETL & OLAP) environment.
• Proficient with ETL tool Informatica Power Center 9.1/8.x/7.x in developing the Data warehouse loads focussing onData Integration.
• Expert in designing confirmed and traditional ETL Architecture involving Source databases Oracle, Flat Files, DB2, SQL server, and Target databases Oracle, Teradata and Flat Files.
• Knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. Knowledge in Data Flow Diagrams, Process Models, and ER diagrams with modeling tools like ERWIN & VISIO.
• Extensive experience in designing and developing complex mappings applying various transformations. Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementation the reconcile process accordingly.
• Excellent knowledge in identifying and resolving performance bottlenecks by tuning the Mappings and Sessions and implementing techniques like partitioning etc.
• Knowledge on database languages such as SQL and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Developed Teradata Loading and Unloading utilities like Fast Export, Fast Load, Bteq and Multiload.
• Extensive knowledge with Teradata SQL Assistant. Developed BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Good Experience in understanding business application, business dataflow and data relation.
• Excellent problem solving skills with a strong technical background and interpersonal skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center9.x/8.x/7.x Power Exchange, Data cleansing, OLAP, OLTP.

Data Modeling: Erwin 4.1/3.5.2.

Database: Teredata,DB2,Oracle 11g/10g/9i/8i, SQL Server 2005/2008

DB Tools: TOAD, SQL*Plus, PL/SQL Developer, SQL * Loader

Programming: SQL, PL/SQL, TSQL, C, Unix Shell Scripting

Environment: UNIX (Aix 5.3), MS Windows (XP, 2000, NT, 98)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica ETL Developer

Responsibilities:

• Interacted with business representatives for Requirement Analysis and to define Business and Functional Specifications.
• Participated in project planning sessions with project managers, team members to analyze business requirements and outline the proposed solution.
• Participated in the Design team and user requirement gathering meetings, and prepared technical and mapping documentation.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules.
• Developed Informatica mappings and mapplets extensively using different transformations and also tuned them for Optimum performance, Dependencies and Batch Design.
• Worked with workflow manager and workflow monitor to schedule batches and run the workflow and monitor session logs.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 9.1.
• Worked on Informatica Power Center 9.1 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
• Involved in creation and usage of stored procedures and loading of data into data marts using Informatica power center on Monthly basis.
• Designed and developed a reporting solution for a system using Oracle BI Publisher. Automated the reporting architecture using webservices to integrate with the system’s infrastructure.

Environment: Informatica Power Center 9.1, Oracle BI Publisher, Oracle 10g, SQL, Erwin 4.1, TOAD, Windows, UNIX.

Confidential -Columbus, OH

ETL Informatica Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Proficiently managed and created folders and users for ETL development using the Repository Manager module of the Informatica Power Center.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i RDBMS in accordance with requirements and specifications.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Performed Unit Testing and tuned the mappings for better performance.
• Created reusable transformations and mapplets.
• Writing PL/SQL procedures days of supply for processing business logic in the Database.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Worked on database connections, SQL Joins in Database level.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.

Environment: Informatica Power Center 8x, DB2, Oracle 9i/8i, SQL, PL/SQL, Flat files, XM, Windows NT.

Confidential -San Antonio, Texas

ETL Informatica Developer

Responsibilities:

• Created new mappings and updating old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i RDBMS in accordance with requirements and specifications.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Performed Unit Testing and tuned the mappings for better performance.
• Created reusable transformations and mapplets.
• Writing PL/SQL procedures days of supply for processing business logic in the Database.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Worked on database connections, SQL Joins in Database level.
• Extensively used SQL to load Data from flat files to Database tables In Oracle.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Using Unix Shell Scripting for scheduling Informatica workflows.
• Used calculations, variables, sorting, drill down, slice and dice for creating Stock Status Report.

Environment: Informatica Power Center 7x, Teradata, DB2, Oracle 9i/8x, Windows NT, Flat files, TOAD, SQL, PL/SQL.