9 Sql Code Jobs

Role & responsibilities BI Product Development using open source framework Apache Superset hence check for their experience in any BI solution or best would be experience in Apache superset , They should have done multiple project on BI. The role need advanced python experience and Advanced SQL knowledge Hence check for their experience using Python and SQL for product development OR in project delivery , What was the use case which required advanced python experience and Advanced SQL knowledge Should be able to perform Advanced analytics like Fraud Analytic / Prediction and Forecasting . Check if they have any such advance analytics experience. Client Management experience for managing BI project. Preferred candidate profile

: Job Title Senior Engineer (SAS/SAS Viya/Unix) AVP LocationPune, India Role Description ITAO is the custodian of the application and is responsible to apply and enable during Life-Cycle of the application the IT policies and procedures with specific consideration to IT management and Information Security. The ITAO ensures a clear separation of the responsibility within the project, aimed at achieving a safe and secure running of the application and compliance to regulations, policies and standards. ITAO is responsible for application documentation, application infrastructure reliability and compliance, and is usually the IT SPOC for audit initiatives. What well offer you , 100% reimbursement under childcare assistance benefit (gender neutral) Sponsorship for Industry relevant certifications and education Accident and Term life Insurance Your key responsibilities You are involved in the whole Software Development Lifecycle starting from analyzing requirements, developing, deploying and testing software as well as maintaining & continuously improving it. Your primary focus will be on software design, development and unit-testing activities including peer code reviews. You provide high-quality solutions that meet functional as well as non-functional requirements. You actively participate and contribute into the sprint activities and ceremonies e.g. daily stand-up, Sprint planning, retrospectives, refinements etc. You collaborate with other team members to achieve the sprint objectives. Candidate should aware and good knowledge on Enterprise IT governance, Security & Governance, Information content publishing, Knowledge management, Business risk management, Continuity management, Data management, Change and Transformation. Delivery and operation Availability management : Contributes to the availability management process and its operation and performs defined availability management tasks. Analyses service and component availability, reliability, maintainability and serviceability. Ensures that services and components meet and continue to meet all of their agreed performance targets and service levels. Implements arrangements for disaster recovery and documents recovery procedures. Conducts testing of recovery procedures. Service acceptanceEngages with project management to confirm that products developed meet the service acceptance criteria and are to the required standard. Feeds into change management processes. Configuration management : Applies tools, techniques and processes to track, log and correct information related to configuration items. Verifies and approves changes ensuring protection of assets and components from unauthorised change, diversion and inappropriate use. Ensures that users comply with identification standards for object types, environments, processes, lifecycles, documentation, versions, formats, baselines, releases and templates. Performs audits to check the accuracy of information and undertakes any necessary corrective action under direction. Asset management : Applies tools, techniques and processes to create and maintain an accurate asset register. Produces reports and analysis to support asset management activities and aid decision making. Change management : Develops implementation plans for complex requests for change. Evaluates risks to the integrity of service environment inherent in proposed implementations (including availability, performance, security and compliance of the business services impacted). Seeks authority for those activities, reviews the effectiveness of change implementation, and suggests improvement to organisational procedures governing change management. Leads the assessment, analysis, development, documentation and implementation of changes based on requests for change. Security administration : Investigates minor security breaches in accordance with established procedures. Assists users in defining their access rights and privileges. Performs non-standard security administration tasks and resolves security administration issues. Application support : Drafts and maintains procedures and documentation for applications support. Manages application enhancements to improve business performance. Advises on application security, licensing, upgrades, backups, and disaster recovery needs. Ensures that all requests for support are dealt with according to set standards and procedures. Problem management : Ensures that appropriate action is taken to anticipate, investigate and resolve problems in systems and services. Ensures that such problems are fully documented within the relevant reporting system(s). Enables development of problem solutions. Coordinates the implementation of agreed remedies and preventative measures. Analyses patterns and trends. To support key role holders such as ITAOs and ISOs to develop a secure environment by evaluating the IT Security requirements as early as possible in the system development life cycle to select the applicable information security controls for implementation. To guide ITAOs on the implementation of compensating controls in case of deviations from the applicable information security controls. To approve the access control and user authorization approach of the assigned IT Assets. To execute and document periodical recertification of Access Rights in compliance with the DB Group Identity and Access Processes. Incident management : Ensures that incidents are handled according to agreed procedures. Investigates escalated incidents to responsible service owners and seeks resolution. Facilitates recovery, following resolution of incidents. Ensures that resolved incidents are properly documented and closed. Analyses causes of incidents, and informs service owners in order to minimise probability of recurrence, and contribute to service improvement. Analyses metrics and reports on performance of incident management process. Your skills and experience At least 10 years experience in as a SAS, SAS Viya . Sound understanding of Production Management processes and controls in large organizations. Excellent problem solving skills in a distributed, multi-technology ecosystem Strong Experience in Base SAS, Advance SAS, Macros, SAS Enterprise Gide, SAS SMC,SAS Viya on UNIX Platform. Strong Skill in Advance Data Step programming statement to solve complex problems Strong Skill in writing and debugging SAS SQL/Proc SQL code. Strong Skill in writing and using SAS Macros. Hands on experience with SAS/Access using Oracle Strong Scripting experience in Shell . Strong Knowledge of Oracle Management, SQL scripts, performance mgmt. Strong understanding of Unix, Linux and Windows. Understanding of Agile and Safe methodologies. How well support you . . . .

