Snowflake Data Engineer

About Birlasoft Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company?s consultative and design-thinking approach empowers societies worldwide, enhancing the efficiency and productivity of businesses. As part of the multibillion-dollar diversified CKA Birla Group, Birlasoft with its 12,000+ professionals, is committed to continuing the Group?s 170-year heritage of building sustainable communities. Job Title: Snowflake Data Engineer Location: Bangalore/Pune (Pan India relocation is considerable - High preference is Pune) Hybrid- 3days WFO & 2 days WFH Contract Duration: 15 Months Contract ? Possibility of conversion is there. HM Interview availability- Post 12PM IST, 2 rounds of interview Position: 1 Shift timings: 1:30PM ? 10:30PM (During Daylight Saving - 2:30PM IST ? 11:30PM IST) Laptop: Provided Notice period: Immediate - 30 days Gap - Upto 3-6 Months Budget ? 2650000 LPA Project Overview: Creation and maintenance of a business data warehouses and marts, including conceptual models, logical data models and physical data models for relational database designs. Expert level understanding of relational database concepts, dimensional database concepts and database architecture and design, ontology and taxonomy design Expertise in designing data driven solution on Snowflake for complex business needs. Knowledge of entire application lifecycle including Design, Development, Deployment, Operation and Maintenance in an Agile and DevOps culture Contractor?s Role: The Data Engineer is responsible designing data base models and implementing them on the data warehouse to realize a business objective. They you will be responsible for the entire lifecycle from data model refinement, warehouse implementations, data pipeline build out, operating and maintaining the warehouse. Experience Level: Level 3(8+ Years) Qualifications: Bachelor?s/relevant exp - with Snowpro Certification Must Have Skills: Overall ? 8+ years Relevant ? 5+ years Snowflake ? Minimum 3+ years 8 + years of experience in Enterprise-level Data Engineering roles. Expertise in OLAP design and deep understanding of data warehousing concepts: star/snowflake schema, ETL/ELT processes, normalization/denormalization, and data modeling. Expertise in writing complex SQL queries, including joins, window functions, and optimization techniques. Expertise and hands-on experience with Snowflake: warehouses, data ingestion with snow pipe, external integrations, working all types of views & tables, UDFs, procedures, streams, tasks and serverless, data masking. Experience with Snowflake-specific features, including clustering, partitioning, and schema design best practices. Strong verbal and written communication skills for collaborating with both technical teams and business stakeholders. Nice to Haves: At least 3+ in asset management/investment management is highly desired. Familiarity with Snowflake?s native tools and services, including Snowflake Data Sharing, Snowflake Streams & Tasks, and Snowflake Secure Data Sharing. Knowledge of best practices for data governance, access control, and compliance. Understanding of software development life cycle including planning, development, quality assurance, change management and release management. Strong problem-solving skills and ability to troubleshoot complex issues. Self-motivated and ability to work independently with minimal supervision. Familiarity with MDM, Data Vault 2. Python skill is a plus.