Roles and Responsibilities
Job description as per Success Factor :
Should have 5-8 years experience
Good experience in Data Warehousing/BI & data architecture, concepts & frameworks.
Extensive experience in designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools, SSIS
Knowledge of BI architectures, concepts and frameworks.
Extensive experience of Azure ADL (Azure Data lake), ADF (Azure Data Factory) & Azure Synapse.
Experience of ADF pipeline migration from one environment to other environment.
Extensive experience in RDBMS platforms i.e. SQL Server.
Capable of facilitating data discovery sessions involving business.
Ability to create and maintain conceptual/business, logical and physical data models.
Ability to synchronize models to ensure that database structures match model.
Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques.
Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
Ability to perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production.
Ability to develop ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
Ability to create, execute and document unit test plans for ETL and data integration processes and programs.
Responsibilities:
Responsible for all aspects of Infrastructure including Strategy, Planning, Resourcing, Process, Training & Mentoring, Tracking, Reporting and On-going demonstrable improvements
Provisioning of Services for all the underlying elements (servers, system, network, database, application) including - procurement & vendor management (where applicable), installation, configuration, patching, maintenance.
Develops technical road-maps for future Azure cloud implementations.
Possess wide experience in country-specific local laws and industry standards from designing to deployment phases
Design scalable infrastructure setup by forward thinking on future market needs, technology challenges and changes
Should be abl

Keyskills: configuration data warehousing azure