2 - 3 Years 1 Opening Trivandrum Role description Role Proficiency: Acts under very minimal guidance to develop error free code; testing and documenting applications Outcomes: Understand the applications features and component design and develop the same in accordance with user stories/requirements. Code debug test and document; and communicate product/component/feature development stages. Develop optimized code with appropriate approach and algorithms following standards and security guidelines independently Effectively interact with customers and articulate their input Optimise efficiency cost and quality by identifying opportunities for automation/process improvements and agile delivery models Mentor Developer I – Software Engineering to become more effective in their role Learn technology business domain and system domain as recommended by the project/account Set FAST goals and provide feedback to FAST goals of mentees Measures of Outcomes: Adherence to engineering processes and standards (coding 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 Meet the Defined productivity standards for project Completion of applicable technical/domain certifications Completion of all mandatory training requirements Outputs Expected: Configure: Follow configuration process Test: Create and conduct unit testing Domain relevance: Develop features and components with good understanding of the business problem being addressed for the client Manage Defects: Raise fix retest defects Estimate: Estimate time effort and resource dependence for one's own work Mentoring: Mentor junior developers in the team Set FAST goals and provide feedback to FAST goals of mentees Document: Create documentation for one's own work Manage knowledge: Consume and contribute to project related documents share point libraries and client universities Status Reporting: Report status of tasks assigned Comply with project related reporting standards/process Release: Adhere to release management process Design: Understand the design/LLD and link it to requirements/user stories Code: Develop code with guidance for the above Skill Examples: Explain and communicate the design / development to the customer Perform and evaluate test results against product specifications Develop user interfaces business software components and embedded software components Manage and guarantee high levels of cohesion and quality Use data models Estimate effort time required for own work Perform and evaluate tests in the customers or target environments Team player Good written and verbal communication abilities Proactively ask for and offer help Knowledge Examples: Appropriate software programs / modules Technical designing Programming languages DBMS Operating Systems and software platforms Integrated development environment (IDE) Agile methods Knowledge of customer domain and sub domain where problem is solved Additional Comments: Job Description - Database Developer UST is looking for a Database Developer with minimum 3 year experience, who under the general supervision of the Engineering Platform Delivery Manager and Delivery Lead, will work to deliver the implementation of a Health care ecosystem for our Health Plan clients. The Senior Database Developer will work with the small to mid-size Health Plan Clients, third party vendors, and onshore and offshore UST associates to develop database for our Advalent healthcare payer system. Candidate should have excellent technical and communication skills and ability to engage as part of a team working both physically together and virtually. You should be an excellent problem solver who is able to grasp customer/team/development needs and brainstorm ways to fulfill them. As a Database Developer at UST, this is your opportunity to: • Be part of a world class health care payer backend system. • Work with the UST-Advalent development team to ensure solution quality and architecture compliance. • Collaborate with numerous external vendors many who are top in the healthcare industry. • Independently develop test and debug Database systems and SQL code. • Utilize your skills in Agile development methodologies including JIRA, SCRUM, Git, BitBucket. • Exercise strong communication skills including the ability to convey technical information effectively. • Ensure repeatability and reusability of integration design, processes, and code. • Consistently use analytical skills - able to synthesize complex information. • Deploy expertise in estimation techniques. • Perform other duties and special projects as assigned. • Support or conduct staff mentoring as needed. • Provide constructive feedback to staff. May have responsibility for staff oversight on a project including goal setting and performance monitoring. • Comply with the organization’s Code of Conduct, all regulatory and contractual requirements, organizational policies, procedures, and internal controls. • Responsible to write and maintain clean, well-written code, as per the best practices. You bring: • Experience and expert level skills with MySQL - Mandatory; Good to have - Microsoft SQL Server, Oracle, other RDBMS systems. • Build Database Objects Following Standards and Specifications (e.g. Tables, Views, Stored Procedure, UDF, Triggers and Indexes). • Develop and Optimize T-SQL Statements (e.g. Queries, Stored Procedures, UDF) to Support Internal and Customer Applications. • Coding, Debugging and Testing the Programs. • Experience with Database versioning. • Maintained the Database Using Procedures, Functions, Cursors and Triggers. • Performance troubleshooting and coding and designing for performance. • Performed Quality Assurance and Testing of SQL Server Environment. • Developed Complex T-SQL Code such as Stored Procedures, Functions, Triggers, Indexes and Views for the Application. • Responsible for Optimizing SQL Queries, Stored Procedures to Improve the Performance Time. • Knowledge on NoSQL databases like MongoDB, Graph Database like Neo4J, Janus etc. • Experience with Agile tools and methodologies including JIRA, SCRUM, Git, BitBucket • Experience in architecting software solutions and understanding of architecture governance. • Bachelor’s degree or higher in business or technical field, 5-8 years of relevant work experience. Work experience in client partner or account interaction is needed. • Strong Customer Focus • Deep understanding of software development in a team, and a track record of implementing quality software solutions on time and on budget. • Experience in any Health care IT application and a managed care environment is preferred. • Experience with Medicare and Medicaid is preferred For this role, we value: • Technical Competence o Healthcare background, especially the payer industry. o Strong problem-solving and excellent communication skills o Project Requirements, Analysis and Objectives o Experience in architecting, designing, and implementing software solutions. o Quality Focus o Ability to understand the architectures, ask the right questions and think bigger (performance, go live, future maintenance) o Ability to influence business and technical leaders in a dynamic environment. o Project organization & Teamwork o Problem resolution o Ability to manage scope and deliverables. o Share design/development ideas with visual tools like Lucidchart/similar. o Very comfortable with daily stand-up meetings with clients, update daily work progress via Project Management systems, voice/video calls, online collaboration using screen-sharing tools. o Exposure/experience in fast-paced, agile development practices. • Behavioral Competence o Engagement and Motivation o Assertiveness o Openness and Creativity o Results Orientation o Efficiency o Reliability o Devotion to high-quality customer service o Excellent interpersonal communication skills o Keen analytical and research abilities Skills Healthcare,Database,Etl Framework,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.