Experience
3+ years.
Mandatory skills
MS SQL Server, Data Lake, Azure, SQL, SSIS, ADF, Azure Function
Qualification
Bachelor’s Degree
Job Purpose
The person in this role must play a pivotal role in conceptualizing and driving various learning initiatives to enhance the skills and knowledge of the employees. This role demands a high level of collaboration skills to deal with internal and external stakeholders. Identify training needs, develop curriculum, and manage overall training operations. Strong communication skills, attention to detail, and a passion for talent development are the key qualities expected out of this role.
Job Description / Duties and Responsibilities
- Designs, develops, and delivers solutions that meet business line and enterprise requirements.
- Participates in rapid prototyping and POC development efforts.
- Advances overall enterprise technical architecture and implementation best practices.
- Assists in efforts to develop and refine functional and non-functional requirements.
- Participates in iteration and release planning.
- Informs efforts to develop and refine functional and non-functional requirements.
- Demonstrates knowledge of, adherence to, monitoring and responsibility for compliance with state and federal regulations and laws as they pertain to this position.
- Strong ability to produce high-quality, properly functioning deliverables the first time.
- Delivers work product according to established deadlines.
- Estimates tasks with a level of granularity and accuracy commensurate with the information provided.
- Works collaboratively in a small team.
- Excels in a rapid iteration environment with short turnaround times.
- Deals positively with high levels of uncertainty, ambiguity, and shifting priorities.
- Accepts a wide variety of tasks and pitches in wherever needed.
- Constructively presents, discusses and debates alternatives.
- Takes shared ownership of the product.
- Communicates effectively both verbally and in writing.
- Takes direction from team leads and upper management.
- Ability to work with little to no supervision while performing duties.
- Proficient in ADF
- Strong in MS SQL & Azure SQL
- Hands on experience in Data Lake
- Hands-on experience in data mart and data warehousing including variant schemas (Star, Snowflake).
- 3+ years of experience with advanced queries, stored procedures, views, triggers, etc.
- 3+ years of experience of performance tuning queries.
- 3+ years of experience of both DDL and DML.
- 3+ years of experience designing enterprise database systems using Microsoft SQL Server/Azure SQL preferred.
- Hands-on experience in Data Migration
- Experience in Lakehouse architecture preferred.
- Experience with Cloud technologies – AWS, Snowflake is preferred.
- Experience with SSIS is a plus.
- Deep understanding of one or more source/version control systems. Develops branching and merging strategies.
- Working understanding of Web API, REST, JSON.
- Working understanding of unit testing creation.
- Adhere to ISMS policies and procedures