ETL Developer - Data Modeling & Warehousing

Job Description :- 7-10 years of IT experience in Data Architecture, Data Warehouse, Business Intelligence, ETL, OLAP Cubes, Data Analysis, Design, Development, Implementation, Testing and troubleshooting of DW, strong emphasis on user requirements gathering, business rules and data analysis.- 7-10 years of technical hands-on experience in development of data warehousing solutions and data modeling capabilities- Microsoft BI (SQL Server Integration Services - SSIS, Analysis Services - SSAS, Power BI tools, DAX functions ,Reporting Services - SSRS, PPS, T-SQL )- Expert in creating taxonomy/data dictionary to communicate data requirements that are important to business stakeholders- Strong Knowledge in design, implement and maintain database objects (tables, views, indexes, ) and database security.- Min 7-10-year exp preparing models that can improve the interoperability of data among the project related systems and improve the performance of underlying data queries and data movement that feed applications- Conduct the evaluation of existing project data systems, including constructing as-is data models (where they are not already documented) and identifying foundational data model issues that could affect the efficient and effective use of data (e.g., slow queries, poorly validated data, unnecessary duplication of data, data quality issued not attended in existing design process etc.)- Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data across systems- Debug and tune SQL server stored procedures for high complex data warehouse systems.- Should be able to develop ETL delta process and tabular models that are compatible with data warehouse standards.- Exp in sales and manufacturing domain - Strong understanding in PDW data standards and knowledge in naming stds- Experience working with SSIS packages, configuration and its maintenance.- Expert knowledge of design and develop the business processes for file transfer automation- Strong in Documentation and data lineage capabilities and analysis (ref:hirist.tech)