Candidate Must Have:
- 4-6yrs Experience in Business Intelligence along with database design and integration experience with SQL Server databases
- Strong experience of SQL Server 2016/Azure databases
- Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology)
- ETL/ELT (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS & T-SQL, Talend, SQL, SOQL)
- Ability to connect to heterogenous sources like Salesforce, Oracle, Anaplan, SQL Server, MySQL etc to perform data migration
Preferred Skills:
- Azure Data Factory & Data Lake
- Analytics/ OLAP Cube Development (Microsoft SSAS/AAS, MDX - Multidimensional Model, DAX - Tabular Model)
- Report and Dashboard Development (Microsoft SSRS and Microsoft Power BI)
Primary responsibilities:
- Demonstrate advanced knowledge and skills in designing and implementing Data Marts, Data Warehouse, ETL and BI solutions
- Expertise / Handson skills in data modelling, ETL and data components development using: SQL Server T-SQL, SQL stored procedures, triggers and views, SSIS, Talend, SQL, SOQL and SQL agent jobs
- Designing, developing and testing data transformations for reporting and interfaces between systems
- Understanding of database architecture, security and deployment strategies
Secondary Responsibilities:
- Developing Cubes using SSAS Models and querying data using Excel and Powerview
- Developing Reports using SSRS / PowerBI
- Helping business with Self-service BI and Analytics
- Hands on administrative experience with SQL Server 2016
Soft Skills:
- Ability to read, analyze, and interpret general business documentation, technical specifications and project management documentation
- Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
- Good analytical, logical reasoning and problem-solving skills
- Good interpersonal, written, and oral communication skills
- Self-motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment
- Experience working in a team-oriented, collaborative environment
BE/BTECH in Information Technology, Computer Science, or related field
All your information will be kept confidential according to EEO guidelines.