Sr. Database developer

Job Title: Senior Data Engineer

Position Summary

We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.

Key Responsibilities

• Design, develop, and maintain reporting infrastructure and data platforms.
• Build and optimize complex SQL queries, data models, and reporting datasets.
• Develop scalable ETL/ELT pipelines and data integration processes.
• Design and maintain database schemas to support analytics and reporting requirements.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Implement data quality, governance, and performance best practices.
• Support and enhance enterprise reporting solutions and dashboards.
• Work with large-scale datasets in cloud data warehouse environments.
• Troubleshoot reporting issues and optimize database performance.
• Partner with engineering and product teams to establish sustainable data architecture.

Must Have: Technical Skills

• PostgreSQL
• Snowflake
• Advanced SQL
• Data Modeling
• Data Warehousing
• Reporting & Analytics Infrastructure
• ETL/ELT Development
• Query Performance Tuning

Success Profile:

The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.

Experience Range: 5-10 years

Role Type: Individual Contributor / Senior Engineer

Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

Job Description: SQL Developer – Mutual Fund / Capital Markets

Location: Noida, Uttar Pradesh

Work Mode: Hybrid

Experience Required: 10+ Years

Employment Type: Full-time

Job Summary

We are looking for an experienced SQL Developer with strong expertise in Microsoft SQL Server, T-SQL programming, complex query development, and database performance optimization. The ideal candidate should have hands-on experience designing, developing, maintaining, and optimizing database objects and handling complex data processing requirements.

Experience in the Mutual Fund or Capital Markets domain will be highly preferred, particularly in financial systems, transaction processing, data reconciliation, and financial reporting.

Key Responsibilities

• Design, develop, maintain, and optimize SQL Server database schemas and database objects.
• Develop and maintain complex T-SQL queries, stored procedures, functions, triggers, views, SQL Jobs, and scripts.
• Perform query optimization and database performance tuning to improve execution speed and efficiency.
• Analyze execution plans, implement indexing strategies, and work with partitioning and performance monitoring.
• Review existing SQL queries and identify performance bottlenecks and opportunities for improvement.
• Perform data extraction, transformation, migration, data porting, and data processing activities.
• Translate business and financial reporting requirements into effective SQL and database solutions.
• Troubleshoot database issues and provide timely resolutions.
• Support production and UAT environments for database-related issues.
• Perform data validation, reconciliation, and migration activities while ensuring data accuracy and consistency.
• Maintain database security, data integrity, and compliance with established standards.
• Collaborate with application developers, business analysts, QA teams, and other stakeholders.
• Take ownership of assigned tasks and deliver solutions independently.

Required Technical Skills

• Advanced knowledge of Microsoft SQL Server and T-SQL.
• Strong hands-on experience with stored procedures, functions, triggers, views, and SQL Server Jobs.
• Proven expertise in developing simple, medium, and complex SQL queries.
• Strong experience in complex data manipulation and data processing.
• Expertise in SQL query performance tuning and optimization.
• Hands-on knowledge of indexing, execution plan analysis, partitioning, and performance monitoring.
• Ability to analyze, debug, and optimize existing SQL queries.
• Strong database troubleshooting and problem-solving skills.
• Understanding of code versioning and version control systems.
• Knowledge of database security standards and best practices.
• Familiarity with data visualization tools will be an added advantage.

Domain Knowledge

• Good understanding of the Mutual Fund domain is preferred.
• Experience with Capital Markets data platforms and financial systems will be an advantage.
• Understanding of financial transactions, business processes, data reconciliation, and financial reporting requirements is desirable.

Educational Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Relevant certifications or advanced qualifications will be an added advantage.

Preferred Candidate Profile

• 10+ years of relevant experience in SQL Server development.
• Strong technical expertise in T-SQL development and database optimization.
• Ability to work independently and manage complex database requirements.
• Strong analytical, debugging, and communication skills.
• Candidates with relevant Mutual Fund or Capital Markets experience will be preferred.

Work Location: Noida, Uttar Pradesh | Work Mode: Hybrid

About Solutionara

Solutionara is an AI-led IT Consulting and Technology Services organization delivering enterprise transformation through Cloud, Integration, Data Engineering, Digital Experience, AI, and Enterprise Applications.

