AWS Cloud ETL Engineer (Redshift and EMR) at Infosys Limited in Charlotte, North Carolina

Job Description:

Infosys is looking for a skilled AWS Cloud ETL Engineer with expertise in Amazon Redshift and Amazon EMR to join our talented team. As an AWS Cloud ETL Engineer specializing in Redshift and EMR, you will be responsible for:

Key Responsibilities:

• Design, develop, and implement ETL pipelines using Amazon Redshift and EMR (Elastic MapReduce) to extract, transform, and load data from various sources into our data warehouse.


• Collaborate closely with data architects, data engineers, and stakeholders to understand data requirements and ensure ETL processes align with business needs.


• Optimize and tune ETL workflows for performance, scalability, and cost-efficiency on AWS cloud infrastructure.


• Implement data quality checks, monitoring, and error handling mechanisms to ensure data integrity and reliability.


• Work with large datasets and big data technologies to process and analyze data efficiently.


• Troubleshoot and resolve issues related to data processing and ETL workflows in Redshift and EMR environments.


• Document ETL processes, data mappings, and system architecture.

• Candidate must be located within commuting distance of Charlotte, NC, Maryland, MO or willing to relocate to these areas.


• Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.


• At least 4 years of experience with Information Technology.


• At least 3 years of hands-on experience in Service Oriented Architecture
  


• At least 3 years of experience using Amazon Redshift and EMR (Elastic MapReduce)


• At least 3 years of experience working with ETL Tools: Matillion, Informatica, Apache Airflow, AWS Glue, or similar.


• At least 3 years of experience with Programming Languages: Python, JavaScript, Bash Scripting


• At least 3 years of experience with Databases: PostgreSQL, MySQL, Oracle 11g, SQL Server


• U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

• API and Frameworks: API, REST web services


• AWS Services : EC2, S3, Glacier, IAM, Kinesis, Cloud Front, Cloud Watch, Code Pipeline, Code Build, Elastic Beanstalk, EFS, VPC, RDS, API Gateway, RedShift, EMR, Cloud Formation etc


• Source Code Management: GIT, BitBucket, Code Commit