Sr Data Engineer at Horizontal Talent in Atlanta, Georgia

Job Description:

Our client is seeking a seasoned Sr. Data Engineer to join their dynamic team. The ideal candidate will have a deep understanding of Teradata architecture, SQL, scripting, ETL tools, and data warehousing principles. Proficiency in AWS services and experience in deploying and managing Teradata in AWS cloud environments is a must.

Key Responsibilities:

- Design, implement, and maintain Teradata databases, optimizing and tuning queries for performance.

- Develop and maintain ETL processes for data integration and transformation.

- Create and maintain data models to support business processes.

- Identify and resolve performance bottlenecks in SQL queries, system configuration, or data design.

- Implement data security best practices and ensure compliance with data governance policies and regulations.

- Implement and manage Teradata on AWS infrastructure, managing data migration from on-premises Teradata environments to AWS cloud-based Teradata instances.

- Design and deploy cloud infrastructure to support Teradata environments.

- Automate infrastructure provisioning, scaling, and monitoring using AWS tools.

- Leverage AWS data services to complement Teradata workloads and implement data pipelines using AWS services for ETL processes.

- Implement AWS security best practices to secure Teradata environments in the cloud.

- Collaborate closely with data architects, analysts, and other stakeholders to understand data needs and deliver solutions.

Required Skillsets:

- In-depth knowledge of Teradata architecture and components.

- Strong SQL skills for querying and managing relational databases.

- Scripting experience for automating tasks.

- Experience with ETL tools and technologies used in Teradata environments.

- Knowledge of query optimization techniques, indexing, partitioning, and workload management in Teradata.

- Strong understanding of data warehousing principles.

- Proficiency with core AWS services.

- Experience deploying and managing Teradata in AWS cloud environments.

- Hands-on experience with AWS CloudFormation, Terraform, or similar tools for automating infrastructure deployment.

- Understanding of encryption and security protocols for data stored and processed in AWS.

Our client is committed to fostering a diverse and inclusive environment. We encourage applications from individuals of all backgrounds, regardless of gender, race, ethnicity, religion, sexual orientation, age, disability, or other marginalized groups.