1997 Sql Queries Jobs - Page 40

Josh Software is relentlessly focused on discovering, developing and delivering innovative solutions that connect our customers to the people they serve through the advanced use of technology. With our reach, range and resources, we provide our customers a universal platform for driving their vision into their markets using consistent and reliable technology solutions. Josh Software has more than 15 years experience and operates in the key strategic geographies in the USA, Australia, Europe, SE Asia and India. Skills (Must have): Strong in Core Java, familiar with latest concepts e.g. Java 17 Familiar with Spring Boost, JSON, XML, Yaml configs etc Sound knowledge of Rest API wrt Security, Performance, Logging and Error handle Hands on with Tools like Postman, Swagger, ELK(Logs), AWS Cloud watch etc. Familiar with Development processes and Network concepts Knowledge of AWA Cloud (good to have) Should have good understanding of DB and should be able to write basic SQL queries Skills (Desirable): Knowledge / Experience in Dockers and Containers AWS or any Cloud concepts Fluency in written and spoken English Qualification: M.C.A, B.Sc/MSc Computers, B.E /B.Tech in Computer Science, Engineering, or a related field. Additional Information: We offer a competitive salary and excellent benefits that are above industry standard. Do check our impressive growth rate on and ratings on Pls submit your resume in this standard 1-page or 2-page Please hear from our employees on

• Strong hands-on experience with Microsoft SQL Server. Additional experience working with Oracle will be preferred. • Experience working with No SQL database will be preferred. • Handled ETL tasks, data imports/exports.

At Allstate, great things happen when our people work together to protect families and their belongings from lifes uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. The Business Intelligence Consultant II is responsible for leveraging data and analytics to answer complex questions and influence business strategy through communication of findings to Stake holders. "The ideal candidate will have a strong background in SQL, Data Modeling, Report Development, and Data visualization. You will work closely with stakeholders to understand business requirements and translate them into interactive reports and analytical solutions. Design, develop, and maintain Power BI dashboards and reports that provide actionable insights Write efficient, optimized and advanced SQL queries to extract and manipulate data from relational databases (e.g., Oracle, Dremio) Develop and maintain data models (star/snowflake schema) and Power BI datasets Collaborate with business stakeholders to gather and analyze reporting requirements Ensure data accuracy, consistency, and performance of reports and dashboards Implement row-level security (RLS) and data refresh schedules in Power BI Service Optimize and tune SQL queries and Power BI performance (DAX, visuals) Work with data engineers and analysts to streamline ETL processes as needed Document solutions, definitions, and business rules used in BI reports Stay current with Power BI and SQL advancements, proposing improvements as appropriate Monitor and evaluate business initiatives against key performance indicators and communicate results and recommendations to management Lead data governance efforts, including standardization of KPIs, data definitions, and documentation Provide mentorship and guidance to junior BI analysts, fostering a culture of continuous learning and knowledge sharing Identify and recommend opportunities to automate reporting and streamline data operations Required Skills & Qualifications Bachelors degree in computer science, Information Systems, Engineering, or related field 4-6 years of professional experience in BI development using SQL and Power BI Expertise in writing complex SQL queries , views, and functions Proficient in DAX , Power Query (M language) , and Power BI Dataflows Strong understanding of data warehousing concepts , data modeling , and ETL pipelines Experience with Power BI Service workspaces, publishing, RLS, and refresh scheduling Good understanding of database systems like Oracle, Dremio Experience with Microsoft Fabric or equivalent unified data platforms (OneLake, Synapse, Data Factory) Ability to work independently and manage multiple projects with minimal supervision Excellent communication, written, Interpretation and documentation skills Primary Skills Analytcial Thinking, Business Intelligence (BI) Solutions, Data Analysis, Data-Driven Decision Making, User Acceptance Testing (UAT) Shift Time Shift B (India) Recruiter Info Annapurna Jhaajhat@allstate.com About Allstate The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporations Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organizations business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition. Learn more about Allstate India here.

