Senior ETL Developer

Looking for Sr. ETL Developer Budget : 30 LPA Exp : 12+ YearsOffice Time : 3 PM – 12:00 AM ISTLocation – Gurgaon, Noida, Chennai, Mumbai, Trichy, Ahmedabad, and Pune.Skillset : Query Optimization, Performance Tunning and Enhancement, Data Modelling (ER Studio or Erwin), MSBI (SSAS and SSIS)

Job Description :12+ 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.12 years of 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 )Expert in creating taxonomy/data dictionary to communicate data requirements that are important to business stakeholdersStrong 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 applicationsConduct 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 systemsDebug 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 and knowledge inStrong understanding in PDW data standards and knowledge in naming stdsExperience working with SSIS packages, configuration and its maintenance.Expert knowledge of design and develop the business processes for file transfer automationStrong in Documentation and data lineage capabilities and analysis

Key Skills

• SQL