I am attempting to find a way to have a Parent Lambda function invoke multiple concurrent parameterized Child Lambda functions, and have another Final Lambda function execute once all of the Child Lambda functions have completed.
The goal is for the Child functions to write data to S3, and for the Final function to import the data from S3 to a database.
Is this possible using Step Functions? If so, how? Is there a better way to approach this?
Yes, it is possible with Step functions. You will need to use a Map state in your state machine.
Here is an AWS Blog post about the Map state that gives examples of it's usage when it was first announced.