CrawlJobs Logo

Specialist-Data Modelling and Engineering

https://www.allianz.com Logo

Allianz

Location Icon

Location:
India, Trivandrum

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Employment contract

Salary Icon

Salary:

Not provided

Job Description:

The role involves being a Production Support Engineer with a strong focus on ETL and Data Warehouse, monitoring and troubleshooting data pipelines, ensuring data integrity, collaborating with teams, and documenting processes. Requires expertise in Oracle databases, AWS, SQL/PLSQL, and DevOps tools.

Job Responsibility:

  • Monitor the daily data pipeline runs, ensure timely data loads by proactively identifying and troubleshooting issues
  • Perform RCA to identify the underlying causes of issues in the data warehouse and ETL pipelines
  • Document findings and implement corrective actions to prevent recurrence
  • Collaborate with various teams, including data engineers, DevOps Engineers, architects, and business analysts, to resolve issues and implement improvements
  • Communicate effectively with stakeholders to provide updates on issue resolution and system performance
  • Maintain detailed documentation of data warehouse configurations, ETL processes, operational procedures, and issue resolutions
  • Participate in an on-call rotation and operate effectively in a global 24*7 environment
  • Ensure data integrity and accuracy and take actions to resolve data discrepancies
  • Generate regular reports on system performance, issues, and resolutions.

Requirements:

  • Strong experience with Oracle databases and AWS cloud services
  • Proficiency in SQL and PL/SQL
  • Should be familiar with monitoring tools Dynatrace, CloudWatch, etc.
  • Familiarity with other AWS services such as Account creation, VPC, Cloud Front, IAM, ALB, EC2, RDS, Route 53, Auto scaling, Lambda, etc.
  • Experience with ETL tools and processes (e.g., Informatica, Talend, AWS Glue)
  • Familiarity with scripting languages (e.g., Python, Shell scripting)
  • Familiarity with DevOps tools and practices (e.g., GitHub, Jenkins, Docker, Kubernetes)
  • Strong analytical and problem-solving abilities
  • Experience in performing root cause analysis and implementing corrective actions
  • Ability to work independently as well as in a collaborative team environment
  • Excellent written and verbal communication skills
  • Bachelor’s degree in computer science, Information Technology, or a related field
  • Minimum of 3 years of experience in a support engineer role, preferably in data warehousing and ETL environments
  • Certification in AWS, Oracle, or relevant DevOps tools is a plus.

Nice to have:

Certification in AWS, Oracle, or relevant DevOps tools.

What we offer:
  • Hybrid work model including up to 25 days per year working from abroad
  • Company bonus scheme
  • Pension
  • Employee shares program
  • Multiple employee discounts (details vary by location)
  • Career development and digital learning programs
  • International career mobility
  • Flexible working
  • Health and wellbeing offers including healthcare and parental leave benefits.

Additional Information:

Job Posted:
May 27, 2025

Employment Type:
Fulltime
Work Type:
Hybrid work
Job Link Share:
Welcome to CrawlJobs.com
Your Global Job Discovery Platform
At CrawlJobs.com, we simplify finding your next career opportunity by bringing job listings directly to you from all corners of the web. Using cutting-edge AI and web-crawling technologies, we gather and curate job offers from various sources across the globe, ensuring you have access to the most up-to-date job listings in one place.