Data Warehouse Engineer L2

Role & responsibilities

• Develop and Design DW Solutions as per industry standards, practices and procedures and attributes of the business intelligence tools and systems.
• Work on multiple projects as a team member.
• Develop Data Load jobs / Scripts / Sequence, Reviews and validates data loaded into the data warehouse for accuracy.
• Responsible for prototyping solutions, preparing test scripts, and conducting tests and data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Implement Best Practices in data warehouses and advise users on conflicts and inappropriate data usage.
• Understand and implement data warehouse development in multi-platform environments.
• Understand data mining in a data warehouse environment which includes data design, database architecture, metadata, and repository creation.
• Maintain knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments

Preferred candidate profile

• Data Warehousing, ETL , BI exposure ,Database
• Experience in Data Warehouse: 5 to 8 years.
• Experience in Data Analytics: 2 years
• Experience in ETL: 3 to 5 years (DBT is an advantage or  Informatica, DataStage, , Azure etc.,)
• Experience in Data Modeling: basic understand Physical and logical models
• Experience in SQL & Shell Script - Basic knowledge is must

Perks and benefits

• Day off on the 3rd Friday of every month (one long weekend each month)
• Monthly Wellness Reimbursement Program to promote health well-being
• Paid paternity and maternity leaves