db={firstCol:[{"_id":ObjectId("6229d3cfdbfc81a8777e4821"),"jobs":[{"job_ID":ObjectId("62289ded8079821eb24760e0"),"Process":[{"profile_id":ObjectId("6285e571681188e83d434797")},{"profile_id":ObjectId("6285e571681188e83d434799")}]},{"job_ID":ObjectId("6228a252fb4554dd5c48202a"),"Process":[{"profile_id":ObjectId("62861067dc9771331e61df5b")}]},{"job_ID":ObjectId("622af1c391b290d34701af9f"),"Process":[""]}],"email":"********@gmail.com"}],user__profiles:[{"_id":ObjectId("6285e571681188e83d434797"),"Name":"Lakshdwanan","Location":"California"},{"_id":ObjectId("6285e571681188e83d434798"),"Name":"LakshdwananB","Location":"California"},{"_id":ObjectId("6285e571681188e83d434799"),"Name":"LakshdwananC","Location":"California"}]}

db.firstCol.aggregate([{$match:{email:"********@gmail.com"}},{$project:{jobs:{$filter:{input:"$jobs",as:"item",cond:{$eq:["$$item.job_ID",ObjectId("62289ded8079821eb24760e0")]}}},_id:0}},{$lookup:{from:"user__profiles",localField:"jobs.Process.profile_id",foreignField:"_id",as:"jobings"}},{$project:{res:"$jobings",_id:0}},{$unwind:"$res"},{$replaceRoot:{newRoot:"$res"}}])