Full Stack Engineer

Project Role : Full Stack Engineer
Project Role Description : Responsible for developing and/or engineering the end-to-end features of a system, from user experience to backend code. Use development skills to deliver innovative solutions that help our clients improve the services they provide. Leverage new technologies that can be applied to solve challenging business problems with a cloud first and agile mindset.
Must have skills : Amazon Web Services (AWS)
Good to have skills : MySQL, Charles River Data and Position Management
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education
Analyze the API end-point detail (attributes): Review and document the attributes available at the API endpoints. Ensure the data structure aligns with the project requirements. Create jobs to pull the data from the API end-points: Develop ETL jobs to automate data extraction from various APIs. Schedule and monitor these jobs to ensure consistent data flow. Reconcile the result with the existing Procedure detail (as applicable): Compare new data extracts with existing datasets to identify discrepancies. Conduct analysis to find any missing attributes in the new data set. Validate the accuracy and completeness of the data against existing records. Validate the data extraction performance of the new end-point: Test and optimize the performance of data extraction processes. Ensure data is extracted efficiently w/o impacting system performance. Collaborate on troubleshooting and data validation efforts in case of any discrepancies, ensuring regular communication with the CRD Data team. Integrate new API endpoints into the data pipeline (via Brew). Write and optimize SQL queries to join and transform data from multiple sources. Conduct unit testing to ensure that data pipeline is functioning as expected. Perform continuous data validation to maintain data integrity and quality. Deploy ETL jobs and data pipelines to the CRD Stage/ Prod environments.