Headquartered in the United States with a Global Delivery Center (GDC) in Noida, India, Solutionara partners with enterprise organizations across retail, manufacturing, distribution, consumer goods, and other industries to design, implement, and support scalable technology solutions.

As a rapidly growing consulting organization, we foster a culture of ownership, innovation, collaboration, and continuous improvement, empowering our teams to contribute beyond their immediate responsibilities while delivering exceptional value to our global clients.

Every team member is expected to think like a consultant and business problem solver—understanding client objectives, challenging assumptions when appropriate, leveraging AI responsibly, and continuously identifying opportunities to improve quality, productivity, and customer outcomes.

AI is embedded into how we work, but it is an enabler—not a replacement for expertise, critical thinking, or accountability.

Role Overview

Solutionara is seeking a Senior Data Engineer with strong data engineering and database expertise to design, build, optimize, and support enterprise-scale data solutions.

This is a hands-on engineering position requiring strong SQL, Python, ETL/ELT, database, cloud, and troubleshooting capabilities. The engineer will work closely with technical leads and client stakeholders while taking ownership of major engineering components.

Location: Noida, India – Onsite | Employment Type: Full-Time | Experience: 6–9 Years

Key Responsibilities

Data Engineering

• Design, develop, test, deploy, and support scalable ETL/ELT pipelines.
• Build ingestion and transformation solutions across databases, APIs, files, and enterprise applications.
• Develop high-quality SQL and Python-based data processing solutions.
• Implement batch and incremental data-processing patterns.
• Develop reusable engineering components and frameworks.
• Support complex data migration and transformation activities.
• Perform source-to-target mapping and technical data analysis.
• Implement pipeline logging, monitoring, exception handling, and recovery mechanisms.

Database & Platform Engineering

• Design and optimize relational database schemas and data structures.
• Analyze and improve SQL/query performance.
• Support indexing, partitioning, storage optimization, and database performance.
• Implement appropriate database security and access controls.
• Support database monitoring, availability, backup/recovery, and operational requirements in collaboration with infrastructure/platform teams.
• Troubleshoot database and pipeline performance issues.
• Contribute to cloud data-platform configuration and optimization.

Data Quality

• Implement automated validation and data-quality controls.
• Develop reconciliation processes between source and target systems.
• Identify duplicate, incomplete, inconsistent, and invalid data.
• Implement cleansing, standardization, validation, and exception-management logic.
• Work with technical and business stakeholders to understand and implement business data rules.

Technical Delivery

• Convert technical designs into reliable production solutions.
• Participate in technical design and code reviews.
• Mentor junior/mid-level engineers.
• Support estimation and technical planning.
• Troubleshoot complex production and integration issues.
• Collaborate with technical leads, application teams, DevOps, QA, BI, and client teams.
• Document technical designs, mappings, configurations, operational procedures, and engineering decisions.

Consulting & AI-Led Working

• Understand the business purpose behind assigned engineering requirements.
• Raise risks, assumptions, dependencies, and potential improvements proactively.
• Communicate effectively with client and internal stakeholders.
• Use AI-assisted tools to improve coding, testing, analysis, documentation, and troubleshooting productivity.
• Independently verify AI-generated code and recommendations before implementation.
• Identify opportunities for engineering automation and process improvement.

Required Qualifications

• 6–9 years of experience in data engineering, database engineering, data integration, or related areas.
• Advanced SQL skills.
• Strong hands-on Python experience.
• Strong ETL/ELT development experience.
• Strong relational database knowledge, such as SQL Server, PostgreSQL, Oracle, or equivalent.
• Experience with data modeling and database design.
• Experience with AWS, Azure, or another major cloud platform.
• Experience with modern data technologies such as Databricks, Snowflake, Redshift, Synapse, Glue, ADF, Airflow, dbt, or equivalent.
• Experience with performance tuning and optimization.
• Experience with data validation and reconciliation.
• Strong troubleshooting and analytical skills.
• Ability to take ownership of engineering deliverables with limited supervision.

Preferred Qualifications

