4 Loops Jobs

As an Intern at Rancho Labs, you will be responsible for conducting interactive game development sessions using MakeCode Arcade, Roblox Studio, and Lua scripting for school students. Your role will involve assisting in designing structured lesson plans, hands-on projects, and engaging gaming exercises. You will guide students in creating interactive games by implementing animations, game physics, and custom game logic. Additionally, you will provide mentorship and support for debugging, problem-solving, and enhancing gameplay mechanics. You will introduce students to key game development concepts such as coordinates, motion control, loops, timers, and AI elements in gaming. It will be essential to stay updated with the latest trends in game development and integrate them into the lessons. Collaboration with the curriculum team to enhance learning materials and assignments will be a crucial aspect of your role. Furthermore, you will be responsible for assessing students" progress and providing constructive feedback to aid in their learning journey. Rancho Labs is an ed-tech company founded in 2019 by IIT Delhi alumni and professors. The company's mission is to inspire students" interest in technology fields like Artificial Intelligence, Coding, and Robotics through engaging experiential learning. Rancho Labs offers a variety of programs tailored for students from Grade 3 to 12, including workshops, long-term courses, and summer camps. These programs focus on hands-on learning, enabling students to build real-world projects such as traffic light systems, chatbots, and clap-activated lamps. Rancho Labs has delivered over 100,000 hours of learning, trained more than 30,000 students, and facilitated the development of over 250 innovations. The company operates both online and offline, with locations across Delhi, including IIT Delhi, Saket, and Gurugram.,

You will be responsible for performing joins such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins of two or more tables. Additionally, you will be expected to work with Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve working with Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER. You should have a good understanding of creating and maintaining Views and Materialized Views, as well as executing Hierarchical queries for data retrieval from tables with hierarchical data structures. Furthermore, you will be required to handle Complex Queries involving Nested queries, inline views, correlated subqueries, and have basic knowledge of Table Partitioning including table and index partitioning. In addition, you must have proficiency in PL/SQL and be able to create and maintain objects like procedures, functions, packages, types, and triggers. Your expertise should also include recursion, loops (FOR, WHILE DO), nested blocks, conditional logic (IF, CASE statements), and managing exceptions effectively. Moreover, you should be familiar with working with Collection & Records in PL/SQL blocks and executing BULK operations efficiently. Requirements: - Minimum of 2 years of relevant experience in posgress SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred certifications: - PL/SQL Developer Certified Associate Preferred Location: - Mumbai: Thane, Mulund, Bhandup, Vikroli, Ghatkopar, Kurla, and Powai Notice Period: - Immediate Joiner required This is a full-time position with a flexible schedule. You will be expected to work day shifts from Monday to Friday with morning shifts and weekend availability. Performance bonuses will be provided based on your contributions. Ability to commute/relocate to Mumbai, Maharashtra is required. Ideally, you should have a total of 1 year of work experience.,

You will be responsible for performing JOIN operations such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins on two or more tables. Additionally, you will handle Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve utilizing Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER for data analysis. You should be adept at working with Views and Materialized Views, understanding the basics of creating and maintaining views. Proficiency in executing Hierarchical queries for data retrieval from tables with hierarchical data is essential. Your expertise in handling Complex Queries like Nested queries, inline views, and correlated subqueries will be crucial. Knowledge of Table Partitioning, including table & index partitioning, is required. You will be expected to work with PL/SQL, creating and maintaining objects such as procedures, functions, packages, types, and triggers. Familiarity with recursion, loops (FOR, WHILE DO), nested blocks, and conditional logic (IF, CASE statements) is necessary. You must possess experience in managing Exception handling for run-time Oracle defined/user-defined errors. Understanding the usage of collections and records in PL/SQL blocks is vital. Proficiency in BULK operations for performing operations on bulk data is a must. Requirements: - Minimum 2 years of relevant experience in PostgreSQL SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: Preferred certifications: - PL/SQL Developer Certified Associate Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred Location: (Mumbai) Thane, Mulund, Bhandup, Vikhroli, Ghatkopar, Kurla, and Powai Notice Period: Immediate Joiner required. Job Types: Full-time Benefits: - Flexible schedule Schedule: - Day shift, Monday to Friday, Morning shift - Weekend availability Performance bonus offered. Ability to commute/relocate: - Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Experience: - Total work: 1 year (Preferred),

Python Fullstack developer JD Job Summary : We are seeking a motivated and skilled Full Stack Python Developer with 2 to 4 years of experience. The ideal candidate should have hands-on experience in developing web applications using Python frameworks like Django or Flask and basic to intermediate frontend development skills. Roles & Responsibilities : Develop, test, and maintain web applications using Python (Django/Flask) and JavaScript. Build user interfaces using HTML, CSS, and JavaScript (React/Angular is a plus). Work with databases such as MySQL, PostgreSQL, or MongoDB. Create and integrate REST APIs and third-party services. Collaborate with team members on design, development, and deployment. Participate in code reviews and contribute to improving development standards. Troubleshoot and resolve bugs or performance issues. Stay updated with current trends and technologies in web development. Required Skills: 2-4 years of experience in full stack development. Proficiency in Python and web frameworks like Django or Flask. Good knowledge of HTML, CSS, JavaScript. Exposure to frontend frameworks like React.js, Vue.js, or Angular is a plus. Experience with REST APIs and integrating third-party services. Understanding of relational databases (MySQL, PostgreSQL) and/or MongoDB. Familiarity with version control tools like Git. Basic understanding of deployment and cloud services is a plus. Preferred Qualifications : Bachelors degree in Computer Science, Engineering, or a related field. Strong analytical and problem-solving skills. Ability to work in a team-oriented, collaborative environment. Willingness to learn and adapt to new technologies Call/Whatsapp - 8591200199 HR Diksha