Proven expert at writing SQL code with at least 10 years of experience. Must have 5+ years of experience working with large data with transactions in the order of 5 10M records. 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. 3+ years of proven expertise in working with large Data Warehouses. Expert at ETL transformations using SSIS.

We are looking for a skilled Senior Power BI Consultant to join our team at Apps Associates (I) Pvt. Ltd, with 4-8 years of experience in the IT Services & Consulting industry. Roles and Responsibility Design and develop interactive dashboards using Power BI to provide data-driven insights. Collaborate with stakeholders to understand business requirements and develop solutions. Develop and maintain complex reports, visualizations, and analytics models. Troubleshoot and resolve issues related to Power BI performance, data quality, and security. Work closely with cross-functional teams to integrate Power BI with other systems and tools. Stay up-to-date with the latest trends and technologies in Business Intelligence and Data Analytics. Job Strong understanding of data modeling, ETL processes, and database concepts. Proficiency in developing complex queries and writing efficient SQL code. Experience working with large datasets and creating scalable data architectures. Excellent communication and interpersonal skills to work effectively with stakeholders. Ability to analyze complex business problems and develop innovative solutions. Strong problem-solving skills with attention to detail and ability to meet deadlines.

R1 RCM India is proud to be recognized amongst India's Top 50 Best Companies to Work ForTM 2023 by Great Place To Work Institute. We are committed to transform the healthcare industry with our innovative revenue cycle management services. Our goal is to make healthcare simpler and enable efficiency for healthcare systems, hospitals, and physician practices. With over 30,000 employees globally, we are about 14,000 strong in India with offices 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. Key Duties Data processing (ETL) using MSSQL 2012/2014 R2 SSIS with stored procedures, views, and other various database objects; import and export processing; data conversions; business process workflows and metrics reporting. Providing client support services and enhancements. Controlling daily ticket resolution/prioritization as client and user volume increases. Prioritizing issues based on client expectations, volume of current tickets, and visibility of issues across the enterprise. Analyzing the overall enterprise environment to find gaps and can think outside-of-the-box in order to design and create functionality which will prove to be of value. Provide SQL training to other technicians. Drive ticket resolution momentum and provide feedback to US Leadership where staff improvements can be made in order to better overall productivity of the technicians. Manage MSSQL Server 2012/2014 R2 database objects (stored procedures, views, synonyms, tables and overall schema), reporting, and administration. Qualifications: Bachelors degree in computer science or equivalent. Skill and Knowledge: 4-7 years of experience writing T-SQL code in order to triage issues, analyse data, and optimize database objects. 2-5 years of experience of troubleshooting using MSSQL 2012 R2/2014 SSIS . 2-3 years of experience relating to ETL flat file/real-time message data loading. Strong with MSSQL 2012 R2/2014 Administration. Key Competency Profile: Identify new opportunities by anticipating change and planning accordingly Feels comfortable working in a changing environment Communicates accurately at client's level of understanding, checking to make sure all information is correct. Be accountable for customer service of highest quality Help people improve by learning from successes and failures Finds flexible and rapid solutions to meet the clients needs. Takes controlled risks, seeking support from team members when unsure. Motivate each other to perform at our highest level Prioritizes work and sets realistic deadlines to ensure that important tasks are achieved on or ahead of time, with quality results. Shares own expertise with team members, while remaining open to others' ideas. Identify area of process improvement and automation Help team members with your expertise to archive common goal. Proactively identifying problems and solutions. Takes full responsibility for meeting the clients level of satisfaction. Checks back with client to ensure the correct information has been provided. Continuously searches for new ideas and better ways of doing things. Takes steps to learn about own department, its vision, its values and its strategic objectives. Encourages others to look for solutions rather than presenting problems Key Success Criteria: 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

