Description

You will design, implement, and maintain Teradata databases and ETL pipelines within AWS cloud environments.

Responsibilities

  • Design and maintain Teradata databases, including query optimization and performance tuning.
  • Develop and manage ETL processes using Teradata utilities like BTEQ, FastLoad, MultiLoad, and TPT.
  • Implement and manage Teradata on AWS infrastructure, including migrations from on-premises environments.
  • Deploy cloud infrastructure using tools like CloudFormation or Terraform to support data workloads.
  • Automate ETL pipelines and data processing workflows using AWS Lambda, Step Functions, or AWS Glue.

Required Skills

  • 5+ years of experience in data engineering.
  • In-depth knowledge of Teradata architecture, including AMP, Nodes, and Parsing Engines.
  • Proficiency in Teradata SQL and Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT).
  • Strong SQL skills for managing relational databases and querying complex datasets.
  • Experience with scripting in Python and Shell for task automation.
  • Hands-on experience with core AWS services including EC2, S3, RDS, Lambda, CloudWatch, and CloudFormation.
  • Knowledge of AWS networking, including VPC, subnets, security groups, and NACLs.
  • Understanding of data warehousing principles, star/snowflake schemas, and OLAP.
  • Experience with Infrastructure as Code using Terraform or AWS CloudFormation.

Preferred Skills

  • Experience integrating Teradata with AWS Redshift for analytics.
  • Familiarity with AWS Athena and Glue for complementary data workloads.

Key Skills
Education

Any Graduate

Back To Jobs