SQL/PLSQL Developer – 5+yrs Exp – Gurgaon – Only immediate joiners – CTC as per market standards

Position Title: SQL/PLSQL Developer
Experience Level: 5+ Years
Location: Gurgaon
Employment Type: [Full-Time]

Job Summary
We are seeking an experienced SQL/PLSQL Developer to join our team. The ideal
candidate will have a strong background in designing, developing, and optimizing database
solutions. They will work closely with business analysts, data architects, and application
developers to ensure seamless integration of database solutions into our applications and
processes. The candidate should have experience in Data warehousing projects and worked
on at least one ETL tool like Informatica, ODI, Datastage etc, also have good understanding
of Data warehousing concept and data modelling skills.

Key Responsibilities

1. Database Development:
   o Write and maintain complex SQL queries, stored procedures, functions,
   triggers, and packages.
   o Design and optimize PLSQL-based solutions for high-performance
   transactional and analytical applications.
   o Implement advanced database features like partitions, materialized views,
   and indexing strategies.
2. Performance Tuning:
   o Analyze and optimize SQL queries and PLSQL code for performance
   improvement.
   o Debug and resolve performance bottlenecks in database operations.
3. Data Integration & ETL:
   o Develop and maintain ETL processes to integrate data from various sources.
   o Handle data cleansing, transformation, and enrichment as per requirements.
   o Good understanding of data warehouse concepts.
   o Worked on data modelling Facts and Dimensions.
4. Collaboration & Documentation:
   o Work with cross-functional teams to understand business requirements and
   translate them into technical specifications.
   o Create and maintain documentation for database designs, data models, and
   codebases.

Required Skills & Qualifications

1. Technical Skills:
   o Proficiency in SQL and PLSQL development (Oracle preferred).
   o Strong understanding of relational database concepts, normalization, and
   indexing.
   o Experience with query optimization and troubleshooting performance issues.
   o Familiarity with database tools like TOAD, SQL Developer, or similar.
   o Exposure to Agile methodologies and tools like JIRA.
   o Knowledge of ETL tools (Tableau, OBIEE) and Data Integration tools
   (Informatica, ODI).
   o Understanding of cloud database services (e.g., AWS RDS, Azure SQL) is
   added advantage.
   o
2. Analytical Skills:
   o Ability to analyze complex requirements and design efficient database
   solutions.
   o Strong problem-solving skills to resolve technical challenges effectively.
3. Communication Skills:
   o Excellent written and verbal communication to collaborate with stakeholders
   effectively.
   o Ability to create clear and concise technical documentation.
4. Experience:
   o Hands-on experience with Oracle databases (version 11g or higher).
   o Experience in database migration, data warehousing, or working with large datasets is a plus.