Developer Programmer - 261312

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

Job Type: Permanent position | Full time position

Job Description

Designation / Job title : Developer Programmer - 261312 Primary or Mandatory skills :-

• AWS Redshift, S3, RDS, Oracle SQL/PLSQL, Jenkins CI/CD
• Databricks, Git version control, shell scripting

Good to have skills :

• Python
• Fivetran
• Tableau

Detailed Job description : - Role: Senior Developer Experience required for the job: 12-15 Years ? The senior developer is responsible for extracting, transforming, loading and validating client data. Manipulating and processing data using SQL/PLSQL.

? Strong experience with SQL Development including Stored Procedures, ideally on Redshift, Oracle, Databricks etc. ? Good understanding of AWS Redshift architecture and data distribution. ? Understanding of Data Lake strategies and implementation.

? Demonstrate experience in writing and executing UNIX shell scripts and Perl scripting ? Ability to automate the deployment process using Jenkins CI/CD ? Responsible for maintaining the code quality and standards ?

Expertise in building data models in Data Warehousing ? Expertise in migrating data across On Prem and Cloud Data Warehouse platforms.

? Good knowledge of Business Intelligence tools like Cognos, Tableau. ? Knowledge on version control systems to track changes in source code during software development. ? Experience in Insurance domain projects.

? Understanding of lean BI-Architecture. ? Working in an Agile environment. ? High-energy, detail-oriented and proactive with the ability to function under pressure in an independent environment.

? Strong communication skills - Excellent spoken and written English communication skills.