Roles and Responsibilities:
Must have Skills:
- Microsoft SQL Server Integration Services SSIS
Preferred Skills :
- Microsoft SQL Server Integration Services SSIS
Key Responsibilities:
- Will be responsible for creating and analyzing stored procedures, Views, User Defined functions, Sub-queries and joins for complex queries involving multiple tables Experience in query tuning, fixing performance related issues.
- Should be able to work on SSIS Transformations to implement complex ETL logic, using lookups, containers.
- Should be able to work on Data Warehousing using schemas, facts, dimensions etc.
- Should be able to work on SSRS Report development.
Technical Experience :
- Should have 4-5 years of experience in Microsoft SQL Server, Microsoft SQL Server Integration Services SSIS, DWH, SSRS
- Should have 4-5 years of experience in Microsoft SQL Server Analysis Services SSAS
- Should have 4-5 years of experience in MSBI.
- Should have 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
Professional Attributes:
- Pure Technical MS SQL and Oracle Technical SQL PL/SQL
Education:
- Bachelors Degree in a technical field
- Should have excellent verbal communication skills
