SUMMARY:

• Over 7+ Years of experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment as a Data Warehouse Consultant.
• Proficiency in utilizing ETL tool Informatica Power Center 9.1/8.x/7.x for developing the Data warehouse loads with work experience focused inData Integrationas per client requirement.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Oracle, Flat Files (fixed width, delimited ),DB2, SQL server, and Target databases Oracle, Teradata and Flat Files ( fixed width, delimited ).
• Having 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, ER diagrams with modeling tools like ERWIN & VISIO.
• Extensive experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• 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 performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques. 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.
• Excellent team player and self - starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS:

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

Databases: Oracle (9i/10g/11g), Teradata V2R5/V2R3, MS-Access,DB2.

OS: Sun Solaris, HP-UX, IBM AIX, Unix, Linux, MS-DOS, Windows.

Programming Skills: C++, Shell Scripting, PL/SQL

DB Tools: SQL*PLUS, SQL*LOADER, TOAD, SQL Navigator

DM Tools: Erwin, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Warren, MI

Sr. Informatica ETL Developer

Responsibilities:

• Worked with Business Users in requirements gathering and creating requirements Specification documents.
• Created Technical System Design documents, Low Level Design documents.
• Worked extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Worked on Informatica transformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected & Unconnected Lookup transformation, Sequence Generator, Transaction Control etc.
• Developed Informatica mappings/sessions/workflows - Extensively used Dynamic/Persistent Lookup cache techniques for minimizing the load window.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Involved in designing ETL data load strategy for SCD type 2, Dimensions and Fact tables, ETL reject handling, ETL restart recovery logic.
• Extracted source data from Flat Files, XML, Oracle and a relational warehouse.
• Involved in client interaction, analyzing issues with the existing requirements, proposing solutions and implementing the same.
• Involved in performance tuning SQL and Informatica mappings/sessions by session partitioning techniques.
• Migrated Informatica objects (mappings/sessions/work lets/workflows) from the Dev to QA to Production Environments.
• Created Unit test case templates (standardized formats).
• Involved in doing the effort analysis for new work requests/enhancements.
• Interfacing with various Technology and Business groups.

Environment: Informatica Power Centre 9.1 Oracle 11g, TOAD, SQL Server 2005, UNIX, Windows, Erwin

Confidential, Jacksonville, FL

ETL Developer

Responsibilities:

• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications.
• Participated in the Design team and user requirement gathering meetings, and prepared technical and mapping documentation.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter 8.6.
• Worked on Informatica PowerCenter 8.6 - 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.
• Extensively used different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules.
• Involved in the Development of informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Used PMCMD command to schedule sessions and batches.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.
• Involved in creation and usage of stored procedures and loading of data into data marts using Informatica power center on Monthly basis.
• Uploaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.

Environment: Informatica Powercenter 8.6, Oracle 10g, SQL, Erwin 4.1, TOAD, Windows, UNIX.

Confidential, New York, NY

Informatica Developer/ Data Analyst

Responsibilities:

• Interacted with business users and business analyst to understand reporting requirements and prepared Functional Requirement document.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Developed complex mappings using Lookups connected and unconnected, Rank, Sorter, Joiner, Aggregator, Filter, Router transformations to transform the data as per the target requirements.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the Workflow Manager.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and rectified them.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user using Informatica Power Exchange 7.1s
• Developed Procedures and Functions in PL/SQL.
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
• Developed Schedules for daily and weekly batches using Maestro.
• Prepared ETL mapping specification document.
• Assisted Testing team in creating test plan and test cases.
• Conducted KT sessions for support team to familiarize the business rules of the applications and issues faced during UAT for ease of future maintenance.

Environment: Informatica Power Center 8.1, Power Exchange 7.1, Oracle 9i, SQL Server, Erwin, MS Access.

Confidential, Elizabeth, NJ

Informatica Developer

Responsibilities:

• Interacted with Business personnel to analyze the business requirements and transform the business requirements into technical requirements.
• Developed and supported the extraction, transformation and load process (ETL) for Data Warehouse from the source systems using Informatica.
• Created Reusable Transformation and Mapplets in the designer using transformation developer and Mapplet designer according to the business requirements.
• Wrote SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using Source Qualifier, Joiner, Aggregator, Lookup, Router, Expression, Update Strategy, Sequence Generator etc.
• Debugging code, testing and validated data after processes are run in development/testing according to business rules.
• Prepared unit test plans and maintained defect logs to resolve issues.
• Communicated with the Team to prepare unit test plans, to find solutions for the defects/issues and to share business knowledge.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed them and implemented performance tuning logic on targets, sources, mapping, sessions to provide maximum efficiency and performance.
• Used Workflow manager and Workflow monitor to create, run and monitor the sessions.
• Extensively used TOAD to check if data is properly loaded into target systems by writing SQL Queries.
• Tuned performance of Informatica sessions for large data files by implementing pipeline Partitioning and increasing block size, data cache size, sequence buffer length, and target based commit interval and resolved bottlenecks.

Environment: Informatica Power Center 7.1.2, Oracle 8i, SQL, TOAD, PL/SQL, Flat files, Sybase, Erwin Designer, Windows NT, Solaris 9.

Confidential, Framingham, MA

ETL/Informatica Developer

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Created ER diagram of the data model using Erwin data modeler to transform business rules into logical model.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Used Source Qualifier, Aggregator, Lookup, Expression, Stored Procedure Transformations.
• Extensively worked with Informatica Designer. Designed and developed Informatica mappings for data loads and data cleansing.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Created Sessions and Batches to run Workflows.
• Responsible for writing unit test cases and performing the unit test.
• Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.
• Involved in Production support and trained the other developers to handle issues.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Documented the ETL process and also issues encountered during UAT and production support for ease of future maintenance.

Environment: Informatica Power Center 6.1.1, Oracle 8i, XML, Toad, SQL Navigator, Erwin, UNIX, Business Objects 6.5, Windows 2000

Confidential

DW Developer

Responsibilities:

• Extracted data from multiple sources, which include relational sources, flat files and XML files.
• Developed Mappings and Workflows using Informatica Powercenter 6.1
• Helped data modeler in designing data model for Data warehouse using Erwin tool.
• Created numerous mappings using Router, Expression, and Update Strategy, Lookup transformation, and other transformations.
• Scheduling and Monitoring Workflows, Worklets and tasks using Workflow Monitor.
• Implemented performance tuning techniques at system, session, mapping, transformation, source and target levels.
• Worked with Oracle, SQL Server and flat file sources.
• Designed and Implemented plan for all types of data movement requested and approved by management.
• Developed Unit test mappings with the test data.

Environment: Informatica PowerMart6.1, Oracle8i, PL/SQL, SQL*Plus, UNIX, Windows 2000.