pathologist

Role - ETL Developer

Work Mode - Hybrid

Experience- 4+ years

Location - Pune, Gurgaon, Bengaluru, Mumbai

Required Skills - AWS, AWS Glue, Pyspark, ETL, SQL

Required Skills:

• 4+ years of hands-on experience in MySQL, including SQL queries and procedure development
• Experience in Pyspark, AWS, AWS Glue
• Experience in AWS ,Migration
• Experience with automated scripting and tracking KPIs/metrics for database performance
• Proficiency in shell scripting and ETL.
• Strong communication skills and a collaborative team player
• Knowledge of Python and AWS RDS is a plus

About Us:*

Yocket is the largest and most active community-driven online platform for international education, founded in 2015. Our mission is to connect students with the world’s best learning opportunities. Having assisted over 1 million students in pursuing higher education globally, we continue to empower students to make informed decisions about their academic journeys. Our platform is a hub for exploring universities, connecting with peers and alumni, and gaining insights into the study abroad process.

We are proud to be recognized as one of the Top 100 Indian Startups by Google and MeitY and ranked #18 on the AppStore’s Education charts. Join us at Yocket to make a meaningful impact on students' futures!

*Role Overview:*

We are looking for a talented Video Editor Associate to join our creative team. In this role, you will oversee video projects from start to finish, editing raw footage into polished, engaging content that aligns with Yocket's marketing objectives. You will work closely with various teams to ensure that the creative vision is executed consistently across all marketing channels. If you’re passionate about video editing and eager to contribute to impactful projects, this is the perfect opportunity for you!

*Key Responsibilities:*

Video Production & Editing: Oversee and manage video projects from initial concept to final delivery, ensuring high-quality output.

Collaboration & Creative Vision: Work with the marketing team to ensure videos align with Yocket’s goals and maintain consistency in creative vision.

Incorporate Visual Features: Add engaging visual elements to videos for promotional, educational, and tech product-related content.

Brand Consistency: Maintain brand guidelines and consistency across all video content to ensure a unified marketing message.

Assist with Remote Shoots: Support video shoots, including remote shoots, and help manage timelines and deadlines.

Stay Updated: Continuously learn about and integrate the latest video editing trends and techniques to enhance content quality.

*Requirements:*

Experience: 1-3 years of video editing experience, preferably in Ed-Tech or related industries.

Skills:

Proficient in Adobe Creative Suite (Photoshop, Illustrator, Premiere Pro).

Strong aesthetic sense and attention to detail.

Solid time management skills to handle multiple video projects simultaneously.

Experience with text animation and graphical representation in videos.

Basic knowledge of After Effects and Figma is a plus.

*Benefits:*

Comprehensive Benefits: Physical and mental well-being benefits to support overall health.

Flexible Work Hours: 5-day workweek with flexible working hours to maintain a healthy work-life balance.

Ownership & Mentorship: A culture of ownership where your contributions are valued, with opportunities for mentorship and growth.

About the company

Sigmoid is a leading data solutions company that partners with Fortune 500 enterprises to drive digital transformation through AI, big data, and cloud technologies. With a focus on scalability, performance, and innovation, Sigmoid delivers cutting-edge solutions to solve complex business challenges.

About the role

You will be responsible for building a highly scalable, extensible, and robust application. This position reports to the Engineering Manager.

Responsibilities:

• Align Sigmoid with key Client initiatives
• Interface daily with customers across leading Fortune 500 companies to understand strategic requirements
• Ability to understand business requirements and tie them to technology solutions
• Open to work from client location as per the demand of the project / customer
• Facilitate in Technical Aspects
• Develop and evolve highly scalable and fault-tolerant distributed components using Java technologies
• Excellent experience in Application development and support, integration development and quality assurance
• Provide technical leadership and manage it day to day basis
• Interface daily with customers across leading Fortune 500 companies to understand strategic requirements
• Stay up-to-date on the latest technology to ensure the greatest ROI for customer & Sigmoid
• Hands on coder with good understanding on enterprise level code
• Design and implement APIs, abstractions and integration patterns to solve challenging distributed computing problems
• Experience in defining technical requirements, data extraction, data transformation, automating jobs, productionizing jobs, and exploring new big data technologies within a Parallel Processing environment

Culture:

• Must be a strategic thinker with the ability to think unconventional / out-of-box
• Analytical and solution driven orientation
• Raw intellect, talent and energy are critical
• Entrepreneurial and Agile: understands the demands of a private, high growth company
• Ability to be both a leader and hands-on "doer"

Qualifications:

