Roles and Responsibilities
Resource required for a regular position
Up to 1 year contract with MNC
SQL BI Developer (Data warehousing, MS SQL DB, SSIS, SSAS) - 10+ years
Excellent opportunity for a senior lead with more than 10yrs of experience in database, data warehousing with SSIS, SSAS. You are expected to work independently with minimal guidance.
Project Role: Senior Lead
Project Role Description: Design, build and configure applications to meet business process and application requirements.
Key Responsibilities : Design, build and deploy effective SSIS packages Implement stored procedures and effectively query a database Translate requirements from the business and analyst into technical code Identify and test for bugs and bottlenecks in the ETL solution Ensure the best possible performance and quality in the packages Provide support and fix issues in the packages
Technical Experience: Writes advanced SQL including some query tuning Experience in the identification of data quality Some database design experience is helpful Experience designing and building complete SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing, Knowledge of DAX, MDX Query a plus, Utilize ad hoc techniques to perform on-the fly analysis of data Proficient in how to deploy to and debug a production SSIS environment
A: Self-disciplined, strong problem solving, trouble shooting skills
B: Should have good communication skills verbal and written
C: Should have good team handling skills
Work Experience: 10+ years
Must Have Skills: Microsoft SQL Server Integration Services (SSIS, SSAS), excellent knowledge of Database.
Good to Have Skills: DAX, MDX Query