Job Search
Pomôžeme vám vybudovať výnimočnú kariéru.
Snowflake – Data Modeler IRC237575
| Job: | IRC237575 |
| Location: | India - Gurgaon, Noida |
| Designation: | Associate Consultant |
| Experience: | 5-10 years |
| Function: | Engineering |
| Skills: | AWS, ETL, Snowflake, SQL |
| Work Model: | Hybrid |
Description:
Database Design & Architecture:
– Design, develop, and optimize Snowflake databases for both OLTP and OLAP systems.
– Create and maintain data models, including conceptual, logical, and physical models.
– Develop and implement database schemas, tables, views, indexes, and other database objects.
Data Integration & ETL Processes:
– Design and manage data integration solutions, including ETL/ELT processes.
– Collaborate with data engineers to implement data pipelines for data ingestion, transformation, and loading into Snowflake.
Performance Tuning & Optimization:
– Analyze and optimize database performance, including query performance, indexing strategies, and storage management.
– Monitor and troubleshoot database performance issues and implement solutions to improve efficiency.
Collaboration & Communication:
– Work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and deliver database solutions.
– Provide technical guidance and mentorship to junior database designers and developers.
Documentation & Compliance:
– Maintain comprehensive documentation of database designs, architectures, and processes.
– Ensure data security, privacy, and compliance with relevant regulations and best practices.
Technical Skills
– Bachelor’s or Master’s degree in Computer Science or similar field.
– Proficiency in SQL and database query optimization.
– Strong understanding of data modeling techniques and best practices.
– Experience with ETL/ELT tools and processes.
– Familiarity with data warehousing concepts and architecture.
– Knowledge of data security and compliance practices.
Soft Skills
– Excellent problem-solving and analytical skills.
– Strong communication and collaboration skills.
– Ability to work independently and as part of a team.
Preferred Qualifications:
– Snowflake certification.
– Experience with cloud platforms such as AWS,
– Familiarity with other database technologies (e.g.MySQL, PostgreSQL, Oracle etc.).
– Experience with data visualization and reporting tools (e.g., Tableau, Power BI).
Requirements:
Database Design & Architecture:
– Design, develop, and optimize Snowflake databases for both OLTP and OLAP systems.
– Create and maintain data models, including conceptual, logical, and physical models.
– Develop and implement database schemas, tables, views, indexes, and other database objects.
Data Integration & ETL Processes:
– Design and manage data integration solutions, including ETL/ELT processes.
– Collaborate with data engineers to implement data pipelines for data ingestion, transformation, and loading into Snowflake.
Performance Tuning & Optimization:
– Analyze and optimize database performance, including query performance, indexing strategies, and storage management.
– Monitor and troubleshoot database performance issues and implement solutions to improve efficiency.
Collaboration & Communication:
– Work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and deliver database solutions.
– Provide technical guidance and mentorship to junior database designers and developers.
Documentation & Compliance:
– Maintain comprehensive documentation of database designs, architectures, and processes.
– Ensure data security, privacy, and compliance with relevant regulations and best practices.
Technical Skills
– Bachelor’s or Master’s degree in Computer Science or similar field.
– Proficiency in SQL and database query optimization.
– Strong understanding of data modeling techniques and best practices.
– Experience with ETL/ELT tools and processes.
– Familiarity with data warehousing concepts and architecture.
– Knowledge of data security and compliance practices.
Soft Skills
– Excellent problem-solving and analytical skills.
– Strong communication and collaboration skills.
– Ability to work independently and as part of a team.
Preferred Qualifications:
– Snowflake certification.
– Experience with cloud platforms such as AWS,
– Familiarity with other database technologies (e.g.MySQL, PostgreSQL, Oracle etc.).
– Experience with data visualization and reporting tools (e.g., Tableau, Power BI).
Job Responsibilities:
Database Design & Architecture:
– Design, develop, and optimize Snowflake databases for both OLTP and OLAP systems.
– Create and maintain data models, including conceptual, logical, and physical models.
– Develop and implement database schemas, tables, views, indexes, and other database objects.
Data Integration & ETL Processes:
– Design and manage data integration solutions, including ETL/ELT processes.
– Collaborate with data engineers to implement data pipelines for data ingestion, transformation, and loading into Snowflake.
Performance Tuning & Optimization:
– Analyze and optimize database performance, including query performance, indexing strategies, and storage management.
– Monitor and troubleshoot database performance issues and implement solutions to improve efficiency.
Collaboration & Communication:
– Work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and deliver database solutions.
– Provide technical guidance and mentorship to junior database designers and developers.
Documentation & Compliance:
– Maintain comprehensive documentation of database designs, architectures, and processes.
– Ensure data security, privacy, and compliance with relevant regulations and best practices.
Technical Skills
– Bachelor’s or Master’s degree in Computer Science or similar field.
– Proficiency in SQL and database query optimization.
– Strong understanding of data modeling techniques and best practices.
– Experience with ETL/ELT tools and processes.
– Familiarity with data warehousing concepts and architecture.
– Knowledge of data security and compliance practices.
Soft Skills
– Excellent problem-solving and analytical skills.
– Strong communication and collaboration skills.
– Ability to work independently and as part of a team.
Preferred Qualifications:
– Snowflake certification.
– Experience with cloud platforms such as AWS,
– Familiarity with other database technologies (e.g.MySQL, PostgreSQL, Oracle etc.).
– Experience with data visualization and reporting tools (e.g., Tableau, Power BI).
What We Offer
Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!