• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 24th Nov 2020

Job Title:  SQL Dev/Engineer with Python and AWS (linked in must)

Duration: 6-9 months

Location: St. Louis (Remote during Covid -19)

End Client: Stifel

Experience: 10+ years

Why is this role open?

The team is responsible for Stifel Data Pipeline.  Currently, it has 4 architects, 1 dev, 1 PO, and 1 SM.  The team is mainly made up of data architects and database developer.  So, you can see that this team will need database dev skill sets (100% cloud based).  At a minimum, candidates must be familiar with AWS in general, Redshift, Aurora, Glue, Lambda, and S3. The languages involved would be Microsoft SQL, Postgres SQL, and Python.

• Local candidates preferred - Candidates will be required to come into St. Louis office to have their laptops configured and set up
• Not looking for an architect (there are 4 on hand), but we do need an engineer to execute, implement, configure the work that architects hand down
• Over 200 objects that need to be connected
• Cloud familiarity
• Heavy use of Python coding
• Must be well-versed with AWS Lambda, Glue, S3
• Must be familiar with Redshift, Postgres, Terraform
• IAM provisioning, access/permissions – utilizing IAM roles

Must have

MS SQL Development/Engineering-8 year(s) of experience

AWS-8 year(s) of experience

Lambda-8 year(s) of experience

Glue-8 year(s) of experience

Redshift-8 year(s) of experience

Aurora-8 year(s) of experience

S3-8 year(s) of experience

Python-8 year(s) of experience

Postgres SQL-8 year(s) of experience

Nice to have

• AWS Data Catalog
• AWS RDS
• Terraform Enterprise
• IAM
• Denodo (upcoming implementation projects)

Daily Duties

• Converting legacy Sql job/objects running on MS 2014 SQL, re-create all functionality using AWS constructs
• May need to transform to Postgres, or may pull all functionality and move to Glue

Best Regards,

Rajesh Varma | Talent Acquisition Consultant |
Direct: (415) 465-8708| rajesh.v@centraprise.com