Senior Database Developer

Persistent Systems; Pune District; Hybrid; INR 2,000,000 - 4,000,000; Full time

Benefits offered by this job

Salary + benefits

Education sponsorship

Flexible work hours

Long Service awards

Job summary

Persistent Systems Limited in Pune invites applications for a Senior Database Developer to design robust data schemas, tables, and data models for loan and reconciliation systems. You will optimize SQL and ensure data accuracy and performance.

The role requires 8–12 years of database development experience, strong SQL skills, and familiarity with data ingestion, validation, and reconciliation across multiple sources. OutSystems experience is a plus.

Qualifications

• 8–12 years of database development experience.
• Advanced SQL skills including complex queries, stored procedures, views and functions.
• Experience with data ingestion, transformation, validation and reconciliation processes.
• Experience with indexing, query optimization and database performance tuning.
• Ability to troubleshoot data discrepancies and perform root-cause analysis.
• Experience integrating data through APIs and file transfers.

Responsibilities

• Design and develop robust database schemas, tables, and data models for financial systems.
• Write and optimize complex SQL queries, stored procedures, views, and functions.
• Manage data ingestion, transformation, and reconciliation datasets across multiple data sources.
• Implement validation and reconciliation logic to identify and resolve data mismatches.
• Ensure data accuracy, integrity, and consistency across financial systems.
• Optimize query performance through indexing, database tuning, and execution-plan analysis.
• Support integrations with OutSystems and external systems through APIs and file transfers.
• Handle large datasets, batch processing, and reporting requirements.
• Troubleshoot data discrepancies and perform root-cause analysis with developers, architects, and business teams.

Skills

Advanced SQL

Education

Bachelor’s degree in CS/IT/Engineering

Tools

OutSystems

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what?s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

We are seeking a Senior Database Developer to design and develop database schemas, tables, and data models for loan and reconciliation systems. The role requires strong SQL expertise and experience managing complex data ingestion, transformation, validation, and reconciliation across multiple sources.

• Role: Senior Database Developer
• Location: Pune
• Experience: 8 to 12 Years
• Job Type: Full Time Employment

What You’ll Do:

• Design and develop robust database schemas, tables, and data models for financial systems.
• Write and optimize complex SQL queries, stored procedures, views, and functions.
• Manage data ingestion, transformation, and reconciliation datasets across multiple data sources.
• Implement validation and reconciliation logic to identify and resolve data mismatches.
• Ensure data accuracy, integrity, and consistency across financial systems.
• Optimize query performance through indexing, database tuning, and execution-plan analysis.
• Support integrations with OutSystems and external systems through APIs and file transfers.
• Handle large datasets, batch processing, and reporting requirements.
• Troubleshoot data discrepancies and perform root-cause analysis with developers, architects, and business teams.

Expertise You’ll Bring:

• Between 8 to 12 Years of database development experience.
• Advanced SQL skills, including complex queries, stored procedures, views, and functions.
• Experience with data ingestion, transformation, validation, and reconciliation processes.
• Strong understanding of indexing, query optimization, and database performance tuning.
• Ability to troubleshoot data discrepancies and perform root-cause analysis.
• Experience integrating data through APIs and file transfers.
• Experience with OutSystems or a similar application-development platform is preferred.
• Knowledge of financial systems, batch processing, and reporting is preferred.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

“Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”