
Job description:
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 standard Big Data / Infra-heavy Data Engineering role. We are specifically looking for a SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic. Python will be your primary tool for moving and orchestrating data, but SQL and database architecture are the heart of this role.
Key Responsibilities
- Database Architecture & Schema Design: Design, implement, and maintain robust relational database schemas, ensuring optimal data modeling (OLTP and OLAP/Data Warehousing).
- Advanced Database Programmability: Write, debug, and optimize complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
- Performance Tuning & Indexing: Analyze query execution plans, identify bottlenecks, and implement advanced indexing strategies, partitioning, and query refactoring to ensure sub-second response times.
- Python ETL/ELT Pipelines: Develop, schedule, and maintain scalable data ingestion and transformation pipelines using Python to connect disparate data sources.
- Data Integrity & Governance: Establish 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 complex queries (CTEs, Window Functions, Analytical queries) and server-side logic (Stored Procedures/Functions) in platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
- Advanced Database Optimization: Deep understanding of how databases work under the hood—specifically indexing (B-Tree, Hash, Clustered/Non-Clustered), execution plans, statistics, and locking/concurrency mechanisms.
- Python for Data Ingestion (3+ Years): Proficient in writing clean, modular Python scripts for data manipulation, API integration, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
- Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, Normalization (3NF), and handling Slowly Changing Dimensions (SCD).
Remote & Soft Skills
- Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement.
- Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
- Legacy Refactoring Mindset: You enjoy opening up a massive, poorly optimized 500-line stored procedure and refactoring it for 10x performance.
Nice-to-Haves
- Experience migrating legacy on-premise stored procedures to modern cloud data warehouses (Snowflake, BigQuery, Redshift).
- Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
- Experience with dbt (data build tool).
Work Location: Remote

About Mango Sciences
About
Mango Sciences is a leading emerging market data science company connecting millions of underrepresented patients to precision medicine. The company’s Querent™ platform utilizes industry-leading AI analytics to transform deep clinical data into key insights that drive global health improvements. Mango Sciences is currently partnering with hospitals to understand the health data of individuals in India and other emerging markets to drive advancement in patient care and drug discovery for all populations.
Website- https://mangosciences.com/
Industry- Health Technology
Headquarters - Boston, Massachusetts
Tech stack
Similar jobs
Role & Responsibilities
The campaign manager is responsible for the technical implementation, management, and optimization of Google Ads campaigns. This role involves ad trafficking, troubleshooting technical issues, and ensuring accurate and efficient campaign execution. The ideal candidate will have strong technical skills, a deep understanding of Google Ads, and a meticulous approach to campaign management.
- Campaign Setup and Management: Create and manage Google Ads campaigns across Search, Display, & UAC.
- Performance Optimization: Monitor and optimize campaigns to improve key metrics such as CTR, CPC, CPA, and ROI.
- Reporting & Analytics: Generate insightful reports to communicate actionables, campaign performance and ROI to stakeholders.
- A/B Testing: Conduct A/B tests on ad copy, creatives, and landing pages to enhance campaign performance.
- Technical Troubleshooting: Identify and resolve technical issues related to ad delivery,tracking , and ad disapprovals.
- Collaboration: Work closely with product and design teams to ensure campaign success.
- Competitor Research: Periodically monitor and evaluate competitor best practices to stay ahead and grow market share.
- Automation: Utilize Google Scripts/rules to automate repetitive tasks and optimize campaign management.
- Industry Trends: Stay ahead in the constantly evolving digital marketing landscape.
Ideal Candidate
- Strong B2C Performance Marketing Profile
- Mandatory (Experience 1): Must have 3+ YOE in managing performance marketing in atleast 1 of Google ads campaigns (Search, Display, Universal App Campaigns UAC)
- Mandatory (Experience 2): Must have hands-on experience with campaign setup, execution, daily optimization, reporting, and performance tracking across key KPIs (CTR, CPC, CPA, ROI)
- Mandatory (Experience 3): Must have strong technical skills including familiarity with Google Tag Manager, Google Analytics
- Mandatory (Company): Must have worked at a B2C digital/tech product company or a digital marketing agency managing B2C digital/tech product clients
- Mandatory (Exclusion): Avoid all e-commerce companies like Meesho, Amazon, Flipkart, Swiggy, as their scope of work is limited and irrelevant to their requirement.
- Note: Candidates must be from B2C tech product companies where the core user experience is driven by the technology itself—not from companies like Ola, Swiggy, Zepto, Zomato, Uber, where the user experience is shaped by a tangible service (e.g., food delivery or cab rides).
- Mandatory (Stability): Minimum 2 years per role required. One short stint is acceptable if there’s a long tenure (eg: 5+ years) in a prior role. Frequent job changes are straight rejects.
- Note: Total years of experience must not exceed 6 years.
Perks, Benefits and Work Culture
- Flexible work hours and leaves
- Salary advance
- Maternity/Paternity leave benefits & adoption assistance
- Butler & Concierge services
- Team Off-sites & Celebrations
Beyond Work:
- Insurance benefits for you and family
- Interest-free loans
- Gift vouchers for special moments
- Fully-equipped Gym
- Education Sponsorship Programs

