SQL/Java Developer/Lead

Job Summary:

Responsibilities:

• Design, develop, and implement complex SQL queries, stored procedures, functions, and triggers for PostgreSQL or Oracle databases.
• Optimize database performance through indexing, query tuning, and database schema improvements.
• Work closely with application developers to integrate database solutions with Java and/or Python applications.
• Develop and maintain ETL processes (Extract, Transform, Load) for data migration and integration.
• Collaborate with business analysts to understand data requirements and translate them into technical specifications.
• Ensure data integrity, security, and availability.
• Perform database performance monitoring, troubleshooting, and tuning.
• Participate in database design reviews and provide recommendations for best practices.
• Develop and maintain documentation for database designs, processes, and procedures.
• Support existing database systems and applications, including on-call rotation as needed.
• Stay up-to-date with the latest database technologies and best practices in PostgreSQL, Oracle, Java, and Python.

Required Skills and Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).

• 3+ years of experience as an SQL Developer.

• Strong proficiency in either PostgreSQL or Oracle databases, including:

• Expertise in writing complex SQL queries, stored procedures, functions, and triggers.
• Experience with database design, normalization, and optimization techniques.
• Understanding of database architecture and administration concepts.

• Proficiency in at least one of the following programming languages:

• Java:

  Experience with JDBC, ORM frameworks (e.g., Hibernate, JPA), and Spring Boot is a plus.

• Python:

  Experience with database connectors (e.g., psycopg2, cx_Oracle), ORM frameworks (e.g., SQLAlchemy), and data manipulation libraries (e.g., Pandas) is a plus.
• Experience with version control systems (e.g., Git).
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
• Ability to work independently and as part of a team in a fast-paced environment.

Preferred Skills (Bonus Points):

• Experience with both PostgreSQL and Oracle databases.
• Familiarity with cloud platforms (AWS, Azure, GCP) and their database services.
• Experience with CI/CD pipelines and DevOps practices.
• Knowledge of data warehousing concepts and tools.
• Experience with data visualization tools (e.g., Tableau, Power BI).
• Familiarity with NoSQL databases (e.g., MongoDB, Cassandra).

About Finacle

Finacle is an industry leader in digital banking solutions. We partner with emerging and established financial institutions to inspire better banking. Our cloud-native solution suite and SaaS services help banks to engage, innovate, operate, and transform better. We are a business unit of EdgeVerve Systems, a wholly-owned product subsidiary of Infosys – a global technology leader with over USD 15 billion in annual revenues. We are differentiated by our functionally-rich solution suite, composable architecture, culture, and entrepreneurial spirit of a start-up. We are also known for an impeccable track record of helping financial institutions of all sizes drive digital transformation at speed and scale.

Today, financial institutions in more than 100 countries rely on Finacle to help more than a billion people and millions of businesses to save, pay, borrow, and invest better.

Finacle website (https://www.edgeverve.com/finacle/solutions/)

Disclaimer :-