Senior Data Warehouse Engineer | AWS/Redshift & CI/CD

Tech Mahindra; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Tech Mahindra is seeking a Senior Developer Programmer in Sydney to handle data extraction, transformation, loading, and validation for client data, using SQL/PLSQL on AWS Redshift, Oracle, and Databricks.

The role requires strong scripting skills (UNIX shell, Perl) and experience automating deployments with Jenkins CI/CD, ensuring code quality and standards. BI tools like Tableau are also part of the responsibilities.

Qualifications

• Senior Developer with 12-15 years experience in data extraction, transformation, loading and validation of client data.
• Strong SQL development experience including stored procedures; Redshift/Oracle/Databricks.
• Experience with AWS Redshift architecture, data distribution, and data lake concepts.

Responsibilities

• Extract, transform, load and validate client data using SQL/PLSQL.
• Write and execute UNIX shell scripts and Perl scripting.
• Automate deployments with Jenkins CI/CD and maintain code quality.
• Build data models in Data Warehousing and migrate data across On Prem and Cloud platforms.
• Collaborate on BI tools like Cognos/Tableau and track changes via version control.

Skills

AWS Redshift

S3

RDS

Oracle SQL/PLSQL

Jenkins CI/CD

Databricks

Git version control

shell scripting

Python

Fivetran

Tableau

Job description

Tech Mahindra is seeking a Senior Developer Programmer in Sydney to handle data extraction, transformation, loading, and validation for client data, using SQL/PLSQL on AWS Redshift, Oracle, and Databricks.

The role requires strong scripting skills (UNIX shell, Perl) and experience automating deployments with Jenkins CI/CD, ensuring code quality and standards. BI tools like Tableau are also part of the responsibilities.