Build 4 x AWS Lambda Functions
- or -
Post a project like this1523
£250(approx. $313)
- Posted:
- Proposals: 11
- Remote
- #2691177
- OPPORTUNITY
- Awarded
AI & Data Science Engineer | Nodejs | Ruby On Rails | AWS | GCP | Python | React | Angular |
Auckland
1422650461086108868123114612552841297002433375323390938341962735758073619197
Description
Experience Level: Intermediate
Hello,
I need a developer to build me 4 x AWS Lambda functions which will do the following:
Lambda Function 1
• When the file is loaded into S3 run a check to ensure the data contained within the file is correct
• If it is correct move the file from one S3 bucket to another S3 bucket
• If the data is not correct, delete the invalid lines from the file. Move the valid data items to the correct S3 buck, and issue an SNS email to confirm the invalid lines which were rejected
Lambda Function 2
• When the file moved from the staging S3 to the holding S3 a check is completed to see if the holding S3 contains more than 6 files
• If there is less than six files no further action take place.
• If there are more than 6 files, the oldest file is moved to Glacier
Lambda Function 3
• Once the file is moved to S3 holding, the file is inserted into an Aurora database for processing without the header row
• The function will purge the existing table and insert the new data for processing
Lambda Function 4
Once the data has been loaded into the ‘Holding’ table, split the data into two further tables based on if the UPRN field is Null
• Where the UPRN is null load the data into the table ‘Holding_UPRN_Check’, purging any old data prior to being loaded
• Where the UPRN is not Null load the data into the table ‘Holding_UPRN_Valid’, purging any old data prior to being loaded
Access will be given to the AWS account, the MySQL database & tables, S3 Buckets, Glacier Buckets, test data and fully documented requirement have been built. You will need to provide your IP address to be connected
There are a further 6 functions to build, so if this goes well there is more work
Many Thanks
Ben
I need a developer to build me 4 x AWS Lambda functions which will do the following:
Lambda Function 1
• When the file is loaded into S3 run a check to ensure the data contained within the file is correct
• If it is correct move the file from one S3 bucket to another S3 bucket
• If the data is not correct, delete the invalid lines from the file. Move the valid data items to the correct S3 buck, and issue an SNS email to confirm the invalid lines which were rejected
Lambda Function 2
• When the file moved from the staging S3 to the holding S3 a check is completed to see if the holding S3 contains more than 6 files
• If there is less than six files no further action take place.
• If there are more than 6 files, the oldest file is moved to Glacier
Lambda Function 3
• Once the file is moved to S3 holding, the file is inserted into an Aurora database for processing without the header row
• The function will purge the existing table and insert the new data for processing
Lambda Function 4
Once the data has been loaded into the ‘Holding’ table, split the data into two further tables based on if the UPRN field is Null
• Where the UPRN is null load the data into the table ‘Holding_UPRN_Check’, purging any old data prior to being loaded
• Where the UPRN is not Null load the data into the table ‘Holding_UPRN_Valid’, purging any old data prior to being loaded
Access will be given to the AWS account, the MySQL database & tables, S3 Buckets, Glacier Buckets, test data and fully documented requirement have been built. You will need to provide your IP address to be connected
There are a further 6 functions to build, so if this goes well there is more work
Many Thanks
Ben
Ben R.
100% (23)Projects Completed
17
Freelancers worked with
16
Projects awarded
41%
Last project
1 Apr 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies