Job Description

12 - 15 Years
3 Openings
Trivandrum


### Role description


Role Proficiency:



Leverage expertise in a technology area (e.g. Informatic Transformation Terradata data warehouse Hadoop Analytics); responsible for System Architecture.



Outcomes:



• Implement any two of either/or data extract and transformation or a data warehouse(ETL Data Extracts Data Load Logic Mapping Work Flows stored procedures data warehouse ) or implement data analysis solution implement data reporting solutions or implement cloud data tools in any one of the cloud provider(AWS/AZURE/GCP)


• Understand business workflows and related data flows and develop strategies for data acquisitions data transformation data modelling data storage; applying business intelligence on data and design of data fetching and dashboard


• Create design by preparing data models; designing information structure work-and dataflow and navigation. Define backup recovery and security specifications


• Define and enforce naming standards and data dictionary for data models


• Provided guidance to business to create use cases for data services


• Provide or guide team to perform estimates


• Help team to develop proof of concepts (POC) and solutions relevant to customer problems; able to trouble shoot problems while developing POCs


• Hold certification in Architect/Big Data Speciality Certification in one of AWS or Azure or GCP with exposure and understanding of other cloud and Big Data platforms



Measures of Outcomes:



• Percent of billable time spent in a year for developing and implementing data architecture


• Number of RFP response given in a year


• Number of best practices documented in any new tool and technology emerging in the market


• Number of associates trained on the data service practice


• Number of Proof of Concepts developed



Outputs Expected:



Strategy & Planning:



• Develop and deliver long-term strategic goals for data architecture vision and standards in conjunction with data users

department managers

clients

and other key stakeholders


• Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap


• Establish processes for governing the identification

collection

and use of corporate data assets and metadata; take steps to assure metadata accuracy and validity


• Implement methods and procedures for tracking data quality

completeness

redundancy

and improvement.


• Ensure that data strategies and architectures meet regulatory compliance requirements.


• Engage external stakeholders including standards organizations

regulatory bodies

operators

and scientific research communities.




Operational Management :



• Establish governance

stewardship

and frameworks for managing data across the organization


• Develop and contribute data management methodologies and standards


• Provide support in implementing the appropriate tools

software

applications

and systems to support data technology goals


• Collaborate with project managers and business teams for all projects involving enterprise data


• Analyse data-related issues with systems integration

compatibility

and multi-platform integration


• Act as a first point of connect for data management

including coaching

training. Implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture


• Document and track the data architecture and environment in order to maintain a current and accurate view of the larger data picture


• Identify and develop opportunities for data reuse

migration

or retirement




Project Control and Review :



• Perform data architecture design review


• Identify opportunities for optimization of cost

time

and asset utilization in complex projects and advise relevant teams accordingly where possible


• Provide advice to teams facing complex technical issues in the course of project delivery


• Conduct planned and unplanned technical audits for complex projects as applicable


• Define and measure project and program specific architectural and technology quality metrics




Knowledge Management & Capability Development :



• Publish and maintain a repository of solutions

best practices and standards and other knowledge articles for data management
• Conduct and facilitate knowledge sharing and learning sessions across the team
• Gain industry standard certifications on technology or area of expertise


• Support technical skill building (including hiring and training) for the team based on inputs from project manager /RTE's
• Mentor new members on the team in technical areas


• Gain and cultivate domain expertise to provide best and optimized solution to customer (delivery)


• Create architecture on-boarding/KT documents for the program




Requirement gathering and Analysis:



• Work with customer. business owners and other teams to collect

analyze and understand the requirements including NFRs/define NFRs
• Analyze gaps and trade-offs based on current system context/ industry practices and clarify the requirements by working with the customer


• Define the systems and sub-systems that define the programs




People Management:



• Set goals and manage performance of technical specialists and team engineers


• Provide career guidance and mentor technical specialists Alliance Management


• Identify alliance partners based on the understanding of service offerings and client requirements


• Collaborate with Architect to create a compelling business case around the offerings


• Conduct beta testing of the offerings and relevance to program




Technology Consulting:



• In collaboration with Architect 2

3

analyze application/ technology landscape

process

tools and arrive at the architecture options best fit for the client

program


• Analyze Cost Vs. Benefits of solution options


• Support Architect 2

3 to create a technology/ architecture roadmap for the client


• Define Architecture strategy for the program




Innovation and Thought Leadership:



• Participate in internal and external forums (seminars

paper presentation etc.)


• Understand clients existing business at the program level and explore new avenues to save cost and bring process efficiency
• Identify business opportunities to create reusable components/accelerators and reuse existing components and best practices
• Support the patent filing process for the IP assets created (applicable to some CoEs)




Sales Support and Project Estimation:



• Provide support in developing RFPs and collaterals for proposals from a technical Architecture/ estimation/ risks perspective


• Conduct demos

and arrange for the demos based on client profiles

if required


• Anchor proposal development with cross-linkages across multiple competency units to arrive at a coherent solution proposal with focus on presenting unique value propositions and clear differentiators




Project Management Support:



• Assist the PM/Scrum Master/Program Manager to identify technical risks and come-up with mitigation strategies




Stakeholder Management:



