The company is looking to develop and manage its databases, build efficient ETL/ELT processes, and implement data warehousing solutions to support analytics and reporting. They also have a secondary interest in integrating CI/CD and cloud technologies into their data operations.
Requirements
- Strong experience in SQL development and query optimization.
- Hands-on experience with Snowflake (preferred), Oracle, or any relational database.
- Expertise in ETL/ELT development, preferably using Talend (or any other ETL tool).
- Strong proficiency in Advanced SQL scripting for data transformation and processing.
- Understanding of Data Warehousing concepts, including Star Schema and Dimension Modeling.
- Hands-on experience with Snowflake (preferred) or other cloud/on-prem data warehouses.
- Understanding of database indexing, partitioning, and performance tuning.
Responsibilities
- Develop and optimize SQL queries.
- Develop and optimize ETL/ELT processes.
- Design, develop, and optimize data pipelines for structured/unstructured data.
- Design and maintain Fact and Dimension tables for analytics and reporting.
- Implement error handling, logging, and recovery mechanisms for ETL processes.
- Perform database indexing, partitioning, and performance tuning.
- Manage data partitioning and performance tuning techniques in DWH environments.
Other
- Good to Have, Not Core Focus: CI/CD & Version Control
- Good to Have, Not Core Focus: Cloud Exposure