Title: Senior Database Developer
Location: Jersey city, NJ (Hybrid)
Duration: 8+months
Skills Required: SQL, SSIS, ETL, Python Heavy(all skills must have)
Pre-screening question-
main focus and SSIS and Python start with Baisc python
diff. component of the transformation
scenario how will load files and table
what is the component
simple queries in SQL, involving outer join, inner join, left join, groupBy
date function, SQL server data functions
Python - DATA TYPES, mostly least array, other array diff b/w those the least and mutable (what is mutable in python)
what are the packages in python
SQL server connect to using python
third party tool you have used in python
dictionary and least array and difference b/w them
collection variable in python
generator, hibrators function in python
how will you decorate the python
slowly changing dimension how to implement in ssis
stored procedure in sql server how you define
how you run ssis in debug mode
Any Graduate