Project Role : Application Tech Support Practitioner Project Role Description : Act as the ongoing interface between the client and the system or application. Dedicated to quality, using exceptional communication skills to keep our world class systems running. Can accurately define a client issue and can interpret and design a resolution based on deep product knowledge. Must have skills : Microsoft SQL Server Administration Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Tech Support Practitioner, you will serve as the vital link between clients and the systems or applications they utilize. Your day will involve engaging with clients to understand their needs, troubleshooting issues, and ensuring that our systems operate seamlessly. You will leverage your exceptional communication skills to provide high-quality support, ensuring that client concerns are addressed promptly and effectively. Your role will also require you to interpret complex client issues and design tailored resolutions based on your extensive product knowledge, contributing to the overall success of our operations and client satisfaction. Roles & Responsibilities:- Expected to be an SME.- Collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Provide solutions to problems for their immediate team and across multiple teams.- Facilitate training sessions for junior team members to enhance their skills and knowledge.- Monitor and evaluate team performance to ensure alignment with organizational goals. Professional & Technical Skills: - Must To Have Skills: Proficiency in Microsoft SQL Server Administration.- Strong understanding of database management and optimization techniques.- Experience with backup and recovery strategies for SQL Server databases.- Familiarity with performance tuning and troubleshooting SQL queries.- Knowledge of security best practices for SQL Server environments. Additional Information:- The candidate should have minimum 5 years of experience in Microsoft SQL Server Administration.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Administration Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will engage in a dynamic work environment where you will analyze, design, code, and test various components of application code for multiple clients. Your day will involve collaborating with team members to perform maintenance and enhancements, ensuring that the applications function optimally and meet client needs. You will also be responsible for developing new features and troubleshooting issues, contributing to the overall success of the projects you are involved in. Roles & Responsibilities:- Expected to be an SME.- Collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Provide solutions to problems for their immediate team and across multiple teams.- Facilitate knowledge sharing sessions to enhance team capabilities.- Mentor junior professionals to foster their growth and development. Professional & Technical Skills: - Must To Have Skills: Proficiency in Microsoft SQL Server Administration.- Strong understanding of database design and optimization techniques.- Experience with performance tuning and troubleshooting SQL queries.- Familiarity with backup and recovery strategies for SQL Server.- Knowledge of security best practices for database management. Additional Information:- The candidate should have minimum 5 years of experience in Microsoft SQL Server Administration.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Project Role : Application Tech Support Practitioner Project Role Description : Act as the ongoing interface between the client and the system or application. Dedicated to quality, using exceptional communication skills to keep our world class systems running. Can accurately define a client issue and can interpret and design a resolution based on deep product knowledge. Must have skills : Microsoft SQL Server Administration Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Tech Support Practitioner, you will serve as a vital link between clients and the systems or applications they utilize. Your typical day will involve engaging with clients to understand their needs, addressing any issues they encounter, and ensuring that our systems operate seamlessly. You will leverage your exceptional communication skills to provide high-quality support, ensuring that client concerns are resolved efficiently and effectively. Your role will require a deep understanding of the product to design appropriate solutions, contributing to the overall success of our operations and client satisfaction. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work related problems.- Assist in the development and implementation of support processes to enhance service delivery.- Provide training and guidance to junior team members to foster their professional growth. Professional & Technical Skills: - Must To Have Skills: Proficiency in Microsoft SQL Server Administration.- Strong understanding of database management and optimization techniques.- Experience with backup and recovery strategies for SQL Server databases.- Familiarity with performance tuning and troubleshooting SQL queries.- Knowledge of security best practices for SQL Server environments. Additional Information:- The candidate should have minimum 3 years of experience in Microsoft SQL Server Administration.- This position is based at our Hyderabad office.- A 15 years full time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : MySQL Good to have skills : Cloud Design and BuildMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will engage in a dynamic work environment where you will analyze, design, code, and test various components of application code for multiple clients. Your day will involve collaborating with team members to ensure the successful implementation of software solutions, while also performing maintenance and enhancements to existing applications. You will be responsible for delivering high-quality code and contributing to the overall success of the projects you are involved in, ensuring that client requirements are met effectively and efficiently. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work related problems.- Collaborate with cross-functional teams to gather requirements and translate them into technical specifications.- Conduct code reviews to ensure adherence to best practices and coding standards. Professional & Technical Skills: - Must To Have Skills: Proficiency in MySQL.- Good To Have Skills: Experience with Cloud Design and Build.- Strong understanding of database design and optimization techniques.- Experience with writing complex SQL queries and stored procedures.- Familiarity with application development frameworks and methodologies. Additional Information:- The candidate should have minimum 3 years of experience in MySQL.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Administration Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will engage in a dynamic work environment where you will analyze, design, code, and test various components of application code for multiple clients. Your day will involve collaborating with team members to ensure the successful implementation of software solutions, performing maintenance and enhancements, and contributing to the overall development process. You will be responsible for delivering high-quality code while adhering to best practices and project timelines, ensuring that the applications meet client requirements and expectations. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work related problems.- Collaborate with cross-functional teams to gather requirements and translate them into technical specifications.- Conduct code reviews to ensure adherence to coding standards and best practices. Professional & Technical Skills: - Must To Have Skills: Proficiency in Microsoft SQL Server Administration.- Strong understanding of database design and management principles.- Experience with performance tuning and optimization of SQL queries.- Familiarity with backup and recovery strategies for SQL Server databases.- Knowledge of security best practices for database management. Additional Information:- The candidate should have minimum 3 years of experience in Microsoft SQL Server Administration.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : GuideWire ClaimCenter Good to have skills : NAMinimum 2 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work, contributing to the overall success of the projects. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work-related problems.- Collaborate with team members to analyze, design, and develop software solutions.- Participate in code reviews and provide constructive feedback.- Troubleshoot and debug software applications to ensure optimal performance.- Document software specifications and technical designs.- Stay updated on industry trends and technologies to suggest improvements. Professional & Technical Skills: - Must To Have Skills: Proficiency in GuideWire ClaimCenter.- Strong understanding of software development lifecycle.- Experience with Java programming language.- Knowledge of relational databases and SQL queries.- Hands-on experience with web services and APIs. Additional Information:- The candidate should have a minimum of 2 years of experience in GuideWire ClaimCenter.- This position is based at our Bengaluru office.- A 15 years full-time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : GuideWire Integration Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work, contributing to the overall success of the projects. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work-related problems.- Collaborate with team members to analyze, design, and develop software solutions.- Participate in code reviews and provide constructive feedback.- Troubleshoot and debug software applications to ensure optimal performance.- Document software specifications and ensure code quality.- Stay updated with industry trends and technologies to enhance skills. Professional & Technical Skills: - Must To Have Skills: Proficiency in GuideWire Integration.- Strong understanding of software development lifecycle.- Experience with integration tools and technologies.- Knowledge of relational databases and SQL queries.- Hands-on experience in troubleshooting and problem-solving.- Good To Have Skills: Experience with Agile methodologies. Additional Information:- The candidate should have a minimum of 3 years of experience in GuideWire Integration.- This position is based at our Pune office.- A 15 years full-time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : GuideWire ClaimCenter Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work, contributing to the overall success of the projects. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work-related problems.- Collaborate with team members to analyze, design, and develop software solutions.- Participate in code reviews and provide constructive feedback.- Troubleshoot and debug software applications to ensure optimal performance.- Stay updated with industry trends and technologies to suggest improvements.- Assist in the documentation of technical specifications and user manuals. Professional & Technical Skills: - Must To Have Skills: Proficiency in GuideWire ClaimCenter.- Strong understanding of software development lifecycle and methodologies.- Experience in Java programming and web application development.- Knowledge of relational databases and SQL queries.- Hands-on experience with debugging and troubleshooting software applications. Additional Information:- The candidate should have a minimum of 3 years of experience in GuideWire ClaimCenter.- This position is based at our Bengaluru office.- A 15 years full-time education is required. Qualification 15 years full time education

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Administration Good to have skills : /Python,Jython Script, ETQ RelMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will engage in a dynamic work environment where you will analyze, design, code, and test various components of application code for multiple clients. Your day will involve collaborating with team members to ensure the successful implementation of software solutions, performing maintenance and enhancements, and contributing to the overall development process. You will be responsible for delivering high-quality code while adhering to best practices and project timelines, ensuring that the applications meet client requirements and expectations. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work related problems.- Collaborate with cross-functional teams to gather requirements and translate them into technical specifications.- Conduct code reviews to ensure adherence to coding standards and best practices. Professional & Technical Skills: - Must To Have Skills: Proficiency in Microsoft SQL Server Administration.- Strong understanding of database design and management principles.- Experience with performance tuning and optimization of SQL queries.- Familiarity with backup and recovery strategies for SQL Server databases.- Knowledge of security best practices for database management. Additional Information:- The candidate should have minimum 3 years of experience in Microsoft SQL Server Administration.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Must be hands on with coding in Java. Experience with REST API development is a must. Must have good computer science fundamentals (data-structure and algorithms). Should be proficient in back-end technologies and willingness to work on front-end technologies as when needed. Deep knowledge of modern Java programming best practices for object-orientation, dependency injection, thread concurrency, performance tuning, and API design, as well as test-driven development for unit and integration testing. Development experience with Java frameworks such as Spring, Hibernate, and Maven. An ability to write complex PL/SQL SQL queries and efficiently retrieve data from a database. Experience as a software developer/Application designer or programmer. Experience and understanding of source code management tools such as GIT and SVN.

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Integration Services (SSIS) Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will engage in a dynamic work environment where you will analyze, design, code, and test various components of application code for multiple clients. Your day will involve collaborating with team members to ensure the successful implementation of software solutions, performing maintenance and enhancements, and contributing to the overall development process. You will be responsible for delivering high-quality code while adhering to best practices and project timelines, ensuring that the applications meet the needs of the clients effectively. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work related problems.- Assist in the documentation of software specifications and design.- Collaborate with cross-functional teams to gather requirements and provide feedback. Professional & Technical Skills: - 4-5 years experience with Datawarehousing concepts.- Proficiency in any Data Modelling Tools-Familiarity with ETL processes and Tools. Strong MS SQL server knowledge.-Strong communication skills & ITSM concepts.-WhereScape RED data warehouse automation tool knowledge (good to have) - Must To Have Skills: Proficiency in Microsoft SQL Server Integration Services (SSIS).- Strong understanding of database management and data integration techniques.- Familiarity with data modeling and database design principles.- Ability to troubleshoot and optimize SQL queries for performance. Additional Information:- The candidate should have minimum 3 years of experience in Microsoft SQL Server Integration Services (SSIS).- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Role ObjectiveWe are currently seeking a Lead - BI Analytics to contribute to Analytics & BI Development process. This is a hands-on technical and Individual Contributor role. This position requires that the candidate be a skilled on Advance Excel, SQL, Python and support on Reporting and Analytics applications. The candidate needs to have strong technical knowledge and be very structured and analytical in his/her approach.Essential Duties and ResponsibilitiesPrimary responsibility involves advanced SQL and advanced Excel report design and development.Publishing and scheduling SSIS\SSRS report as per the business requirements.Will be responsible for END TO END BI & Visualization solutions development and projects delivery across multiple clients.Drive the development and analysis of data, reporting automation, Dash boarding, and business intelligence programs.Would be supporting in consulting engagement and should be able to articulate and architect the solution effectively to bring-in the values which data analytics & visualization solution can deliver.Good understanding of database management systems and ETL (Extract, transform, load) frameworkConnecting to data sources, importing data and transforming data for Business Intelligence.Experience in using advance level calculations on the data set.Responsible for design methodology and project documentation.Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.Should have knowledge and experience in prototyping, designing, and requirement analysis.QualificationsGraduate (BE-BTEC Computer science /BCA/MCA/MSc Computers) or have an equivalent academic qualificationGood communication Skills (both written & verbal)2+ years experience in Reporting and Analytics with Python, SQL and excel must have prior experience on Relational Database and BI developer using SQL server, SSIS, Power BI, Tableau, Advance Excel. Skill SetGood to have:Experience on Design and develop relational database models/schemas and Query performance tuning and write ad-hoc SQL queries.Exposure to Snowflake would be ab added advantageExperience with advanced query design, stored procedures, views, functions. Ability to communicate with technical and business resources at many levels in a manner that supports progress and success.Understanding of Python and different libraries - Pandas, Numpy etc Exposure to Cloud Computing such as Microsoft AzureGood knowledge/expertise on different versions of .Microsoft Sql Server 2008, 2012, 2016, 2017, 2020 Working in an evolving healthcare setting, we use our shared expertise to deliver innovative solutions. Our fast-growing team has opportunities to learn and grow through rewarding interactions, collaboration and the freedom to explore professional interests. Our associates are given valuable opportunities to contribute, to innovate and create meaningful work that makes an impact in the communities we serve around the world. We also offer a culture of excellence that drives customer success and improves patient care. We believe in giving back to the community and offer a competitive benefits package. To learn more, visitr1rcm.com Visit us on Facebook

