Description

You will lead the migration of ETL jobs and databases from on-premises environments to AWS, building new solutions and ensuring data quality.

This role is on-site.

Responsibilities

• Migrate on-premises ETL processes to AWS Glue PySpark, Redshift, and Aurora PostgreSQL.
• Design and implement scalable ETL solutions, APIs, and full-stack components as required.
• Automate and orchestrate ETL pipelines using AWS Step Functions, Airflow, and Lambda.
• Conduct data analysis, validation, and impact analysis to ensure data integrity and compliance.
• Provide production support, monitoring, and troubleshooting for cloud-based data services.

Required Skills

• 10+ years of experience in ETL development, data warehousing, and AWS cloud services.
• Proficiency in Informatica, DataStage, Korn Shell, Python, and Perl scripting on Unix/Linux.
• Strong expertise in SQL with DB2 (AIX), Amazon RDS, Aurora PostgreSQL, and Redshift.
• Experience with API development using REST and SOAP frameworks.
• Familiarity with Git/Bitbucket, Jenkins pipelines, and CI/CD processes.
• Ability to validate data using Excel, Python, and Tableau.
• Bachelor's degree in Computer Science, IT, or related field (or equivalent experience).

Preferred Skills

• AWS certifications and expertise in AI/ML.
• Familiarity with automotive industry data warehousing concepts.

Key Skills

Education

Any Graduate