Senior Database Developer

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