Teradata ETL Engineer

About Client

The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong emphasis on employee training and development. Client is known for its commitment to innovation and invests in research and development to stay at the forefront of technological advancements.

It offers a comprehensive set of services, including:

• IT Services:
  Application development, maintenance, and testing.
• Consulting:
  Business consulting, IT strategy, and digital transformation.
• Business Process Outsourcing (BPO):
  Outsourcing of business processes to improve efficiency.
• Enterprise Solutions:
  Implementation and support of enterprise-level software solutions.
• Digital Services:
  Services related to digital technologies, such as analytics, cloud, and IoT.

Salary: $120K/Annum

• Design and develop Teradata ETL jobs and data pipeline.
• Design, develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
• Extracting data from various data sources, transforming, and loading it into target systems.
• Ensuring data quality, integrity, and consistency across different systems.
• Developing and maintaining data warehouses, data lakes and data mart architecture.
• Optimizing ETL processes for performance, scalability and reliability.
• SQL proficiency (intermediate skill level minimum)
• Ability to manage Teradata/SQL Server/Oracle database migration including code migration, data loads and server retirements.
• Troubleshooting and resolving data integration issues.
• Solid skills with writing/translating SQL queries and SQL data validation.
• Performance tuning of SQL queries.