Data Ingestion Engineer
CurrentAs the Data Ingestion Engineer with Nextonic Solutions, I build data pipelines for the National Center for Advancing Translational Sciences (NCATS), a division of the National Institutes of Health (NIH). In this role, I: • Design, develop, and implement efficient data ingestion (ETL/ELT) processes, primarily with Python;• Validate the data to ensure accuracy, consistency, and integrity at every stage of the ingestion process;• Automate workflows to minimizing the need for manual monitoring or routine interaction;• Manage, monitor, and optimize databases (Postgres, MySQL) to ensure high availability, performance, and scalability;• Implement best practices for indexing, query optimization, and database tuning to ensure optimal query performance.