PROFESSIONAL SUMMARY:

• Having 9.1 years of progressively responsible Data warehouse experience in managing and Delivering projects using Teradata and Informatica Powercenter, 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, Informatica Powercenter and Big Data Edition.
• Hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export)
• 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(workflows, Pushdown Optimization techniques, Performance tuning)
• 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 EXPERTISE:

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

ETL Tools: Informatica Power Center 9.6.1,9.5.1, 9.1.0, 8.6 & Big Data Edition

Database: Teradata V2R6, 12, 13, 14,15

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

Web Development Technologies: HTML, JavaScript

TECHNICAL SKILLS

Confidential

Informatica Lead Designer

Responsibilities:

• Understanding the functional Requirements from Client.
• Developed Sqoop command to loa raw data from HDFS file system to Teradata Tables.
• Developed mappings in Powercenter to load data from Teradata source to Teradata final Integration layer to accommodate both history data and Incremental data so as to put the entire data copy in Teradata systems.
• Involved in Leading a team and designing Architecture along with High level architects.
• Involved in Developing Informatica mappings using Powercenter version.
• Involved in development of mappings using Pushdown Optimization along with performance tuning so as to reduce the bottlenecks at the Transformations.
• Participated in Internal Reviews and Assessments.
• Involved in Complete End to End process of Developing, Unit Testing, UAT.
• Providing technical guidance to team as required.
• Following Naming Standards throughout the process.

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.
• Developed mappings in Powercenter to load raw data from Source systems to Hadoop systems. Developed mappings in Big Data edition version (Developer tool) to accommodate both history data and Incremental data so as to put the entire data copy in Hadoop systems.
• Created externally managed Hive tables to load the data form different sources to Hadoop systems.
• Involved in Developing Informatica mappings Big Data Edition version which supports both Teradata and Hadoop and also Powercenter version.
• Involved in development of mappings using Pushdown Optimization along with performance tuning so as to reduce the bottlenecks at the Transformations.
• Participated in Internal Reviews and Assessments.
• Using and understanding Informatica Big Data Edition 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:

• Currently the Dual Load process is performed so as to make: High availability during planned and unplanned outages, Reduce data latency and enable reporting on Prod2, Re-distribute the load between two systems.
• 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 the 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 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.
• Involved in development of mappings using Pushdown Optimization so as to reduce the bottlenecks at the Transformations.
• The mappings contain the logic which is optimal and less hit to database kind architecture to reduce the load on the Database.
• Process compliance - effective reviews and checkpoints.
• Participated in Internal Reviews and Assessments.
• Using and understanding Teradata Utilities like Multiload, TPUMP and Fastload 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

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.
• Handling job failures of Fastload and multi load
• Modified Informatica code to provide an optimal solution and used Pushdown Optimization techniques to avoid bottlenecks during data process.
• Scheduling sessions through $U tool.
• Analyzing the cases raised by user.
• Creating CRs to change in database objects.
• Loading the data to Teradata using TPUMP Fastload and Multiload 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 TPUMP and Fastload.
• 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
• 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
• 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.