Aws_Python_Redshift

Infosys

5–7 yrs Bengaluru Full Time Hybrid (office + remote)
Infosys logo
Posted : today
Actively hiring

Job description

Join Infosys as a Consultant within our Data & Analytics Unit. This role focuses on transforming client challenges into innovative digital solutions. You will be instrumental in understanding customer needs, designing effective strategies, and ensuring seamless implementation for maximum client satisfaction.

Your contributions will involve developing compelling proposals, contributing to solution architecture, and meticulously configuring products to meet client specifications. You'll also lead crucial activities like conference room pilots and providing expert support for requirement and design-related queries.

Showcase product capabilities through demonstrations and workshops, and craft accurate effort estimates that align with client budgets and organizational financial frameworks. This is an opportunity to lead small projects, drive unit-level initiatives, and deliver high-quality, value-added solutions that empower clients on their digital transformation journey.

Responsibilities

Design, develop, and maintain scalable Amazon Redshift data warehouses to support enterprise analytics and reporting.

Construct and implement dimensional data models, including star schemas with fact and dimension tables, optimized for analytical workloads.

Develop, tune, and troubleshoot complex SQL queries for efficient, large-scale data processing.

Build and manage ETL/ELT pipelines utilizing AWS Glue and other data integration technologies.

Enhance Redshift performance through strategic application of RA3 nodes, Distribution Keys, Sort Keys, and Redshift Spectrum.

Integrate diverse data sources such as S3, PostgreSQL, APIs, and third-party applications into the data warehouse environment.

Collaborate with Data Architects, Analysts, and business stakeholders to deliver robust and scalable data solutions.

Uphold data quality, governance, security, and compliance standards across the AWS data platform.

Qualifications

A minimum of 5 years of experience in Data Engineering and Data Warehousing, with a strong command of Amazon Redshift.

Proficiency in designing, developing, and maintaining scalable data warehouse solutions.

Experience building Dimensional Data Models (Star Schema), including fact and dimension tables.

Skilled in developing, optimizing, and troubleshooting complex SQL queries for large datasets.

Hands-on experience with ETL/ELT pipeline development using AWS Glue and similar tools.

Expertise in optimizing Redshift performance using RA3 nodes, Distribution Keys, Sort Keys, and Redshift Spectrum.

Experience integrating data from various sources like S3, PostgreSQL, and APIs.

Familiarity with AWS services including S3, Lambda, IAM, and CloudWatch. Exposure to Python/PySpark is essential.

Possess a Bachelor of Engineering or Bachelor of Technology degree.

Essential Skills

Amazon RedshiftData WarehousingETLELTSQLDimensional Data ModelingAWS GlueAWSS3LambdaIAMCloudWatchPythonPySparkAWS Enviornment ProvisioningAmazon Dynamo DBAWS Core servicesAWS - Database Technologies

Highlights

  • Actively hiring

More Details

RoleAws_Python_Redshift
DepartmentData Engineering
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Infosys logo

Infosys

IT Consulting

Aws_Python_Redshift at Infosys | SkillMX | SkillMX