hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Solution Architect

12.00 to 14.00 Years   Chandigarh   18 Oct, 2021
EMERSON INNOVATION CENTER
Job LocationChandigarh
EducationNot Mentioned
SalaryNot Disclosed
IndustryManufacturing
Functional AreaArchitecture
EmploymentTypeFull-time

Job Description

*Job Summary:Designing and development support to Architecture of Data Warehouse s and Enterprise Data Lake Programs, design logical and physical data models, designing data load strategies, data archival and purge strategy and designing data staging, transformation, and final layers. Involve in data optimization initiatives, suggest improvements in overall data layer strategies and underlying database parameters.The position is responsible to contribute in design program of Enterprise Datawarehouse environment. The requirements of the position include Datawarehouse design, data load strategies, performance tuning and expertise in dimensional modelling and design.Roles and Responsibilities: Candidate will be responsible to design and develop programs and recommendations to Data migration projects from multi tool enterprise sources to centralised data lakes. This requires to have expertise level on ETL & ELT tools stack especially using Azure Synapse and SSDT.Roles and Responsibilities: Candidate will be responsible to design and develop programs and recommendations to Data migration projects from multi tool enterprise sources to centralised data lakes. This requires to have expertise level on ETL & ELT tools stack especially using Azure Synapse and SSDT., *Required Skills and Experience:

  • 12+ years of relevant experience working in Data warehouse designing, data load strategies, Data purge strategies etc using different ETL Tools.
  • Ability to work in a demanding user environment.
  • Ability to take lead and work with minimum information.
  • Strong Written and Oral communication skills.
  • Should have exposure to Azure DevOps and Agile methodology.
  • Working with Scrum Masters/ Product Owners for assistance in various project implementations.
Functional Responsibilities:
  • Expertise in solution designing, data modelling and performance optimization of ETL programs.
  • Data warehouse design, development and maintenance using Star Schema (Dimensional Modelling) for logical and physical layer
  • Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Data Purge strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
  • Exposure to Star Schema and Snowflake schema Vs Normalisation with good understanding of CM, SDE, SIL, PLP, Knowledge Modules, Load Tracking tables, Metadata etc
  • Expertise in designing data load strategies involving data ingestion from disparate sources (Databases, Flat Files, NoSQLs, XMLs, Sharepoint etc)
  • Expertise in performance tuning and able to suggest design level optimization changes.
  • Must have strong Oracle database experience including complex SQL, query debug and optimization
  • Creating and maintaining SQL Server Database Projects and Deployments to on-Prem SQL server or Azure Synapse Analytics SQL Pool
  • Develop Power BI reports & dashboards driven on Data Warehouse to measure Key Performance Indicators needed to monitor/improve our business
  • Working in Azure DevOps/Agile Scrum based execution methodologies
  • Strong understanding on data migration services to cloud environment.

Keyskills :
javadeliverycustomer relationssalesenvironmentkey performance indicatorspower bisql serverflat filesstar schemadata modelsdata modelingdata migration

APPLY NOW

Solution Architect Related Jobs

© 2019 Hireejobs All Rights Reserved