Data Engineer (Teradata)

Responsibilities

Design, develop, and implement Teradata database solutions.
Map source system attributes to targets within the FSLDM.
Map FSDLM structures to target structures in downstream data marts.
Create and optimize SQL queries for efficient data retrieval and manipulation.
Work on database modeling, indexing, and partitioning to ensure optimal performance.
Develop and maintain ETL processes using tools like Teradata Utilities (Fast Load, MultiLoad, BTEQ, etc.).
Collaborate with data architects and other teams to ensure seamless data integration across different platforms.
Identify and resolve performance bottlenecks in Teradata databases.
Contribute to the design and maintenance of data warehouse structures.
Implement data warehousing best practices and standards.
Implement and maintain data security measures, including access controls and encryption, to ensure data integrity and confidentiality.
Provide support for Teradata-related issues, troubleshoot problems, and implement solutions.

Skills/Requirement

Bachelor’s degree in Engineering/Compute Science /Information Technology
In-depth knowledge and hands-on experience with Teradata database technologies.
Good understanding of Financial logical Data Model Teradata (FSLDM) is preferred.
Proficient in writing and optimizing complex SQL queries.
Experience with Teradata utilities such as FastLoad, MultiLoad, BTEQ, and other ETL tools.
Familiarity with data modeling concepts and the ability to design efficient database structures.
Experience in customizing the FSLDM model is preferred.