R1 is leading provider of technology-driven solutions that help hospitals and health systems to manage their financial systems and improve patients experience. We are the one company that combines the deep expertise of a global workforce of revenue cycle professionals with the industry's most advanced technology platform, encompassing sophisticated analytics, Al, intelligent automation and workflow orchestration. R1 is a place where we think boldly to create opportunities for everyone to innovate and grow. A place where we partner with purpose through transparency and inclusion. We are a global community of engineers, front-line associates, healthcare operators, and RCM experts that work together to go beyond for all those we serve. Because we know that all this adds up to something more, a place where we're all together better. R1 India is proud to be recognized amongst Top 25 Best Companies to Work For 2024, by the Great Place to Work Institute. This is our second consecutive recognition on this prestigious Best Workplaces list, building on the Top 50 recognition we achieved in 2023. Our focus on employee wellbeing and inclusion and diversity is demonstrated through prestigious recognitions with R1 India being ranked amongst Best in Healthcare, amongst Top 50 Best Workplaces for Millennials, Top 50 for Women, Top 25 for Diversity and Inclusion and Top 10 for Health and Wellness. We are committed to transform the healthcare industry with our innovative revenue cycle management services. Our goal is to make healthcare work better for all by enabling efficiency for healthcare systems, hospitals, and physician practices. With over 30,000 employees globally, we are about 17,000+ strong in India with presence in Delhi NCR, Hyderabad, Bangalore, and Chennai. Our inclusive culture ensures that every employee feels valued, respected, and appreciated with a robust set of employee benefits and engagement activities. Role Objective We are currently seeking a Lead Associate to work in Analytics & BI Development processes. This is a hands-on technical and Individual Contributor role. This position requires that the candidate be a skilled on SQL (Must), Advance Excel, Power BI and support on Analytics applications. The candidate needs to have strong technical knowledge and be very structured and analytical in his/her approach. Essential Technical Duties and Responsibilities 3+ years- experience where primary responsibility involves writing complex SQL queries, building views and Store procedures. Proficiency in SQL and experience with database management systems. Design, develop, and maintain SQL views and stored procedures. Write complex SQL queries to extract, manipulate, and analyze data. Optimize database performance by tuning SQL queries and indexing. Collaborate with software developers and data analysts to integrate SQL views and stored procedures with applications. Excellent communication skills and ability to translate complex to simple and easier terms for business leaders and users of data. Good to have knowledge and skills for Cloud Computing such as Microsoft Azure, Snowflake In-depth understanding of database management systems and ETL (Extract, transform, load) framework. Should know how to develop Transition Tool Kit, Documentations, SOP, Artifacts Should know all data driven technologies and have hands-on in End-to-End Analytics which include Story-telling, Descriptive, Diagnostics, Predictive and Prescriptive Analysis. Drive the development and analysis of data, reporting automation, Dash boarding, and business intelligence program. Qualifications Graduate (BE-BTEC Computer science /BCA/MCA/MSc Computers) or have an equivalent academic qualification Good communication Skills (both written & verbal) Skill Set 3 + years experience on Relational Database and BI developer using SQL server(Must), Advance Excel(Desired) and Power BI(Good To have) Extensive experience on Design and develop relational database models/schemas and Query performance tuning and write ad-hoc T-SQL queries. Experience with advanced query design, stored procedures, views and functions. Experience with SQL Server & Data Warehouse Concepts. Working knowledge of statistical modeling and analysis. Strong oral and written communication skills. Ability to communicate with technical and business resources at many levels in a manner that supports progress and success. Working in an evolving healthcare setting, we use our shared expertise to deliver innovative solutions. Our fast-growing team has opportunities to learn and grow through rewarding interactions, collaboration and the freedom to explore professional interests. Our associates are given valuable opportunities to contribute, to innovate and create meaningful work that makes an impact in the communities we serve around the world. We also offer a culture of excellence that drives customer success and improves patient care. We believe in giving back to the community and offer a competitive benefits package. To learn more, visitr1rcm.com Visit us on Facebook

