Padmi

Microsoft SQL Server Integration Services Professional

Delhi NCRPosted 2 months ago
Infrastructure And DatabasesMid-levelFull Time; Regular
Apply at BCFORWARD INDIA TECHNOLOGIES PRIVATE LIMITED

Opens the source posting on shine.com

Source description

About the role

View original

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.

One address, no account. We’ll tell you when matching roles go live.

More at BCFORWARD INDIA TECHNOLOGIES PRIVATE LIMITED

Related open roles

View all roles