Source description
About the role
You will be responsible for creating and analyzing stored procedures, views, user-defined functions, sub-queries, and joins for complex queries involving multiple tables. Your experience in query tuning and fixing performance-related issues will be crucial. Additionally, you should be able to work on SSIS transformations to implement complex ETL logic using lookups and containers. Data warehousing using schemas, facts, dimensions, etc., and SSRS report development will also be part of your key responsibilities. Key Responsibilities: - Create and analyze stored procedures, views, user-defined functions, sub-queries, and joins for complex queries - Work on SSIS transformations to implement complex ETL logic - Implement data warehousing using schemas, facts, dimensions, etc. - Develop SSRS reports Qualifications Required: - 4-5 years of experience in Microsoft SQL Server, Microsoft SQL Server Integration Services SSIS, DWH, SSRS - 4-5 years of experience in Microsoft SQL Server Analysis Services SSAS - 4-5 years of experience in MSBI - 4-5 years of experience in database/DWH/SSIS/SSRS design and optimization - Sound knowledge of ETL processing in SQL server and data warehousing concept You should possess a Bachelor's degree in a technical field and excellent verbal communication skills. Immediate-15 days joiners are preferred. You will be responsible for creating and analyzing stored procedures, views, user-defined functions, sub-queries, and joins for complex queries involving multiple tables. Your experience in query tuning and fixing performance-related issues will be crucial. Additionally, you should be able to work on SSIS transformations to implement complex ETL logic using lookups and containers. Data warehousing using schemas, facts, dimensions, etc., and SSRS report development will also be part of your key responsibilities. Key Responsibilities: - Create and analyze stored procedures, views, user-defined functions, sub-queries, and joins for complex queries - Work on SSIS transformations to implement complex ETL logic - Implement data warehousing using schemas, facts, dimensions, etc. - Develop SSRS reports Qualifications Required: - 4-5 years of experience in Microsoft SQL Server, Microsoft SQL Server Integration Services SSIS, DWH, SSRS - 4-5 years of experience in Microsoft SQL Server Analysis Services SSAS - 4-5 years of experience in MSBI - 4-5 years of experience in database/DWH/SSIS/SSRS design and optimization - Sound knowledge of ETL processing in SQL server and data warehousing concept You should possess a Bachelor's degree in a technical field and excellent verbal communication skills. Immediate-15 days joiners are preferred.
More at BCFORWARD INDIA TECHNOLOGIES PRIVATE LIMITED