Data Engineer

Position Overview

Job Title: Data Engineer

Company: MetaDesign Solutions

Location: Bengaluru, Karnataka, India (On-site)

Experience: 4-5 years

MetaDesign Solutions is a technology services and product engineering firm focused on delivering scalable data-driven solutions that help enterprises accelerate decision-making and digital transformation. We are seeking a highly skilled Data Engineer to join our Bangalore engineering team and own the performance, stability, and scalability of mission-critical PostgreSQL databases and data pipelines. The successful candidate will play a central role in optimizing query performance, designing efficient stored procedures, and ensuring reliable data availability for analytics and application workloads.

Key Responsibilities

• Develop, maintain, and optimize complex SQL queries and PLSQL stored procedures to process and transform large volumes of data efficiently.
• Administer and optimize PostgreSQL databases that host numerous tables and high-record-volume datasets, ensuring availability and reliability for production workloads.
• Perform query performance analysis and fine-tuning using execution plans, indexing strategies, partitioning, and other optimization techniques.
• Design, implement, and improve ETL/ELT pipelines and data integration processes to support analytics, reporting, and application consumption.
• Collaborate closely with software engineers, data analysts, and product teams to understand requirements, validate data quality, and ensure accurate data delivery.
• Implement and maintain database monitoring, alerting, backup, and disaster recovery processes; proactively identify and remediate performance bottlenecks and incidents.
• Troubleshoot database-related production issues, perform root-cause analysis, and drive permanent fixes and continuous improvement.
• Document database schemas, procedures, operational runbooks, and optimization efforts; provide regular reports on performance metrics and improvement initiatives.

Required Qualifications

• 4-5 years of experience in a Data Engineer, Database Engineer, or similar role with hands-on responsibility for large-scale relational databases.
• Expert-level proficiency in SQL and strong experience writing and optimizing complex PLSQL stored procedures.
• Very strong experience with PostgreSQL, including administration, performance tuning, indexing, partitioning, and configuration for large datasets.
• Proven track record optimizing query performance using EXPLAIN/ANALYZE, index design, query refactoring, and execution-plan analysis.
• Solid understanding of database design principles, normalization, denormalization trade-offs, and data modeling for analytical and transactional workloads.
• Experience building and maintaining ETL/ELT processes and integrating data from multiple sources while ensuring data quality and integrity.
• Familiarity with database monitoring and performance tools and techniques for SQL databases (e.g., pg_stat_statements, monitoring stacks, slow-query analysis).
• Strong problem-solving skills and the ability to work with large datasets under production constraints.
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.

Preferred Qualifications

• Experience with cloud-based data platforms and managed database services on AWS, Azure, or GCP (for example RDS/Aurora, Cloud SQL, or equivalent).
• Knowledge of data warehousing concepts, columnar storage, and analytical database technologies.
• Familiarity with workflow orchestration and ETL tools (such as Apache Airflow, dbt, or similar) and streaming platforms (Kafka, Kinesis) is a plus.
• Experience working with NoSQL databases and polyglot persistence patterns.
• Proficiency in scripting or programming languages such as Python or Shell scripting for automation and data processing tasks.
• Relevant certifications in PostgreSQL, cloud platforms, or data engineering are advantageous.

What We Offer

• Competitive salary commensurate with experience and a benefits package aligned with industry standards.
• Opportunity to work on challenging data engineering problems and influence the architecture of high-volume data systems.
• Collaborative, growth-oriented work culture with cross-functional teams focused on product and client outcomes.
• Professional development support, training opportunities, and access to modern data engineering tools and best practices.
• On-site role in our Bengaluru office with opportunities for career progression and meaningful impact on client-facing solutions.