Azure Data Engineer

Sr. Data Engineer
Skills Mandatory: MS SQL Server, Data Lake, Azure SQL, SSIS, ADF, Databricks, Pyspark
Total Experience : 6+ years
Relevant Experience : 4+ years
Work Location : Kochi/TVM/Remote
Expected date of onboarding : Immediate

Job Purpose (both Onsite / Offshore) :
Responsible for delivering senior-level innovative, compelling, coherent software solutions for our consumer, internal operations and value chain constituents across a wide variety of enterprise applications through the creation of discrete business services and their supporting components.

Job Description / Duties and Responsibilities :

1. Designs, develops and delivers solutions that meet business line and enterprise requirements.
2. Participates in rapid prototyping and POC development efforts.
3. Advances overall enterprise technical architecture and implementation best practices.
4. Assists in efforts to develop and refine functional and non-functional requirements.
5. Participates in iteration and release planning.
6. Informs efforts to develop and refine functional and non-functional requirements.
7. Demonstrates knowledge of, adherence to, monitoring and responsibility for compliance with state and
federal regulations and laws as they pertain to this position.
8. Strong ability to produce high-quality, properly functioning deliverables the first time.
9. Delivers work product according to established deadlines.
10. Estimates tasks with a level of granularity and accuracy commensurate with the information provided.
11. Works collaboratively in a small team.
12. Excels in a rapid iteration environment with short turnaround times.
13. Deals positively with high levels of uncertainty, ambiguity, and shifting priorities.
14. Accepts a wide variety of tasks and pitches in wherever needed.
15. Constructively presents, discusses and debates alternatives.
16. Takes shared ownership of the product.
17. Communicates effectively both verbally and in writing.
18. Takes direction from team leads and upper management.
19. Ability to work with little to no supervision while performing duties.
20. Proficient in ADF & good in Databricks
21. Strong in MS SQL & Azure SQL
22. Hands on experience in Data Lake
23. Hands-on experience in data mart and data warehousing including variant schemas (Star, Snowflake).
24. 5+ years of experience with advanced queries, stored procedures, views, triggers, etc.
25. 5+ years of experience of performance tuning queries.
26. 5+ years of experience of both DDL and DML.
27. 5+ years of experience designing enterprise database systems using Microsoft SQL Server/Azure SQL
preferred.
28. Hands-on experience in Data Migration
29. Experience in Lakehouse architecture preferred.
30. Experience with SSIS is must.
31. Deep understanding of one or more source/version control systems. Develops branching and merging
strategies.
32. Working understanding of Web API, REST, JSON.
33. Working understanding of unit testing creation.
34. Bachelors Degree is required, and/or a minimum of four (4) + related work experience.
35. To adhere to the Information Security Management policies and procedures.