Responsibilities:
Develop, optimize, and maintain SQL queries, stored procedures, and functions for efficient data retrieval and manipulation.
Design and implement ETL processes using SSIS for data extraction, transformation, and loading from various sources.
Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
Create and maintain data models, ensuring data integrity, normalization, and performance.
Generate insightful reports and dashboards using SSRS to facilitate data-driven decision making.
Troubleshoot and resolve database performance issues, bottlenecks, and data inconsistencies.
Conduct thorough testing and debugging of SQL code to ensure accuracy and reliability.
Stay up-to-date with emerging trends and advancements in SQL technologies and provide recommendations for improvement.
Should be an independent and individual contributor.
Requirements:
Minimum of 4+ years of experience in MS SQL server, SQL Programming, ETL development.
Proven experience as a SQL Developer with a strong focus on MS SQL Server.
Proficiency in SQL programming, including writing complex queries, stored procedures, and functions.
In-depth knowledge of ETL processes and hands-on experience with SSIS.
Strong expertise in creating reports and dashboards using SSRS.
Familiarity with database design principles, query optimization, and data modeling.
Experience with performance tuning and troubleshooting SQL-related issues.
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration abilities.
Ability to work independently and handle multiple tasks simultaneously.
Preferred Skills:
Certification in MS SQL Server or related technologies.
Knowledge of other database systems such as Oracle or MySQL.
Familiarity with data warehousing concepts and tools.
Experience with version control systems