8 Plsql Query Jobs

Purpose As a Technical Consultant (TC) working with the implementation team, you will deliver implementation and/or consulting to projects to achieve successful on-time projects with client satisfaction. As an integral part of this team, you will be primarily responsible for developing C#, PL/SQL code, and Telerik reports to support these client projects. Essential Functions Develop custom code using PL/SQL to query and execute functions within the Clinisys Laboratory Solutions (CLS) LIMS platform, typically working from details provided by team members or working directly with the clients. Configure reports using Telerik Report Writer to be generated from within the Clinisys Laboratory Solutions (CLS) LIMS platform, typically working from details provided by team members working directly with the clients. Perform all alpha testing on the work you develop to ensure it meets all specified requirements and works properly when executed from within the CLS platform. Demonstrate completed work either to internal team members or directly to the clients as needed. Develop a strong understanding of the CLS functionality and its data model. Provide guidance to internal team members as to how to best accomplish specific project goals within that platform. Provide input to process improvements by monitoring both client and departmental feedback. Maintain a high level of commitment to superior customer satisfaction through the entire duration of the customer relationship. Resolve project issues in a timely manner or determine when escalation to senior staff or management is required. Collaborate with and mentors other Technical Consultants and Professional Services Consultants to expand own and others depth & breadth of Clinisys product knowledge. Effectively organize and prioritize project tasks to ensure timely completion of projects assigned. Complete other tasks as assigned. Skills needed to be successful Ability to work independently and effectively manage project priorities from start to finish Strong understanding of client/ laboratory workflow concepts relative to software applications with strong knowledge of interfaces Strong communication and presentation skills with the ability to present to all levels of the organization Strong analytical and problem-solving skills Able to provide mentoring and consultation to improve workflow processes and procedures. Required Experience & Education Bachelors degree in Computer Science, Software Engineering, Data Science, Bioinformatics, Healthcare, Chemistry/Biology, Life Sciences/Pharma, Forensics/Toxicology, or related field, or equivalent relevant work experience. 3+ years experience working with a LIS or LIMS system 3+ years experience with PL/SQL query writing (Oracle DB Knowledge preferred) 3+ years’ experience with C# programing 3+ years’ experience developing LIS/LIMS reports using a common report writing tool (i.e. Crystal Reports, SSRS, etc.) Shift Timings: This is a permanent role comprising a five-day week with shifts to cover our core UK hours from Monday to Friday. For India these are UK shifts from 1:30 PM to 9:30 PM IST. Preferred Experience & Education 3+ years’ experience developing reports using Telerik report designer 3+ years’ experience with Horizon LIMS, especially as a LIMS administrator 3-5 years’ experience working in a LIMS/LIS implementation environment 3+ years’ experience with API/Interfaces (HL7) Physical Requirements Work is performed in a normal office setting with minimal exposure to health or safety hazards. Prolonged periods of sitting at a desk and working on a computer. Up to 25% travel may be required. Moderate lifting/carrying 15-44 lbs; use of fingers, walking/standing 2-6 hours Exposure to hazardous materials or various weather conditions Travel to client sites that can pose risk associated with healthcare organization May be required to follow customer location health and safety requirements

Key Responsibilities: Develop and optimize P&L reports and financial statements using advanced Oracle SQL and PL/SQL. Design and implement data extraction, transformation, and loading (ETL) processes for financial systems. Collaborate with Finance, FP&A, and Data teams to gather reporting requirements and translate them into technical specs. Create and maintain stored procedures, packages, and functions supporting financial reporting workflows. Troubleshoot and resolve performance issues in SQL queries and ensure report accuracy and data consistency. Ensure security, integrity, and compliance of financial data in accordance with internal controls. Support period-end financial close processes with accurate and timely data outputs. Document solutions and contribute to data governance best practices. Required Skills and Qualifications: 4+ years of experience in Oracle SQL/PLSQL development . Strong understanding of financial accounting principles , especially P&L components (Revenue, COGS, OPEX, etc.) . Experience with Oracle Financials , EBS, or other ERP systems (optional but preferred). Expertise in performance tuning and writing complex queries involving multiple joins, subqueries, CTEs, etc. Experience building financial dashboards or BI reports is a plus (e.g., using Power BI, Tableau, or Oracle BI). Ability to work independently and in collaboration with cross-functional teams. Strong analytical and problem-solving skills with attention to detail.