Who we are: R1 is a leading provider of technology-driven solutions that help hospitals and health systems to manage their financial systems and improve patients experience. We are the one company that combines the deep expertise of a global workforce of revenue cycle professionals with the industry's most advanced technology platform, encompassing sophisticated analytics, Al, intelligent automation and workflow orchestration. R1 is a place where we think boldly to create opportunities for everyone to innovate and grow. A place where we partner with purpose through transparency and inclusion. We are a global community of engineers, front-line associates, healthcare operators, and RCM experts that work together to go beyond for all those we serve. Because we know that all this adds up to something more, a place where we're all together better. R1 India is proud to be recognized amongst Top 25 Best Companies to Work For 2024, by the Great Place to Work Institute. This is our second consecutive recognition on this prestigious Best Workplaces list, building on the Top 50 recognition we achieved in 2023. Our focus on employee wellbeing and inclusion and diversity is demonstrated through prestigious recognitions with R1 India being ranked amongst Best in Healthcare, amongst Top 50 Best Workplaces for Millennials, Top 50 for Women, Top 25 for Diversity and Inclusion and Top 10 for Health and Wellness. We are committed to transform the healthcare industry with our innovative revenue cycle management services. Our goal is to make healthcare work better for all by enabling efficiency for healthcare systems, hospitals, and physician practices. With over 30,000 employees globally, we are about 17,000+ strong in India with presence in Delhi NCR, Hyderabad, Bangalore, and Chennai. Our inclusive culture ensures that every employee feels valued, respected, and appreciated with a robust set of employee benefits and engagement activities. Designation Lead Associate Essential Duties and Responsibilities: Designing, developing, and maintaining databases Writing complex SQL queries for data retrieval and manipulation Optimizing database performance and ensuring data integrity Troubleshooting and resolving database-related issues Collaborating with cross-functional teams to gather requirements and implement solutions Certification NA Skill Set * Should have strong Analytical Skills and Advance Excel knowledge.* Should have Strong knowledge on VBA Programming.* Should have Strong knowledge on SQL (Advanced).* Should have Hand's-on Experience in Advanced Excel.* Should have AR Follow-up Domain Knowledge Pre-requisite: Should have overall 3+ years of experience in RCM Operations Should have analytical skills & exhibit clear thinking/reasoning Should be able to comprehend & well-articulated to present his/her thought process well Should have excellent feedback and coaching skills Working in an evolving healthcare setting, we use our shared expertise to deliver innovative solutions. Our fast-growing team has opportunities to learn and grow through rewarding interactions, collaboration and the freedom to explore professional interests. Our associates are given valuable opportunities to contribute, to innovate and create meaningful work that makes an impact in the communities we serve around the world. We also offer a culture of excellence that drives customer success and improves patient care. We believe in giving back to the community and offer a competitive benefits package. To learn more, visitr1rcm.com Visit us on Facebook