Role Proficiency:
Performs tests in strict compliance independently guides other testers and assists test leads
Additional Comments:
Position Title: - Automation + Manual Tester Primary
Skills: Playwright, xUnit, Allure Report, Page Object Model, .Net, C#, Database Queries
Secondary Skills: GIT, JIRA, Manual Testing Experience: 4 to 5 years ESSENTIAL FUNCTIONS AND
BASIC DUTIES
1. Leadership in Automation Strategy: o Assess the feasibility and scope of automation efforts to ensure they align with project timelines and requirements. o Identify opportunities for process improvements and automation within the software development life cycle (SDLC).
2. Automation Test Framework Development: o Design, develop, and implement reusable test automation frameworks for various testing phases (unit, integration, functional, performance, etc.). o Ensure the automation frameworks integrate well with CI/CD pipelines and other development tools. o Maintain and optimize test automation scripts and frameworks for continuous improvements.
3. Team Management: o Lead and mentor a team of automation engineers, ensuring they follow best practices, writing efficient test scripts, and developing scalable automation solutions. o Conduct regular performance evaluations and provide constructive feedback. o Facilitate knowledge-sharing sessions within the team.
4. Collaboration with Cross-functional Teams: o Work closely with development, QA, and operations teams to ensure proper implementation of automated testing and automation practices. o Collaborate with business analysts, product owners, and project managers to understand business requirements and translate them into automated test cases.
5. Continuous Integration & Delivery (CI/CD): o Ensure that automated tests are integrated into the CI/CD pipelines to facilitate continuous testing. o Identify and resolve issues related to the automation processes within the CI/CD pipeline.
6. Test Planning and Estimation: o Contribute to the test planning phase by identifying key automation opportunities. o Estimate effort and time required for automating test cases and other automation tasks.
7. Test Reporting and Metrics: o Monitor automation test results and generate detailed reports on test coverage, defects, and progress. o Analyze test results to identify trends, bottlenecks, or issues in the automation process and make necessary improvements.
8. Automation Tools Management: o Evaluate, select, and manage automation tools and technologies that best meet the needs of the project. o Ensure that the automation tools used align with the overall project requirements and help to achieve optimal efficiency.
9. Test Environment and Data Management: o Work on setting up and maintaining the test environments needed for automation. o Ensure automation scripts work across multiple environments, including staging, testing, and production environments.
10. Risk Management & Issue Resolution:
• Proactively identify risks associated with the automation efforts and provide solutions or mitigation strategies.
• Troubleshoot issues in the automation scripts, framework, and infrastructure to ensure minimal downtime and quick issue resolution.
11. Develop and Maintain Automated Tests: Write and maintain automated scripts for different testing levels, including regression, functional, and integration tests.
12. Bug Identification and Tracking: Report, track, and manage defects identified through automation testing to ensure quick resolution.
13. Improve Test Coverage: Identify gaps in test coverage and develop additional test scripts to improve test comprehensiveness. 14. Automation Documentation: Create and maintain detailed documentation for test automation processes, scripts, and frameworks.
15. Quality Assurance: Ensure that all automated testing activities meet the quality standards, contributing to delivering a high-quality software product.
16. Stakeholder Communication: Regularly update project stakeholders about automation progress, risks, and areas for improvement.
REQUIRED KNOWLEDGE
1. Automation Tools Expertise: Proficiency in tools like Playwright, Allure reports and integration with CI/CD pipelines.
2. Programming Languages: Strong knowledge of languages such as .NET and test frameworks like xUnit.
3. Version Control: Experience using Git for script management and collaboration.
4. Test Automation Frameworks: Ability to design scalable, reusable frameworks for different types of tests (functional, integration, etc.).
5. Leadership and Mentoring: Lead and mentor automation teams, ensuring adherence to best practices and continuous improvement.
6. Problem-Solving: Strong troubleshooting and analytical skills to identify and resolve automation issues quickly.
7. Collaboration and Communication: Excellent communication skills for working with cross-functional teams and presenting test results.
8. Time Management: Ability to estimate, prioritize, and manage automation tasks to meet project deadlines.
9. Quality Focus: Strong commitment to improving software quality, test coverage, and automation efficiency.
Skills: xUnit, Allure report, Playwright, C#
We are looking for a Frontend Developer who would be working on the bleeding edge of technologies. We work primarily with React, Typescript and Redux.
Responsibilities:
- Understand why a particular design was chosen and code accordingly.
- Will have to deliver clean bug-free unit-tested code with minimal guidance.
- Strive for continuous improvement by refactoring and applying best practices.
- Learn and adapt to new technologies as necessary.
Requirements:
- Must be proficient in React, Redux, Redux Toolkit and Typescript.
- Used Typescript for React Components.
- Unit Testing, Component Testing, and Custom React hook tests with React Testing Library.
- Integration Tests with Cypress.
- Data Fetching libraries like Axios, React Query, RTK Query etc.
- Should have maintained React Components with Storybook.
- Experience contributing to open-source software will be preferred.
- Used various CSS stylings methods like CSS Modules, LESS, SCSS, Tailwind, Styled Components, Emotion etc.
- Should understand Git.
- Ability to work in a fast-paced and dynamic work environment.
- Exceptional interpersonal skills and demonstrated leadership abilities.
Mandatory Skills:
- AZ-104 (Azure Administrator) experience
- CI/CD migration expertise
- Proficiency in Windows deployment and support
- Infrastructure as Code (IaC) in Terraform
- Automation using PowerShell
- Understanding of SDLC for C# applications (build/ship/run strategy)
- Apache Kafka experience
- Azure web app
Good to Have Skills:
- AZ-400 (Azure DevOps Engineer Expert)
- AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
- Apache Pulsar
- Windows containers
- Active Directory and DNS
- SAST and DAST tool understanding
- MSSQL database
- Postgres database
- Azure security
Technical:
- Rich experience with .NET Core (MVC)
- Strong C# and object-oriented programming skills
- Working knowledge of MSSQL 2016 or Above
- Html5, CSS3, LINQ, Entity Framework 6.X
- Provide best practices for Client-Side scripting using JQuery, ReactJS
- Previous experience with Web API, Restful APIs
- Core Architecture and Design Patterns (Builder, Generic Repository)
- Proficient understanding of code versioning tools (e.g. GIT, Azure DevOps)
- Experience with IoT projects would be added advantage
Non Technical:
- Effective Communication skills
- Good Listener & Interpersonal Skills
- Excellent Team Player
- Troubleshooting and Problem Solving Skills
- Assist with other areas of the Application Development Life Cycle as needed
- Required Test Driven Development Approach
Roles & Responsibilities:
- Able to attend Daily Scrum meetings
- Familiar with Agile Development Methodologies (Scrum/Kanban)
- Participate in peer-reviews for solutions related to coding.
- Help Team Leader to manage the flow of day-to-day operations
- Able to work with minimal supervision
- Maintain high standards of application quality within the team by establishing good practices and habits.
We are expecting you to have a strong understanding of the latest industry trends and content management systems.
Please note: This is a work from office job. Our office is in Vashi, Navi Mumbai.
WordPress Web Developer duties and responsibilities:
Designing and implementing new features and functionality
Establishing and guiding the website's architecture
Ensuring high-performance and availability, and managing all technical aspects of the CMS
Helping formulate an effective, responsive design.
Requirements & Qualifications:
Experience with WordPress is mandatory, other CMS/ framework experience will be an added advantage.
Good understanding of front-end technologies
Experience building user interfaces for websites
Experience designing and developing responsive design websites
Ability to convert comprehensive layout and wireframes into working pages
Understanding of PHP
Experience with page builders- Elementor, Divi.
Technologies: React JS
Experience: 3 to 8 years
Notice Period: Immediate joiner
Job Location: Kalyani Nager, Pune, MH
Job Summary
Looking for React JS developers who will be responsible for architecting and building applications, as
well as coordinating with the teams responsible for other layers of the product infrastructure.
Responsibilities and Duties:-
●
Responsible for development of new highly-responsive, web-based user interface
●
Build pixel-perfect, buttery smooth UIs across both mobile platforms.
●
Diagnose and fix bugs and performance bottlenecks for performance that feels native.
●
Reach out to the open source community to encourage and help implement mission-critical
software fixes—React Native moves fast and often breaks things.
●
Maintain code and write automated tests to ensure the product is of the highest quality.
●
Transition existing React web apps to React Native.
●
Construct visualizations that are able to depict vast amounts of data
●
Work and collaborate with the rest of the engineering team
●
Work with product team and graphic designers
●
Develop a flexible and well-structured front-end architecture, along with the APIs to support it
Required Experience, Skills and Qualifications:-
● Experience with automated testing suites, like (Jest or Mocha)
● Experience with JavaScript, REACT, HTML / CSS, REST API's
● Experience with Git knowledge is a plus
● Hands on Redux
●Familiarity with native build tools, like XCode, Gradle (Android Studio, IntelliJ)
●Understanding of REST APIs, the document request model, and offline storage
Proper user information authentication Develop responsive web-based UI Non-Technical: Constant interaction with other developer teams and design teams to discuss UI ideas A thorough review of applications needs and interfacing elements.
Follow proper documentation for changes in application and further updates ReactJS Developer Skills
Technical Skills: React JS Version 16 or above , Strong proficiency in JavaScript, object model, DOM manipulation and event handlers, data structures, algorithms, JSX. Complete understanding of ReactJS and its main fundamentals like JSX, Virtual DOM, component lifecycle, etc.
Preceding experience with ReactJS workflows like Flux, Redux, Create React App, data structure libraries Understanding of RESTful APIs/GraphQL, HTML/CSS, ES6 (variables and scoping, array methods), DevOps, performance testing frameworks Preferred degree in Computer Science, Information Technology or similar Soft Skills: Competence to translate business needs into technical requirements Open-minded team player, willing to accept feedback and offer suggestions.
Experience : 1 - 3 years (min 1 year in IT recruitment)
Location : Mumbai, Pune & Bengaluru.
The areas of responsibilities/skills for the Technical Recruiter include: (Job Responsibility)
Review Job descriptions to understand the needs of the client as well to ask questions thatll help you identify the right candidate(s). This is by far the most important skill a technical recruiter needs.
Understand technology, technical roles and technical skills required to successfully fulfil the client mandate.
Identify. Sourcing and uncovering candidates using necessary tools and social networking.
Screen. Ascertain the competence of candidates against a technical job description provided by the client.
Present. Showing or offering candidate resume to hiring managers to scrutinize or consider
Schedule. Schedule telephonic, Skype or Face to face interviews with the client after necessary co-ordination.
Networking. Keep candidates in the loop. Build a pipeline of good candidates for future mandates.
Key Deliverables:
Successful placement of candidates through presentation of employable and qualified candidates for technical positions in various industries and for job roles such as in software development, systems administration, database, architecture, business processes etc.
The following skills would be necessary:(Skills Required)
Technology knowledge Ability to understand technology and to keep abreast of technology trends at Client Company.
Proven work experience as a IT Recruiter (either an in-house recruiter or a staffing agency recruiter), Domestic recruitment.
Solid ability to conduct different types of interviews (structured, competency-based, stress etc)
Familiarity with HR databases, Applicant Tracking Systems (ATS) and Candidate Management Systems (CMS)
Relationship Building & Networking Building a strong pipeline of qualified IT candidates through regular follow-ups and networking.
Excellent communication in English & Hindi and interpersonal skills
Hands on experience with various selection processes (phone interviewing, reference check etc)






