SIRT

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.

The Mission: TestMu AI

TestMu AI (formerly LambdaTest) is an AI-native platform moving software testing beyond automation into the era of agentic intelligence.

We provide end-to-end AI agents that manage the entire Quality Engineering lifecycle.

• Full-Stack AI Agents: Autonomously plan, author, and execute tests.
• Comprehensive Coverage: Supporting web, mobile, and enterprise apps.
• Real-World Testing: Scale execution across real devices and browsers.
• Continuous Optimization: Self-learning agents that enhance testing depth

What You’ll Own (and Ace)

You're not here to manage. You're here to lead, grow, and wow. Join a company that’s redefining how the world tests software. At LambdaTest, you’ll drive impact at scale and thrive in a high-growth, innovation-first environment.

You’ll Thrive Here If You Have

✅ Account Management Experience:

• 7-12 years of experience in Account Management within SaaS or enterprise technology.

✅ Account Management Skills:

• Proven success in managing large and complex accounts, including C-level stakeholder engagement.
• Strong relationship-building skills combined with commercial acumen.
• Proficiency in CRM tools (e.g., HubSpot, Salesforce) and Excel for account planning.

✅ Bonus Skills:

• Knowledge of DevOps, QA tools, or cloud infrastructure is a plus.

Your Mission

🤝 Relationship Management

• Own key accounts and be their go-to point of contact
• Deep dive into usage patterns, feedback loops, and business needs
• Deliver insights that help clients scale smarter

📈 Business Growth

• Identify and close upsell/cross-sell opportunities
• Drive account renewals, expansions, and product adoption
• Focus on managing and growing Enterprise Accounts with significant revenue potential and intricate stakeholder relationships.



🎯 Performance + Coordination

• Track and report account performance regularly
• Collaborate with internal teams (Sales, CS, Product) to unlock value
• Resolve blockers and challenges without waiting to be asked

What Your Day Looks Like at LambdaTest

• Every day is dynamic, fast-paced, and full of opportunities to make an impact:
• Morning huddle to align goals with your pod
• Strategic calls with enterprise clients to drive engagement
• Deep dive into client metrics to identify new value opportunities
• Syncs with product, sales, and CS to resolve blockers and deliver exceptional service
• Time for learning, mentorship, and driving innovation in client strategies
• Wrap with a performance review and prep for a stronger tomorrow

Meet Your Mentors

Saahil Menoki - VP of Sales, A scale-driven SaaS leader with zero tolerance for mediocrity. Expect mentorship, autonomy, and high-growth momentum.

Growth Timeline at TestMu AI

Your role isn’t a stop, it’s a launchpad.

Here's an overview of what growth looks like here based on your performance:

Perks That Matter

• Comprehensive Health Insurance: 100% premium covered for you + family (spouse, kids, parents), with cashless claims, maternity, and annual check-ups.
• Meals On Us: Fresh, daily lunch and dinner served at the office.
• Cab Facility: Safe, GPS-enabled transport for eligible shifts, home-office-home.
• POD Engagement Budgets: Quarterly team-building budgets to bond, celebrate, and collaborate.
• Flexible Work Culture: Hybrid setup, flexible hours, and WFH reimbursements based on role/team.

Why TestMu AI?

• Real impact, global scale
• A launchpad for leadership
• Inclusive, learning-obsessed culture
• Top-tier perks: Full health cover (incl. parents), fresh meals, safe commute, WFH support

This isn’t just a job. It’s where your career takes flight.

Apply now and start building what’s next.

Apply for this job

Senior Data Engineer

Experience: 5+ years

Chennai/ Trichy (Hybrid)

Type: Fulltime

Skills: GCP + Airflow + Bigquery + Python + Docker

The Role

As a Senior Data Engineer, you own new initiatives, design and build world-class platforms to measure and optimize ad performance. You ensure industry-leading scalability and reliability of mission-critical systems processing billions of real-time transactions a day. You apply state-of-the-art technologies, frameworks, and strategies to address complex challenges with Big Data processing and analytics. You work closely with the talented engineers across different time zones in building industry-first solutions to measure and optimize ad performance.

