Description

Title: Senior Database Developer

 

Location: Jersey city, NJ (Hybrid)

 

Duration: 8+months

 

Skills Required: SQL, SSIS, ETL, Python Heavy(all skills must have)

 

  • Able to write SQL queries
  • 8-15 years of experience
  • Strong exp. with SQL queries
  • Have some knowledge in Business intelligence tools
  • SSIS, SQL, Python
  • Some Python experiences is required
  • ETL tools exp. is plus
  • How to write complex sql queries - screen share
  • ETL modern stack - connecting data from APIs, jsons
  • Rewrite/modify Python code at minimum
  • Business intelligence resiliency team
  • 40 data sources
  • Helpful to have an understanding of the business -transform their requirements
  • Do reporting

 

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

 

 

 

 

Education

Any Graduate