Key Skillset (Must Have)
- Strong database programming/ backend development experience using SQL Server/Azure SQL, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
- Strong knowledge in data modeling and Datawarehouse concepts.
- Experience on Azure Data Factory or any other ETL
- Develops, maintains, and optimizes all data layer components for new and existing systems, including databases, stored procedures, ETL packages, and SQL queries
- Experience on Azure data platform offerings.
- Interacts with application developers from various core systems to address changes in those systems and their impact on existing SQL databases
- Defines data solutions for business problems by working directly with project managers, seniors and clients
- Ability to effectively communicate with other senior leaders of IT on program strategies and plans and negotiate quality solutions
Secondary Skillset (Good to Have)
- Snowflake, Snowpipe
- Databricks
- Python or Pyspark or Scala
- Any NoSQL Database
Qualification & Experience Required
- Strong verbal and written communications skills
- Ability to work as an individual contributor.
- 4+ years of experience on SQL DB/Server including building SQL Database, database designing and data modelling, SQL server experience with SSIS, Any ETL experience.
- Experience on Azure Data Factory or SSIS or any other ETL tools
- Exposure to visual analytics tool (Power BI) would be good to have but not mandatory
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.