Description

Build and optimize data integration processes within a distributed cloud environment, owning the ETL pipeline lifecycle from design to production automation.

This role is on-site.

Responsibilities

• Create and enhance ETL jobs to load external feeds into warehouse and data mart tables.
• Tune ETL processes and user queries for optimal performance in distributed databases.
• Automate production ETL workflows and document procedures for the production team.
• Support User Acceptance and Integration testing by researching anomalies and refreshing environments.

Required Skills

• 3+ years designing and implementing ETL processes with distributed databases.
• 1+ years hands-on experience integrating Informatica Cloud (IICS).
• Proficiency in SQL query writing and optimization on distributed databases.
• Experience with Kafka, AWS Redshift, and S3.
• Strong understanding of relational, star schema, and dimensional data models.
• Experience with data modeling, schema design, data loading, and data replication.
• Working knowledge of AWS technologies and distributed database clusters.

Preferred Skills

• Any Graduate degree.

Key Skills

Education

Any Graduate