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