Job Description

5 - 7 Years
1 Opening
Bangalore


###

Role description

Role Proficiency:



This role requires proficiency in data pipeline development including coding and testing data pipelines for ingesting wrangling transforming and joining data from various sources. Must be skilled in ETL tools such as Informatica Glue Databricks and DataProc with coding expertise in Python PySpark and SQL. Works independently and has a deep understanding of data warehousing solutions including Snowflake BigQuery Lakehouse and Delta Lake. Capable of calculating costs and understanding performance issues related to data solutions.



Outcomes:



Act creatively to develop pipelines and applications by selecting appropriate technical options optimizing application development maintenance and performance using design patterns and reusing proven solutions.rnInterpret requirements to create optimal architecture and design developing solutions in accordance with specifications.

Document and communicate milestones/stages for end-to-end delivery.

Code adhering to best coding standards debug and test solutions to deliver best-in-class quality.

Perform performance tuning of code and align it with the appropriate infrastructure to optimize efficiency.

Validate results with user representatives integrating the overall solution seamlessly.

Develop and manage data storage solutions including relational databases NoSQL databases and data lakes.

Stay updated on the latest trends and best practices in data engineering cloud technologies and big data tools.

Influence and improve customer satisfaction through effective data solutions.


Measures of Outcomes:



Adherence to engineering processes and standards

Adherence to schedule / timelines

Adhere to SLAs where applicable

# of defects post delivery

# of non-compliance issues

Reduction of reoccurrence of known defects

Quickly turnaround production bugs

Completion of applicable technical/domain certifications

Completion of all mandatory training requirements

Efficiency improvements in data pipelines (e.g. reduced resource consumption faster run times).

Average time to detect respond to and resolve pipeline failures or data issues.

Number of data security incidents or compliance breaches.


Outputs Expected:



Code Development:



Develop data processing code independently
ensuring it meets performance and scalability requirements.


Define coding standards
templates

and checklists.


Review code for team members and peers.



Documentation:



Create and review templates
checklists

guidelines

and standards for design

processes

and development.


Create and review deliverable documents
including design documents

architecture documents

infrastructure costing

business requirements

source-target mappings

test cases

and results.




Configuration:



Define and govern the configuration management plan.

Ensure compliance within the team.



Testing:



Review and create unit test cases
scenarios

and execution plans.


Review the test plan and test strategy developed by the testing team.

Provide clarifications and support to the testing team as needed.



Domain Relevance:



Advise data engineers on the design and development of features and components
demonstrating a deeper understanding of business needs.


Learn about customer domains to identify opportunities for value addition.

Complete relevant domain certifications to enhance expertise.



Project Management:



Manage the delivery of modules effectively.



Defect Management:



Perform root cause analysis (RCA) and mitigation of defects.

Identify defect trends and take proactive measures to improve quality.



Estimation:



Create and provide input for effort and size estimation for projects.



Knowledge Management:



Consume and contribute to project-related documents
SharePoint

libraries

and client universities.


Review reusable documents created by the team.



Release Management:



Execute and monitor the release process to ensure smooth transitions.



Design Contribution:



Contribute to the creation of high-level design (HLD)
low-level design (LLD)

and system architecture for applications

business components

and data models.




Customer Interface:



Clarify requirements and provide guidance to the development team.

Present design options to customers and conduct product demonstrations.



Team Management:



Set FAST goals and provide constructive feedback.

Understand team members' aspirations and provide guidance and opportunities for growth.

Ensure team engagement in projects and initiatives.



Certifications:



Obtain relevant domain and technology certifications to stay competitive and informed.


Skill Examples:



Proficiency in SQL Python or other programming languages used for data manipulation.

Experience with ETL tools such as Apache Airflow Talend Informatica AWS Glue Dataproc and Azure ADF.

Hands-on experience with cloud platforms like AWS Azure or Google Cloud particularly with data-related services (e.g. AWS Glue BigQuery).

Conduct tests on data pipelines and evaluate results against data quality and performance specifications.

Experience in performance tuning of data processes.

Expertise in designing and optimizing data warehouses for cost efficiency.

Ability to apply and optimize data models for efficient storage retrieval and processing of large datasets.

Capacity to clearly explain and communicate design and development aspects to customers.

Ability to estimate time and resource requirements for developing and debugging features or components.


Knowledge Examples:



Knowledge Examples



Knowledge of various ETL services offered by cloud providers including Apache PySpark AWS Glue GCP DataProc/DataFlow Azure ADF and ADLF.

Proficiency in SQL for analytics including windowing functions.

Understanding of data schemas and models relevant to various business contexts.

Familiarity with domain-related data and its implications.

Expertise in data warehousing optimization techniques.

Knowledge of data security concepts and best practices.

Familiarity with design patterns and frameworks in data engineering.


Additional Comments:



Seeking a highly skilled and motivated Data Engineer/Tech Lead to manage the end-to-end delivery for one of our key project. This role involves overseeing the data lake transition work, addressing data warehouse defects, and implementing enhancements raised by the team. The ideal candidate will have excellent communication skills and be willing to work during morning US East hours to collaborate effectively with the Laboratory Products team for requirements and delivery. A background in supply chain management and finance is a plus, but a willingness to learn is essential. Experience with Databricks and JIRA is highly desirable. Role Scope / Deliverables: o End-to-End Delivery Management: Lead and manage the data lake transition work and ensure smooth delivery of projects within the Gold framework. o Data Warehouse Management: Address defects and implement enhancements related to the data warehouse as raised by the team. o Team Collaboration: Work closely with the Laboratory Products team to gather requirements and ensure timely and accurate delivery of solutions. o Technical Leadership: Provide technical guidance and mentorship to the team, fostering a collaborative and high-performance environment. o Communication: Maintain clear and effective communication with stakeholders, team members, and other departments to ensure alignment and successful project outcomes. o Supply Chain Knowledge: Utilize supply chain knowledge to enhance project delivery or show a willingness to learn and adapt to supply chain requirements. o Finance Knowledge: Apply finance knowledge to support project delivery or demonstrate a willingness to learn financial concepts relevant to the projects. o Databricks Expertise: Utilize Databricks for data processing, analytics, and integration tasks within the projects. o JIRA Management: Manage and track project tasks, defects, and enhancements using JIRA for efficient workflow and project management.


###

Skills

Databricks,Data Warehousing,ETL,SQL



###

About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact--touching billions of lives in the process.