Sr./Lead Power Electronics Hardware Engineer

Experience: 4+ years.

Location: Vadodara & Pune

Skills Set- Snowflake, Power Bi, ETL, SQL, Data Pipelines

What you'll be doing:

• Develop, implement, and manage scalable Snowflake data warehouse solutions using advanced features such as materialized views, task automation, and clustering.
• Design and build real-time data pipelines from Kafka and other sources into Snowflake using Kafka Connect, Snowpipe, or custom solutions for streaming data ingestion.
• Create and optimize ETL/ELT workflows using tools like DBT, Airflow, or cloud-native solutions to ensure efficient data processing and transformation.
• Tune query performance, warehouse sizing, and pipeline efficiency by utilizing Snowflakes Query Profiling, Resource Monitors, and other diagnostic tools.
• Work closely with architects, data analysts, and data scientists to translate complex business requirements into scalable technical solutions.
• Enforce data governance and security standards, including data masking, encryption, and RBAC, to meet organizational compliance requirements.
• Continuously monitor data pipelines, address performance bottlenecks, and troubleshoot issues using monitoring frameworks such as Prometheus, Grafana, or Snowflake-native tools.
• Provide technical leadership, guidance, and code reviews for junior engineers, ensuring best practices in Snowflake and Kafka development are followed.
• Research emerging tools, frameworks, and methodologies in data engineering and integrate relevant technologies into the data stack.

What you need:

Basic Skills:

• 3+ years of hands-on experience with Snowflake data platform, including data modeling, performance tuning, and optimization.
• Strong experience with Apache Kafka for stream processing and real-time data integration.
• Proficiency in SQL and ETL/ELT processes.
• Solid understanding of cloud platforms such as AWS, Azure, or Google Cloud.
• Experience with scripting languages like Python, Shell, or similar for automation and data integration tasks.
• Familiarity with tools like dbt, Airflow, or similar orchestration platforms.
• Knowledge of data governance, security, and compliance best practices.
• Strong analytical and problem-solving skills with the ability to troubleshoot complex data issues.
• Ability to work in a collaborative team environment and communicate effectively with cross-functional teams

Responsibilities:

• Design, develop, and maintain Snowflake data warehouse solutions, leveraging advanced Snowflake features like clustering, partitioning, materialized views, and time travel to optimize performance, scalability, and data reliability.
• Architect and optimize ETL/ELT pipelines using tools such as Apache Airflow, DBT, or custom scripts, to ingest, transform, and load data into Snowflake from sources like Apache Kafka and other streaming/batch platforms.
• Work in collaboration with data architects, analysts, and data scientists to gather and translate complex business requirements into robust, scalable technical designs and implementations.
• Design and implement Apache Kafka-based real-time messaging systems to efficiently stream structured and semi-structured data into Snowflake, using Kafka Connect, KSQL, and Snow pipe for real-time ingestion.
• Monitor and resolve performance bottlenecks in queries, pipelines, and warehouse configurations using tools like Query Profile, Resource Monitors, and Task Performance Views.
• Implement automated data validation frameworks to ensure high-quality, reliable data throughout the ingestion and transformation lifecycle.
• Pipeline Monitoring and Optimization: Deploy and maintain pipeline monitoring solutions using Prometheus, Grafana, or cloud-native tools, ensuring efficient data flow, scalability, and cost-effective operations.
• Implement and enforce data governance policies, including role-based access control (RBAC), data masking, and auditing to meet compliance standards and safeguard sensitive information.
• Provide hands-on technical mentorship to junior data engineers, ensuring adherence to coding standards, design principles, and best practices in Snowflake, Kafka, and cloud data engineering.
• Stay current with advancements in Snowflake, Kafka, cloud services (AWS, Azure, GCP), and data engineering trends, and proactively apply new tools and methodologies to enhance the data platform. 

Business Development is a critical aspect of our platform business.

1. Actively seeking out new sales opportunities through cold calling, networking, and social media.

2. Calling 65-70 leads every day

3. Setting up meetings with potential clients (parents)

4. Generating Trial Classes - Pitch Parents to take PlanetSpark Trial Classes

5. Negotiate/close deals and handle complaints or objections

6. Follow and achieve the department’s sales goals on a monthly, quarterly, and yearly basis (3L revenue per month)

7. “Go the extra mile” to drive sales

What are we looking for?

We are looking for a talented product engineer to facilitate the design and manufacturing of our next line of exciting products. As a product engineer, you will be working closely with the design team to create industry-relevant products that meet company specifications. You will also be required to design and oversee the product manufacturing process to ensure that our products meet state safety requirements.