• Experience working with enterprise ERP, CRM, PIM, PLM, MES, or related systems.
• Experience with manufacturing, retail, distribution, or consumer-goods data.
• Experience with CI/CD and infrastructure/platform engineering practices.
• Experience with API and event-driven integrations.
• Previous consulting or technology-services experience.

What Success Looks Like

• Pipelines and databases perform reliably at enterprise scale.
• Engineering solutions are maintainable, reusable, and well documented.
• Data issues are detected and addressed systematically.
• Junior engineers receive effective technical guidance.
• Problems are owned through resolution rather than simply escalated.
• Engineering decisions reflect both technical requirements and client business objectives.

🚨 WE ARE HIRING – SENIOR DATA ENGINEER | BANGALORE 🚨

Looking for experienced Senior Data Engineers with strong expertise in PySpark, Oracle SQL/PLSQL, and Data Modeling!

🔹 Role: Senior Data Engineer

🔹 Experience: 7+ Years

🔹 Location: Bangalore

🔹 CTC: Up to 26 LPA

🔹 Notice Period: Immediate to 10 Days Preferred

💻 Mandatory Skills

✅ PySpark

✅ Oracle SQL / PL/SQL

✅ Data Modeling & Design / Modernization

✅ Python

✅ ETL

✅ Data Pipelines

⚙️ Good to Have / Ecosystem Skills

✅ Kafka

✅ Hadoop

✅ AWS / Azure / GCP

✅ Git

✅ JIRA

📌 Key Responsibilities

• Develop and maintain scalable data pipelines using PySpark

• Work extensively with Oracle SQL/PLSQL for data processing and transformation

• Design and implement data models and data architecture

• Work on data design and modernization initiatives

• Develop and optimize ETL processes and data pipelines

• Handle large volumes of data using PySpark and Python

• Work with technologies such as Kafka, Hadoop, and Cloud platforms

• Collaborate with cross-functional teams to deliver scalable data solutions

• Use Git and JIRA for version control and project tracking

📩 Interested candidates can share their updated CV along with:

Total Experience:

Relevant PySpark Experience:

Relevant Oracle SQL/PLSQL Experience:

Data Modeling Experience:

Current Location:

Notice Period:

Current CTC:

Expected CTC:

#Hiring #DataEngineer #SeniorDataEngineer #PySpark #Oracle #PLSQL #DataModeling #Python #ETL #DataPipelines #Kafka #Hadoop #AWS #Azure #GCP #BangaloreJobs #ITJobs #TechJobs #ImmediateJoiners

Role overview:

·         Technology Expertise & DBA Skill Set

·         Cloud Platforms: AWS, Azure

·         Database IaaS: Oracle, Microsoft SQL Server, PostgreSQL

·         Database PaaS: CosmosDB, MySQL, SQL Managed Instance, RDS Aurora, MongoDB

·         Infrastructure as Code: Terraform, Ansible

·         CI/CD & Automation: GitHub Actions, GitLab, Azure DevOps

·         Programming & Scripting: Python, Bash/Shell, PowerShell

·         Operating Systems: Linux/Unix (RHEL, Ubuntu), Window

Database Team Overview

Our Database Team is the foundation of enterprise-grade databases delivering secure, compliant and high-performing database platforms across Azure and AWS. We provide managed services for Oracle and Microsoft SQL Server, operating in a system DBA role to ensure platform reliability, resilience, and operational excellence. In addition, we support PaaS and RDS database services by acting as the platform team defining policies, enforcing security standards, and managing networking configurations while enabling self-service capabilities for application teams to consume these services efficiently.

What would you do here:

·         Database Security & Compliance: Implement robust security controls, encryption, and auditing to safeguard sensitive data and meet regulatory requirements.

·         Lifecycle Management: Oversee patching, upgrades, and end-of-life transitions to maintain platform stability and minimize risk.

·   Performance Optimization: Monitor and tune databases for optimal performance across diverse workloads.

·         Automation & Operational Excellence: Design and deploy automation for provisioning, monitoring, and maintenance to achieve “brilliant basics” and reduce manual intervention.

·         Business-Critical Certification: Validate and certify database environments to support mission-critical applications with high availability and disaster recovery strategies.

·         Incident & Problem Management: Provide rapid response and  root-cause analysis for database-related incidents to ensure business continuity.