• Monitor the concerns of internal stakeholders like Product Managers & RTE's & external stakeholders like client architects

on Architecture aspects; follow through on commitments and achieve timely resolution of issues
• Conduct initiatives to meet client expectations
• Work to expand professional network in the client organization at the Team and Program levels




New Service Design:



• Identify potential opportunities for new service offerings based on customer voice/ partner inputs


• Support the development of business case for investments for approval from management
• Work with partners to co-develop a joint GTM (as applicable)
• Develop IP/tools and framework to address the opportunity technically
• Conduct beta testing / POC as applicable
• Develop collaterals

guides for GTM



Skill Examples:



• Use Domain/ Industry Knowledge in order to understand business requirements. Create POC to meet business requirements contextualize the solution to the industry under guidance. Create architecture interact with SMEs at various stages of the development; translate business requirements to system requirements and perform impact analysis of changes in requirements


• Use Technology Knowledge to create Proof of Concept (POC) / (reusable) assets. Assist in performance troubleshooting and complex troubleshooting. Define decide and defend the technology choices made review solutions


• Use knowledge of Technology Trends to provide inputs on potential areas of opportunity for UST


• Use knowledge of Architecture Concepts and Principles to create architecture catering to functional and non-functional requirements under guidance of the specialist. Re-engineer existing architecture solutions under the guidance of the specialist. Provide training on best practices in architecture under guidance


• Use independent knowledge of Design Patterns Tools and Principles to create high level design for the given requirements. Evaluate multiple design options and choose the appropriate options for best possible trade-offs. Conduct knowledge sessions to enhance team's design capabilities. Review the low level and high level design created by Specialists for efficiency (consumption of hardware memory and memory leaks etc.)


• Use knowledge of Software Development Process Tools & Techniques to identify and assess incremental improvements for software development process methodology and tools. Take technical responsibility for all stages in the software development process. Conduct optimal coding with clear understanding of memory leakage and related impact. Implement global standards and guidelines relevant to programming and development come up with 'points of view' and new technological ideas


• Use knowledge of Project Management & Agile Tools and Techniques to support plan and manage medium size projects/programs as defined within UST; identify risks and mitigation strategies


• Use knowledge of Project Metrics to understand relevance in project. Collect and collate project metrics and share it with relevant stakeholders


• Use knowledge of Estimation and Resource Planning to create estimate and plan resources for specific modules / small projects with detailed requirements or user stories in place


• Use knowledge of Knowledge Management Tools & Techniques to leverage existing material and re-usable assets in knowledge repository. Independently create and update knowledge artefacts. Create and track project specific KT plans. Provide training to others write white papers/ blogs at internal level write technical documents/ user understanding documents at the end of the project


• Use knowledge of Technical Standards Documentation & Templates to create documentation appropriate for the project needs. Create documentation appropriate for the reusable assets best practices and case studies


• Use knowledge of Requirement Gathering and Analysis to support creation of requirements documents or user stories and high level process maps. Identify gaps on the basis of business process analyse responses to clarification questions and produce design documents. Create and review estimates and solutions at project level/program level. Create and review design artefacts update resourcing and schedule based on impacted areas identified. Create design specifically for the non-functional requirements


• Strong proficiencies in understanding data workflows and dataflows


• Attention to details


• High analytical capabilities


• Creativity in developing solutions


• Self-learning


• Resilience in solving problems



Knowledge Examples:


• Skilled in writing design documents usage of Power Point Visio

+ Data visualization streaming

+ Data migration

+ RDMSs (relational database management systems) SQL

+ Databases such as NoSQL and cloud computing

+ Hadoop technologies like MapReduce Hive and Pig

+ Programming languages especially Python and Java

+ Operating systems including UNIX and MS Windows

+ Cloud solutions

+ Backup/archival software

+ Understanding of data security

Additional Comments:

o 10+ years of experience working with Microsoft SQL Server, MS SQL o 10+ years of strong hands on background as a SQL developer o Excellent knowledge on writing complex SQL stored procedures in an application development environment. o Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures. o Work with other front-end developers in completing the database modules end to end o Query optimization for performance improvement. o Should be proficient in creating database triggers o Create / Modify and optimize database schemas, stored procedures and SQL queries. o Analysing, troubleshooting, and resolving data issues. o Understanding of 3rd party software APIs in order to integrate them with your solutions. o Working closely with business stakeholders and assist with data analysis with regard to SQL. o Preparing the mapping documents for the existing stored procedures. o Should be able to perform SQL profiling o Analyse the performance issues of existing stored procedure and fine tune performance of the system o Identifies and proposes database system improvements and changes. o Builds and executes data queries for business partners. o Implements systems changes, upgrades, and modifications according to business needs. o Maintain active relationships with stakeholders to understand business requirements, lead requirement gathering meetings and review designs with the stake holders o Perform technical design reviews and code reviews o Perform peer reviews on source code to ensure reuse, scalability and the use of best practices o Participate in collaborative technical discussions that focus on design, architecture, and development o Identify opportunities that can improve efficiency of business processes o Troubleshoot software application and technical issues - identify modifications needed in existing applications to meet changing user requirements
### Skills


Sql,Ms Sql,Healthcare



### 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.