Work Schedule
Other
Environmental Conditions
Office
Job Description

Summarized Purpose:
We are seeking a Lead Database Engineer to design, build, optimize, and support AWS-based data lake, data warehouse, and database platforms. This role will lead database architecture, performance tuning, data quality, lineage, source-to-target mapping, production support, and technical delivery across PostgreSQL, Redshift, Athena, DynamoDB, SQL Server, and related AWS services.

Education/Experience:
- Bachelor's degree or equivalent experience and relevant formal academic/vocational qualification.
- Previous roles showcasing 7+ years of database engineering, data architecture, AWS data platform, SQL development, performance tuning, and production support experience, or an equivalent blend of education, training, and experience.

Major Job Responsibilities:
- Design, build, and maintain AWS-based data lake and warehouse architecture using S3, Redshift, DynamoDB, RDS, Athena, and related cloud data services.
- Optimize PostgreSQL, Redshift, Athena, DynamoDB, SQL Server,



and SQL-based workloads for performance, reliability, scalability, and cost.
- Lead data integrations, ETL processes, database operations, and source-to-target mapping based on stakeholder and collaborator requirements.
- Maintain and improve existing integrations while adding recent EMR, clinical, operational, and enterprise data integrations.
- Implement data quality frameworks, automated validation, reconciliation, monitoring, and alerting to ensure accurate warehouse and lakehouse loads.
- Normalize EMR, claims, clinical, operational, and flat-file data into data warehouse, analytical, and downstream reporting structures.
- Develop and maintain mapping tables, data dictionaries, source-to-target mappings, metadata, lineage, and technical documentation for analysts and downstream systems.
- Link and transform patient activity, operational, and business data into standardized outputs for analytics and reporting.
-

📌 Lead Database Engineer (Bengaluru)
🏢 Thermo Fisher Scientific
📍 Bengaluru