Project Role : Application Support Engineer Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems. Must have skills : Oracle Database Architecture Good to have skills : NAMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Support Engineer, you will act as software detectives, providing a dynamic service that identifies and resolves issues within various components of critical business systems. Your typical day will involve collaborating with team members to troubleshoot problems, analyzing system performance, and ensuring the smooth operation of applications that are vital to business functions. You will engage with stakeholders to understand their needs and provide timely solutions, contributing to the overall efficiency and effectiveness of the organization. Roles & Responsibilities:A:Need to provide logical and/or application DBA support technical support, 24/7 for maintenance of oracle database systems within a defined operating model and processes.B :Write, review, and optimize application SQL queries, stored procedures, and views to ensure efficient data access and performance.C:Analyze slow-running queries and troubleshoot application-level database performance issues using logical techniques working with developers and application teams.D:Provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance Technical Experience:Perform SQL performance tuning and optimization for Oracle databases to enhance application efficiency.Review and fine-tune Oracle SQL queries, PL/SQL stored procedures, packages, and indexes to improve execution performance.Analyze inefficient Oracle SQL statements, complex joins, and subqueries; enhance Oracle execution plans for optimal results using database profiles and othersDiagnose and resolve Oracle database-related application errors and performance issues using Oracle tools (e.g., AWR, ADDM, SQL Trace).Analyze Oracle database usage patterns to recommend improvements to the logical data model and schema design.Design and maintain logical data structures, Oracle database schemas, views, PL/SQL packages, triggers and user-defined functions.Lead Oracle schema design initiatives to support evolving business needs.Collaborate with application developers to convert business requirements into efficient Oracle database designs.Define and enforce data validation rules, constraints, and referential integrity within the Oracle environment.Manage Oracle metadata, data dictionaries and representing logical structures.Provide logical database support for application development.Ensure that Oracle database designs meet performance, scalability, and maintainability goals.Write Oracle SQL queries to meet business and reporting requirements.Assist app developers with logical Oracle database tasks, including schema versioning, migrations, and validation testing.Facilitate promotion of logical Oracle database changes through environments (Dev, QA, Prod).Support logical components during oracle db migrations and version upgrades.Document Oracle logical database structures, data dictionaries, and ERDs for development and operational use.Support data validation and testing efforts within Oracle database environments.Assist in logical security tasks within Oracle , including role definitions, privileges, and access control at schema level. Professional & Technical Skills: Able to prioritize and execute tasks in a high-pressure environment Work in a team-oriented, collaborative environment Should be able to perform initial level of trouble shootings. Additional Information:- The candidate should have minimum 3 years of experience in Oracle Database Administration (DBA).- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Project Role : Application Support Engineer Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems. Must have skills : SAP TM Transportation Management Good to have skills : Application PackagingMinimum 7.5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Support Engineer, you will act as software detectives, providing a dynamic service identifying and solving issues within multiple components of critical business systems. You will play a crucial role in ensuring the smooth functioning of the applications and resolving any technical issues that may arise. Roles & Responsibilities:- Expected to be an SME, collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Provide solutions to problems for their immediate team and across multiple teams.- Ensure timely resolution of application issues and incidents.- Perform root cause analysis and implement preventive measures.- Collaborate with cross-functional teams to troubleshoot and resolve technical issues.- Conduct regular system audits to identify areas for improvement. Professional & Technical Skills: - Must To Have Skills: Proficiency in SAP TM Transportation Management.- Good To Have Skills: Experience with Application Packaging.- Strong understanding of software development lifecycle and application support processes.- Experience in troubleshooting and resolving application issues.- Knowledge of database management systems and SQL queries.- Familiarity with ITIL framework and incident management processes. Additional Information:- This position is based at our Mumbai office. Qualification 15 years full time education

