Job Title: SQL Server Developer - 71034
Job Location: Iselin, NJ 08830 - LOCALS ONLY
Job Duration: 6 - 12 + Months
Client: DISYS
Rate: $52/hr on w2 all inclusive
SQL is 50%, C# is 30%, AWS data lake is 20%.
Notes:
This is a long term role with potential to hire.
candidate should be local as they will be expected to report into the office at some point soon.
Must be strong with SQL.
The ideal candidate has 10+ years of experience with SQL and C# with some recent experience with AWS (AWS, S#, EMR, Hive, Python).
first round interview will be technical specific to SQL and C# then with some light questions on AWS, data lake, python.
this is a 100% development role.
they already have the design, will show them the pipeline and they'll follow that pattern and start working on AWS data lake later.
SQL is 50%, C# is 30%, AWS data lake is 20%.
10 years in sql/c# and 1-2 with AWS ideal.
with C3, they may be changing or modifying their reporting engine executed in C#.
Seeking a Database Engineer with AWS experience with a Data Warehousing background and C#.
Data Engineer with experience in Microsoft Stack (MS SQL Server, C#) and Cloud based technologies (AWS).
Candidate should have experience designing and developing data warehouses, data lakes, data pipelines, analytics and business intelligence solutions.
Candidate must be fluent in designing product architecture within the cloud and inhouse.
Needs to be comfortable mentoring senior level engineers in cloud technologies.
Candidate should also have some web applications development experience using Microsoft/.NET.
Advanced SQL development knowledge using MS SQL Server
Experience in Data Modeling and building data warehouse/data lake solutions that involve multiple disparate sources
Experience building data lakes in AWS environment
Experience using Lake Formation or other Third Party tools for creation of data pipelines
Experience in Web applications development using .NET stack (C#, MVC)
Experience in creation of data integration components
Provide design decisions around data warehouse solutions that involve multiple disparate business systems.
Ensure quality level of documentation is produced and maintained in regards to data solution architecture
Experience working in an Agile/Scrum environment
Background in Banking/Finance
Skill Set Required:
SQL, ETL/ELT and MDM
Strong hands on experience in MS SQL server, Hive and HiveQL
C# .NET, MVC, Web API
Python, Spark, PySpark, Jupyter/Zepplin
AWS Data Lakes related skills Hadoop, HDFS, S3, EMR, Athena, Redshift, Glue, QuickSight, Apache Ranger
Familiarity with Linux Shell Scripting
Kafka streaming a big plus
AWS Certified is a plus