3+ Data migration Jobs in Mumbai | Data migration Job openings in Mumbai

Senior Data Engineer

Location: Bangalore, Gurugram (Hybrid)

Experience: 4-8 Years

Type: Full Time | Permanent

Job Summary:

We are looking for a results-driven Senior Data Engineer to join our engineering team. The ideal candidate will have hands-on expertise in data pipeline development, cloud infrastructure, and BI support, with a strong command of modern data stacks. You’ll be responsible for building scalable ETL/ELT workflows, managing data lakes and marts, and enabling seamless data delivery to analytics and business intelligence teams.

This role requires deep technical know-how in PostgreSQL, Python scripting, Apache Airflow, AWS or other cloud environments, and a working knowledge of modern data and BI tools.

Key Responsibilities:

PostgreSQL & Data Modeling

· Design and optimize complex SQL queries, stored procedures, and indexes

· Perform performance tuning and query plan analysis

· Contribute to schema design and data normalization

Data Migration & Transformation

· Migrate data from multiple sources to cloud or ODS platforms

· Design schema mapping and implement transformation logic

· Ensure consistency, integrity, and accuracy in migrated data

Python Scripting for Data Engineering

· Build automation scripts for data ingestion, cleansing, and transformation

· Handle file formats (JSON, CSV, XML), REST APIs, cloud SDKs (e.g., Boto3)

· Maintain reusable script modules for operational pipelines

Data Orchestration with Apache Airflow

· Develop and manage DAGs for batch/stream workflows

· Implement retries, task dependencies, notifications, and failure handling

· Integrate Airflow with cloud services, data lakes, and data warehouses

Cloud Platforms (AWS / Azure / GCP)

· Manage data storage (S3, GCS, Blob), compute services, and data pipelines

· Set up permissions, IAM roles, encryption, and logging for security

· Monitor and optimize cost and performance of cloud-based data operations

Data Marts & Analytics Layer

· Design and manage data marts using dimensional models

· Build star/snowflake schemas to support BI and self-serve analytics

· Enable incremental load strategies and partitioning

Modern Data Stack Integration

· Work with tools like DBT, Fivetran, Redshift, Snowflake, BigQuery, or Kafka

· Support modular pipeline design and metadata-driven frameworks

· Ensure high availability and scalability of the stack

BI & Reporting Tools (Power BI / Superset / Supertech)

· Collaborate with BI teams to design datasets and optimize queries

· Support development of dashboards and reporting layers

· Manage access, data refreshes, and performance for BI tools

Required Skills & Qualifications:

· 4–6 years of hands-on experience in data engineering roles

· Strong SQL skills in PostgreSQL (tuning, complex joins, procedures)

· Advanced Python scripting skills for automation and ETL

· Proven experience with Apache Airflow (custom DAGs, error handling)

· Solid understanding of cloud architecture (especially AWS)

· Experience with data marts and dimensional data modeling

· Exposure to modern data stack tools (DBT, Kafka, Snowflake, etc.)

· Familiarity with BI tools like Power BI, Apache Superset, or Supertech BI

· Version control (Git) and CI/CD pipeline knowledge is a plus

· Excellent problem-solving and communication skills

Responsibilities:

• Design, implement, and maintain scalable and reliable database solutions on the AWS platform.
• Architect, deploy, and optimize DynamoDB databases for performance, scalability, and cost-efficiency.
• Configure and manage AWS OpenSearch (formerly Amazon Elasticsearch Service) clusters for real-time search and analytics capabilities.
• Design and implement data processing and analytics solutions using AWS EMR (Elastic MapReduce) for large-scale data processing tasks.
• Collaborate with cross-functional teams to gather requirements, design database solutions, and implement best practices.
• Perform performance tuning, monitoring, and troubleshooting of database systems to ensure high availability and performance.
• Develop and maintain documentation, including architecture diagrams, configurations, and operational procedures.
• Stay current with the latest AWS services, database technologies, and industry trends to provide recommendations for continuous improvement.
• Participate in the evaluation and selection of new technologies, tools, and frameworks to enhance database capabilities.
• Provide guidance and mentorship to junior team members, fostering knowledge sharing and skill development.

Requirements:

• Bachelor’s degree in computer science, Information Technology, or related field.
• Proven experience as an AWS Architect or similar role, with a focus on database technologies.
• Hands-on experience designing, implementing, and optimizing DynamoDB databases in production environments.
• In-depth knowledge of AWS OpenSearch (Elasticsearch) and experience configuring and managing clusters for search and analytics use cases.
• Proficiency in working with AWS EMR (Elastic MapReduce) for big data processing and analytics.
• Strong understanding of database concepts, data modelling, indexing, and query optimization.
• Experience with AWS services such as S3, EC2, RDS, Redshift, Lambda, and CloudFormation.
• Excellent problem-solving skills and the ability to troubleshoot complex database issues.
• Solid understanding of cloud security best practices and experience implementing security controls in AWS environments.
• Strong communication and collaboration skills with the ability to work effectively in a team environment.
• AWS certifications such as AWS Certified Solutions Architect, AWS Certified Database - Specialty, or equivalent certifications are a plus.

Rajasthan Studio is looking for young and bright minds for its upcoming innovative, never-experienced-before app platform for virtual art experiences.

We are looking for programmers with problem-solving skills and critical thinking abilities for the position of Back End developer. Back End developers are responsible for creating a bridge between customers and business logic, optimizing applications for maximum efficiency, creating dashboards for internal teams, and maintaining brand consistency across the application, among other duties.

Backend Web Developers are responsible for managing the interchange of data between the server and the users. The role's primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. A basic understanding of front-end technologies is necessary as well.

Responsibilities -

• Creating RESTful API/GraphQL to be consumed by Flutter developers
• Building reusable code and libraries for future use
• Optimization of the application for maximum speed and scalability
• Implementation of security and data protection
• Design and implementation of data storage solutions
• Participate in the entire application lifecycle, focusing on coding and debugging
• Write clean code to develop functional web applications
• Troubleshoot and debug applications
• Provide training and support to internal teams

Skill & Qualifications -

• Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3
• Understanding accessibility and security compliances
• User authentication and authorization between multiple systems, servers, and environments
• Integration of multiple data sources and databases into one system
• Management of hosting environment, including database administration and scaling an application to support load changes
• Data migration, transformation, and scripting
• Setup and administration of backups
• Outputting data in different formats
• Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform
• Creating database schemas that represent and support business processes
• Implementing automated testing platforms and unit tests
• Proficient understanding of code versioning tools, such as Git
• Proficient understanding of OWASP security principles
• Understanding of “session management” in a distributed server environment
• Knowledge of Yii framework - version 2 (preferred)