Highlights
Responsibilities: Take existing SQL stored procedures, transforming to fabric notebooks and those will create the silver tables in the Lakehouse in fabric, and they should match 1 to 1 SQL tables on PREM. Will be building silver layer in the medallion architecture (will be in a solely isolated environment) - bronze is outside of scope and gold is beyond their score.
Numbers & Facts
| Location | Rapid City, IL (Remote) |
| Industry | Computer/IT Services |
| Salary | $60–$63 Per Hour |
| Company Size | 500 to 999 employees |
| Website | https://www.apolisrises.com/ |
Description
Data Engineer – SQL to Microsoft Fabric Modernization/Migration
100% remote
This is a 10-week project (that is about 2.5 months)
We are targeting October 12th or 19th as a start date
Strong Communication required
Must provide LinkedIn Profile
Responsibilities:
Apolis2024
100% remote
This is a 10-week project (that is about 2.5 months)
We are targeting October 12th or 19th as a start date
Strong Communication required
Must provide LinkedIn Profile
Responsibilities:
- Take existing SQL stored procedures, transforming to fabric notebooks and those will create the silver tables in the Lakehouse in fabric, and they should match 1 to 1 SQL tables on PREM
- Creating orchestration framework using data pipelines in fabric
- Must do validate artifacts - reconciliation results, expectance evidence, making sure the tables match 1 to 1
- Build out validation tests that can consistently run day in and day out
- Will be building silver layer in the medallion architecture (will be in a solely isolated environment) - bronze is outside of scope and gold is beyond their score
- Creating technical documentation to cover what they have done -this is what we did and how
- 5-7 years of experience (SQL, T-SQL, Spark)
- Fabric (1-2 years minimum)
- Very strong SQL and T-SQL (understand stored procedures, understand SQL, taking that SQL and migrating it to fabric notebooks)
- PySpark
- Spark SQL
- Understand data flows in Fabric, data pipelines, understand what a Lakehouse is an how to use it
- What a medallion architecture will be primarily in the silver layer
- Some understanding the orchestration and scheduling in fabric
- Nice to have is experience using metadata framework
Apolis2024
Benefits
Paid Sick Days, Employee Referral Program, Employee Events, Retirement / Pension Plans
About Company
Since 1996, RJT has provided successful SAP, Oracle, and IT consulting solutions and staffing services to clients around the world. The new Apolis brings you the same personalized service fortified with a greater array of IT solutions, global expertise, and cost-management strategies.
We are a global IT consultancy that seamlessly integrates experts and leading-edge solutions into your organization so you can focus on what really matters.