For an international project in Chennai, we are urgently looking for a Senior PL/SQL Developer with Dremio to design data solutions using Data Lake query engines, that guarantee stability, reliability, and performance. Focus is building Data Lake based large data and analytics platform using Dremio as a query engine, and multi-layered semantic approach to process and present data for varied usage.
We are looking for a contractor.
This position is long-term. Candidates need to be fluent in English.
Tasks and responsibilities:
- Design, development, and optimization of complex ANSI SQL query using Dremio as a Data Lake query engine to meet business requirements efficiently;
- Proactively identifying and addressing SQL query performance issues to ensure scalability and responsiveness;
- Planning and executing SQL, PL/SQL codes across ANSI SQL compliant query engines to ensure seamless transitions, optimized design, and performance;
- Understand and implement robust access control mechanisms, security protocols and compliance measures to protect sensitive data and ensure regulatory adherence;
- Investigating and simplifying complex data structures, leveraging expertise and experience in creating business friendly semantic view of data;
- Collaborate with cross-functional teams to align data solutions with organizational goals and data strategies;
- Maintaining comprehensive documentation of database architectures, processes, and best practices;
- Sharing knowledge and mentor junior developers;
- Make changes to code, perform unit testing, and assist the business team in user acceptance testing, adhering to all change management policies and procedures;
Profile:
- Master degree;
- +7 years of experience in data engineering or related roles, building and/or enhancing large data warehousing solutions, preferably in Azure cloud environment;
- +5 years of hands-on experience with advanced PL/SQL (expert knowledge required on SQL);
- +3 years using data lake query engines like Dremio or similar semantic query engines;
- Demonstrated experience in designing and implementing large-scale data solutions;
- Fluent in English;