Dear Candidate, Job Description: ESSENTIAL DUTIES AND RESPONSIBILITIES: Job Description - PLSQL Developer Location: Noida Sector 62 Work from office Only Position Type: Full-time Skills Required: Oracle PLSQL developer. Hands on experience in writing complex SQL queries and creating DB objects like Stored Procedures, Triggers, Functions, views and materialized views etc. Developing Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL Proficiency in computer concepts and functionalities. Proficiency with actual work experience in using: Oracle PL/SQL development for Packages, Procedures, and Functions Oracle Forms/Reports Development using Oracle Developer Suite Oracle Application Server Oracle DB Good understanding and knowledge in systems analysis and application development. Advance understanding on Client/Server. Knowledgeable in UNIX/Linux and has hands-on experience in shell scripting.

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 : Oracle Applications DevelopmentMinimum 7.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. Your typical day will involve collaborating with teams to develop solutions that align with business needs and requirements. 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- Lead the team in implementing innovative solutions- Conduct regular team meetings to ensure alignment and progress- Mentor junior team members to enhance their skills Professional & Technical Skills: - Must To Have Skills: Proficiency in Oracle Procedural Language Extensions to SQL (PLSQL)- Good To Have Skills: Experience with Oracle Applications Development- Strong understanding of database design and development- Proficient in writing complex PLSQL queries and procedures- Experience in performance tuning and optimization of PLSQL code- Knowledge of Oracle database architecture and data modeling Additional Information:- The candidate should have a minimum of 7.5 years of experience in Oracle Procedural Language Extensions to SQL (PLSQL)- This position is based at our Pune office- A 15 years full-time education is required Qualification 15 years full time education

Greetings!!! This is in regards to a Job opportunity for Oracle PLSQL Developer with Datamatics Global Services Ltd. Position: Oracle PLSQL Developer Website: https://www.datamatics.com/ Job Location: Mumbai/Bangalore Job Description: 1. An Oracle PLSQL Developer is responsible for developing and maintaining Oracle database applications using the PLSQL programming language. 2. Developing and maintaining Oracle database applications using PLSQL. 3. Designing and developing database schemas, stored procedures, functions, and triggers using PLSQL. 4. Optimizing database performance by tuning SQL queries and PLSQL code. 5. Developing and executing test plans to ensure the quality and accuracy of PLSQL code. 6. Troubleshooting and resolving issues related to PLSQL code. 7. Convert user stories into application logic; reports, printed outputs, and interfaces with other systems. Roles and Responsibilities: 1. Fixes and develops changes to applications to meet functional and technical designs following best practices and development standards and guidelines. 2. Supports production systems; analyzes and resolves production problems in a timely manner; resolves end user service requests as assigned. 3. Participates in Backlog grooming, sprint planning and Daily stand-up meetings. 4. Engages with business analysts and stakeholders to understand functional requirements, and contributes to completion of functional specifications. 5. Prepares technical documentation on application specifications 6. Debugs applications and ensures specifications are met before integrating new modules and upgrades into the online production database system. 7. Adheres to coding standards and other standard work as laid out for applications development. 8. Responds promptly to customer needs; takes a customer-centric approach to problem solving; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments; manages customer expectations.

Job Summary: We are looking for a skilled and experienced Oracle Integration Cloud (OIC) and PL/SQL Technical Consultant to join our team in Kolkata. The ideal candidate will have strong technical expertise in Oracle Cloud integrations, PL/SQL development, and hands-on experience with Oracle Fusion or EBS environments. Key Responsibilities: Design, develop, and implement integrations using Oracle Integration Cloud (OIC). Build and maintain PL/SQL programs, packages, procedures, and triggers. Analyze and troubleshoot integration issues and provide timely resolutions. Work closely with functional teams to gather requirements and translate them into technical specifications. Ensure high performance and responsiveness of the integrations and database components. Create technical documentation for integrations, enhancements, and data mapping. Participate in code reviews, unit testing, and system testing. Support migration and deployment activities across different environments. Required Skills and Experience: 5 to 8 years of hands-on experience in PL/SQL development and Oracle Integration Cloud (OIC). Strong understanding of Oracle Fusion Cloud / EBS architecture. Proficient in creating SOAP and REST web services. Experience with file-based data import/export, adapters (FTP, SOAP, REST, DB, ERP), and process automation using OIC. Solid experience in debugging, performance tuning, and optimization of PL/SQL code. Experience in working with large datasets and writing complex SQL queries. Good knowledge of data migration and integration techniques. Strong problem-solving skills and ability to work independently. Preferred Qualifications: Experience with Oracle Fusion ERP modules (Finance, SCM, HCM) integration. Familiarity with Agile/Scrum development methodologies. Oracle Cloud certifications in OIC or PL/SQL will be an added advantage. Education: Bachelors or Master’s degree in Computer Science, Information Technology, or a related field

