SUMMARY

• Having 8.8 years of progressively responsible Data warehouse experience in managing and Delivering projects using Teradata and Informatica Powercenter, Informatica BDE(Big Data Edition - Hadoop).
• Good understanding of the overall Software Development Life Cycle (SDLC).
• Experience in Development, execution and managing projects within the defined scope, timeline.
• In-depth knowledge of Teradata and Informatica and BDE(Big Data Edition) version.
• Hand on Experience in Usage of Hive queries.
• Proficient in understanding business processes/ Functional requirements and translating them into technical requirements
• Have very good experience in trouble-shooting techniques, tuning SQL statements, Query Optimization, Join Indexes.
• Hands on experience in Designing and Developing Informatica ETLs(mappings, workflows)
• Hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export)
• Expertise in slowly changing dimensions to maintain historical data using Type I, Type II and Type III strategies
• Experienced in Production and Development Environments.
• Involved in Development using Java, JSP, JDBC, CASPER Framework
• Efficient Communicator, Highly creative, motivated and result oriented.
• Very good logical skills suitable for process design, development & implementation
• Good problem solving skills for timely identification and resolution of issues and problems
• Excellent Inter-personal and Business communication skills.
• Good work ethics and “we can do” attitude with excellent communication & interpersonal skills and was successful in the customer delighted delivery.
• Ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Tools: and Utilities: BTEQ, TPUMP, FastLoad, MultiLoad, Toad, $Universe, Eclipse

ETL Tools: Informatica Power Center 9.5.1, 9.1.0, 8.6 & Informatica BDE (Big Data Edition - Hadoop)

Database: Teradata V2R6, 12, 13

Operating System: Windows (98/2000/Professional/XP)

Web Development Technologies: HTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, San Jose CA

Teradata/Informatica Architect

Responsibilities:

• Understanding the functional rules of the modules.
• Understanding the Existing logic and architecture and develop the New architecture(ETL approach) to load into Hadoop systems.
• Involved in Developing Informatica mappings using Informatica BDE version which supports both Teradata and Hadoop.
• Participated in Internal Reviews and Assessments.
• Using and understanding Informatica BDE and Hive Queries concepts so as to connect them with mappings and load data.
• Involved in Complete End to End process of Developing, Unit Testing, CR deployment.
• Providing technical guidance to team as required.

Confidential, San Jose CA

Teradata/Informatica Architect

Responsibilities:

• Understanding the functional rules of the modules.
• Understanding the Existing logic and architecture and develop the New architecture(ETL approach)
• Involved in Developing Informatica mappings with Dynamic lookups and Persistant Cache files so as to reduce the running time of ETL and number of hits to Database.
• Process compliance - effective reviews and checkpoints.
• Participated in Internal Reviews and Assessments.
• Using and understanding Teradata Utilities to load data with Loader connections in Informatica mappings
• Involved in Complete End to End process of Developing, Unit Testing, CR deployment.
• Providing technical guidance to team as required.

Confidential, Chattanooga Tennessee

Teradata/Informatica Tech Lead

Responsibilities:

• Preparing business requirement document, functional specification document.
• Preparing design documents, High level design and low level design.
• Understanding the functional rules of the modules.
• Involved in Development of BTEQ, FEXP, MLOAD scripts.
• Developed JCLs to execute the flow of developed Teradata Utility scripts.
• Process compliance - effective reviews and checkpoints.
• Participated in Internal Reviews and Assessments.
• Providing technical guidance to team as required.
• Capturing Requirement Volatility.
• Developed knowledge in customer product.

Environment: Teradata, Informatica, Mainframes

Confidential, San Jose CA

Teradata/Informatica Developer

Responsibilities:

• Handling job failures of fastload and multi load
• Modified Informatica code as per the requirement.
• Scheduling sessions through $U tool.
• Analyzing the cases raised by user.
• Creating CRs to change in database objects.
• Loading the data to Teradata using utilities.
• Scheduling of Informatica mappings.
• Providing Adhoc reports to users.
• Resolving Issues while loading the data to database through utilities.
• Implementing permanent fixes through CR.
• Attending Tele conferences with the Higher officials and taking Knowledge Transfer from Onsite Team

Environment: Teradata, Informatica 8.6.1, TD SQL Assistant 12.0, $Universe, Citrix, TOAD

Confidential, San Jose CA

Teradata/Informatica Prod Support

Responsibilities:

• Handling job failures of fastload and multi load.
• Developed Bteq scripts and modified Informatica Code.
• Scheduling sessions through $U tool.
• Analyzing the cases raised by user.
• Involved in creating CRs to change in database objects.
• Scheduling ETL mappings according to dependency
• Resolving Issues while loading the data to database through utilities.
• Implementing permanent fixes through CR.
• Completing the Scheduled run of Jobs of all Tracks with in SLA time.
• Attending Tele conferences with the Higher officials and taking Knowledge Transfer from Onsite Team

Environment: Teradata, Informatica 8.6.1, TD SQL Assistant 12.0, $Universe, Citrix, TOAD

Confidential, Bentonville Arizona

Teradata Tech Analyst

Responsibilities:

• Analyzing requirements and preparing the High level design & Detailed Design documents.
• Designing ETL Jobs based on the requirements using Informatica as the media
• Data migration between tables to meet the requirements for generating reports
• Generating Test Plans and documenting them according to the mapping documents
• Integrating all modules and performing Unit Testing and System Testing
• Documentation Reviews, Warranty support, Co-ordination, Status reporting and Customer interfacing
• Involved in Resource planning & Project Estimates along with Project Manager.

Environment: Teradata, Informatica, TOAD.

Confidential

Developer

Responsibilities:

• Understanding, Analysis and Review of Business/Technical Requirements
• Designing the HD (Harmonization Design), Review and walk thru with the clients
• Involved in Design, Development, Build in the application
• Coding using HTML pages, JSP and Java API
• Worked on resolving the Defects of other modules
• Preparation and Review of Unit Test Plans, Scripts and Results
• Testing - unit testing & integration testing of entire application

Environment: Java, JSP, CASPER, Eclipse, TOAD, Ant, eMatrix

Confidential

Software Developer

Responsibilities:

• Understanding, Analyzing and Review of Business/Technical Requirements
• Designing the HD (Harmonization Design), Review and walk thru with the clients
• Involved in Design, Development and Build of the module in an application
• Developed HTML pages, JSPs and Java code
• Worked on resolving the Defects of other modules
• Involved in Preparation and Review of Unit Test Plans, Scripts and Results
• Testing - unit testing & integration testing of entire application.