Description

Key Responsibilities

Analyze and understand existing Perl scripts and ETL processes.

Convert and migrate legacy Perl scripts to Python.

Develop and maintain robust Python-based ETL solutions.

Write complex SQL queries for data extraction, transformation, validation, and reconciliation.

Support migration of existing ETL processes and data pipelines to Snowflake.

Assist with Snowflake data migration and integration activities.

Migrate applications, scripts, and data pipelines from on-premise/legacy environments to AWS.

Develop and optimize data pipelines using Python, SQL, and AWS services.

Perform data validation, reconciliation, troubleshooting, and performance tuning.

Collaborate with data engineers, architects, and business teams during the migration and modernization process.

Document existing and newly developed ETL processes and technical solutions.

Required Skills

Strong Python development experience.

Strong SQL skills.

Hands-on experience with Perl scripting.

Experience converting Perl scripts to Python.

Strong understanding of ETL/data migration processes.

Experience with Snowflake and Snowflake data migration.

Experience with AWS cloud migration and AWS data services.

Strong understanding of data transformation, data validation, and reconciliation.

Experience working with legacy application modernization and migration projects.

Preferred Skills

AWS services such as S3, Lambda, Glue, Redshift, and/or EC2.

Snowflake ETL/ELT and performance optimization.

Experience with CI/CD and Git.

Experience working in large enterprise or banking environments.

Knowledge of data warehousing and cloud data architecture.

Key Skills

Education

Bachelor's degree