SUMMARY

• Over 8 years of experience in Data Warehouse / Data Mart Projects using ETL tools Informatica and Data Stage
• Over 6 years of solid ETL (Extract Transform Load) Data Warehouse experience using Informatica Power Center 8.X, 7.X, 6.X, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gantt Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Informatica Power Connect, Performance Tuning and Error Handling .
• Extensive experience in Data warehousing tools including Informatica Power Mart / power Center 7x/6x/5x, Oracle 9.x/8.x/7.x, MS Access 1997/2000, OLTP, OLAP
• Experience in working on analytical projects with statistical and business analysts.
• Experience working cross platforms UNIX, Windows, and MVS Z/OS.
• Experience in all phase of software development like Requirement gathering, coding and testing, also to develop quick reports for End users.
• Strong experience with Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager and Informatica Server Manager, Workflow Manage/Monitor.
• Analyze information requirements and business rules based on current documentation, source system understanding and from JAD sessions.
• Fine tune the design for performance improvements based on the end user access tool (OLAP).
• Analyze source system data structures and map target schema to source data structures.
• Experience with data quality, data reengineering, and data standardization.
• Developing programs filter, integrate, transform, standardize and process the extracted data.
• Extensive experience in Creating Repository, Source, Target Databases.
• Solid work experience of MS Excel, MS Word, MS power point and MS Office 2013.

TECHNICAL SKILLS

Data Warehousing ETL: Talend, Informatica Power Center 9.X, 8.X, 7.X, 6.X, Data Stage 7.5, 8.5

Databases: Sybase, Oracle 10g, Oracle 9i, Oracle 8i, DB2

Scripting Languages: UNIX Shell scripting, Basic VB Scripting

Programming Languages: SQL, PL/SQL, Oracle, Unix Shell Scripts (Unix Bash shell,), COBOL, JCL and IBM DB2.

Utilities: Oracle Enterprise Manager, Data pump, Export/Import, SQL Trace, SQL*PLUS, Microsoft Visio, File Aid/Marvel, Putty.

Productivity tools: TOAD, SQLPLUS, Rapid SQL, File Aid, Edit Plus, File Marvel, expeditor, Telnet and FTP, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, VA

ETL Informatica Developer

Responsibilities:

• Extensively used all standard ACTIVE, PASSIVE, Re-Usable transformations, session, Workflows and all other critical components involved in a typical ETL project development
• Extensively worked with performance tuning at mappings level like implementing active transformation like filter as early as possible in the mappings.
• Worked extensively with update strategy transformation for implementing inserts and updates
• Worked with connected lookup and un-connected lookup.
• Extensively used all common Informatica 9.5.1 transformations, mapplet’swith standard process and procedures

Environment: Informatica Power Center 9.5.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Oracle, SQL, SQL Scripting, UNIX Shell Scripting, Microsoft Visio

Confidential, Basking Ridge, NJ

ETL Informatica Developer

Responsibilities:

• Extensively used all standard ACTIVE, PASSIVE, Re- Usable and non-reusable transformations, session, Work flows and all other critical components involved in a typical ETL project development
• Extensively worked with performance tuning at mappings level like implementing active transformation like filter as early as possible in the mappings.
• Involved in support of 500+ Informatica objects
• Worked extensively with update strategy transformation for implementing inserts and updates
• Worked with connected lookup and un-connected lookup.
• Extensively used all common Informatica 9.0 transformations, mapplet’swith standard process and procedures

Environment: Informatica Power Center 9.5.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Oracle, SQL, SQL Scripting, UNIX Shell Scripting, Microsoft Visio, SQL Server

Confidential, Philadelphia, PA

ETL Developer

Responsibilities:

• Responsible for gathering the requirements both functional and technical documentation.
• Worked with the business analysts in requirement analysis and technical specification preparation to implement the ETL workflow procedures and process.
• Extensively worked with various active and complex transformations.
• Creating Audit scripts for testing validations
• Worked in Data partitioning, split data streams.
• Worked with complex lookups configured the same for implementing complex logic.
• Created re-usable transformations and mapplets.
• Responsible for gathering functional specifications and converting it into mapping documents.
• Involved in creating UNIX shell scripts.

Environment: Informatica 9.1, SQL Server 2005, SQL Scripting, UNIX Shell Scripting, Microsoft Visio, TOAD, Windows XP.

Confidential, Mooresville, NC

Informatica Developer

Responsibilities:

• Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input, and Mapplet Output transformations
• Worked with the Joiner transformation using Normal Join, Master outer join, Detail Outer Join, and Full Outer Join
• Experienced in various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database, and Shared Cache
• Used transformations like Router, Sorter, Connected Lookup, update strategy, Expression, Aggregator and Joiners.
• Have experience in debugging and performance tuning of mappings
• Used SQL overrides, and Lookup overrides and involved in creating UNIX shell scripts.
• Used various data cleansing functions in Informatica and data conversion functions.
• Worked along with QA team to fix the defects

Environment: Informatica Power Center 9.0.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Sybase 5, Oracle 10g, TOAD, SQL Scripting, UNIX Shell Scripting, Windows XP, Tidal Scheduler.

Confidential

Software Programmer

Responsibilities:

• Worked extensively with Oracle Stored Procedures, Sub Queries, triggers, and Views
• Developed UNIX shell scripts and scheduled using BSD’s “cron” schedulers.
• Responsible for requirement gathering and meetings with the end users
• Coded complex functions and procedures using PL/SQL
• Generated custom reports in SQL Plus
• Worked with ETL team and gather requirements.
• Designed Mappings using Data Stage Designer to load incrementally.
• Involved in performance tuning of Data Stage jobs at stage level, buffer level.
• Used DS manager for nodes creation and dataset management.
• Extensively worked in Java, JDBC.
• Involved in SQL performance tuning using cost based optimizer and Oracle SQL Advisor recommendations.

Environment: ETL tool, Data Stage, Oracle, SQL, PL/SQL, IBM AIX, UNIX Shell Scripts, SQL*Loader, Java, HTML.