PythonRole 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.
Shubham Vishwakarma
Full Stack Developer - Averlon
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
Data Science
Machine Learning (ML)Python
Amazon Web Services (AWS)Company social profiles
Similar jobs
KubernetesAmazon Web Services (AWS)Job Title : DevOps Engineer – Fintech (Product-Based)
Experience : 5+ Years
Location : Mumbai
Job Type : Full-Time | Product Company
Role Summary :
We are hiring a DevOps Engineer with strong product-based experience to manage infrastructure for a Fintech platform built on stateful microservices.
The role involves working across hybrid cloud + on-prem, with deep expertise in Kubernetes, Helm, GitOps, IaC, and Cloud Networking.
Mandatory Skills :
Product-based experience, deep Kubernetes (managed & self-managed), custom Helm Chart development, ArgoCD/FluxCD (GitOps), strong AWS/Azure cloud networking & security, IaC module development (Terraform/Pulumi/CloudFormation), experience with stateful microservices (DBs/queues/caches), multi-tenant deployments, HA/load balancing/SSL/TLS/cert management.
Key Responsibilities :
- Deploy and manage stateful microservices in production.
- Handle both managed & self-managed Kubernetes clusters.
- Develop and maintain custom Helm Charts.
- Implement GitOps pipelines using ArgoCD/FluxCD.
- Architect and operate secure infra on AWS/Azure (VPC, IAM, networking).
- Build reusable IaC modules using Terraform/CloudFormation/Pulumi.
- Design multi-tenant cluster deployments.
- Manage HA, load balancers, certificates, DNS, and networking.
Mandatory Skills :
- Product-based company experience.
- Strong Kubernetes (EKS/AKS/GKE + self-managed).
- Custom Helm Chart development.
- GitOps tools : ArgoCD/FluxCD.
- AWS/Azure cloud networking & security.
- IaC module development (Terraform/Pulumi/CloudFormation).
- Experience with stateful components (DBs, queues, caches).
- Understanding of multi-tenant deployments, HA, SSL/TLS, ingress, LB.
Experience with various stream processing and batch processing tools (Kafka,
Spark etc). Programming with Python.
● Experience with relational and non-relational databases.
● Fairly good understanding of AWS (or any equivalent).
Key Responsibilities
● Design new systems and redesign existing systems to work at scale.
● Care about things like fault tolerance, durability, backups and recovery,
performance, maintainability, code simplicity etc.
● Lead a team of software engineers and help create an environment of ownership
and learning.
● Introduce best practices of software development and ensure their adoption
across the team.
● Help set and maintain coding standards for the team.
About the role
Media Planning Executives are responsible for analyzing data, thinking creatively and dreaming up innovative strategies to make sure marketing campaigns reach the right target audience in the most effective way possible. Armed with this critical analysis, media planning executives devise, propose, or recommend strategies for using certain media effectively to attract and retain customers, increase brand recognition, and maintain customer satisfaction and loyalty.
Some of the things we’d like you to do:
● Creation of tactical plan presentation and supporting media plan templates
● Creation of campaign analysis plan
● Oversee the successful launch of campaigns
● Maintain accuracy and timely updates of deliverable tracking documents for team
● Collate commentary on media performance and conduct first review on quality
● Adherence to team quality standard for reporting template and delivery
● Keep consistent track of campaign performance and target (monthly) across all channels, flagging needs for intervention
● Use understanding of campaign and marketplace to contribute ideas for campaign experiments and also prioritize experiments
● Manage accurate forecasts, media plans, and all key media planning documentation
A bit about yourself:
● At least 2-3 years of experience in Tradional media advertising
● Working knowledge and effective vocabulary across Offline & Online
● Experience with Media Research Tools (Comscore, GWI, TGI)
● Strong organizational skills with a keen ability to prioritize and multitask.
● Proven problem solving skills and ability to think outside of the box
● Ability to work independently and collaborate in a team environment
● Detail oriented and responsive, deadline-driven with strong reasoning skills
What you can expect from Essence
Essence’s mission is to make advertising more valuable to the world. We do this by employing the world’s very best talent to solve some of the toughest challenges of today’s digital marketing landscape. It’s important that we hire people whose values reflect those of our own: genuine, results-focused, daring and insightful. As an Essence employee, we promise you a workplace that invests in your career, cares for you and is fun and engaging. We believe these factors create a workplace where you can be yourself and do amazing work.
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, or marital status.
Vue.js
AngularJS (1.x)
Angular (2+)
React.js
Javascript- Good knowledge of the Object Oriented Programming and experience with creating basic Java applications.
- Have a good grasp and hands on experience with querying in SQL databases like MySQL.
- Knowledge of creating REST APIs using Spring or Spring Boot.
- Write well designed, testable, efficient code - Good knowledge of Unit Test Frameworks like JUnit, TestNG
- Experience with creating Java application JARs & resolving build issues. - A good grasp on the basic concepts of anyone git tool like Gitlab/Github - Knowledge in developing applications with Angular, JavaScript, CSS, HTML 5 and other broadly used Web development technologies.
- Good understanding in Angular with Angular material latest(typescript with angular).
- Should be able to understand REST APIs in JSON format.
- Hands on gulp. - Able to do browser-based debugging, performance testing
- Monitoring and improving front-end performance
- Knowledge of Node JS or any back-end would be an added advantage. - Building reusable components and front-end libraries for future use - (Optional) Understanding of CI/CD paradigm - (Optional) Basic knowledge of docker - (Optional) Have worked with ORMs like Hibernate
- (Optional) Have worked with Redis, Kafka, OAuth
- Respond to customer queries in a timely and accurate way, via phone, email or chat
- Identify customer needs and help customers use specific features
- Share feature requests and effective workarounds with team members
- Inform customers about new features and functionalities
- Follow up with customers to ensure their technical issues are resolved
- Gather customer feedback and share with our Product, Sales and Marketing teams
Vue.jsAngularJS (1.x)React.jsAngular (2+)Javascript- Application Developer -UI
- 2-5 years of experience in Front end development including Vue.js (preferred) or Angular js
- Strong proficiency in JavaScript / TypeScript
- While Vue.js preferred a good understanding of Angular / React is acceptable. Should be able to adopt to Vue.js. quickly.
- Familiarity with RESTful APIs.
- Knowledge of modern authorization mechanisms, such as JWT (JSON Web Token) and Core web fundamentals: HTML, JavaScript, and CSS.
- Good communication skills.
- 2+ years of experience in Technical recruitment
- Design and implement overall recruiting strategy
- Develop and update job descriptions and job specifications
- Perform job and task analysis to document job requirements and objectives
- Source and recruit candidates by using databases, social media etc
- Screen candidates resumes and job applications
- Conduct interviews using various reliable recruiting and selection tools/methods to filter candidates within schedule
- Assess applicants’ https://resources.workable.com/tutorial/recruiting-skills-training" target="_blank">relevant knowledge, skills, soft skills, experience and aptitudes
- Onboard new employees in order to become fully integrated
- Monitor and apply HR recruiting best practices
- Provide analytical and well documented recruiting reports to the rest of the team
- Act as a point of contact and build influential candidate relationships during the selection process
Adobe IllustratorExperience- 1 year and 2 year
Location - Navi Mumbai
Notice Period - Immediate or 15 days.
*Immediate joiners preferred.*
Job Description:
- Must be proficient in Adobe Illustrator, Photoshop, Corel Draw & other graphic tools is a must.
- Well versed with Digital Media & other Graphic Design
- Knowledge of video editing will be an added advantage
- Cultivate a solid body of work Proven graphic designing experience
- Candidates should pay attention to quality and detail.
Perks of working with us:-
1) A huge learning curve
2) Get the chance to learn Emerging Tech like ML/AI, Blockchain, VR/AR, IoT
3) Flexible working hour
4) Work from home facility
5) Work in a highly competitive environment to take your career to the next level
6) Unlimited Coffee and Snacks (If we are working at the off
DockerKubernetesResponsibilities
- Building and maintenance of resilient and scalable production infrastructure
Improvement of monitoring systems
- Improvement of monitoring systems
- Creation and support of development automation processes (CI / CD)
- Participation in infrastructure development
- Detection of problems in architecture and proposing of solutions for solving them
- Creation of tasks for system improvements for system scalability, performance and monitoring
- Analysis of product requirements in the aspect of devops
- Incident analysis and fixing
Skills and Experience
- Understanding of the distributed systems principles
- Understanding of principles for building a resistant network infrastructure
- Experience of Ubuntu Linux administration (Debian-like will be a plus)
- Strong knowledge of Bash
- Experience of working with LXC-containers
- Understanding and experience with infrastructure as a code approach
- Experience of development idempotent Ansible roles
- Experience of working with git
Preferred experience
Experience with relational databases (PostgeSQL), ability to create simple SQL queries
- Experience with monitoring and metric collect systems (Prometheus, Grafana, Zabbix)
- Understanding of dynamic routing (OSPF)
- Knowledge and experience of working with network equipment Cisco
- Experience of working with Cisco NX-OS
- Experience of working with IPsec, VXLAN, Open vSwitch
- Knowledge of principles of multicast protocols IGMP, PIM
- Experience of setting multicast on Cisco equipment
- Experience administering Atlassian products
- Writing financial documents, news items, articles, research Reports.
- Keeping updated on various financial regulatory and global activities.
- Keeping watch on various global stock markets especially US Market.
- Writing various financial documents for clients majorly Fintech Companies, agencies.
- Developing content for print, online, and presentation materials.
What you need to have:
- Minimum of 1 year experience in Financial report writing
- Exposure to US financial/Security market
- Candidates from financial background or experience in financial content writing - articles, blogs and from financial news candidates/financial writing companies.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon