SUMMARY

• Around 7 Years of extensive experience in Data Warehousing.
• Worked on Informatica in UNIX environment.
• Sound knowledge in creating Tasks, Sessions, Worklets and Workflows in Workflow manager/designer.
• Good Understanding of DWH concepts.
• Strong understanding of performance tuning in Informatica and Oracle database, loading data into Data Warehouse/Data Marts using Informatica.
• Deep understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions
• Expertise in SQL
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experience in integration of various data sources like SQL Server, Oracle, IBM Mainframe Flat files, DB2 into the staging area
• Proficient working with Unix/Linux environments and writing UNIX shell scripts
• Worked on Various Databases Oracle, and DB2.
• Experienced in Performing Unit testing, system testing, regression testing and system integration testing.
• Excellent interpersonal, communication, documentation and leadership skills.

TECHNICAL SKILLS

OS: Windows95/98/2000/XP, Windows NT 4.0, UNIX, MS DOS

Languages: SQL and PL/SQL, Unix Shell scripting.

ETL Tools: Informatica Power Center 8.x.,9.x

Databases: Oracle 11g/10g/8i/9i, DB2, Sybase.

DB Tools: Toad, SQL*plus, SQL Developer, Aqua Studio

Scheduling Tools: Autosys

Reporting Tools: BO 6.5,BOXI

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. ETL Developer

Responsibilities:

• Working with business Analyst to understand requirements and developing Design documents.
• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using Informatica.
• Design and Development of Informatica mappings.
• Develop various BO Reports.
• Design Universe and modification of existing reports.
• Worked on WEBI reports.
• Used SCD type 2 to implement ETL.
• Design and Development of Workflows and load strategy.
• Used various transformations like Aggregator, Lookup Transformation, Expression Transformation, Filter Transformation etc.
• Worked extensively on reusable components like worklet, Command prompt’s and email notifications.
• Usage of parameter File concept for initializing the mapping parameters and Connection Strings.
• Worked with UNIX scripts for automation of ETL Jobs using Autosys Scheduler.
• Perform review of Session log files to trace causes of bottlenecks.
• Worked on scheduling of the Informatica job’s and design Load plan to maintain Data integrity.
• Documentation of Informatica mappings using standard templates.
• Responsible for overseeing the Quality procedures related to the project.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individual developed mappings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables

Environment: Informatica 9.5.1,BO 6.5, Oracle 11i, SQL Developer, Linux

Confidential - Edison, NY

ETL Developer

Responsibilities:

• Design, Development and Documentation of the ETL strategy to populate the repository from various source systems.
• Developed Functional design documents and Technical design specification documents for ETL Process.
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from mainframes and load to SQL server database.
• Extensively used transformations such as Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up (Target as well as Source), Update Strategy, Source Qualifier, Stored Procedure and Joiner.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Responsible for DefiningMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues
• Perform review of Session log files to trace causes of bottlenecks.
• Implemented optimization techniques in Mappings and Sessions for improving overall performance of workflows.
• Involved in primary unit testing, regression testing and system testing of mappings
• Involved in resolving various types of existing production issues by making code changes.
• Designed and developed a strategy for a specific and vital reporting need. Emphasis was on a design to support current and historic reporting.

Environment: Informatica 8.6.1, Oracle 10g, Sql Developer, PL/SQL, Linux

Confidential, Erie, PA

ETL Developer

Responsibilities:

• Working with business Analyst to understand requirements and developing Design documents.
• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using Informatica.
• Design and Development of Informatica mappings.
• Design and Development of Workflows and load strategy.
• Used various transformations like Aggregator, Ranker, Lookup Transformation, Expression Transformation, Filter Transformation etc.
• Worked extensively on reusable components like worklet, Command prompt’s and email notifications.
• Usage of parameter File concept for initializing the mapping parameters and Connection Strings and UNIX paths.
• Worked on scheduling of the informatica job’s and design Load plan to maintain Data integrity.
• Documentation of Informatica mappings using standard templates.
• Take Part in Migration from Development to QA.
• Responsible for overseeing the Quality procedures related to the project.
• Actively participated in the code review process and provided inputs to the team members

Environment: Informatica 8.6, Oracle 9i, DB2, Toad, Linux

Confidential

ETL Developer

Responsibilities:

• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using Informatica.
• Development of Mappings and Sessions.
• Development of reusable components like mapplet, worklet
• Development of Shell Scripts for file ftp and creation of parameter files.
• Performance tuning of sessions running for long time.
• Documentation of Informatica mappings using standard templates.

Environment: Informatica 8.6.1, Oracle 9i, SQL Developer, Linux

Confidential

ETL Developer

Responsibilities:

• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using Informatica.
• Development of Mappings and Sessions.

Environment: Informatica 7x, DB2, SQL Developer, Linux