Data Engineer Snowflake + Kafka @ Zensar

Key
- Build, optimize, and maintain efficient data management workflows for event-driven processes.
- Write highly efficient PL/SQL blocks to process and manipulate data.
- Work on Snowflake pipelines (e.g., Snowpipe) for real-time and batch data ingestion.
- Collaborate with cross-functional teams to design and deliver scalable solutions.
- Support and monitor the live and staging environments, especially during critical events.
- Develop and maintain shell scripts for automation and orchestration of database tasks.
- Work with Kafka or Pub/Sub for real-time event streaming (optional but preferred).
- Ensure the high quality of deliverables by participating in code reviews and adhering to best practices for database development.

Qualification
- 5-6 years of professional experience as a Data Engineer or in a similar role.
- Strong expertise in writing PL/SQL blocks for Oracle or other relational databases.
- Hands-on experience with Snowflake and its ecosystem (e.g., Snowpipe, data sharing, and performance optimization).
- Proficiency in Oracle database management and SQL performance tuning.
- Experience with shell scripting for automation tasks.