Senior Engineer

LPL Financial Global Capability Center; Hyderabad; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

LPL Financial Global Capability Center in Hyderabad seeks a Senior Engineer to reshape compensation processing through data and application capabilities. You will design end-to-end Oracle data pipelines, implement ETL/ELT workflows, and integrate AWS services with Varicent to modernize enterprise compensation processing.

The role requires strong PL/SQL and Oracle development, AWS exposure, and collaboration with architects, SMEs, and engineering teams to deliver scalable, future-ready solutions.

Qualifications

• 8+ years of experience designing and implementing complex systems.
• 5+ years of hands-on PL/SQL and Oracle development experience, ideally in transformation-heavy domains.
• Strong understanding of enterprise integration patterns and system design principles.
• DevOps experience with GitHub, CI/CD, build and deploy pipelines.
• Bachelor's degree in Computer Science or related field.

Responsibilities

• Design and implement end-to-end data pipelines to support compensation calculations, ingestion, validation, and downstream processing.
• Build and maintain ETL/ELT workflows using PL/SQL, Oracle SQL, and enterprise data integration patterns.
• Develop and optimize stored procedures, packages, and database objects for rules-driven compensation processing.
• Implement data quality, reconciliation, auditing, and monitoring layers for high data integrity in compensation processes.
• Model, transform, and tune relational data in Oracle for performance, reliability, and scalability.
• Design and implement event-driven workflows leveraging AWS services and serverless components to orchestrate compensation data flows.
• Configure and support Varicent workflows including data loading, plan execution, and output distribution.
• Contribute to application components and microservices supporting compensation workflows (.NET - optional).
• Assist with API design or UI enhancements to improve access to compensation data and processing.
• Partner with product, architecture, QA, and DevOps teams in an Agile environment.
• Apply CI/CD practices for automation and deployment of database scripts and cloud-based data components.
• Troubleshoot data, database, and workflow issues quickly and effectively.
• Analyze existing processes and propose improvements to increase transparency, scalability, and automation in compensation processing.
• Communicate clearly with business stakeholders, compensation SMEs, and technology partners.

Skills

PL/SQL

Oracle

AWS

Varicent

.NET (optional)

Education

Bachelor's degree in Computer Science or related field

Tools

TOAD

SQL Developer

Job description

Job Description:

Where Ambition Meets Innovation

At LPL’s Global Capability Center, you'll find a collaborative culture where your voice matters, integrity guides every decision, and technology fuels progress. Your skills, talents, and ideas will redefine what's possible. LPL's success reflects its exceptional employees, who together pursue one noble purpose: empowering financial advisors to deliver personalized advice for all who need it. We’re proud to be expanding and reaching new heights in Hyderabad.

Job Overview

We are seeking a highly skilled Senior Engineer to join our Compensation Transformation Program. This role is critical to designing and implementing modern data and application capabilities that transform how compensation processing, data flows, validation, and automation operate across the enterprise.

The ideal candidate brings strong experience in PL/SQL and Oracle database development, AWS cloud services, and Varicent platform integration. .NET experience can be beneficial but is not a mandatory requirement for this role.

You will work closely with architects, product teams, compensation SMEs, and engineering partners to deliver scalable, resilient, and future-ready systems that modernize the compensation platform end-to-end.

Key Responsibilities

Core - Oracle Data Engineering

• Design and implement end-to-end data pipelines to support compensation calculations, ingestion, validation, and downstream processing
• Build and maintain ETL/ELT workflows using PL/SQL, Oracle SQL, and enterprise data integration patterns
• Develop and optimize stored procedures, packages, and database objects for rules-driven compensation processing
• Implement data quality, reconciliation, auditing, and monitoring layers to ensure high data integrity for compensation processes
• Model, transform, and tune relational data in Oracle for performance, reliability, and scalability

Cloud & Platform Integration

• Design and implement event-driven workflows leveraging AWS services and serverless components to orchestrate compensation data flows
• Configure and support Varicent workflows including data loading, plan execution, and output distribution

Application & Platform Engineering (Good-to-Have)

• Contribute to application components and microservices supporting compensation workflows (.NET - optional)
• Assist with API design or UI enhancements as needed to improve access to compensation data and processing

Engineering Excellence

• Partner with product, architecture, QA, and DevOps teams in an Agile environment
• Apply CI/CD practices for automation and deployment of database scripts and cloud-based data components
• Troubleshoot data, database, and workflow issues quickly and effectively
• Analyze existing processes and propose improvements to increase transparency, scalability, and automation in compensation processing
• Communicate clearly with business stakeholders, compensation SMEs, and technology partners

Technical Skills & Platforms

Primary - PL/SQL & Oracle

• PL/SQL development: stored procedures, packages, functions, and complex SQL
• Oracle database design, modelling, indexing, and performance optimization
• ETL/ELT development and relational data transformation in Oracle environments
• Experience with SQL coding/compiling tools like TOAD, SQL Developer or other similar DB utilities.
• Experience with Oracle Forms/Reports would be asset and good to have.

Secondary - AWS Cloud & Varicent

• AWS: Glue, Lambda, EventBridge, RDS, S3, Step Functions, SQS, and SNS
• Varicent: data ingestion, workflow configuration, and compensation calculation support
• Hybrid integration patterns connecting Oracle, AWS, and Varicent

Good-to-Have - .NET

• .NET, C#, or Web API development for compensation-related application components

Required Qualifications

• 8+ years of experience designing and implementing complex systems
• 5+ years of hands-on PL/SQL and Oracle development experience, ideally in transformation-heavy or rules-driven domains
• Strong understanding of enterprise integration patterns, SOA concepts, and system design principles
• DevOps experience with GitHub, CI/CD, build and deploy pipelines
• Bachelor's degree in Computer Science or related field

Preferred Qualifications

• Experience with Snowflake or other modern cloud data warehouses
• Experience developing systems related to compensation, payroll, financial calculations, or rules-driven engines
• Experience with Jira, TeamCity, or Octopus Deploy
• Hands-on experience implementing self-service portals or customer service applications
• Experience writing unit tests (NUnit, JUnit, or equivalent)
• Knowledge of estimation tools and principles
• Exposure to cloud-based application design and implementation

Soft Skills & Competencies

• Excellent communication, stakeholder management, and cross-team collaboration
• Strong analytical, problem-solving, and debugging skills
• Ability to troubleshoot production issues under tight timelines
• Self-driven, innovative, and quick learner

What Are We Looking For?

We're looking for strong collaborators who deliver exceptional client experiences and thrive in fast-paced, team-oriented environments. Our ideal candidates pursue greatness, act with integrity, and are driven to help our clients succeed. We value those who embrace creativity, continuous improvement, and contribute to a culture where we win together and create and share joy in our work.

LPL Global Business Services, LLP - PRIVACY POLICY

Requirements: