₹11L – ₹25L a year estimatetypical for IT Jobs in India, 825 posts
Posted 18 days ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Effectively capable of handling Development and Support.
Interact with cross functional business teams to understand business needs and prioritize requirements and deliver it.
Would be required to understand business logic from PMO team and convert it into technical specification
Experience
6–8 years
Must-have skills
PostgreSQLSQL
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Job Purpose Effectively capable of handling Development and Support. Interact with cross functional business teams to understand business needs and prioritize requirements and deliver it.Duties and Responsibilities • Would be required to understand business logic from PMO team and convert it into technical specification • Should be responsible for project deliveries on time. • Would prepare technical design for enhancements/new projects and get it developed from team (External Business partner/internal). • Would be responsible to Design, build and launch new data extraction, transformation and loading processes. • Would be responsible to provide support with resolution for all critical process related to Lending & Collection Platform and Integration processes. • Would be responsible to address all issue related to Core Platforms. • Would be responsible to build up data integration module between different systems. • Would be responsible to build data expertise and own data quality. • Would be responsible to prepare processes and best practices in day to day activities and get it implemented by team. • Interface with business users and product managers to satisfy day-to-day data needs as well as to lead and build the overall delivery strategy. • Provide timely guidance to team. • Would be responsible to address all performance related issues in programs. • Define and manage SLAs for all jobs, reports and schedule task. • Work with Development team to identify issues and drive to resolution. Ability to manage workloads by setting priorities, planning, and monitoring progress, ensuring meeting deadlines and budgetsKey Decisions / Dimensions • Decision making is crucial in production issues to fix itMajor Challenges • Managing Delivery & Support at a timeRequired Qualifications and Experience a) Qualifications Any Graduate Good negotiation and communication skill. b) Work Experience Relevant work experience of 6 to 8 Years c) Skills Keywords Good Knowledge of SQL, PL/SQL, PostgreSQL or any other database development technology
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
