Data Engineer

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 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. 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. 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.