Skills and Qualifications:
• 7+ years of experience in DW/BI space in both designing the model and building analytics. At least executed two end-to-end implementations. At least worked for min. 2 year in Azure SQL and ADF
• SQL / Relational Database Proficiency: Strong knowledge of SQL syntax, database design principles, and SQL Server, Oracle or other database systems.
• Data Management: Experience with data modeling, data warehousing, and ETL (Extract, Transform, Load) processes
• Proficient in Infor Omni-Channel Campaign Management- Enterprise Marketing Suite – creating jobs, ETL process in Infor Admin, setting up jobs, creation of reports, creating/updating users and Groups
• Preferred Understanding of IBM WAS (Web Application server) – node agents, manager, applications
• Strong understanding of Azure Data Factory: Expert-level knowledge of Azure Data Factory’s features, capabilities, and best practices.
• Master in Azure SQL stack architecture (SQL Server, SQL Warehouse and Azure Data factory)
• Understanding of data analysis principles and reporting techniques.
• Preferred knowledge of python, Pentaho, or shell scripting
• Problem-solving and Analytical Skills: Ability to identify and resolve data warehouse issues and analyze complex data sets.
• Communication Skills: Ability to communicate technical concepts to both technical and non-technical audiences.
• Functional knowledge of common business processes like quote to cash, clickstream analysis, revenue, booking, billing, etc. is desirable.