Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.
Work with an agile team to deliver and evolve the data platform services
Hands-on experience in Integrating Informatica Cloud (IICS)
Must have Kafka experience
3 plus years of experience distributed databases particularly in designing and implementing ETL processes; understanding of data models and data flow
Experience in dimensional data modelling, star schema designing, data loading, data replication, SQL Query writing and optimization on distributed databases preferably on Cloud Technologies.
Must have Kafka experience
Experience with AWS technologies
Working experience with distributed databases on cluster/platform.
Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments.
Performance tuning ETL process and user queries.
Develop the production process to automate the ETL and create documentation to transition the process to the Production team.
Experience in working in Agile methodology
Excellent oral and written communication.
Ability to handle multiple priorities and meet deadlines.