Key Requirements

• Extensive knowledge of writing and optimizing complex Stored Procedures and T-SQL queries to interact with the database efficiently

•Experience with SSIS (SQL Server Integration Services) for ETL (Extract, Transform, Load) processes and data integration or equivalent

•Expertise in large-scale and efficient data processing, including handling XML, CSV, API data, text files, and interacting with databases

•Proficiency in database and data warehouse design, including schema design, indexing, performance tuning, and data modeling

•Proficient in C# and/or VB NET programming languages

•Understanding and practical experience with Object-Relational Mapping (ORM) frameworks such as Entity Framework or NHibernate for efficient database access and management

Bonuses for these sorts of skills

•Knowledge of other data warehousing systems including Snowflake

•Understanding and practical experience with CQRS (Command Query Responsibility Segregation) using clean architecture principles

•Knowledge of various design patterns and their application in software development

•Familiarity with MediatR or similar libraries for implementing the Mediator pattern in communication between application components

•Experience using MassTransit or equivalent messaging frameworks for building scalable and distributed systems

•Experience in building REST APIs using ASP NET Core, including request handling, routing, validation, and serialization/deserialization

•Understanding of microservices architecture and its principles, including service decomposition, bounded contexts, and communication patterns

•Experience in unit testing .NET Core applications using frameworks like NUnit or xUnit

Team

•Understanding of team collaboration in Scrum/Agile environments, including working effectively within a team, participating in Scrum ceremonies, and collaborating with other team members

•Knowledge of testing methodologies and practices, including unit testing and integration testing, to ensure code quality and functionality

•Excellent communication skills to clearly convey ideas, requirements, and progress to team members and stakeholders

•Ability to work in backlog refinement, including breaking down user stories, estimating effort, and prioritizing tasks within the team’s sprint cycles

•Experience in working with feature-based teams, understanding the development process, and delivering features within the team’s sprint cycles

Experience

•More than 5 years of experience in SQL, ETL processes, data modeling, and data architecture