Description

You will design and implement ETL processes to load external feeds into warehouse and data mart tables.

Responsibilities

• Create and enhance ETL jobs to manage data loading into warehouse and data mart tables.
• Support User Acceptance and Integration testing environments by researching anomalies and refreshing environments.
• Tune ETL processes and user queries to improve performance.
• Automate production ETL processes and document workflows for production team transitions.
• Collaborate within an agile team to evolve data platform services.

Required Skills

• Over 3 years of experience designing and implementing ETL processes in distributed databases.
• At least 1 year of hands-on experience with Informatica Cloud (IICS).
• Proficiency in SQL query writing and optimization on distributed databases.
• Experience with AWS technologies.
• Strong understanding of relational, star schema, and dimensional data models.
• Experience with data modeling, schema design, data loading, and data replication.
• Working knowledge of Kafka and ETL workflows.
• Experience working with distributed databases on clusters or platforms.
• Ability to work within Agile methodologies.

Key Skills

Education

Any Graduate