KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
๐Ÿ”ฅ Today
N #2701
Applications open Full-Time Job

Senior Developer - MDM/SQL

LPL Financials

  • Hyderabad, India
  • Competitive Package (Best in Industry)
  • 8-12 Yrs
  • Posted Today
Apply on official portal Prep kit
Build resume Find recruiter WhatsApp
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.
Connect LinkedIn

About the role

Essential Functions: Design, develop and maintain data management systems for Team according to best practices and architectural guidance. Enhance/Maintain/support existing applications. Collaborate with other developers in designing.

Collaborate with business partners, Architects, Quality Assurance, Release Management, and the Change Control board to plan, design, develop and implement solutions based on the needs. Suggest new processes and document reoccurring processes that will help streamline software development. Participate in all phases of the software engineering life cycle.

Ensure the necessary platform technical documentation is maintained in an appropriate manner. Provide technical troubleshooting and advanced debug support. Requirements Bachelor's or Advanced Degree in Computer Science, Information Technology, or a related field. 7+ years of experience in data management/master data solutions, including experience with mastering tools (IHS Markit/Cadis preferred). 7+ years of hands-on experience in database design and development using MS SQL Server and Oracle.

Experience with data extraction, transformation, and summarization across multiple data sources, along with end-to-end Software Development Lifecycle (SDLC) involvement. Familiarity with TFS source control, build processes, and continuous delivery (CI/CD); experience in Financial Services is preferred. Core Competencies Knowledge of data modeling, database design, and design patterns, with the ability to apply them in solution development.

Experience in analyzing, troubleshooting, and resolving technical issues across data and application environments. Ability to communicate technical concepts and collaborate with cross-functional teams to deliver project objectives. Experience working in team-based environments, managing assigned deliverables, and meeting project timelines.

Ability to facilitate solution delivery and support organizational change initiatives through stakeholder engagement and process adoption.

Eligibility & process

Who can apply

Experience: 8-12 Yrs. Open to matching qualifications.

Skills & stack

Informatica Data Modeling Data Management SQL Oracle DB SQL Server CI/CD Data Structures & Algorithms

Selection process

  1. Online Assessment / Technical Interview Rounds / HR Review

Prep kit

20 resources
Study material 4
๐Ÿ“– Aptitude Practice Questions & Mock Tests Curated logical, quantitative, and verbal reasoning problems for the initial online screening round. ๐ŸŽฏ Company-Specific Interview Preparation Corner Detailed interview experiences, exam formats, and previous test questions for LPL Financials and tech roles. ๐Ÿ“ Technical Placement Question Bank High-yield coding cheat sheets, core CS fundamentals (OOP, DBMS, OS, Networks), and rapid revision guides. ๐Ÿ’ป Algorithm, DSA & Live Code Debugger Practice Hands-on problem sets to improve coding speed and step-by-step memory debugging.
Company-specific guides 4
๐Ÿ“– APTITUDE & LOGIC Aptitude Practice Questions & Online Mock Tests Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test. ๐ŸŽฏ COMPANY GUIDE LPL Financials Interview Preparation Corner Comprehensive guide covering typical interview formats, common questions, and preparation tips for LPL Financials and off-campus tech roles. ๐Ÿ“ MOCK TESTS & PAPERS Comprehensive Interview Prep Resources & Syllabus Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds. ๐Ÿ’ป CODING PRACTICE Algorithm and Data Structure Problem Set Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.
Likely coding questions 4
๐Ÿ’ป Two Sum & Two Pointers Array Optimization Easy / Medium Asked in 85% tech rounds โšก Live debugger ๐Ÿ’ป Reverse Linked List & Detect Cycle (Floyd's Algorithm) Medium Frequently asked in core rounds โšก Live debugger ๐Ÿ’ป SQL Nth Highest Salary with DENSE_RANK() & Subqueries Medium Top standard database question โšก Live debugger ๐Ÿ’ป Valid Parentheses & Stack Implementation Easy / Medium Standard online assessment problem โšก Live debugger
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Informatica, Data Modeling, Data Management, SQL, Oracle DB, SQL Server, CI/CD, Data Structures & Algorithms) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion LPL Financials Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join LPL Financials as a Senior Developer - MDM/SQL?
Highlight LPL Financials's market reputation, recent tech innovations, and how your skills in Informatica directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More fresh requirements in Software Engineering

View category feed โ†—
Reczee Today

Software Engineer Intern โ€“ FinBox

Bengaluru, India Rs 15,000/month

Procore Technologies Today

Senior Software Engineer

Bengaluru, India Competitive Package

Motive Today

Software Engineer, Workforce Management

Bengaluru, India Competitive Package

XO Health Inc. Today

Senior Full Stack Engineer

Delhi NCR, India Competitive Package

LPL Financials Competitive Package (Best in Industry)
Recruiter Resume Apply
Chat Chat with Kashii