Project Role : Software Development Lead Project Role Description : Develop and configure software systems either end-to-end or for a specific stage of product lifecycle. Apply knowledge of technologies, applications, methodologies, processes and tools to support a client, project or entity. Must have skills : Oracle CC&B Technical Architecture Good to have skills : NAMinimum 7.5 year(s) of experience is required Educational Qualification : 15 years full time education Summary As an Oracle CC&B Developer you will be responsible for designing, developing, and implementing customized solutions within the Oracle Customer Care and Billing (CC&B) platform. The ideal candidate should have a deep understanding of Oracle CC&B modules, a solid foundation in Oracle technologies, and the ability to tailor the solution to meet business requirements for utility clients. Roles & Responsibilities:-Solid understanding of Oracle Utilities Application Framework (OUAF), including expertise in customizing and developing for Oracle CC&B. Experience in developing UI Maps, BPA scripts, service scripts, and business objects.-Solution Design and Development:Design and develop custom solutions within Oracle CC&B, focusing on key modules such as Billing, Collections, Customer Management, and Meter Data Management. Customize CC&B components to meet client-specific requirements, including UI Maps, BPA scripts, service scripts, and business objects (BOs).-Configure and extend Oracle CC&B applications and modules as needed to enhance customer care and billing processes. Customize business processes and workflows to ensure they meet user expectations and business needs.-Leverage SOA based integration techniques to integrate Oracle CC&B with other enterprise systems and third-party applications. Ensure smooth and effective data exchange between systems.-Work on data migration strategies to ensure seamless transfer of data from legacy systems into Oracle CC&B, ensuring data accuracy, integrity, and consistency.-Conduct unit and system testing to ensure the developed solution meets functional and technical specifications. Troubleshoot and resolve technical issues and defects in Oracle CC&B and related systems.-Maintain clear, detailed technical documentation for all CC&B customizations, configurations, and integrations. -Work closely with functional consultants, business analysts, and project teams to gather requirements, design solutions, and deliver high-quality solutions. Provide technical expertise and guidance to team members as needed.-Provide post-implementation support and maintenance for Oracle CC&B solutions. Professional & Technical Skills: -Experience with SOA based integrations, including working with web services and other integration techniques to connect Oracle CC&B to other enterprise systems.-Proficient in writing optimized SQL queries and scripts for data retrieval, reporting, and automation within the Oracle environment.-Strong problem solving skills, with the ability to troubleshoot issues within Oracle CC&B and related applications.-Excellent communication skills with the ability to work effectively with cross-functional teams and business stakeholders.-Ability to work effectively in a team environment, collaborating with business users, functional consultants, and other technical team members.-Knowledge of utility-specific business processes such as billing, customer service, and meter data management. Additional Information-12+ years of experience in Oracle CC&B design and development, including hands-on experience with configuration, customization, and integration of Oracle CC&B.-Bachelor degree in Computer Science, Information Technology, or a related field.-This position is based at our Bangalore office. Qualification 15 years full time education

