Company Logo

Data Engineer

Hiring EventHiring Event
MetaDesign SolutionsBangalore, Karnataka, India
Onsite
Job TypeFullTime
CTC Icon₹10L - ₹17L /year
Posted this week
Openings4 Openings

Skills Required

AirflowAirflowAirflowAirflow+ More
Job Description

Job Title: Data Engineer

Company: MetaDesign Solutions

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

Experience: 4-5 years


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.


Perks
Paid Time Off (PTO)
Performance Bonus

Refer & Earn Cash Rewards!

Know someone for this job? Refer via email or followed users & track easily! Log in to get your referral link and start sharing

Refer & Earn