Data Engineer

Prolifics, Inc.; Hyderabad; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

Prolifics Corporation Private Limited is seeking an experienced Data Engineer to lead Snowflake SQL optimization, refactor legacy code, and design scalable databases for the Rules Catalog and Audit Repository. The role requires collaboration with Drools, Camunda, and business teams to modernize rules and data processes.

The ideal candidate has 8+ years in data engineering, strong SQL expertise, and experience with data warehousing, ETL/ELT, and governance, in Hyderabad, India.

Qualifications

• 8+ years of experience in Data Engineering or Database Development.
• Strong Snowflake SQL, stored procedures, and query optimization.
• Experience analyzing and refactoring complex legacy SQL code.
• Strong database design and data modeling skills (logical and physical models).
• Experience with data warehousing concepts, ETL/ELT processes, and data governance.

Responsibilities

• Refactor and optimize Snowflake SQL stored procedures for performance and maintainability.
• Design and implement the Rules Catalog database and Audit database for rule execution tracking.
• Collaborate with architects, analysts, and developers; participate in design reviews.
• Provide guidance and mentoring to junior engineers; estimate effort and propose best practices.

Skills

Snowflake SQL

Stored procedures

Query optimization

Data modeling

Data warehousing

ETL/ELT

Data governance

SQL performance tuning

Cloud data platforms

Collaboration

Education

B.Tech/BE/M.Tech/MCA/M.Sc

Tools

Drools

Camunda

Git

CI/CD

Python

Job description

Prolifics Corporation Private Limited | FTE

At Prolifics, we are currently implementing multiple solutions in Software Development, and we are looking to hire a talentedData Engineer for our development center in India. This position would be based out of Hyderabad and is a permanent position.

Job Title:Data Engineer Primary skills:Data Engineering or Database Development. Secondary skills:Snowflake SQL, stored procedures, and query optimization. Location:Hyderabad (Mindspace#12B) Educational Qualification:B.Tech/BE/M.Tech/MCA/M.Sc

Experience: 8+ Years

Role Summary

We are seeking an experienced Data Engineer / Data Engineering Lead with strong expertise in Snowflake, SQL, and data modeling to support a business rules modernization initiative. The primary responsibility is to analyze, refactor, and optimize existing Snowflake SQL stored procedures, while designing a scalable database architecture for the Rules Catalog and Audit Repository. The role requires close collaboration with Drools, Camunda, business analysts, and application development teams throughout the project lifecycle.

Key Responsibilities:

1. Snowflake SQL Analysis & Refactoring (Primary Focus – Wave 1)

• Analyze existing Snowflake SQL stored procedures to understand business logic, data transformations, and dependencies.
• Refactor and optimize stored procedures for improved maintainability, readability, and performance.
• Document the existing and target logic to support the rules modernization effort.
• Work closely with business and technical teams to validate functional equivalence after refactoring.
• Support migration of embedded business rules from SQL into the target rules engine where applicable.

2. Data Modeling & Database Design

• Design the logical and physical data model for the Rules Catalog repository.
• Design Audit database tables to capture rule execution history, decision outcomes, versioning, and traceability.
• Define relationships, indexing strategy, naming standards, and data governance considerations.
• Ensure scalability, performance, and maintainability of the database design.
• Develop and optimize SQL queries, views, stored procedures, and data pipelines.
• Support integration between Snowflake, Drools, Camunda, and downstream applications.
• Ensure data consistency, integrity, and performance across systems.
• Assist in troubleshooting data-related issues during development and testing.

4. Collaboration & Technical Leadership

• Collaborate with architects, business analysts, rule authors, and application development teams.
• Participate in technical design reviews and solution discussions.
• Provide effort estimates, technical guidance, and best practices for data engineering activities.
• Mentor junior engineers where required.

Required Skills

• 8+ years of experience in Data Engineering or Database Development.
• Strong expertise in Snowflake SQL, stored procedures, and query optimization.
• Experience analyzing and refactoring complex legacy SQL code.
• Strong database design and data modeling skills (logical and physical models).
• Experience with data warehousing concepts, ETL/ELT processes, and data governance.
• Strong SQL performance tuning and troubleshooting skills.
• Familiarity with cloud data platforms and modern data architectures.
• Excellent analytical, problem-solving, and communication skills.

Preferred Skills

• Experience with Drools, Camunda, or Business Rules Management Systems (BRMS).
• Python scripting for automation and data processing.
• Experience with AI-assisted development tools (e.g., Codex or similar).
• Knowledge of CI/CD, Git, and Agile delivery practices.
• Experience with data lineage, audit frameworks, and metadata management.

Project Focus

• Refactor and optimize existing Snowflake SQL stored procedures.
• Design and implement the Rules Catalog database.
• Design and implement the Audit database to support rule execution tracking and compliance.
• Enable a scalable, maintainable data foundation for the Rules Modernization Program.

About us:

Prolifics Corporation Limited is a Global Technology Solutions Provider with presence across North America (USA and Canada), Europe (UK and Germany), Middle East & Asia. In India, we have offshore development centres: 2 in Hyderabad & 1 in Pune.

For more than 40 years, Prolifics has transformed enterprises of all sizes including over 100 Fortune 1000 companies by solving their complex IT challenges. Our clients include Fortune 50 and Fortune 100 companies across a broad range of industries including Financial Services, Insurance, Government, Healthcare, Telecommunications, Manufacturing and Retail. We rank consistently in Dream Companies to Work for and Dream Employer of the Year ranking from World HRD Congress, ranked 7 in 2019.

We encourage you to visit us on www.prolifics.com or follow us on Twitter, LinkedIn, Facebook, YouTube and other social media to know more about us.