Hi,
Please go through the requirement given below and kindly send me your resume in word document. Please mention your minimum expected salary, visa status, current location and availability to start a new project. Please let us know if you would like to work on our W2 or 1099/CTC. You can please email the resumes to varma@hermitageinfotech.com.
Mail - varma@hermitageinfotech.com
We need to post a requirement for Cloud Data Engineer., Below are the job duties.
Develop Entity Relationship models and Star schemas for clinical data warehouse to support the needs of customer business analytics.
ð Create data models for MATCH & CTRP using Visual Paradigm.
ð Define data integrity constraints between the entities.
ð Create Aurora MySQL database out of the export SQL from ERD model.
§ Perform ETL activities to process the data from MongoDB and Dynamo DB to Aurora relational database.
ð Writing Lambda functions to process the clinical data from source systems (Mongo DB JSON document collections) to Aurora staging layer.
ð Creating PySpark ETL jobs to process the data into the clinical data warehouse, which supports customer’s reporting dashboard analytics.
§ Develop and perform complex SQL-based queries against the DWH, which is being built in Amazon Redshift database.
ð Create Redshift database defining Sort & DIST keys for the tables
ð Enable encoding for the tables to speed up the data retrieval.
ð Perform vacuum operations regularly on Redshift database.
§ Leverage Amazon Redshift for DWH activities
ð Create views to access the data from reporting.
ð Create custom SQL queries required for data visualization
ð Create ELT script to populate the data across the tables in Redshift.
§ Work in Linux and OS/X based environments
ð Write shell scripts to move JSON & flat files data across different platform servers.
§ Prepare migration document to move the AWS lambdas from development to testing and then to production environments.
§ Collaborate and communicate with other team members towards the development of high-quality technical deliverables.
§ Provide documentation for all developed data models, including process flow and source and target mapping.
§ Perform test plan preparation and unit and system testing.
§ Conduct performance tuning and troubleshooting.
Qualification: BA/BS in Engineering, CS or related field.
Years of experience: 8 plus years