Job Summary: We are looking for a skilled Application Support – Database Developer to ensure the performance and reliability of production systems. The role involves responding to incidents, identifying and resolving system vulnerabilities, and applying creative solutions to maintain a stable application and infrastructure environment. This position requires hands-on expertise in Oracle PL/SQL and related systems, along with strong troubleshooting and communication skills. Roles and Responsibilities Troubleshoot and resolve issues in production systems and applications across various technologies. Investigate and address user-submitted incident and service request tickets. Work primarily with Oracle PL/SQL-based applications and supporting systems, including web, mobile, and web services. Monitor and respond to internal and external reports of product issues. Analyze complex technical problems across applications, systems, and infrastructure. Collaborate with business and IT teams, including network, server, QA, and development teams, to resolve production issues. Make application modifications to fix defects and reduce the risk of future incidents. Participate in testing and validation of system changes. Modify database applications using SQL, PL/SQL, and Oracle Forms. Review upcoming production changes and contribute to minimizing their potential impact. Perform additional duties as assigned by the Director of Application Support. Required Skills and Qualifications Strong experience in application support or development in an RDBMS environment, particularly with SQL and PL/SQL on Oracle. Proficiency in developing reliable and maintainable PL/SQL code, including packages, procedures, and triggers. Working knowledge of Linux operating systems. Excellent communication and interpersonal skills. Strong analytical and problem-solving skills. Ability to think creatively and develop alternative solutions. Quick adaptability to changing technologies and business needs. Familiarity with enterprise technologies such as sFTP, SSL/SSH, networking basics, Citrix, and ETL tools. Able to work independently as well as in a team-oriented environment. Strong customer-focus and a desire to support end users effectively. Preferred Skills Bachelor’s degree in Computer Science, Information Systems, or a related field. Experience with web and mobile application technologies. Knowledge of enterprise performance monitoring tools such as AppDynamics or Dynatrace. Familiarity with MS-SQL and MySQL, including their procedural languages. Background in supporting complex, database-driven transaction processing applications. Exposure to ColdFusion/CFML web applications and PHP-based portals. Familiarity with Oracle E-Business Suite is an added advantage. This position will serve as a level II support engineer and will be required to work outside normal business hours in response to production outages & impacts. Off hours on-call operates as a rotation among the team. The candidate’s objective is to eliminate those occurrences by identifying and closing vulnerabilities before they become a production incident.

Key Duties: Data processing (ETL) using MSSQL 2012/2014 R2 SSIS with stored procedures, views, and other various database objects; import and export processing; data conversions; business process workflows and metrics reporting. Providing client support services and enhancements. Controlling daily ticket resolution/prioritization as client and user volume increases. Prioritizing issues based on client expectations, volume of current tickets, and visibility of issues across the enterprise. Analyzing the overall enterprise environment to find gaps and can think outside-of-the-box in order to design and create functionality which will prove to be of value. Provide SQL training to other technicians. Drive ticket resolution momentum and provide feedback to US Leadership where staff improvements can be made in order to better overall productivity of the technicians. Manage MSSQL Server 2012/2014 R2 database objects (stored procedures, views, synonyms, tables and overall schema), reporting, and administration. Qualifications: Bachelors degree in computer science or equivalent. Skill and Knowledge: 4-7 years of experience writing T-SQL code in order to triage issues, analyse data, and optimize database objects. 2-5 years of experience of troubleshooting using MSSQL 2012 R2/2014 SSIS . 2-3 years of experience relating to ETL flat file/real-time message data loading. Strong with MSSQL 2012 R2/2014 Administration. Key Competency Profile: Identify new opportunities by anticipating change and planning accordingly Feels comfortable working in a changing environment Communicates accurately at client's level of understanding, checking to make sure all information is correct. Be accountable for customer service of highest quality Help people improve by learning from successes and failures Finds flexible and rapid solutions to meet the clients needs. Takes controlled risks, seeking support from team members when unsure. Motivate each other to perform at our highest level Prioritizes work and sets realistic deadlines to ensure that important tasks are achieved on or ahead of time, with quality results. Shares own expertise with team members, while remaining open to others' ideas. Identify area of process improvement and automation Help team members with your expertise to archive common goal. Proactively identifying problems and solutions. Takes full responsibility for meeting the clients level of satisfaction. Checks back with client to ensure the correct information has been provided. Continuously searches for new ideas and better ways of doing things. Takes steps to learn about own department, its vision, its values and its strategic objectives. Encourages others to look for solutions rather than presenting problems Key Success Criteria:

Position summary Perform ETL operations on healthcare data from multiple sources. To succeed in this role, the candidate should be analytical and excellent communicator. Experience in the healthcare industry is a plus. Experience integrating data from disparate sources in MS SQL Environment. You will be responsible towards working with different stakeholders to accomplish business and operation goals. Key duties & responsibilities Data processing (ETL) using MSSQL 2012/2014 R2 SSIS with stored procedures, views, and other various database objects; import and export processing; data conversions; business process workflows and metrics reporting. Providing client support services and enhancements. Controlling daily ticket resolution/prioritization as client and user volume increases. Prioritizing issues based on client expectations, volume of current tickets, and visibility of issues across the enterprise. Analyzing the overall enterprise environment to find gaps and can think outside-of-the-box in order to design and create functionality which will prove to be of value. Provide SQL training to other technicians. Drive ticket resolution momentum and provide feedback to US Leadership where staff improvements can be made in order to better overall productivity of the technicians. Manage MSSQL Server 2012/2014 R2 database objects (stored procedures, views, synonyms, tables and overall schema), reporting, and administration. Skills and Knowledge Bachelors degree in computer science or equivalent. 4-7 years of experience writing T-SQL code in order to triage issues, analyse data, and optimize database objects. 2-5 years of experience of troubleshooting using MSSQL 2012 R2/2014 SSIS. 2-3 years of experience relating to ETL flat file/real-time message data loading. Strong with MSSQL 2012 R2/2014 Administration. Key competency profile Identify new opportunities by anticipating change and planning accordingly Feels comfortable working in a changing environment Communicates accurately at client's level of understanding, checking to make sure all information is correct. Be accountable for customer service of highest quality Help people improve by learning from successes and failures Finds flexible and rapid solutions to meet the clients needs. Takes controlled risks, seeking support from team members when unsure. Motivate each other to perform at our highest level Prioritizes work and sets realistic deadlines to ensure that important tasks are achieved on or ahead of time, with quality results. Shares own expertise with team members, while remaining open to others' ideas. Identify area of process improvement and automation Help team members with your expertise to archive common goal. Proactively identifying problems and solutions. Takes full responsibility for meeting the clients level of satisfaction. Checks back with client to ensure the correct information has been provided. Continuously searches for new ideas and better ways of doing things. Takes steps to learn about own department, its vision, its values and its strategic objectives. Encourages others to look for solutions rather than presenting problems

About The Role : Job TitleSenior SAS Engineer , AVP LocationPune, Magarpatta Role Description:- The SAS Sr Engineer designs and implements technical solutions and configures applications in different environments in response to business problems. With the partial/ full ownership of Production platforms, SAS Engineer is required to ensure environment stability, expeditious and timely resolution of Production issues, ensuring minimal downtimes and continuity of services. Further, the SAS Engineer investigates, proposes, and implements various solutions, standardizing where possible, to ensures stability and reliability of the application platforms. What we'll offer you As part of our flexible scheme, here are just some of the benefits that youll enjoy Best in class leave policy Gender neutral parental leaves 100% reimbursement under childcare assistance benefit (gender neutral) Sponsorship for Industry relevant certifications and education Employee Assistance Program for you and your family members Comprehensive Hospitalization Insurance for you and your dependents Accident and Term life Insurance Complementary Health screening for 35 yrs. and above Your key responsibilities Application Analysis Carries out deep technical analysis of the production to identify performance, stability and resilience enhancements. Assists in design and creation of NFRs through identification of further requirements. Development activities such SAS Codes , SQL Script, Documents etc. Problem management Investigates problems in systems, processes, and services. Assists with the implementation of agreed remedies and preventative measures. Attends Program Meetings to prioritize owned stability and performance enhancements as identified in production. Release and deployment : Uses the tools and techniques for specific areas of release and deployment activities. Administers the recording of activities, logging of results and documents technical activity undertaken. May carry out early life support activities such as providing support advice to initial users. Your skills and experience Sound understanding of Production Management processes and controls in large organizations. Excellent problem solving skills in a distributed, multi-technology ecosystem Strong Experience in Base SAS, Advance SAS, Macros, SAS Enterprise Gide, SAS SMC on UNIX Platform. Strong Skill in Advance Data Step programming statement to solve complex problems Strong Skill in writing and debugging SAS SQL/Proc SQL code. Strong Skill in writing and using SAS Macros. Hands on experience with SAS/Access using Oracle Strong Scripting experience in Shell . Strong Knowledge of Oracle Management, SQL scripts, performance mgmt. Strong understanding of Unix, Linux and Windows. Understanding of Agile and Safe methodologies. How we'll support you Training and development to help you excel in your career Coaching and support from experts in your team A culture of continuous learning to aid progression A range of flexible benefits that you can tailor to suit your needs