Senior ETL Developer

Role: Senior ETL DeveloperExperience: 6+ YearsCompany: Mastek Digital INDIA Locations: Noida / Gurgaon / Chennai / Mumbai / Pune / Ahmedabad / Trichi

7+ 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.Technical hands-on experience in development of data warehousing solutions and data modeling capabilitiesMicrosoft BI (SQL Server Integration Services - SSIS, Analysis Services - SSAS, Power BI tools, DAX functions ,Reporting Services - SSRS, PPS, T-SQL )Strong Knowledge in design, implement and maintain database objects (tables, views, indexes, ) and database securityConduct 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.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 an

Key Skills

• SQL