Company Overview

Career mantra is an esteemed educational advisory established in 2008, aimed at simplifying the course and college selection process for students pursuing undergraduate and postgraduate courses in India and abroad. With a robust database and an interactive platform, we offer detailed information on over 1,500 institutions and 25,000 courses, empowering students to make informed decisions. Our mission is to bridge the gap between students and their educational goals with comprehensive support.

Job Overview

We are seeking a talented SQL Data Engineer at a mid-level position to join our team remotely in Pune. This contract position requires proficiency in SQL, ETL processes, and Amazon Redshift and involves data integration and analysis to support our educational information platform. The ideal candidate will be passionate about leveraging data to enhance user experience and support our mission to guide students in their educational journey.

Qualifications and Skills

• Proficiency with SQL, ETL processes, and Amazon Redshift (Mandatory skill) for efficient data querying and transformation.
• Experience in data modeling to design and structure databases that support our institutional and course data.
• Strong database management skills to maintain and improve data storage systems ensuring easy retrieval and accuracy.
• Ability to perform data analysis for extracting meaningful insights from educational data to inform business decisions.
• Competence in data integration to combine information from various sources into unified structures.
• Skilled in data manipulation to transform raw data into usable formats through various operations and processes.
• Excellent problem-solving skills to tackle data issues and implement effective solutions promptly and efficiently.
• Effective communication skills to collaborate with team members and report on data findings and projects.

Roles and 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.