To ensure success as a product engineer, you should have excellent analytical and design skills, good working knowledge of design software, and advanced troubleshooting skills. A top-notch product engineer should be able to transform ideas into high-end products that perfectly meet the needs of our customers.

• Meeting with the development team to discuss product ideas.
• Analyzing market and industry product trends.
• Determining product feasibility costs and return on investments.
• Developing design ideas based on customer interests, budgets, and market research.
• Creating rough product designs using sketches and computer software.
• Conducting theoretical testing on design models.
• Creating full product designs and specifications using computer software modeling techniques.
• Selecting product materials and designing the product manufacturing process.
• Overseeing production and ensuring that products conform to market specifications and safety regulations.

• Bachelor’s degree in mechanical engineering or a similar field.
• Previous experience working as a product engineer.
• Advanced analytical and design skills.
• Excellent written and verbal communication skills.
• Knowledge of industry and market trends.
• Ability to visualize theoretical models and design ideas.
• Good project management skills.
• A keen eye for detail.

• Candidate must have knowledge in the testing domain and must have knowledge of testing of web-based applications.
• The candidate will be responsible for the testing of web-based applications.
  The candidate will also act as the Business Analyst for the project. 
  The eye-catching ability to find bugs from a client’s perspective.
• Exposure to Automation Testing using Testing Tools such as (Selenium Web driver, TestNG, jmeter or similar tools) will be an added advantage.
• Good understanding of software development life cycle.
• Familiar with Database testing; good reporting & documenting skills.
• Good analytical skills with Out of the box thinking and can do attitude.
• Should be flexible and adaptable 
• Good Problem-solving and Troubleshooting skill
• Will be responsible for creating Test cases and creating Client & Internal Reporting. 

• Own the Strategy, Roadmap, Execution, and Success for STAGE OTT product
• Take product ideas from ideation to implementation
• Develop backend services that expand the capabilities of our CMS for the content team
• Optimize the performance of our APIs
• Collaborate with Product and Design to iterate on our product
• Participate in design and code reviews

• Growth and Ownership mindset
• 1+ years of experience working in a Software Engineering role
• Strong foundation in programming, algorithms, and software application design
• Experience in Node.js Express and obsessed about optimizing Mongoose queries.
• Passionate about solving challenging problems and iterating quickly
• Previous experience in distributed systems, data processing and analytics is a plus
• Ability to extract, analyze and communicate data

• 2+ years of experience on Java, Spring Boot, Hibernate in medium to large-scale projects
• Must have experience with at least some flavours of both SQL (MySQL, Postgres) and NoSQL (Kafka, MongoDB, ElasticSearch, NoSQL distributed cache system, DynamoDB etc), datastores in production
• Must have experience with Kafka or similar message queue systems in production
• Stellar problem solving skills
• Hunger to learn new things and ability to grasp new concepts quickly
• Ability to move quickly without breaking things too much (we are dreamers)
• Ability to work under immense pressure which is balanced by a sense of responsibility and ownership
• Should be able to groom juniors and take them to the next level

Lodestone Software (Ahmedabad) is a testing focused company (with a team of 800+employees) and we are looking for people with a strong drive to build a career in QA Automation.

This position requires : 

• Overall 3+Years experience in Test Automation
• Interview for software concepts, Programming skills (practical hands-on) and overall attitude and approach towards problem solving.
• Cypress or Jest/Puppeteer or Protractor or a similar JavaScript-based e2e/UI automation framework knowledge/experience is a Plus.
• Good object oriented programming concepts and practical knowledge. 
• Mobile application knowledge (Android, iOS) along with ADB/xCode is essential.
• Working knowledge of Databases along with ability to write efficient queries.
• Overall attitude and approach towards building a career in QA Automation.

• Ideate and create concept storyboards
•   Conceptualise and present ideas as per the brief
•   Pick and arrange effects, music that adds to the narrative
•   Shortlist visuals and footage to be used in the video
•   Collaborate with internal stakeholders to create videos for all marketing and product needs.
•   Reorder and fine-tune content to ensure logical sequencing and smooth running of the video and time constraints are incorporated
•   Improve and correcting lighting, coloring and faulty footage & sound
•   Create transitions, titles, graphics and other supporting materials for the video
•   Work closely with producers, directors, external vendors, motion graphic designers and learning managers to present a final product that matches the overall vision
•   Take ownership of post-production management of assets and deliverables, channels & maintenance