• Years of track record of relevant work experience and a computer Science or a related technical discipline is required
• Experience in development of Enterprise scale applications and capable in developing framework, design patterns etc. Should be able to understand and tackle technical challenges and propose comprehensive solutions
• Experience with functional and object-oriented programming, Java or Python is a must
• Experience in Springboot, API, SQL
• Good to have: GIT, Airflow, Node JS, Python, Angular
• Experience with database modeling and development, data mining and warehousing
• Unit, Integration and User Acceptance Testing
• Effective communication skills (both written and verbal)
• Ability to collaborate with a diverse set of engineers, data scientists and product managers
• Comfort in a fast-paced start-up environment
• Experience in Agile methodology
• Proficient with SQL and its variation among popular databases

• Design, develop, test, deploy, maintain, and improve software and new user-facing features across Novo’s products and services.
• Drive technical decisions on a multi-functional, Agile team alongside product management, product design, and engineering.
• Optimize applications for maximum speed and scalability and analyze feedback from customers and internal teams to identify issues and improvement opportunities. 
• Champion a passion for engineering best practices such as code quality, linting, and testing.
• Ensure our software is reliable, extensible, maintainable, debuggable, secure, well-tested and performs well under load.
• Mentor junior engineers in all aspects of planning, development and testing.
• Stay engaged with latest technologies and evaluate strategies to keep the Novo technology stack up to date.

• 5+ years experience in a highly technical role at a hyper-growth startup or fast-paced company.
• Extensive background designing, developing, testing, deploying, maintaining, and improving software.
• Good understanding of Node.js & Javascript.
• Demonstrated ability to translate business goals and initiatives into technical requirements.
• Strong understanding of SQL database.
• Demonstrable experience architecting scalable and cost effective solutions to ensure and support customer growth.
• Experience mentoring junior engineers in all aspects of planning, development and testing.
• Strong understanding of system design and architecture.
• Interest in engaging with latest technologies and evaluating strategies to keep the Novo technology stack up to date.
• Excellent written and verbal communication skills with the ability to collaborate with both technical and non-technical teams effectively.

1. Proficiency in Python , Django and Other Allied Frameworks;
2. Expert in designing UI/UX interfaces;
3. Expert in testing, troubleshooting, debugging and problem solving;
4. Basic knowledge of SEO;
5. Good communication;
6. Team building and good acumen;
7. Ability to perform; 
8. Continuous learning

Big data Developer

Exp: 3yrs to 7 yrs.
Job Location: Hyderabad
Notice: Immediate / within 30 days

1. Expertise in building AWS Data Engineering pipelines with AWS Glue -> Athena -> Quick sight
2. Experience in developing lambda functions with AWS Lambda
3. Expertise with Spark/PySpark Candidate should be hands on with PySpark code and should be able to do transformations with Spark
4. Should be able to code in Python and Scala.
5. Snowflake experience will be a plus

We can start keeping Hadoop and Hive requirements as good to have or understanding of is enough rather than keeping it as a desirable requirement.

We are looking for a Product Designer who will be responsible for creating great websites/apps for our product. Primary duties include conceptualising and implementing creative ideas for the product, as well as creating visual elements. You will be working closely with our development team to ensure proper and hassle-free implementation.

To be successful in this role, you will need to have excellent visual design skills and be proficient in graphic design software such as Adobe Photoshop, Adobe Illustrator, Adobe XD, and Figma.

Responsibilities:

• Conceptualizing creative ideas with the team.
• Testing and improving the design of the website/app.
• Establishing design guidelines, standards, and best practices.
• Maintaining the appearance of websites by enforcing content standards.
• Designing visual imagery for websites and ensuring that they are in line with branding.
• Working with different content management systems.
• Communicating design ideas using user flows, process flows, site maps, and wireframes.
• Incorporating functionalities and features into websites.
• Designing sample pages including colours and fonts.
• Preparing design plans and presenting the website structure.

Requirements:

• Proficiency in graphic design software including Adobe Photoshop, Adobe Illustrator, Adobe XD, Figma and other visual design tools.
• Experience 5+ years
• Good understanding of content management systems.
• Proficient understanding of cross-browser compatibility issues.
• Excellent visual design skills.
• Up-to-date experience with international web protocols, standards, and technologies.
• Creative and open to new ideas.
• Adaptable and willing to learn new techniques.
• Excellent communication skills.

• Taking care of all statutory compliances in the organization (Application of licenses, renewal of licenses, filing of returns)
• Front ending with all statutory/ labour inspections
• Undertaking workforce planning studies and hiring people across all non corporate functions (all levels)
• Compensation benchmarking for non corporate teams
• Proposing compensation structures, perks, benefits, incentives and increments for the workforce
• Creating the skill matrix and skill assessment guidelines for the workforce
• Drafting HR Policies/guidelines/formats applicable for the workforce
• Addressing grievances of employees
• Advising the management regarding all issues related to the workforce
• Handling performance assessment for workforce (Design and execution)
• Handling all disciplinary issues/ absconding/ termination cases
• Acting on behalf of the company with respect to employee matters/ litigation if any

What you must have: