Apache Calcite Developer

CLOUDSUFI is seeking an Apache Calcite Senior Developer with at least 6+ years of experience to join their team in Noida, India (Remote work is also available). As an Apache Calcite Developer, you will play a crucial role in designing and building JDBC connectors using Apache Calcite for various relational and cloud-based data sources. Your responsibilities will include developing custom adapters, optimizing queries, supporting complex data operations, and performance tuning. **Job Responsibilities:** - **JDBC Connector Development with Apache Calcite:** - Design & Build JDBC Connectors: - Develop JDBC connectors for various data sources using Apache Calcite for query parsing, optimization, and execution. - Implement custom adapters for different databases to ensure seamless data access and accurate SQL translation. - Query Optimization & Rewriting: - Utilize Apache Calcite's query optimization features to enhance query performance. - Modify Calcite's relational algebra or add new optimization rules based on specific data sources or performance requirements. - Support Complex Data Operations: - Enable optimal execution of complex data operations across multiple sources via JDBC connectors. - Extend Calcite's relational algebra to handle specific business logic or SQL dialects. - **Performance Tuning and Monitoring:** - Optimize Query Execution: - Analyze query execution plans and improve query efficiency using Calcite's query planner. - Monitor performance bottlenecks and apply optimization strategies. - Troubleshoot Performance Issues: - Identify and resolve performance issues related to query execution, translation, and database communication. - **Development Best Practices:** - Follow TDD, code reviews, and CI/CD pipelines for high-quality, maintainable code. - Create unit and integration tests to validate JDBC connectors. - Stay updated with new releases of Apache Calcite and related technologies. **Required Qualifications:** - 2+ years of Ruby experience - 3+ years of Kotlin experience - 2+ years of Java development experience, particularly in building JDBC connectors - Strong experience with JDBC connectors for relational and cloud-based databases - Working experience with Looker Ruby and Kotlin SDKs - Deep understanding of Apache Calcite's architecture and SQL - Experience with query optimization and custom rules using Apache Calcite - Hands-on experience with SQL parsers and query translation layers **Non-Technical/ Behavioral competencies required:** - Experience working with US/Europe based clients - Excellent verbal and written communication skills - Analytical and problem-solving skills - Task prioritization and time management skills - Quick learner and team player - Experience working under stringent deadlines - Demonstrated Organizational Citizenship Behavior (OCB),