AWS Redshift Data Engineer

Infosys; Bengaluru; Presencial; INR 2.500.000 - 4.500.000; Jornada completa

Descripción de la vacante

Infosys in Bengaluru, Karnataka, is seeking a Data Engineer with 5+ years of experience in Data Warehousing and a strong background in Amazon Redshift. You will design and maintain scalable data warehouses, build star schema models, and optimize complex SQL queries for enterprise analytics.

You will implement ETL/ELT pipelines using AWS Glue, integrate data from S3, PostgreSQL, and APIs, and ensure data quality, governance, and security across the AWS data platform.

Formación

• 5+ years of experience in Data Engineering and Data Warehousing.
• Strong expertise in Amazon Redshift.
• Design, develop, and maintain scalable Redshift data warehouses.
• Build Dimensional Data Models (Star Schema) with fact and dimension tables.
• Develop, optimize, and troubleshoot complex SQL queries for large-scale processing.
• Design and maintain ETL/ELT pipelines using AWS Glue.
• Optimize Redshift performance using RA3 nodes, Distribution Keys, and Sort Keys/Redshift Spectrum.
• Integrate data from S3, PostgreSQL, APIs, and third-party apps.
• Collaborate with Data Architects, Analysts, and Business stakeholders.
• Ensure data quality, governance, security and compliance on AWS data platform.
• Hands-on experience with AWS services (S3, Lambda, IAM, CloudWatch) and Python/PySpark

Responsabilidades

• Design and implement scalable Redshift data warehouses for enterprise analytics.
• Develop and maintain dimensional models with star schemas.
• Create and optimize SQL queries for large data volumes.
• Build and manage ETL/ELT pipelines with AWS Glue.
• Integrate data from multiple sources like S3, PostgreSQL, and APIs.
• Work with stakeholders to deliver efficient data solutions.
• Ensure data quality, governance, and security across platforms.

Conocimientos

AWS Redshift

Python

SQL

PySpark

AWS Glue

Herramientas

AWS Glue

S3

PostgreSQL

APIs

Descripción del empleo

Aws_Python_Redshift

Primary skills: Technology->Cloud Platform->AWS Enviornment Provisioning, Technology->Data On Cloud - NoSQL->Amazon Dynamo DB, Technology->Data On Cloud - Platform->AWS Redshift Engineer

• 5+ years of experience in Data Engineering and Data Warehousing with strong expertise in Amazon Redshift.
• Design, develop, and maintain scalable Redshift data warehouses to support enterprise analytics and reporting needs.
• Build and implement Dimensional Data Models (Star Schema), including fact and dimension tables for analytical workloads.
• Develop, optimize, and troubleshoot complex SQL queries for large-scale data processing and performance improvement.
• Design and maintain ETL/ELT pipelines using AWS Glue and other data integration tools.
• Optimize Redshift performance through effective use of RA3 nodes, Distribution Keys, Sort Keys, and Redshift Spectrum.
• Integrate data from multiple sources such as S3, PostgreSQL, APIs, and third-party applications into the data warehouse.
• Collaborate with Data Architects, Analysts, and Business stakeholders to deliver scalable and efficient data solutions.
• Ensure data quality, governance, security, and compliance across the AWS data platform.
• Hands-on experience with AWS services (S3, Lambda, IAM, CloudWatch) and exposure to Python/PySpark