Workday Integration - Cross hire5 Good understanding of 1) data extraction and transformation processes for HR and Finance. Optimize SQL queries, Application Engine, and SQR scripts for efficient data migration. 2) Map PeopleSoft data fields to Workday equivalents and resolve inconsistencies. Implement ETL tools and validate data accuracy post-migration. 3) Collaborate with functional teams and Workday consultants for a smooth transition. 4 Maintain documentation for data conversion processes and procedures. 5) Quick learner 6) Strong XSLT, XML, Java script knowledge 7) Strong communication skills

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Oracle Procedural Language Extensions to SQL (PLSQL) Good to have skills : Informatica PowerCenterMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. A typical day involves collaborating with various teams to understand their needs, developing solutions that align with business objectives, and ensuring that applications are optimized for performance and usability. You will also engage in problem-solving activities, providing support and enhancements to existing applications while ensuring that all development adheres to best practices and standards. Roles & Responsibilities:- Expected to be an SME.- Collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Provide solutions to problems for their immediate team and across multiple teams.- Facilitate knowledge sharing sessions to enhance team capabilities.- Monitor project progress and ensure timely delivery of application features. Professional & Technical Skills: - Must To Have Skills: Proficiency in Oracle Procedural Language Extensions to SQL (PLSQL).- Good To Have Skills: Experience with Informatica PowerCenter.- Strong understanding of database design and optimization techniques.- Experience in developing and maintaining complex SQL queries.- Familiarity with application development methodologies and best practices. Additional Information:- The candidate should have minimum 5 years of experience in Oracle Procedural Language Extensions to SQL (PLSQL).- This position is based at our Hyderabad office.- A 15 years full time education is required. Qualification 15 years full time education