·         Capacity Planning & Scalability: Forecast growth and optimize resources to support evolving business needs.

Best Regards!

Data Platform Engineer

Design, automate, and scale our data platform — this is an engineering role, not a traditional "DBA job.

Must-have :

• Data modeling & schema design (from first principles, not just maintenance)
• PostgreSQL (deep, hands-on — partitioning, replication, tuning)
• Any distributed NoSQL store (Cassandra, ScyllaDB, or similar wide-column/distributed DB) (real production experience)
• Python (automation & tooling, not just scripting)
• DevOps & CI/CD (building pipelines, not just using them)
• Terraform (infrastructure-as-code)

You'll:

• Design schemas, partitioning strategies, and lead the Postgres → Cassandra migration end-to-end
• Own PostgreSQL performance, replication, and zero-downtime schema changes
• Build Python-based automation to eliminate repetitive DB work
• Own CI/CD pipelines and Terraform-based infra provisioning
• Drive uptime, DR, monitoring, and incident response
• Own multi-tenant security (RLS, least-privilege access) and data governance

Experience: 4–9 years, data/database/platform engineering in demanding production environments.

Bonus: Kafka/Debezium (CDC), Redis, Flyway/Liquibase, GDPR/DPDP exposure.

Job Title : Data Platform Engineer (SDE 2 / SDE 3)

Experience : 3 to 8 Years (SDE2 : 3 to 5 Years | SDE3 : 5.5 to 8 Years)

Location : Remote (Contract) → Pune (Post Conversion)

Employment Type : Contract-to-Hire (3 Months)

Mandatory Skills :

Java / Python / Go, SQL, Data Engineering, ETL / ELT, Apache Airflow, Apache Spark / Flink, Kafka, AWS/GCP/Azure, Distributed Systems, API Development, Docker, Kubernetes, CI/CD, System Design

Role Overview :

We are looking for a Data Platform Engineer with strong backend engineering expertise to build scalable, high-performance data platforms and distributed systems. The ideal candidate should have hands-on experience in developing production-grade backend applications along with designing and maintaining modern data pipelines.

Key Responsibilities :

• Build and maintain scalable ETL/ELT and data processing pipelines.
• Develop backend services and APIs using Java (preferred), Python, or Go.
• Design batch and real-time data pipelines using Spark, Flink, Kafka, and Airflow.
• Optimize SQL queries, data models, and distributed data systems.
• Work with cloud platforms (AWS, GCP, or Azure) and container technologies (Docker, Kubernetes).
• Implement CI/CD, monitoring, logging, and performance optimization.
• Collaborate with product and engineering teams on scalable system design and architecture.

Required Qualifications :

• SDE 2 : 3 to 5 years of Backend + Data Engineering experience.
• SDE 3 : 5.5 to 8 years of Backend + Data Engineering experience.
• Strong coding skills in Java (preferred), Python, or Go.
• Excellent SQL and data modeling knowledge.
• Hands-on experience with Airflow, Apache Spark / Apache Flink, or similar technologies.
• Experience building scalable backend services and APIs.
• Good understanding of distributed systems, system design. and scalable architecture.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Hands-on experience with Docker and Kubernetes.
• Strong understanding of CI/CD pipelines.
• Excellent problem-solving and debugging skills.

Good to Have :

• Experience with Snowflake, BigQuery, or Redshift.
• Understanding of Kafka, Kinesis, or Pub/Sub
• Performance optimization of large-scale distributed systems
• FinTech or high-scale distributed systems experience.
• Knowledge of data governance, security, and compliance.

Preferred Candidate Profile :

• Strong Backend + Data Engineering experience
• Experience building scalable production systems
• Strong ownership mindset
• Good system design knowledge
• Experience processing millions of events using Kafka/Spark
• Built APIs supporting data infrastructure
• Production engineering experience

Interview Process :

1. Take-home Coding Assignment (48 Hours)
2. Leadership & Strategy Round (1 Hour)
3. Technical Depth – Data Engineering & Performance (1 Hour)
4. Culture & Values Fit (30 Minutes)

Senior Data Engineer – PySpark & Oracle

Experience: 7+ Years

Location: Bangalore

Notice Period: Immediate to 10 Days

