Aws_Python_Redshift

Job Overview:

• An overview of the role at Infosys
• As a member of the Infosys consulting team, your main responsibility will be to delve deep into customer challenges, identify problem areas, create innovative solutions, and ensure successful deployment, ultimately leading to client satisfaction.
• You will take ownership of specific sections of the proposal document, contributing to solution design based on your areas of expertise.
• You will organize configuration activities, configure the product according to the design specifications, conduct conference room pilots, and assist in addressing any queries related to requirements and solution design.
• You will facilitate solution product demonstrations, conduct Proof of Concept (POC) workshops, and create effort estimates that align with the client's budgetary constraints while adhering to the organization’s financial guidelines.
• Take the lead on small projects and contribute to both unit-level and organizational initiatives aimed at delivering high-quality, value-added solutions to clients.
• If you believe you are the right fit to assist our clients in their digital transformation journey, this opportunity is for you.

Core Responsibilities:

• Redshift Engineer
• A minimum of 5 years of experience in Data Engineering and Data Warehousing, with a strong focus on Amazon Redshift.
• Design, develop, and sustain scalable Redshift data warehouses to meet enterprise analytics and reporting demands.
• Construct and execute Dimensional Data Models, including Star Schemas with fact and dimension tables tailored for analytical workloads.
• Develop, optimize, and troubleshoot intricate SQL queries for large-scale data processing and performance enhancement.
• Design and oversee ETL/ELT pipelines utilizing AWS Glue and other data integration technologies.
• Enhance Redshift performance using RA3 nodes, Distribution Keys, Sort Keys, and Redshift Spectrum effectively.
• Integrate data from diverse sources such as S3, PostgreSQL, APIs, and third-party applications into the data warehouse.
• Work collaboratively with Data Architects, Analysts, and Business stakeholders to deliver scalable and efficient data solutions.
• Ensure adherence to data quality, governance, security, and compliance across the AWS data platform.
• Hands-on expertise with AWS services such as S3, Lambda, IAM, CloudWatch, and familiarity with Python and PySpark.

Technical Qualifications:

• Primary skills include Cloud Technology, AWS Environment Provisioning, and Data Management on Cloud using NoSQL and Amazon DynamoDB.

Desired Skills:

• Cloud Platform expertise in AWS Database and Core services, along with Data Management on Cloud using AWS.