PROFESSIONAL SUMMARY:

• Total 15 Years of IT experience in different tools and technologies like Informatica, VLDB, Teradata, Vertica, Sybase, Oracle, and PL/SQL.
• Vital experience in Informatica Power Center 9.x/8.x/7.x/6.x, Data Warehousing, Data Integration, Business Intelligence as Sr. ETL/Informatica Developer, Oracle10g/9i/8i, SQL, PLSQL, Shell Scripts, Unix, Windows.
• Excellent 10 Years of experience in leading and mentoring development teams in different models.
• Recent exposure to informatica Web Service hub and WSDL development.
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle.
• Expertise in applying data integration concepts in Finance business verticals.
• Experience with business requirements gathering, business analysis and documentation.
• Strong analytical skills with a knack for problem solving.
• Highly skilled, motivated team player with excellent communication and inter - personal skills.
• Excellent in Performance Tuning.
• Experience in Writing JIL for scheduling for Autosys Job.
• Ability to work well under pressure and meet deadlines.
• Delivered end-to-end ETL Architecture solution and strategies for complex data integration projects

TECHNICAL SKILLS:

SETL Tools: Informatica PowerCenter 9.x/8.x/7.x, Sunopsis, ODI, Informatica Web Service Hub

Scheduling Tool: Tidal, Autosys

Database: Oracle (8i/9i/10g/11), Teradata, Vertica, Sybase, Netezza, DB2 and SQL Server

Core Technology: Oracle PL/SQL, SQL

Languages: C/C++, Java, Visual Basic

Operating Systems: MS Windows 95/98/2000/XP, MS Windows NT 4.0, UNIX (SunOS)

Other Tools: PL/SQL developer, TOAD, Squirrel, MS Studio, Rapid SQL

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Sr. Informatica Developer/ETL Architect

Responsibilities:

• Involved in code the requirements into mappings and shell scripts and tune those.
• Recently developed new product to use any Informatica workflow using WSDL and call by any SOAP UI using Informatica Web Service hub.
• Develop, test and maintain the code using perforce and labeling.
• Participated in the development and maintenance of a Date Warehouse Load Schedule.
• Performed production support duties on a 24/7 basis.
• Prepared Autosys jobs for scheduling daily batch.
• Extensively used PL/SQL to embed complex business logic in stored procedures.
• Extensive involvement in ETL code optimization, performance enhancements and code reviews.
• Use the deployment group from INFA for Production deployments.
• Implemented logic to control job dependencies between ETLs solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.
• Responsible for coordinating development and testing efforts with offshore team members.

Confidential, New York, NYC

Sr. Informatica Developer/Tech Lead

Responsibilities:

• Worked on more than 50 objects including INFA, DB and UNIX side.
• Participated in the development and maintenance of a Date Warehouse Load Schedule.
• Prepared Tidal jobs for scheduling daily batch.
• Extensively used Teradata to embed complex business logic in stored procedures.
• Implemented logic to control job dependencies between ETLs solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.
• Responsible for coordinating development and testing efforts with offshore team members.
• Involved in optimization of Lookup SQL queries in order to reduce lookup cache size.

Confidential, 70 Hudson St. Jersey City NJ

Sr. Informatica Developer/ETL Architect

Responsibilities:

• Worked on more than 100 objects including INFA, DB and UNIX side.
• Established Application Development Framework (Event Channel)
• Build Common User Interface/Portal.
• Consolidated / Shared Data Environments (ODS & DWH)
• Define Data Exception Types, proper data controls and daily checks.
• Expose Data Quality Exceptions to Operations
• Establish exception management process with IT and Operations.
• Involved in code the requirements into mappings and shell scripts and tune those.
• Participated in the development and maintenance of a Date Warehouse Load Schedule.
• Performed production support duties on a 24/7 basis.
• Prepared Autosys jobs for scheduling daily batch.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.
• Extensive involvement in ETL code optimization, performance enhancements and code reviews.
• Responsible for coordinating development and testing efforts with offshore team members.
• Worked on making session runs more flexible through the use of mapping parameters and variables and used parameter files and variable functions to manipulate them.