About CAMS: Computer Age Management Services (CAMS) is the leading Mutual Fund Transfer Agency to the Indian Asset Management Companies servicing ~70% of the MF Industry AUM. CAMS is also a technology enabled service solutions partner to Private Life Insurance, Private Equity Funds, Software development / maintenance and Payments. The mutual fund business constitutes ~90% of the groups revenue. Besides serving as a B2B solutions partner, CAMS brings a unique ability of B2C to serve the end customers through a variety of touch points such as pan India network of Service centers, Call center and Online Services. The company was incorporated in year 1988, has four back-office delivery centers in Chennai, Business Continuity Plan (BCP) site at Coimbatore and a Pan India network of 270+ customer service centers. CAMS is a listed company and has Warburg Pincus LLC (a leading global private equity firm) and HDFC Group among its shareholders, headquartered in Chennai, India. CAMS conducts its software solutions business through subsidiary Sterling Software Private Limited. SSPL owns, develops and maintains the technology solutions for Mutual Fund clients and as of June 30, 2020, it had a technology team of 428 personnel. Among others, Sterling Software developed Investrak.NET, a scalable Mutual Fund transfer agency platform. SSPL assists with website design and development for other businesses and consumers, providing mobility solutions, performing trend analysis, business intelligence and analytics-based services, and technical and domain consulting services. We are looking for senior dot net developers with good experience, a passion for coding and solving complex problems in the financial domain. The developer should be able to explain and code OOPS, ACID, SOLID principles. He or she should have demonstrated experience in Restful web services development and implementing various design patterns. Once in a lifetime opportunity to be part of the high performing technology team developing the platform that's leading the consented citizen's financial data movement across silos! Key Responsibilities: Develop and Maintain PL/SQL Code : Design, develop, and maintain PL/SQL stored procedures, functions, packages, and triggers to meet business requirements. SQL Queries and Reports : Write efficient SQL queries to extract and manipulate data and ensure proper indexing and optimization. Performance Tuning : Optimize SQL and PL/SQL code for performance, including query optimization and indexing strategies. Database Design : Assist with database schema design, including creating tables, views, indexes, and relationships. Data Integration : Work with cross-functional teams to integrate databases with external systems and applications. Error Handling : Implement proper error handling and exception management in PL/SQL procedures. Testing and : Maintain accurate documentation for developed procedures, functions, and other code structures. nice, functionality, and security. Documentation :Maintain accurate documentation for developed procedures, functions, and other code structures. Collaboration : Work closely with other developers, system administrators, and business analysts to ensure the overall success of database projects. Required Skills: Proficiency in PL/SQL and Oracle Database systems. Strong SQL skills and experience with performance tuning. Familiarity with database design concepts and data modeling. Understanding of data manipulation, triggers, and stored procedures. Experience with version control tools (e.g., Git, SVN). Ability to troubleshoot and resolve database-related issues. Strong problem-solving skills and ability to optimize SQL queries for performance. Qualifications: BE /B. Tech / MCA / Bachelors and master’s degree in computer application or a related field (or equivalent work experience). Knowledge and Experience with Oracle 12c or later . Python, ETL and knowledge of additional Back-end tool is value added. Kindly share the Relevant Profiles to: swetha.n@camsonline.com

Must have 8+ yrs into Application Support, RevPro Exp, RightRev Exp Expertise in Oracle PL/SQL & Snowflake mandatory Deep understanding of advanced PL/SQL concepts Willing to work in shifts Only 0-15 days Notice Period considered