Share this Job

Director - Data Engineering

Apply now »

Date: Jun 27, 2022

Location: US

Company: Larsen & Toubro Infotech Ltd

Roles & Responsibilities:

A.Lead effort to design, build/migration and configure applications, acting as primary POC

B. SnowFlake Architecture Experience in designing and architecting Snowflake migration & build projects.

C. Should be front ending all the customer, architecture, technical discussions and lead the entire team

D. Responsible for solution workshop & Contribute in area i.e. estimation, building PoV, offerings development, training and capability building

Technical experience:

Must have total 10+ yrs. in IT and 3+ years’ experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects.

Must have experience at least two end to end implementation of Snowflake cloud data warehouse migration projects and 3 end to end data warehouse

implementations on-premise & cloud.

Should have very good hands on experience in ETL tools like Informatica, Talend , SAP BODS

Should have very good hands on experience in API handling, Java, Python

Should be well versed in Data modelling & architecture

Expertise in Snowflake data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts

Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features

Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns

Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python

Experience in Data Migration from RDBMS to Snowflake cloud data warehouse

Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)

Experience with data security and data access controls and design

Build processes supporting data transformation, data structures, metadata, dependency and workload management

Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot

Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface

Certified Snowflake cloud data warehouse Architect (Desirable).

Should be able to troubleshoot problems across infrastructure, platform and application domains.

Resolve technical issues of projects and Explore alternate designs

Good to have SAP HANA experience & Cloud technology skillsets

Professional Attributes:

Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.

Effectively collaborates and communicates with the stakeholders and ensure client satisfaction

Train and coach members of project groups to ensure effective knowledge management activity

Should be able to identify areas of risk and escalation points and proactively provide solution to team

Should have worked in offshore & onshore model

Job Segment: Data Warehouse, Developer, Warehouse, SQL, Database, Technology, Manufacturing