Azure SQL Developer

"Skills Required
• Experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager etc
• Experience with data warehouse, ETL, SSIS to move data / integrate systems.
• Clear communication and interpersonal skills required.
• Experience in migrating database workload from SQL Server on premise to Azure database services (Azure SQL Managed instance)
• Experience in migrating on-premises SSIS workload to SSIS in ADF (or) Synapse pipelines.
• Experience with Azure Data / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus
• Attention to detail and feedback from clients on dashboards and reports must be completed rapidly.
• Experience with SDLC methodologies required eg. Agile / Waterfall
• Experience with databases, data modeling design
• Experience working with Content Management Systems like MS SharePoint or box.com a plus.
• Knowledge on Banking / Risk related systems is a plus.
• Experience developing code to consuming REST API services a plus.
• Experience integrating systems with COTS Commercial Off the Shelf software packages a plus.
• Experience with implementing DevOps a plus
• Experience with MS Azure Cloud services

Responsibilities:
• [Critical] Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse.
• Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients.
• Developing SQL views to enable data consumers to read data from data warehouse.
• Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
• Responsible for documenting databases, data process flows and maintain data dictionaries.
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required.
• Train and assist users at all levels. "