SUMMARY:

• Over 7 + years of experience.
• Specialized in Data warehousing with expertise in Informatica, Oracle, Teradata, UNIX and for building complex data warehouses.
• Experienced in Design,Developing data warehouse applications in Extraction and transform loading
• Process using Informatica tools such as Repository Manager, Designer, and Server/Workflow Manager. Sound Perception of the latest ETL technologies & Tool Informatica.

HAS EXTENSIVELY WORKED ON:

• Informatica 9
• Oracle PL/SQL
• UNIX shell script.
• Maestro.
• Teradata
• Toad
• BTEQ scripts
• TPT Load

TECHNICAL SKILLS:

Operating System: Windows 2000 Professional, and Unix

Hardware: Dell System

Language: SQL, PL/SQL and Unix Shell Scripts

Tools: (BI and ETL)/Others: Informatica 8.6,TPT Loader

RDBMS: Oracle9i,Teradata

Scripting Language: BTEQ, FLOAD,MLOAD,Unix shell script.TPR Script

Servers: Citrix Metaframe Presentation server.

Automation Tools: Cron Jobs, Cronacle, Maestro scheduler.

Version control system: CVS,PVCS.

PROFESSIONAL EXPERIENCE:

Programmer Analyst

Confidential

Responsibilities:

• Application development and Support.
• Informatica mapping development and unit testing.
• Teradata BTEQ, FLOAD,MLOAD scripts coding and testing.
• Fix the Job failures and solve the incident tickets.
• Involved design and Code review meeting with development team.
• Worked on Implementation activity.
• Involved minor code fix and executed in production systems.
• Involved On call jobs activity under 24/7 support.

Confidential

ETL & Teradata Lead

Tools: Informatica Power Center 8.1.6(ETL), Business object, Unix, BTEQ,FLOAD,MLOAD

Responsibilities:

• Involved on R3V project related High level design and Detail design solutions.
• .Reviewed with ETL architect and get the sign off.
• Involved in build and unit testing for the design solutions.
• Involved in developing SFTP file transfer between two different systems.
• Developed teradata Fload and BTEQ scripts for the various stages of the project.
• Coordinated with Quality team and completed audit related works.
• Coordinated with Code review compliance team and provided the suggestion.
• Developed and executed the integration test case and test plan.
• Coordinated with Migration team and moved the code to Qual and Production.
• Conducted the KT session with support team.
• Involved in warranty support for two months for the completed projects.

Confidential

ETL & Teradata Developer

Tools: Informatica Power Center 8.1.6(ETL), Business object, Unix, BTEQ, TPT Loader, TBR scripts.

Responsibilities:

• Data conversion from oracle to Teradata using NBCU standards
• Migrate the Transactional and non transactional components to Teradata for the SML Modules..
• Convert the PL/SQL procedures and functions in to Informatica ETL.
• Convert the SML process norm, survey load, promo and online survey UNIX script to invoke the informatica workflow.
• Develop batch load in the place of the DB links used currently to interact with show tracker.
• Convert the SML crystal and Excel reports to work in Teradata environments.
• Comply with NBCU standards and guidelines for performance in the Teradata environments.

Confidential

ETL & Teradata Developer

Tools: Informatica Power Center 8.1.6(ETL), Business object, Unix, BTEQ, TPT Loader, tbr scripts.

Responsibilities:

• Study the existing projects and identify the ETL and database objects.
• Tables and Views creation for Database objects.
• Migration of Informatica mapping from Oracle to Teradata environment.
• Migration of Oracle Stored Procedure to Teradata Procedure and BTEQ Scripts.
• Performance tuning comparison between Oracle code and Teradata code.
• Loading of data from Oracle to Teradata tables using tbr Scripts.
• Creation of parameter files and passes the parameters to Informatica session and workflows.
• Execute the Informatica workflows and BTEQ, Stored procedures through UNIX shell scripts.
• Developed Unit Test report and test plan and tested the data.
• Defect Fixing for Development Issues
• Coordinate with Migration team and moved the codes from Dev to QA and QA to prod.
• Writing Production deployment Plan to deploy code into production.

Confidential

ETL Developer

Tools: Informatica Power Center 7.1.5(ETL),Redwood Cronacle2.0(scheduler), Business object, Unix, BTEQ

Responsibilities:

• Requirements analysis and preparing Design Document.
• Developing Construction after the design review.
• Used Parameter File to change Customer Type easily via end - user request.
• Involved in optimizing mappings.
• Monitoring Production system.
• Modifying Source Definition to reflect data warehouse and Sales data mart
• Creating Sessions.
• Performed Incremental, and Full Refresh load.
• Loading data from production to development to Generate Test Data.
• Involved in writing Unit Test cases.
• Defect Fixing for Development Issues .
• Writing Implementation Plan to deploy mapping into production.

Confidential

ETL Developer (Informatica)

Tools: Informatica Power Center 7.1.3(ETL),Redwood Cronacle2.0(scheduler), Business object,BTEQ,Unix

Responsibilities:

• Involving in develop requirement Specifications Analysis and Design documents.
• Developing Informatica Mapping, workflow, BTEQ and Unix Scripts.
• Worked the Hii Logs and updated into CVS Folder in GEHC.
• Run the workflow and Teradata scripts in Cronacle Jobs
• Validation and test the Data’s in Fact, dimension and Conformed Dimension tables.
• Involved in the system testing using automation tool and validate the data in each stage.
• Support with Migration team to move the Informatica, BTEQ scripts and Cronacle scripts from Development to QA and QA to Production.
• Support with PST Team and solve the production issues.

Confidential

ETL Developer (Informatica)

Tools: Informatica Power Center 7.1.3(ETL),Unix

Responsibilities:

• Created ETL specification based on the client requirement.
• Developed the Informatica Mapping and workflow for each stage.
• Interact with onsite team and update the task status and estimations.
• Implemented the Parameter generation Template and generated the Parameter file through UNIX shell script.
• Involved in Code review and Unit testing.