Company Overview

Career Mantra is a leading organization in the Education industry, dedicated to empowering individuals with career counselling, skill development, and recruitment services. Located in Pune, our mission is to bridge the gap between talent and opportunity, providing personalized guidance, resume building, interview preparation, and corporate training. With a team size of 51-200 employees, we are committed to fostering growth and success for both job seekers and businesses.

Job Overview

We are seeking a highly skilled SQL Data Engineer to join our dynamic team at Career Mantra. This is a Senior-level position located in Pune with the flexibility of working remotely. The successful candidate will possess a maximum of 10 years of work experience, and be responsible for data management and analytics processes. This is a Full-Time employment opportunity, and the ideal candidate will demonstrate expertise in handling complex data systems.

Qualifications and Skills

• Strong proficiency in SQL, redshift, and code migration (Mandatory skill), ensuring efficient data processing and handling.
• In-depth understanding of data modeling techniques to structure and organize data effectively for analytics and reporting.
• Proven experience in designing and implementing ETL processes to seamlessly integrate and transform data from various sources.
• Robust knowledge of database management systems, reflecting an ability to optimize and maintain database performance.
• Experience with big data technologies, showcasing the capability to work with and analyze large volumes of data efficiently.
• Ability to collaborate with cross-functional teams to collect, analyze, and interpret data to drive informed decisions.
• Excellent problem-solving skills, with an innovative approach to designing data solutions that meet business requirements.
• Strong attention to detail, ensuring accuracy in data analysis and reporting to support organizational goals.

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.