Database Developer

Job Title: Database Developer ( (only W2)

Location : Jersey City, (Hybrid)

Duration: Long Term

Job Description:

• Skills Required: SQL, SSIS, Python (all skills must have) heavy SSIS
• 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