SN843 Data
Job Title: Senior Teradata Data Engineer
Domain: Data
Sub-Domain: Enterprise Data Warehouse (EDW)
Experience Level: Senior (L3 – 6–9 years)
Location: Kuala Lumpur
Job Summary:
We are seeking an experienced Senior Teradata Data Engineer to design, develop, and maintain enterprise-scale data warehouse solutions. The ideal candidate will have strong expertise in Teradata, Informatica, and SQL, with experience building high-performance ETL pipelines, optimizing data models, and supporting large-scale data integration initiatives. The role involves collaborating with business stakeholders, data architects, and cross-functional teams to deliver reliable, scalable, and high-quality data solutions.
Key Responsibilities:
Design, develop, and maintain Teradata-based Enterprise Data Warehouse (EDW) solutions.
Develop, enhance, and support ETL workflows using Informatica.
Create and optimize complex SQL queries, stored procedures, and scripts for data processing and reporting.
Perform data modelling and implement enterprise data models such as FSLDM and MDM.
Optimize Teradata database performance through query tuning, indexing, and workload management.
Integrate data from multiple sources including Oracle, SQL Server, and other enterprise systems.
Perform data validation, reconciliation, and ensure data quality across the warehouse.
Troubleshoot production issues and provide timely resolution for data-related incidents.
Collaborate with business analysts, solution architects, and application teams to understand data requirements.
Prepare technical documentation, data flow diagrams, and deployment artifacts.
Support production releases and participate in code reviews while following development best practices.
Required Skills:
6–9 years of experience in Data Engineering or Enterprise Data Warehouse development.
Strong hands-on experience with Teradata database development and administration concepts.
Proficiency in Informatica PowerCenter for ETL development.
Advanced SQL programming and query optimization skills.
Experience working with Enterprise Data Warehouse (EDW) environments.
Knowledge of Master Data Management (MDM) and Financial Services Logical Data Model (FSLDM).
Experience with Oracle and SQL Server databases.
Familiarity with Linux and AS/400 operating systems.
Strong understanding of data warehousing concepts, dimensional modelling, and ETL best practices.
Excellent analytical, troubleshooting, and problem-solving skills.
Strong communication and stakeholder management abilities.
Nice-to-Have Skills:
Experience with cloud-based data platforms (AWS, Azure, or GCP).
Knowledge of data governance, data lineage, and metadata management.
Familiarity with CI/CD pipelines and DevOps practices for data engineering.
Experience with scripting languages such as Shell or Python.
Exposure to Agile/Scrum development methodologies.
Experience in the Banking or Financial Services industry.
Teradata or Informatica professional certifications.
About Accenture
Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.
Visit us at www.accenture.com
Equal Employment Opportunity Statement
We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.
Read Full Description