Corporate sales -Mumbai

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please Note: This is not a pure Data Engineering role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic with Python, ETL, Cloud. SQL mastery and database architecture are the absolute heart of this role.

If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.

Key Responsibilities

1. Database Architecture & Schema Design

• Design, implement, and maintain robust relational database schemas.
• Architect optimal data models for both operational (OLTP) and analytical (OLAP/Data Warehousing) workloads.
• Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.

2. Advanced Database Programmability

• Write, debug, and optimize highly complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.

3. Performance Tuning & Indexing

• Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B-Tree, Clustered/Non-Clustered, Partitioning).
• Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub-second response times.

4. Python & Cloud ETL/ELT Pipelines

• Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
• Leverage Cloud Data Platforms alongside modern Python libraries to build efficient data movement workflows.

5. Data Integrity & Governance

• Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing server-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep, under-the-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
• Python for Data Engineering (3+ Years): Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Cloud Data Experience: Hands-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (Snowflake, BigQuery, or Redshift).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.

Remote & Soft Skills

• Legacy Refactoring Mindset: You genuinely enjoy opening up a massive, poorly optimized 500-line legacy stored procedure and refactoring it for maximum efficiency.
• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.

Nice-to-Haves

• Experience migrating legacy on-premise infrastructure and stored procedures to modern cloud data warehouses.
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Hands-on experience with dbt (data build tool) for in-warehouse transformations.

JOB TITLE: Quality Engineer – Steel Forging Company

Overview: We are looking for a Quality Engineer with a Mechanical Engineering background to oversee product quality, conduct inspections, and ensure compliance with industry standards. This role involves frequent travel to suppliers, manufacturing sites, and customer locations to conduct audits and resolve quality issues.

Key Responsibilities:

1. Quality Control & Assurance:

a)     Develop and implement quality inspection procedures for raw materials, in-process, and finished forged products.

b)     Conduct root cause analysis (RCA) and corrective actions for quality issues.

c)     Ensure compliance with industry standards such as ISO 9001, IATF 16949, or AS9100, depending on the sector.

d)     Monitor heat treatment, machining, and surface finishing processes to maintain product integrity.

2. Inspection & Testing:

a)     Perform dimensional, mechanical, and metallurgical testing using CMM, hardness testers, spectrometers, and other quality equipment.

b)     Analyze microstructure, grain flow, and mechanical properties of forged parts.

c)     Work with suppliers and vendors to ensure incoming material quality.

3. Documentation & Reporting:

a)     Generate inspection reports, non-conformance reports (NCRs), and corrective action reports (CARs).

4. Process Improvement:

a)     Optimize forging processes to minimize defects such as cracks, porosity, laps, and inclusions.

5. Customer & Regulatory Compliance:

1.     Work closely with customers to address quality concerns and implement corrective actions.

2.     Ensure products meet standards such as ASTM, SAE, DIN, or customer-specific requirements.

Preferred Skills:

1.     Familiarity with ERP systems, Minitab, AutoCAD, and SolidWorks is a plus.

2.     Analytical mindset, problem-solving, and attention to detail.

3.     Willingness to Travel: Required for supplier audits, inspections, and customer visits.

We’re Hiring: HR Manager

📍 Noida – Sector 63 (Onsite)

🕒 4–6 Years Experience

🏢 IT Industry Experience Required

Role Focus:

Own and manage the complete employee life cycle, HR operations, compliance, and people processes.

Preference will be given to female professionals.

We are a passionate & dedicated team having fun building something truly unique and believe in working like a sports team optimized for innovation and speed.

Hitwicket is looking for a Passionate candidate who can build a world-class mobile gaming experience for a billion cricket fans. We value your hunger and creativity in helping us build Hitwicket.

Responsibilities:

• Good Knowledge in Sketching and Painting (BFA Preferable).Interpret concept art and sketches to create virtual characters, environments and props
• Follow design guidelines, asset naming conventions and other technical constraints
• Prototype and iterate on models and characters based on feedback from team members
• Optimize, refine and correct model geometry
• Rig models and characters for animation
• Color characters, add Textures and shade the given characters based on the material used
• Create textures that generate visual interest and define the characteristics.
• Generate the output within the time frame by understanding the desired output.
• Create a UV map and Occlusion map
• Work with artists, animators and programmers to execute projects on time
• Keep abreast with the latest developments in 3D design, capture and modeling tools and technologies

Requirements

• Good Knowledge in Sketching and Painting (BFA Preferable).
• Minimum 3 years of experience as a 3D artist(Modeling and texturing)
• Good organization skills.
• Good Knowledge of 3D Modeling, Lighting and Rendering.
• Excellent knowledge of real-time modeling techniques (shaders, PBR, normal, displacement etc. )
• Strong portfolio showing 3D art skills and demonstrating a high level of artistic creativity.
• Strong high & low-resolution modeling and texturing skills.
• Good experience in the video game industry with 3D packages, preferably Maya or 3DSMax & ZBrush.
• Experience working on published mobile games would be a strong advantage.
• College Diploma/Degree in graphic design, 3D, video game development or equivalent training.

Requirements:

• Passion for building and delivering great software with a strong sense of ownership.
• Good understanding into .Net Core and PS
• Minimum of two years of experience in building web applications using ASP.NET MVC and .NET platform in general.
• Should have strong UI development skills using HTML, CSS/JavaScript frameworks.-

     Good understanding of IIS configuration

• Strong experience with Build and Release, Agile processes and Estimation/Planning-
  
  Exposure to New Relic or similar tools to optimize web application performance
  Strong expertise in SQL programming, with experience of writing & optimizing queries that access/process millions of records-
  Experience of architecting and designing web applications and servicesTeam TA,LeadSquared (ref:hirist.com)

• Provide the team with a vision and objectives; manage key performance indicators
• Set the monthly, weekly, daily targets for the team and ensure that the targets are achieved
• Maintain the sales report of the team
• Needs to own hiring, firing and deliverables of at least 10 education counselors
• Motivating & mentoring team to achieve & exceed targets
• Design & develop business models
• Conducting weekly reviews for performance & training
• Identifying the areas of improvements & KPI’s
• Involved in a lot of calling on phone for negotiation and objection handling
• Are dynamic professionals who drive their team to exceed business targets
• Possess sound knowledge and understanding of consumer (students and parents) behavior
• Thrive in a fast paced ambiguous work environment
• Have excellent communication skills in English and the regional language
•