Lead SQL MIS Specialist

We are seeking SQL Specialists for our Finacle MIS team. The ideal candidate will have strong expertise in SQL and the ability to work with complex queries and database structures.

Key responsibilities include:

• Designing and executing SQL queries using various clauses such as WHERE, HAVING, GROUP BY, EXISTS, IN, WITH, UNION, UNION ALL, and JOIN.
• Writing and optimizing SQL joins, subqueries, and Common Table Expressions (CTEs).
• Implementing aggregate functions, indexing, partitioning, and window functions to improve query performance.
• Performing type casting and ensuring data integrity across different database operations.
• Collaborating with team members to analyse data requirements and develop effective data solution.
• The skill sets required for the role are,
• Proficiency in SQL, including joins, subqueries, and CTEs.
• Strong understanding of SQL clauses (WHERE, HAVING, GROUP BY, EXISTS, IN, WITH, UNION, UNION ALL, JOIN).
• Experience with aggregate functions, indexing, partitioning, and window functions.
• Knowledge of type casting in SQL.
• Ability to work in a collaborative environment and contribute to data analysis andsolutions.
• Control-M (Script) for scheduling jobs
• Finacle Software knowledge
• Unix Operations System
• If you have a passion for data and possess these skills, we encourage you to apply and be a part of our innovative team.