Senior Data Engineer – ETL, Cloud & GenAI

EXASOFT CONSULTING PTE. LTD.

Singapore
Informatica powercenter idmc experience
Dbt data transformation skills
Aws redshift s3 glue migration
The role involves designing and optimizing ELT/ETL pipelines using Informatica, DBT, and Kafka for structured and semi-structured data

Job Summary

  • The role involves designing and optimizing ELT/ETL pipelines using Informatica, DBT, and Kafka for structured and semi-structured data.
  • Candidates will lead cloud migration projects moving on-premises data warehouses to AWS services like Redshift and S3.
  • The position requires automating infrastructure and deployments through Terraform, Git, and CI/CD pipelines while ensuring data quality.

Matching Summary

Match Score: 85

The role involves designing and optimizing ELT/ETL pipelines using Informatica, DBT, and Kafka for structured and semi-structured data.

Skills & Requirements

Must-have

  • Informatica PowerCenter IDMC experience
  • DBT data transformation skills
  • AWS Redshift S3 Glue migration
  • Python Shell scripting automation
  • Oracle PostgreSQL database management
  • Terraform Git CI/CD implementation

Nice-to-have

  • Kafka streaming platform knowledge
  • Advanced SQL PL/SQL performance tuning
  • Data lineage and governance expertise
  • Collaboration with analytics teams
  • Scalable data modeling strategies

Key Requirements

  • 5+ years of experience in Informatica and DBT
  • Strong SQL and PL/SQL proficiency required
  • Hands-on experience with Oracle and PostgreSQL databases
  • Practical background in AWS cloud migration projects
  • Proficiency in Python and Shell scripting

Work Rights

Not specified

Tailored Resume

Cover Letter