Confidential, Reston, VA

ETL/Informatica Lead

Responsibilities:

• Defined Target Load Order Plan and Constraint based loading.
• Wrote shell scripts to merge files, append timestamp to filenames and move files.
• Implemented entire ETL job plan (150 jobs) through Autosys scheduler.
• Translated the business processes into Informatica mappings.
• Design and development of CDC process using time-stamping method.
• Developed ETL sessions for initial full loading and incremental loading.
• Unit and Integration testing of Informatica mappings.
• Involved in ETL code optimization, performance enhancements and code reviews.
• Design ETL specifications, including data flow, source system selection, data quality and transformations.
• Design and Developed ETL best practices document (Development standards, File

Naming, design strategy source format, mapping design, reusable objects etc).

Confidential, Newark, NJ

Informatica Architect/Lead

Responsibilities:

• Design, Analysis and development of new ETL.
• Worked with materialized views to obtain optimal query performance.
• Supported the database application development team to tune their applications to suit the database needs.
• Involved in code for List Pulls and E-migration modules. The target is Oracle data base.
• Worked with Global Clients to understand the business requirements and implemented the business requirements in Data warehouse.
• Creation of XML files for source and target.
• Performed unit testing, point-to-point testing and integration testing to confirm ETL code integrity.

Confidential, NYC

ETL Lead/Admin

Responsibilities:

• Extensively involved in the current development processes of all Applications, gathered Business User Requirements and wrote in the Technical Design Documentation.
• Coordinated as Release Package Lead for production releases.
• Implemented Client Dimensions for Data warehouse and Data Mart layer
• Extensively created and reviewed unit, system and integration test cases for all cycles.
• Worked Extensively with Expression, Lookup, Joiner, Sorter, Aggregator, Update Strategy, Sequence Generator, Filter, Rank and Router transformations.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Gained working knowledge of Autosys jils at command line for loading/force starting jobs, changing job status and monitoring job progress.
• Documented all the technical work into high and low level design docs for team’s reference.

Confidential, Charlotte, NC

ETL Lead/Admin

Responsibilities:

• Documented analysis documents, PSAD, HLD, LLD and mapping documents for team’s reference.
• Extensively created Autosys jobs for scheduling purpose.
• Conducted new employee training sessions to provide insight of the working/functionality of Informatica workflows.
• Demonstrated ability to quickly grasp team guidelines, processes, practices and procedures. ETL and Data base coding like mappings, workflows and Stored Procedures.
• Design and Developed ETL best practices document (Development standards, File Naming, design strategy source format, mapping design, reusable objects etc, security, session best practices, deployment etc).
• Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines.

Confidential, Secaucus NJ

ETL Lead/Sr. ETL Developer

Responsibilities:

• Extensively participated in the workshops for gathering requirements
• Involved in implementation of requirements into ODI interfaces.
• Mainly worked on developing Scenarios, Interfaces, procedures and SQLs.
• Extensively worked on ETL and data base coding
• Learned to handle Service calls.
• Gained working knowledge of creating estimation plan for development.

Confidential

TL Lead/Sr. Informatica Developer

Responsibilities:

• Extensively worked directly with business to analyze their needs and priorities for these very large-scale and highly visible data mart projects.
• Gained knowledge of Developing complex Informatica mappings to load ODS, EDW and Data Marts and PL/SQL packages for reporting.
• Extensively involved in designing the monthly financial data reconciliation process
• Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines.
• Got the chance to coordinate with onsite team.
• Induction of new resources, knowledge acquisition, and knowledge transfers.
• Extensively involved in writing Oracle PL/SQL Stored Procedures/Functions/Packages and Triggers.