Company OverviewCareer Mantra, established in 2008, is an educational advisory platform known for simplifying course and college selection for students aiming for undergraduate and postgraduate studies in India and abroad. With a comprehensive repository featuring over 1,500 institutions and 25,000 courses, Career Mantra offers reliable data to over 10 lakh students. Our mission is to bridge the gap between students and their educational aspirations by offering detailed insights and personalized experiences. Headquartered in Gwalior, our dedicated team aims to empower and guide students to success.

Job Overview :

Career Mantra is seeking a Mid-Level SQL Data Engineer for a remote, contract position based in Pune. This role involves utilizing SQL expertise to manage our extensive educational databases, supporting our mission of empowering student decisions through reliable and detailed information. The ideal candidate will thrive in a remote work environment, contributing significantly to data operations that enhance our user experience and educational service delivery.

Qualifications and Skills:

• Proficiency in SQL, essential for managing and extracting valuable insights from large datasets. (Mandatory skill)
• Proven experience with Amazon Redshift, crucial for our cloud data warehousing solutions. (Mandatory skill)
• Expertise in ETL processes to ensure efficient data flow across systems. (Mandatory skill)
• Strong understanding of data integration techniques to harmonize disparate sources into cohesive datasets.
• Skilled in data manipulation, facilitating the transformation of data into useful, actionable information.
• Knowledge of data modelling to support and enhance database performance and integrity.
• Experience in database management to maintain robust, efficient, and secure data environments.
• Ability to perform data analysis, converting raw data into strategic insights for the organization.

Responsibilities :

• Redshift SQL Database Expertise: Possess expert-level knowledge and a minimum of 5 years of experience with Redshift SQL Database and stored procedures.
• Stored Procedures Debugging: Exhibit advanced skills in debugging stored procedures.
• Test-Driven Development: Understand and apply test-driven development concepts to stored procedures.
• Application Support: Provide software application support under the guidance of the Senior Engineer.
• Functionality Analysis and Improvement: Analyze software application functionality and recommend enhancements.
• Database Functionality: Ensure the effective database functionality of applications.
• Code Migration Management: Manage code migration across different environments to maintain synchronized functionality.
• Error Analysis and Escalation: Identify root causes of application errors and escalate significant concerns as needed.
• Configuration Changes and Updates: Keep detailed records of configuration changes and schedule application updates.
• Process Documentation and Monitoring: Document processes and monitor application performance metrics.