Data Warehouse Architect - ETL Tools (5-8 yrs)

Experience (In Years) : 5-8 years (At least One DWH project must be executed end to end).

Educational Qualification : Bachelor's degree or its equivalent in computer science, information technology, engineering, or related technical field.

Job Description :

One of our leading IT clients is hiring a Data Warehouse Engineer who works on the full life cycle of development of the business's data warehouse.

Also responsible for the development of ETL processes, cube development for database and performance administration, and dimensional design of the table structure.

Roles and Responsibilities :

- Understand the company's present data infrastructure, identify gaps, and develop plans to integrate the current systems with the desired future model.

- Designing the data warehouse initiatives and data warehousing systems also recommends measures to improve performance for all metadata relating to various Extract/Transform/Load (ETL) processes.

- Develop as many ETL processes as needed and prepare Online Analytical Processing (OLAP) cubes also maintain database scripts and tools to make automation run smoother.

- Analyze every data warehouse architecture goal and identify what skill requirements they require.

- Monitor processes and develop plans to expedite gathering and accessing all relevant metadata.

Required Skills :

- Must have a deeper understanding of Data Modeling, SQL, Snowflake, OLAP, and ETL, including practical experience with at least one ETL tool, such as SSIS.

- Should be familiar with best practices and automation of processes like building, configuration, deployment, documentation, testing, and monitoring.

- Added Advantage for data warehouse architect Certification At least One DWH project must be executed end to end.