Our client is a highly reputed bank.
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.
- Optimize queries, indexing strategies, and database configurations for better efficiency.
- 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:
- In-depth knowledge and hands-on experience with Teradata database technologies.
- Good understanding of Financial logical Data Model Teradata (FSLDM).
- 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.
- Strong skills in performance tuning of Teradata databases, including query optimization and indexing strategies.
- Understanding of data warehousing concepts and best practices.
- Knowledge of scripting languages like Python or Unix Shell scripting is a plus.
- Experience in customizing the FSLDM model
We regret to inform that only shortlisted candidates will be contacted.
PERSOLKELLY Singapore Pte Ltd • EA License No. 01C4394 • EA Registration No. R1551626 (SUJA THERESA FRANCIS)
**********************************
The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited.
By sending us your personal data and curriculum vitae (CV), you are deemed to consent to PERSOLKELLY Singapore Pte Ltd and its local and overseas subsidiaries and affiliates collecting, using and disclosing your personal data to prospective employers/companies based in any country for purposes of evaluating suitability for employment, conducting reference checks, administering employment related services and such other purposes stated in our privacy policy. Our full privacy policy is available at www.persolkelly.com.sg. If you wish to withdraw your consent, please drop us an emailto let us know. Please feel free to contact us if you have any queries.
All parties involved in any form of workforce engagement are to strictly adhere to prevailing regulations and laws that govern local fair employment practices, and to invest reasonable efforts in building a strong Singaporean core workforce, recruit and select candidates based on merit and prohibit discrimination based on age, race, gender, religion, marital status and family responsibility or disability. For more information, please refer to MOM and TAFEP websites.
**********************************