Teradata Architect

Detailed Job Summary

 

• Teradata Architect with hands on experience in developing solutions to develop and manage Enterprise Data Warehouse for customer business need.
• Excellent hands-on knowledge on Teradata tools and technologies for the solution implementation. Technical architect involved in requirement gathering, Analysis, Technical solution designing and architecture and Implementation of DWH using Teradata, ETL and ELT methods
• At least one project experience on Migration experience from legacy warehouse to Teradata
• Interact with customers and their business users to gather requirements to develop and to clarify program objectives for their Teradata Datawarehouse and Business Intelligence
• Create technical solution design documentation based on the customer requirements and develop specific program/code to satisfy the business needs
• Create processes based on Teradata Solution Methodology (TSM) and standards for implementing the Teradata database and ETL/ ELT architecture accordingly
• Create Mapping design documents from source to logical and logical to physical model. Worked on mapping source systems with PDM (Physical data model)
• Analysis and design of ETL process flow documentation and Technical Specification documentation. Creating high level design documents for individual mapping customization
• Designing ETL/Semantic layer architecture and development of Teradata Views, Macros, Stored procedures, Join Indexes. Advanced hands on experience on Teradata Database Administration, performance improvement activities, System administration, SQL tuning activities
• Experience and understanding of Physical Data Model and perform activities like Physical design and implementation of database objects. Worked on DDL conversions, DDL creation from physical data model using Erwin, adding new entities, attributes, building relationships, creating PI/PPI's based on data profiling, DDL generation and deployment of database objects. Performed activities like Create Tables, Views, macros, Stored Procedures
• Develop Semantic Views on Teradata and Extract BI Reports using TPT and UNIX Shell scripts
• Data Analysis and Correction & Performance Tuning on Teradata database
• Work on performance tuning of SQL scripts using explain plan technology and analyzing the data distribution among AMPs and index usage, optimizing stored procedures for faster execution, using Analytic and OLAP functions in semantic layer views for faster data retrieval
• Involved with complete lifecycle of the project execution starting from Solution designing, Architecture build, ETL estimations, work allocation, tracking, development, unit testing, SIT, UAT, Production implementation and Operations support and contribute to the custom development of certain key modules
• Engage in change and impact analysis; effort estimations and tracking, conduct quality reviews and walk throughs
• Coordinating application development for multiple projects/modules, assist in troubleshooting and resolving issues related to database objects, ETL/ELT code
• Identify modifications needed in existing applications to meet changing user requirements, also work towards enhancing existing processes for better performance and standardization