Role:
Data Warehouse Architect
Min Experince:
6 Years
Employment Type:
Full-Time (WFH)
Industry Type:
IT-Software - Software Services
Functional Area:
IT Software - Data Warehouse and ETL
Key Skills Required:
SQL Server, DW, MSBI, SSIS, ETL, Star Schema, Snowflake, Data Vault, Azure - Data Factory | Data Lake | Data bricks | Blob Storage | Analytical service Synapse
Roles and Responsibilities
- Should have a strong professional background in ETL Data warehouse concepts like StarSchema, Snowflake and Data Vault.
- Develop, test, and maintain SQL queries, and stored procedures built on SSIS and inaccordance with established standards.
- Candidate should be proficient and experienced in creating and change ETL packages in SSISand creating new Stored Procedures to extract and load data.
- Experience working with Azure Data Warehouse/Data Factory. Maintaining and ManagingADF Pipelines is a plus.
- Candidate should be proficient in SQL, PL SQL, T-SQL.
- Experience in creating ETL jobs with Azure Data Factory Pipelines & Dataflows.
- Experience in Azure stack modules like Azure Data Lakes, SQL DW.
- Should have good understanding on the Azure cloud eco system.
- Should have good knowledge on Azure Analytical service Synapse, Azure Data Factory,Azure data lake, Azure Databricks, Azure Blob Storage, SQL DB & Data warehouse.
- Understanding of RDBMS databases and concept and implementation of NoSQL databaseslike MongoDB and Cosmos.
- Working experience on handling large sets of data in Tera/Petabytes size.
- Proficient in writing complex SQL scripts.
- Should have Strong statistical and quantitative analysis skills.
- Should have Strong problem-solving skills.
- Should have Strong verbal and written communication skills.
Desired Candidate Profile
- Should have minimum 6 Years of working experience in Data warehouse technologies.
- Should have design and architecture experience in Data warehouse.
- Qualification: Minimum of 15 years of full time Education (10 + 2 + 3).
Benefits
- Permanent Work From Home Opportunity.
- Floating Medical Insurance Coverage of Rs. 18,00,000 per annum for self and dependents (Spouse & Children)
- Personal Accident Insurance coverage of Rs. 10,00,000 for Employee
- Gratuity on separation after 5 years of continuous service, payable as per Payment of Gratuity Act
- PF is contributed at the rate of 12% of your basic subject to a maximum of Rs.1800 per month.
Send Your Resume
Click the links below to send your resume
Email: careers@intechhub.com
Whatsapp: +91 9791565317.