Data Engineer

loanDNA; Chennai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Consolidated Analytics, a data-driven mortgage solutions partner, seeks a Database Engineer with 3+ years of hands-on experience in database development, migration, and optimization. You will design, implement, and optimize SQL Server and other databases, ensure data integrity, and collaborate with developers to build scalable data architectures.

The role covers security, backup, recovery, and performance tuning across on-premises and cloud environments, including Snowflake and NoSQL

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum 3 years hands-on experience in database development, management, architecture, migration, and optimization.
• Proven experience with SQL Server is mandatory; MySQL, PostgreSQL preferred.

Responsibilities

• Design, develop, and maintain SQL Server and other databases (MySQL, PostgreSQL).
• Write efficient, complex queries, stored procedures, and functions.
• Collaborate with application developers to design and optimize database structures.
• Implement and manage database security, backup, and recovery plans.
• Monitor and optimize the performance of the database systems.
• Plan and execute data migrations between systems, ensuring data integrity and minimal downtime.
• Design and implement database systems based on business requirements.
• Create and maintain data models and database diagrams.

Skills

SQL Server

T-SQL

NoSQL

Snowflake

Cloud Platforms

Data Migration

Performance Tuning

Database Security

Education

Bachelor's in CS/IT

Tools

MySQL

PostgreSQL

MongoDB

Job description

We are seeking an experienced and highly skilled Database Engineer to join our dynamic team. The ideal candidate will have over 3 years of hands-on experience in database development, management, architecture, migration, and optimization. Proficiency in SQL Server is mandatory, with additional expertise in NoSQL databases, Snowflake, and cloud technologies considered a plus.

Key Responsibilities:

• Database Development and Management:
• Design, develop, and maintain SQL Server and other databases (MySQL, PostgreSQL).
• Write efficient, complex queries, stored procedures, and functions.
• Collaborate with application developers to design and optimize database structures.
• Implement and manage database security, backup, and recovery plans.
• Monitor and optimize the performance of the database systems.
• Database Architecture and Design:
• Design and implement database systems based on business requirements.
• Ensure database architecture aligns with enterprise standards and best practices.
• Create and maintain data models and database diagrams.
• Database Migration and Optimization:
• Plan and execute data migrations between systems, ensuring data integrity and minimal downtime.
• Optimize database performance through indexing, query tuning, and hardware/software configuration.
• Implement and maintain data replication and clustering solutions.
• Security and Compliance:
• Implement database security measures to protect sensitive data.
• Ensure compliance with relevant data protection regulations and policies.
• Conduct regular security audits and vulnerability assessments.
• Support and Troubleshooting:
• Provide technical support and troubleshooting assistance for database-related issues.
• Respond to and resolve database access and performance issues.
• Collaborate with development teams to assist with database-related application issues.

Qualifications:

• Education:
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience:
• Minimum of 3 years of hands-on experience in database development, management, architecture, migration, and optimization.
• Proven experience with SQL Server is mandatory. MySQL, PostgreSQL are preferable.
• Technical Skills:
• Strong knowledge of SQL and T-SQL scripting.
• Experience with NoSQL databases (e.g., MongoDB, Cassandra) is preferred.
• Familiarity with Snowflake data warehousing solutions.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) and cloud-based database services.
• Knowledge of database security, backup and recovery, and disaster recovery procedures.
• Understanding of database replication, clustering, and high availability solutions.
• Soft Skills:
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Detail-oriented with a focus on accuracy and quality.

Preferred Certifications:

• Microsoft Certified: Data Analyst Associate
• Snowflake SnowPro Certification
• AWS Certified Database - Specialty

Consolidated Analytics | End-to-End Mortgage Solutions. Real Expertise. Real Results.

Consolidated Analytics is a data-driven mortgage solutions partner supporting the full life of the loan, from origination through servicing and capital markets. We combine asset-level intelligence with enterprise-scale solutions to power smarter decisions and measurable business outcomes. Our integrated capabilities span due diligence, residential and commercial valuation, collateral and risk analytics, process and technology optimization, and regulatory compliance, helping clients operate with clarity, agility, and confidence in a rapidly evolving market.

What sets us apart?

We bring together deep mortgage industry expertise, integrated technology, and a multidisciplinary workforce to help clients optimize quality, drive operational performance, and enhance decision-making at scale. Across the loan lifecycle, whether managing volume, acquiring assets in bulk, scaling originations, launching or expanding servicing, or navigating market and regulatory change, our teams deliver with clarity, compliance, and speed.

Core Services

• Mortgage Due Diligence
• Property Valuation + Analytics
• Mortgage Fulfillment (Origination and Servicing)
• Default Services (Claims, REO, Rental Management)
• Risk + Compliance Advisory
• Business Process Solutions (BPS)

Our Evolution

Over the past decade, we’ve strategically acquired and integrated best-in-class firms, including OpEXNOW, Equitable Mortgage Solutions, Carrington Property Services, and RealInfo into a unified platform designed to meet the demands of today’s dynamic market.

We’re not just a vendor, we’re a partner built for transformation.

Careers

We’re always hiring talented professionals who want to grow, lead, and win.