PLSQL Developer

About CAMS:

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 masters 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:

twinkle.b@camsonline.com