Data Engineer

Look for a Mid-level consultant Should have good experience with Sql, PySpark, ssis, ssrs, reporting Who has worked as a Data Engineer/Analyst? Any Visa Works 100% Remote – EST Time zone Description • Strong Communication Skills • 5 – 6 years IT experience using SQL • Good SQL skills - hands on and granular level • Data Lineage between source and target systems • Experienced in Pyspark • Good to Have: MS SQL Server, SSRS, SSIS, Power BI • SQL: various Joins, Clauses, Truncate, Delete, Pseudo code, Sub Query, complex queries • Reports: Sub Reports, parameters, drill downs • Understand requirements, Design data models Below is Interview criteria – need strong SQL Query skills with some Reports and Data Analysis skills. Role: Has to perform data analysis on various clinical trials through SQL queries and provide lineage and information to Dashboards team to generate reports. Skills required (SQL):

1. Various Joins
2. Normalization/Denormalization
3. Indexes, Constraints, Operators, Triggers, Variables (Global / Local), Forms
4. Sub Queries, Sub Reports, Functions in Reports
5. SQL Queries – How to fetch Characters, Records
6. Clauses – WITH, WHERE
7. Truncate / Delete / Drop
8. Complex Queries, SQL techniques
9. Data Analysis Skills
10. MS BI skills – SSIS, Power BI, SSRS