SQL Server Developer

Top Skills Details

1) SQL Server and SSIS experience - experience writing stored procedures, object oriented, querying, DDLs. SSIS - know how to connect to source, what are the transformations/ doing transformations, how to log/ do logging.
How do you connect to a source?
What are the transformations?
How do you do logging?

2) Hadoop experience - python scripting, how to query hive data, how do you enrich this data through Spark. Eventually in the future they will be migrating to Hadoop so need to have that experience. Experience pulling data from SQL using SSIS to massage it, from Hadoop to SQL
- How do you query hive data?
- How do you enrich this data through Spark?

3) Experience discussing requirements with the business team and changing into the technical requirements. Need to know the SDLC process and Jira process, Scrum and Kanban should know that.

4) Experience with data analysis and coming in with request and reporting requirements based on what those are, looking at the metrics and figuring out what the issues are, collect that data.