SQL Server Developer

SQL Server DeveloperJob Location: Iselin, NJ 08830 - LOCALS ONLYJob Duration: 6 - 12+ MonthsClient: DISYSRate: $52/hr on w2 all inclusiveSQL is 50%, C# is 30%, AWS data lake is 20%.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/FinanceSkill Set Required:SQL, ETL/ELT and MDMStrong hands on experience in MS SQL server, Hive and HiveQLC#.NET, MVC, Web APIPython, Spark, PySpark, Jupyter/ZepplinAWS Data Lakes related skillsHadoop, HDFS, S3, EMR, Athena, Redshift, Glue, QuickSight, Apache RangerFamiliarity with Linux Shell ScriptingKafka streaming a big plusAWS Certified is a plus