Your Impact: Applies developed subject matter knowledge to solve common and complex business issues within established guidelines and recommends appropriate alternatives. Works on problems of diverse complexity and scope. May act as a team or project leader providing direction to team activities and facilitates information validation and team decision making process. Exercises independent judgment within generally defined policies and practices to identify and select a solution. Ability to handle most unique and complex situations. What the Role Offers: Responsible for implementing part or all the technical solution to the client, in accordance with an agreed technical design. Responsible for providing a detailed technical design for enterprise solutions. Understands a broad spectrum of Micro Focus/OpenText ITOM technology in order to provide part or all of a detailed technical design which meets customer requirements. Often leads & front ends small to medium technical projects as part of the or individually. Works with and under the direction of the Project/Technical Manager and with customer nominated representatives or independently as a consultant or as a Subject Matter expert to customer. Provides advice on solution and integration opportunities to defined segments. Communicates across client community and is viewed as adding value. Proactively encourages membership and contributions of others to professional community. Uses professions to meet the relevant certification and professional standards. Participates in the selling process in delivery reviews and works with sales/principals on pre- sales activities. What you Need to Succeed: Must have the ability to conduct workshops for ITIL Process, SMAX/SM Entities and prepare design documents. Must have the ability to understand RFP and Prepare SMAX/SM and Its integration solution based on RFP. Must have hands on experience in Deploying SMAX/SM on HA and DR architectures. Must have hands on experience in Upgrading SMAX (Single Hop and Multi Hop) Must have hands on experience in Upgrading SM Must have hands on experience in full deployment of SMAX/SM and its components along with its integration (Minimum 3 Full Projects) Experience in Linux, REST API, Rest Client (Postman), PG Admin (Postgres Client) Experience in OPB (On-Premises integration) agent integration 3rd Party tools Familiarity in AWS, Azure, GCP, OpenShift, Kubernetes, Docker, and Containers Must be an expert in integrations such as Connect IT, UCMDB(NSACM), OBM, LDAP, Email (Inbound and Outbound) Knowledge on Integration engine a must Knowledge on Configuration Management and Asset Management Good to have knowledge on JavaScripts, Python, SQL Queries, or any other programing language. Must have the ability to Train Colleagues, Customer and New Joiners Good to have knowledge on BI tools like Power BI, Crystal reports. Experience of building app(s) in SMAX platform for the customer would be given preference. Knowledge on other MF/OT Products is added advantage.

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Meter Data Management Good to have skills : Utilities RetailMinimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. You will collaborate with teams to ensure seamless integration and functionality of applications. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work-related problems.- Develop and implement software solutions to meet business requirements.- Collaborate with cross-functional teams to ensure application functionality.- Conduct testing and debugging to ensure software meets quality standards.- Provide technical support and troubleshooting for applications.- Stay updated on industry trends and technologies to enhance application development. Professional & Technical Skills: - Must To Have Skills: Proficiency in Meter Data Management.- Strong understanding of data management in Utilities Retail sector.- Experience with software development lifecycle and methodologies.- Knowledge of database management systems and SQL queries.- Hands-on experience in application design and development. Additional Information:- The candidate should have a minimum of 3 years of experience in Meter Data Management.- This position is based at our Bengaluru office.- A 15 years full-time education is required. Qualification 15 years full time education

Educational Bachelor of Engineering,Bachelor Of Comp. Applications,Master Of Comp. Applications Service Line Application Development and Maintenance Responsibilities Analyzing user requirements, envisioning system features and functionality. Design, build, and maintain efficient, reusable, and reliable .Net codes by setting expectations and features priorities throughout development life cycle Identify bottlenecks and bugs, and recommend system solutions by comparing advantages and disadvantages of custom development Contributing to team meetings, troubleshooting development and production problems across multiple environments and operating platforms Understand Architecture and ensure effective Design, Development, Validation and Support activities Additional Responsibilities: Min. 5 years of relevant .Net experience with team handling experience Must have design experience using best practices, Design Patterns, SDLC, OOP, OOD Must have experience in leading and mentoring teams Must be experienced in developing applications using SQL databases, schema, SQL queries Must be experienced in GIT and version control systems Must be skilled in Database constructs, schema design, SQL Server or Oracle, SQL Queries, query optimization. Must be hands-on experienced in MSTest or NUnit, Mocking frameworks, Jasmine, Karma, Cucumber Solid understanding of object-oriented programming Experience with both external and embedded databases Creating database schemas that represent and support business processes Implementing automated testing platforms and unit tests Good verbal and written communication skills Ability to communicate with remote teams in effective manner High flexibility to travel Strong analytical, logical skills and team leading skills Technical and Professional : .NET, ASP.NET, MVC, C#, WPF, WCF, SQL Server, Entity Framework Preferred Skills: Technology-Microsoft Technologies-.NET Frameworks Technology-ASP.Net-ASP.Net Web API