Key Skills:

• Strong expertise in Data Modeling, Data Design & Modernization
• Primary skills: PySpark, Oracle SQL/PLSQL
• Secondary skills: Python, ETL & Data Pipelines
• Experience with Kafka and Hadoop
• Exposure to AWS / Azure / GCP
• Good knowledge of Git and JIRA

Roles & Responsibilities:

• Design, develop, and modernize scalable data models and data architecture.
• Develop and optimize data processing solutions using PySpark and Oracle SQL/PLSQL.
• Build and maintain robust ETL workflows and data pipelines.
• Work with Kafka, Hadoop, and cloud platforms for data processing and integration.
• Perform data transformation, optimization, and performance tuning.
• Collaborate with technical teams on data design, development, testing, and deployment.

Shift: Second Shift (2:00 PM – 10:00 PM)

Joining: Immediate

About the Role

We are looking for an experienced Data Integration Developer with strong hands-on expertise in SQL, Python, ETL development, Snowflake, and AWS data services.

The ideal candidate should have extensive experience in designing, developing, and maintaining data integration solutions, building data warehouse architectures, and implementing scalable ETL pipelines. Strong SQL development and performance optimization skills are essential for this role.

This is a remote position; however, candidates must be available to visit our Mumbai or Bangalore location for three days during the onboarding process.

Key Responsibilities

SQL Development & Performance Optimization

• Develop complex SQL queries, stored procedures, and data transformation logic.
• Optimize SQL queries for performance, scalability, and efficiency.
• Perform advanced data analysis, validation, and reconciliation.
• Troubleshoot complex SQL and data-related issues.

ETL Development & Data Integration

• Design, develop, and maintain ETL pipelines and data integration workflows.
• Work with SQL and Python for data extraction, transformation, and loading.
• Ensure data accuracy, consistency, and integrity across systems.
• Identify and resolve data pipeline failures and integration issues.

Data Warehousing & Data Modeling

• Design and maintain data warehouse architectures.
• Develop data warehouse schemas based on business requirements.
• Work on dimensional data modeling, including Facts and Dimensions.
• Implement Slowly Changing Dimensions (SCD).
• Support data analysis and business information reconciliation.

Snowflake & AWS

• Develop and manage data solutions using Snowflake.
• Work with AWS services, particularly Amazon S3.
• Manage AWS connections and data access configurations.
• Build and maintain cloud-based data integration solutions.

Python & Apache Airflow

• Develop data processing and automation solutions using Python.
• Build, schedule, and monitor workflows using Apache Airflow.
• Troubleshoot workflow failures and improve pipeline reliability.

Agile & Development Lifecycle

• Participate in Agile development processes, sprint planning, and team discussions.
• Contribute throughout all stages of the software development lifecycle.
• Collaborate with cross-functional teams to understand business and technical requirements.
• Perform root cause analysis and implement appropriate corrective actions.

Required Skills

• Advanced SQL – Strong hands-on expertise is mandatory.
• Python Development
• ETL Development and Data Integration
• Snowflake
• Apache Airflow
• AWS Services, particularly Amazon S3
• AWS Connection Management
• Data Warehouse Architecture
• Data Modeling (Facts & Dimensions)
• Slowly Changing Dimensions (SCD)
• SQL Query Optimization and Performance Tuning
• Data Analysis and Reconciliation
• Troubleshooting and Root Cause Analysis
• Agile Development Methodologies
• Strong understanding of the Software Development Life Cycle (SDLC)

Experience & Qualifications

• 8–10 years of overall experience in Data Engineering / Data Integration / ETL Development.
• Strong professional experience in advanced SQL and Python.
• Hands-on experience with Snowflake, Apache Airflow, and AWS.
• Proven experience designing and developing data warehouse solutions.
• Experience working across the complete product development lifecycle.
• Ability to independently troubleshoot complex technical challenges.

Additional Requirements

• Immediate joiners preferred.
• Must be comfortable working in the second shift (2:00 PM – 10:00 PM).
• Position is remote, with a mandatory three-day onboarding visit to Mumbai or Bangalore.
• Strong communication, analytical, and problem-solving skills.
• Ability to work independently and collaboratively in an Agile environment.