PROFESSIONAL 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 teh overall Software Development Life Cycle (SDLC).
• Experience in Development, execution and managing projects wifin teh defined scope, timeline.
• In-depth noledge 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
• Has 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 wif excellent communication & interpersonal skills and was successful in teh customer delighted delivery.
• Ability to follow through wif 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

ETL Teradata/Informatica Architect

Responsibilities:

• Understanding teh functional rules of teh modules.
• Understanding teh Existing logic and architecture and develop teh 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 wif 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

ETL Teradata/Informatica Architect

Responsibilities:

• Use ETL Approach for majority of data ingest like Simple and Light to Medium Transformations Continue to use ELT Approach for Large Complex Transformations
• Informatica used for data extraction and transformation
• Informatica / UNITY* for feeding teh load ready data to target systems
• Extend foundational aspects like Job Launch Framework, Auditing and Job Monitoring
• Define new ETL standards, estimation and complexity guidelines for retrofit
• Responsibilities:
• Understanding teh functional rules of teh modules.
• Understanding teh Existing logic and architecture and develop teh New architecture(ETL approach)
• Involved in Developing Informatica mappings wif Dynamic lookups and Persistant Cache files so as to reduce teh 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 wif 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

ETL Teradata/Informatica Tech Lead

Responsibilities:

• Preparing business requirement document, functional specification document.
• Preparing design documents, High level design and low level design.
• Understanding teh functional rules of teh modules.
• Involved in Development of BTEQ, FEXP, MLOAD scripts.
• Developed JCLs to execute teh 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 noledge 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 teh requirement.
• Scheduling sessions through $U tool.
• Analyzing teh cases raised by user.
• Creating CRs to change in database objects.
• Loading teh data to Teradata using utilities.
• Scheduling of Informatica mappings.
• Providing Adhoc reports to users.
• Resolving Issues while loading teh data to database through utilities.
• Implementing permanent fixes through CR.
• Attending Tele conferences wif teh 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

ETL 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 teh cases raised by user.
• Involved in creating CRs to change in database objects.
• Scheduling ETL mappings according to dependency
• Resolving Issues while loading teh data to database through utilities.
• Implementing permanent fixes through CR.
• Completing teh Scheduled run of Jobs of all Tracks wif in SLA time.
• Attending Tele conferences wif teh 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 teh High level design & Detailed Design documents.
• Designing ETL Jobs based on teh requirements using Informatica as teh media
• Data migration between tables to meet teh requirements for generating reports
• Generating Test Plans and documenting them according to teh 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 wif Project Manager.

Environment: Teradata, Informatica, TOAD.

Confidential

Developer

Responsibilities:

• Understanding, Analysis and Review of Business/Technical Requirements
• Designing teh HD (Harmonization Design), Review and walk thru wif teh clients
• Involved in Design, Development, Build in teh application
• Coding using HTML pages, JSP and Java API
• Worked on resolving teh 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 teh HD (Harmonization Design), Review and walk thru wif teh clients
• Involved in Design, Development and Build of teh module in an application
• Developed HTML pages, JSPs and Java code
• Worked on resolving teh Defects of other modules
• Involved in Preparation and Review of Unit Test Plans, Scripts and Results
• Testing - unit testing & integration testing of entire application.