At Prolifics, we are currently implementing multiple solutions in Software Development, and we are looking to hire a talented Data Engineer for our development center in India. This position would be based out of Hyderabad and is a permanent position. If you are looking for a high growth company with rock-solid stability, if you thrive in the energetic atmosphere of high-profile projects, we want to talk to you today! Let’s connect and explore the possibilities of having you onboard the Prolifics team!
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
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.
3. Data Engineering & Integration
- 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.
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.
Skills Required
- 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 logical and physical data modeling skills
- Experience with data warehousing, 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
- Bachelor's or master's degree in a relevant field, including B.Tech, BE, M.Tech, MCA, or M.Sc
- Experience with Drools, Camunda, or business rules management systems
- Python scripting for automation and data processing
- Experience with AI-assisted development tools such as Codex
- Knowledge of CI/CD, Git, and Agile delivery practices
- Experience with data lineage, audit frameworks, and metadata management
What We Do
Prolifics brings your digital transformation visions to life. We deliver results faster ... and provide accelerators and solutions for any point on your digital roadmap, or the entire transformation journey. Our global team of consultants and experienced engineers advise on the best starting point to give you immediate impact, deliver cloud and other digital solutions in a DevOps environment that are scalable to meet your changing needs and stay with you after the implementation to provide managed services so your teams can focus on other priorities. That lets you get on with the business of exceeding your own customers expectations.
