Senior Data Warehouse Developer

Fortinet   •  

Sunnyvale, CA

Industry: Software

  •  

Not Specified years

Posted 296 days ago

This job is no longer available.

Position Overview

Required Skills sets


Back End Knowledge
• SQLServer (2016) ? Complete knowledge about Database {Create, Backup, performance tuning }
• TSQL  ? Complete knowledge of CURD including {Create Tables\procedures\views\functions }
• SSIS ? Complete knowledge of all ETL tasks  including( error handling\reporting, scheduling and security)
• Experience designing, building, developing and supporting end-to-end ETL strategies

Front End Knowledge
• Data Retrieving
• Data modelling\Data shaping
• Complete Knowledge with BI Tools
• Tableau\Power BI (based on what we choose)
• SSRS

 

Responsibilities
• Collaborate with business users to capture & define business requirements
• Responsible to gather requirements, design, model, develop, test, document, train and support data warehouse and business intelligence programs
• Troubleshoot issues and insure optimal performance for ETL and reporting
• Create key reports based on business user needs
• Based on user request do fit-gap analysis to add additional data schemas, fields into data marts


Additional Skills
• PSQL
• Scripting Language: JavaScript\VB Script
• Microsoft Office
o Excel(power Query, power Pivot) 
o Excel VBA
• Knowledge of OBIEE and ODI
• Basic understanding about financial terms like {PO, Sales order, Billings}
• SSAS (Optional)

 

Personality
• Good Communication  (Mandatory)
• Dedicated to deliver the results  (Mandatory)
• Able to suggest alternate and quick solutions  (Mandatory)

 AMGA603