What you’ll do

● Write solid code with a focus on high performance for services supporting high throughput and low latency

● Architect, design, and build big data processing platforms handling tens of TBs/Day, serve thousands of clients, and support advanced analytic workloads

● Providing meaningful and relevant feedback to junior developers and staying up-to-date with system changes

● Explore the technological landscape for new ways of producing, processing, and analyzing data to gain insights into both our users and our product features

● Design, develop, and test data-driven products, features, and APIs that scale

● Continuously improve the quality of deliverables and SDLC processes

● Operate production environments, investigate issues, assess their impact, and develop feasible solutions.

● Understand business needs and work with product owners to establish priorities 

● Bridge the gap between Business / Product requirements and technical details

● Work in multi-functional agile teams with end-to-end responsibility for product development and delivery

Who you are

● 3-5+ years of programming experience in coding, object-oriented design, and/or functional programming, including Python or a related language

● Love what you do and are passionate about crafting clean code, and have a steady foundation.

● Deep understanding of distributed system technologies, standards, and protocols, and have 2+ years of experience working in distributed systems like Airflow, BigQuery, Spark, Kafka Eco System ( Kafka Connect, Kafka Streams, or Kinesis), and building data pipelines at scale.

● Excellent SQL, DBT query writing abilities, and data understanding

● Care about agile software processes, data-driven development, reliability, and responsible experimentation 

● Genuine desire to automate decision-making, processes, and workflows

● Experience working with orchestration tools like Airflow

● Good understanding of semantic layers and experience in tools like LookerML, Kube

● Excellent communication skills and a team player

● Google BigQuery or Snowflake

● Cloud environment, Google Cloud Platform 

● Container technologies - Docker / Kubernetes

● Ad-serving technologies and standards 

● Familiarity with AI tools like Cursor AI, CoPilot.

Job Title: Sales Agent

Responsibilities:

- Generate new business leads

- Build client relationships

- Negotiate and close sales deals

- Meet sales targets

Requirements:

- 6 Months to 1 Year sales experience

- Proven sales track record

- Excellent communication skills

Candidate must have good experience in customer interaction in Sales, along with that they have a good knowledge of Tally Sales

Job Title: Performance Marketing Associate

Location: Pune

We are looking for a Performance Marketing Associate to join our team at Propacity. In this role, you will help execute and optimize digital marketing campaigns tailored for the real estate sector, focusing on lead generation, customer acquisition, and revenue growth.

You will work closely with senior marketing professionals, gaining hands-on experience in paid media, performance tracking, and campaign optimization. If you have a data-driven mindset, strong analytical skills, and a passion for digital marketing, we’d love to hear from you!

Responsibilities:

• Assist in planning and executing digital advertising campaigns across Google Ads, Facebook, Instagram, LinkedIn, and other paid media platforms.
• Monitor campaign performance, analyze data, and provide insights to optimize ROI and lead quality.
• Conduct market research and competitor analysis to refine targeting and messaging strategies.
• Work closely with creative and content teams to develop engaging ad copies and visuals.
• Utilize web analytics tools to track, measure, and report on key performance indicators (KPIs).
• Support senior marketing managers in client calls, reporting, and campaign optimizations.

Skills & Qualifications:

• Bachelor’s degree in Marketing, Business, or a related field (MBA is a plus).
• 1-3 years of experience in digital marketing, performance marketing, or a similar role.
• Experience in the real estate industry is preferred but not mandatory.
• Familiarity with Google Ads, Facebook Ads Manager, and other digital advertising platforms.
• Strong analytical skills with the ability to interpret data and suggest improvements.
• Excellent communication and collaboration skills.
• A proactive, detail-oriented approach to campaign execution and optimization.

What We Offer:

• Learn & grow in one of India's fastest-growing real estate proptech companies.
• Work with industry experts and gain hands-on experience in performance marketing.
• Access the latest marketing automation & analytics tools for campaign execution.
• Collaborative, innovative, and fast-paced work environment with exciting career growth opportunities.

About Propacity:

Propacity is one of India's fastest-growing proptech companies. Since our founding in 2021, we have empowered 100+ top real estate developers by increasing their sales velocity, simplifying operations, and providing cutting-edge tech solutions. We are backed by leading investors, including Good Capital, Inuka Capital, and 30+ unicorn/soonicorn founders.

Master’s Degree/PG in computer science or B.E/ B. Tech in Computer/Electronics or equivalent with minimum 2 years industrial/academic experience in UI/UX development, computational biology, MD simulations, PHP, MySQL, Bash scripting, Server admin. Proficiency in programming languages, such as Java, HTML, or PHP, and CSS. Experience in exploring libraries and frameworks (for example Bootstrap and J Query) and using GitHub, a version control system. Extensive knowledge of advancements and trends in web design. Exceptional ability to contribute creativity and innovation to web projects. Superb leadership, collaboration and communication skills. Excellent organizational and time management skills.

We enable humans & machines with internet connectivity at a price that they can afford.

The inspiration for Wifi Dabba came from the founders working together for the last decade in the mobile application industry and realising the biggest reason for user churn being access to cheap and affordable internet access. From having worked on ground onboarding users and facing poor connectivity issues all the time, we took it on ourselves to fix the internet access problem for the common citizen.

At Wifi Dabba (YC W17), we are building a low cost, scalable & distributed Wi-Fi infrastructure to connect next billion users online. We do this by deploying a grid of lasers (Free Space Optics) over the cities & town and bring cheap and fast internet for everyone. We enable anyone to buy 1 gig of data access at a time at a price they can afford. Sachetization of internet access is the foundation to rebuilding internet for all. We do this by leveraging crypto and blockchain to truly make internet infrastructure ownership distributed — our vision is to be connectivity layer for the Web3 world.

• You will get the chance to be an early team member at a fast-growth YC startup.
• You get to define the future of telecom infrastructure ownership and operations.
• We’re a tight-knit team where you'll learn a ton and have ownership.
• Opportunity to build for the next billion users.

• Strong engineering background preferably in Computer Science
• Experience architecting, developing, and testing iOS application code end-to-end
• Strong knowledge of iOS UI design principles, patterns, and best practices
• Experience with AWS services
• Experience working with remote data via REST and JSON
• Experience working with mobile analytics
• Knowledge of Apple’s design principals and application
• Knowledge of code versioning tools like GIT, SVN.
• Experience in building user interfaces for mobile apps.
• Participate in design discussions with business users, web producers and engineering teams.
• Perform requirements analysis, high-level design, effort estimation for new business requirements and feature enhancements.
• Write clean, concise, and sustainable code.
• Team player who enjoys collaborative effort.

• Entrepreneurial mindset (we encourage all employees to be future founders and this can be a great stepping stone towards that)
• Customer-centric and passionate about working in a small & focused team
• Previous experience building/working in telecom software or infrastructure
• Previous experience building web3 project - DeFi / Blockchain infrastructure
• Previous experience at a high-growth, fast-paced startup

Roles and Responsibilities:

• Manipulate and edit film pieces in a way that is invisible to the audience.
• Trim footage segments and put together the sequence of the film.
• Input music, dialogues, graphics, and effects.
• Create rough and final cuts.
• Ensure logical sequencing and smooth running.
• Consult with stakeholders from production to post-production process.
• Continuously discover and implement new editing technologies and industry best practices to maximize efficiency.

Requirements:

• 0-1 experience with digital technology and editing software packages (e. g. Premiere Pro, After Effects & Adobe Illustrator)
• Demonstrable video editing ability with a strong portfolio.
• Thorough knowledge of timing, motivation, and continuity.
• Creative mind and storytelling skills.
• Should be good at creating content curation from already available assets.
• Graphic Design is majorly preferred.