SQL- DWH Developer

Required Qualifications & Skills:

• Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• Minimum of 5+ years of professional experience in backend software development, with a strong focus on systems using . NET Framework /. NET Core (C#).
• Proven, significant experience in backend software development using the . NET framework /. NET Core (C#, ASP. NET Web API, Entity Framework).
• Expert-level proficiency in T-SQL, including writing and optimizing complex queries, stored procedures, functions, and understanding database design principles (preferably with MS SQL Server).
• Demonstrated ability to read, understand, and analyze complex legacy code to determine functionality and troubleshoot issues effectively.
• Strong analytical and problem-solving skills, with experience in debugging and resolving production system issues.
• Experience in leading technical initiatives or mentoring junior engineers.
• Formal team lead experience is a strong plus, if for Lead level role.
• Solid understanding of software development lifecycle (SDLC), APIs, and backend architecture patterns.
• Excellent communication and interpersonal skills.

Responsibilities:

• Lead and Mentor: Guide, manage, and mentor a backend engineering team of approximately 4 members, fostering a collaborative and high-performing environment.
• Backend Development: Architect, design, develop, test, and deploy scalable and maintainable backend services, APIs, and database solutions using. NET (C#) and T-SQL.
• Enhancement Ownership: Take ownership of technical design and implementation for new features and enhancements requested for our POS and web platforms.
• Legacy System Expertise: Dive into existing codebases (.NET and T-SQL) to thoroughly understand current system functionality, data flows, and business logic, becoming a subject matter expert.
• Production Support: Act as a key escalation point for diagnosing and resolving complex production issues related to the backend systems. Perform root cause analysis and implement effective solutions.
• Technical Guidance: Provide technical direction, conduct code reviews, establish and enforce coding standards and best practices within the team.
• System Knowledge & Communication: Clearly articulate how backend systems work and answer technical questions from team members and other stakeholders.
• Collaboration: Work closely with front-end developers, QA testers, product managers, and potentially clients to deliver integrated solutions

Job Summary: 

We are in search of a proficient Java Lead with a minimum of 10 years' experience in designing and developing Java applications. The ideal candidate will demonstrate a deep understanding of Java technologies, including Java EE, Spring Framework, and Hibernate. Proficiency in database technologies such as MySQL, Oracle, or PostgreSQL is essential, along with a proven track record of delivering high-quality, scalable, and efficient Java solutions. 

We are looking for you! 

You are a team player, get-it-done person, intellectually curious, customer focused, self motivated, responsible individual who can work under pressure with a positive attitude. You have the zeal to think differently, understand that career is a journey and make the choices right. You must have experience in creating visually compelling designs that effectively communicate our message and engage our target audience. Ideal candidates would be someone who is creative, proactive, go getter and motivated to look for ways to add value to job accomplishments. 

As an ideal candidate for the Java Lead position, you bring a wealth of experience and expertise in Java development, combined with strong leadership qualities. Your proven track record showcases your ability to lead and mentor teams to deliver high-quality, enterprise-grade applications. Your technical proficiency and commitment to excellence make you a valuable asset in driving innovation and success within our development projects. You possess a team oriented mindset and a "get-it-done" attitude, inspiring your team members to excel and collaborate effectively.  

You have a proven ability to lead mid to large size teams, emphasizing a quality-first approach and ensuring that projects are delivered on time and within scope. As a Java Lead, you are responsible for overseeing project planning, implementing best practices, and driving technical solutions that align with business objectives. You collaborate closely with development managers, architects, and cross-functional teams to design scalable and robust Java applications.

What You Will Do: 

• Design and development of RESTful Web Services. 
• Hands on database experience (Oracle / PostgreSQL / MySQL /SQL Server).
• Hands on experience with developing web applications leveraging Spring Framework.
• Hands on experience with developing microservices leveraging Spring Boot.
• Experience with cloud platforms (e.g., AWS, Azure) and containerization technologies. 
• Continuous Integration tools (Jenkins & Git Lab), CICD Tools.  
• Strong believer and follower of agile methodologies with an emphasis on Quality & Standards based development. 
• Architect, design, and implement complex software systems using [Specify relevant technologies, e.g., Java, Python, Node.js. 

What we need? 

• BTech computer science or equivalent 
• Minimum 8 years of relevant experience in Java/J2EE technologies
• Experience in building back in API using Spring Boot Framework, Spring DI, Spring AOP
• Real time messaging integration using Kafka or similar framework 
• Experience in at least one database: Oracle, SQL server or PostgreSQL
• Previous experience managing and leading high-performing software engineering teams

Why join us? 

• Work with a passionate and innovative team in a fast-paced, growth-oriented environment. 
• Gain hands-on experience in content marketing with exposure to real-world projects.
• Opportunity to learn from experienced professionals and enhance your marketing skills. 
• Contribute to exciting initiatives and make an impact from day one.
• Competitive stipend and potential for growth within the company. 
• Recognized for excellence in data and AI solutions with industry awards and accolades. 

Employee Benefits:

1. Culture:

1. Open Door Policy: Encourages open communication and accessibility to management.
2. Open Office Floor Plan: Fosters a collaborative and interactive work environment.
3. Flexible Working Hours: Allows employees to have flexibility in their work schedules.
4. Employee Referral Bonus: Rewards employees for referring qualified candidates.
5. Appraisal Process Twice a Year: Provides regular performance evaluations and feedback.

2. Inclusivity and Diversity:

1. Hiring practices that promote diversity: Ensures a diverse and inclusive workforce.
2. Mandatory POSH training: Promotes a safe and respectful work environment.

3. Health Insurance and Wellness Benefits:

1. GMC and Term Insurance: Offers medical coverage and financial protection.
2. Health Insurance: Provides coverage for medical expenses.
3. Disability Insurance: Offers financial support in case of disability.

4. Child Care & Parental Leave Benefits:

1. Company-sponsored family events: Creates opportunities for employees and their       families to bond.
2. Generous Parental Leave: Allows parents to take time off after the birth or adoption of a child.
3. Family Medical Leave: Offers leave for employees to take care of family members' medical needs.

5. Perks and Time-Off Benefits:

1. Company-sponsored outings: Organizes recreational activities for employees.
2. Gratuity: Provides a monetary benefit as a token of appreciation.
3. Provident Fund: Helps employees save for retirement.
4. Generous PTO: Offers more than the industry standard for paid time off.
5. Paid sick days: Allows employees to take paid time off when they are unwell.
6. Paid holidays: Gives employees paid time off for designated holidays.
7. Bereavement Leave: Provides time off for employees to grieve the loss of a loved one.

6. Professional Development Benefits:

1. L&D with FLEX- Enterprise Learning Repository: Provides access to a learning repository for professional development.
2. Mentorship Program: Offers guidance and support from experienced professionals.
3. Job Training: Provides training to enhance job-related skills.
4. Professional Certification Reimbursements: Assists employees in obtaining professional      certifications.
5. Promote from Within: Encourages internal growth and advancement opportunities.

What We’re Looking For:

• Strong experience in Python (4+ years).
• Hands-on experience with any database (SQL or NoSQL).
• Experience with frameworks like Flask, FastAPI, or Django.
• Knowledge of ORMs, API development, and unit testing.
• Familiarity with Git and Agile methodologies.
• Familiarity with the Kafka tool (Added Advantage)

Role & Responsibilities:

• Individuals are responsible for all traditional development activities analysis, design, coding, testing, and documentation.
• Add new features to existing Windows and Web-based applications in Visual Studio 2019. Interacting with internal team.
• Transform business and design needs into innovative products.
• Drive all projects to completion within deadlines.
• Perform thorough testing to find issues ahead of time.
• Engineering software needs more precise analysis & coding skillset 
• Enhance skillset by working with fortune 500 clients
• Interacting with internal team. 

Qualifications:

• B.E in computer science or related fields.
• Hand on development experience with web & database technologies (MS SQL).
• Excellent programming & communication skills Strong problem solving, judgmental, and decision-making skills.
• Ability to work at the tactical and strategic levels of IT initiatives.
• Impressive hands-on experience in .Net technologies. Impressive hands-on experience and knowledge with C#, SQL, JSON, XML, Win Forms & MVC, Angular, JavaScript, jQuery , HTML/CSS.
• Self-Motivated, flexible & Innovative.

What You'll Do


You will be part of our data platform & data engineering team. As part of this agile team, you will work in our cloud native environment and perform following activities to support core product development and client specific projects:

• You will develop the core engineering frameworks for an advanced self-service data analytics product.
• You will work with multiple types of data storage technologies such as relational, blobs, key-value stores, document databases and streaming data sources.
• You will work with latest technologies for data federation with MPP (Massive Parallel Processing) capabilities
• Your work will entail backend architecture to enable data modeling, data queries and API development for both back-end and front-end data interfaces.
• You will support client specific data processing needs using SQL and Python/Pyspark
• You will integrate our product with other data products through Django APIs
• You will partner with other team members in understanding the functional / non-functional business requirements, and translate them into software development tasks
• You will follow the software development best practices in ensuring that the code architecture and quality of code written by you is of high standard, as expected from an enterprise software
• You will be a proactive contributor to team and project discussions

Who you are


• Strong education track record - Bachelors or an advanced degree in Computer Science or a related engineering discipline from Indian Institute of Technology or equivalent premium institute.
• 2-3 years of experience in data queries, data processing and data modeling
• Excellent ANSI SQL skills to handle complex queries
• Excellent Python and Django programming skills.
• Strong knowledge and experience in modern and distributed data stack components such as the Spark, Hive, Airflow, Kubernetes, Docker etc.
• Experience with cloud environments (AWS, Azure) and native cloud technologies for data storage and data processing
• Experience with relational SQL and NoSQL databases, including Postgres, Blobs, MongoDB etc.
• Familiarity with ML models is highly preferred
• Experience with Big Data processing and performance optimization
• Should know how to write modular, optimized and documented code.
• Should have good knowledge around error handling.
• Experience in version control systems such as GIT
• Strong problem solving and communication skills.
• Self-starter, continuous learner.

Good to have some exposure to

• Start-up experience is highly preferred
• Exposure to any Business Intelligence (BI) tools like Tableau, Dundas, Power BI etc.
• Agile software development methodologies.
• Working in multi-functional, multi-location teams

What You'll Love About Us – Do ask us about these!

• Be an integral part of the founding team. You will work directly with the founder
• Work Life Balance. You can't do a good job if your job is all you do!
• Prepare for the Future. Academy – we are all learners; we are all teachers!
• Diversity & Inclusion. HeForShe!
• Internal Mobility. Grow with us!
• Business knowledge of multiple sectors

Required Candidate profile

Must-Have:

• Core Java (Must be good in Core Java concepts, Java programming practices, Clean coding.)
• Spring Framework(Must have working experience in Spring Core)
• Any SQL framework(hands-on working experience in any of these: Hibernate/JPA/MyBatis/Spring Data/Others)
• Hands-on experience in REST API
• Hands-on experienceSQL Database(any of the databases: Oracle/MySQL/PostgreSQL/SQLServer)
• Must have working experience with basic GIT
• Maven or Gradle (Must have working experience in building Java projects using maven or Gradle.)
• Should be able to work independently under someone's guidance.

Good to have:

• Advanced Java(Threading, Performance optimization)
• Spring Boot
• Other Spring frameworks(Spring Security, Spring Batch, Others)
• Microservices - Any NoSQL database(MongoDB, Cassandra, others)
• Application designing concepts.

As an SDE, you will develop a deep understanding of our business, work closely with development teams and own the architecture and end-to-end delivery of software components.

Requirements:

• Exp: 3 - 8 years.
• 4 + years' experience building successful production software systems.
• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field).
• The ability to take convert raw requirements into good design while exploring technical feasibility tradeoffs.
• Expertise in System design (design patterns, LLD, HLD, Solid principle, OOAD, Distributed systems etc. ), Architecture (MVC/Micro services).
• Excellence in technical communication.
• Has experience in mentoring other software developers.
• BS/MS in Computer Science or equivalent.
• Experience developing service oriented architectures and an understanding of design for scalability, performance and reliability.
• Demonstrated ability to mentor other software developers to maintain architectural vision and software quality.
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
• Expertise in delivering high-quality, innovative application.
• Strong desire to build, sense of ownership, urgency, and drive.
• Strong organisational and problem solving skills with great attention to detail.
• Ability to triage issues, react well to changes, work with teams and ability to multi-task on multiple products and projects.
• Experience building highly scalable, high availability services.
• The ideal candidate will be a visionary leader, builder and operator.
• He/she should have experience leading or contributing to multiple simultaneous product development efforts and initiatives.
• He/she needs to balance technical leadership with strong business judgment to make the right decisions about technology choices.
• He/she needs to be constantly striving for simplicity, and at the same time demonstrate significant creativity, innovation and judgme.
• Proficiency in, at least, one modern programming language.
• Experience in SQL or Non-SQL database.
• Strong sense of ownership, urgency, and drive.
• Demonstrated leadership abilities in an engineering environment in driving operational excellence and best practices.
• Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
• Excellent communication, collaboration, reporting, analytical and problem solving skills.
• Good understanding of at least some of the modern programming languages (Java) and open-source technologies

Job Description: