Database Engineer

ConfidentialNoida, Pune

30+ days ago

Job description

Key Skills and Responsibilities

Snowflake Architecture : Deep understanding of Snowflakes architecture, components, and functionalities.
Snowflake cost model : Understanding of how Snowflake cost model operates and ability to improve efficiency and track costs across the platform.
Database Management : Expertise in creating, managing, and optimizing databases, schemas, tables, and views.
Data Modeling : Knowledge of dimensional modeling (star and snowflake schemas) for data warehousing.
Data Warehousing : Knowledge of data warehousing concepts, methodologies, and best practices.
SQL : Proficiency in SQL for querying, manipulating, and analyzing data.
Performance Optimization : Understanding of performance tuning techniques (clustering, materialized views, warehouse sizing) to improve query performance.
Security : Expertise in implementing security measures (IAM, role-based access control, data encryption, password rotation processes) to protect sensitive data.
ETL / ELT Tools : Familiarity with ETL / ELT tools (e.g., HVR, SnapLogic) for data loading and transformation.
Cloud Computing : Understanding of cloud concepts (e.g., scalability, elasticity, resource management) and experience with cloud platforms (AWS, Azure).
Scripting : Proficiency in scripting languages (e.g., Python, Bash) for automation and data processing tasks.
Reporting platform : Experience in setting up Power BI workspaces and Cognos Packages with secure data models ready for reporting.
Project Management : Knowledge of project management methodologies (e.g., Agile, Waterfall) and tools.

Other Skills

Problem-Solving : Ability to troubleshoot and resolve technical issues efficiently.

Communication : Effective communication skills to interact with stakeholders and team members.

Analytical Thinking : Ability to analyze data and identify patterns and trends.

Attention to Detail : Meticulous approach to ensure data accuracy and integrity.

Adaptability : Willingness to learn new technologies and adapt to changing requirements.

Project Management : Ability to plan, execute, and monitor projects effectively.

Leadership : Ability to lead and motivate project teams.

Time Management : Effective time management skills to meet project deadlines.

Adaptability : Flexibility to adapt to changing project requirements.

Stakeholder Management : Ability to manage expectations and build relationships with stakeholders.

Skills Required

Data Modelling, Data Warehousing, Azure, Snow Flake, Etl, Aws

Create a job alert for this search

Database Engineer • Noida, Pune