PLSQL Developmer with Informatica Expertise

Job Title

Experience Required

Job Summary

PL/SQL Developer

Key Responsibilities

• Design, develop, optimize, and maintain complex PL/SQL procedures, packages, triggers, and functions.
  
• Analyze and tune SQL queries and PL/SQL code for performance improvements.
  
• Work with large datasets in Oracle databases within a data warehousing environment.
  
• Develop and maintain ETL processes using

  Informatica PowerCenter

  .
• Handle data extraction, transformation, and loading (ETL) across multiple systems.
  
• Schedule and monitor batch jobs using

  Control-M

  automation tool.
• Troubleshoot and resolve issues in ETL workflows and scheduled jobs.
  
• Collaborate with cross-functional teams including data analysts, DBAs, and business users.
  
• Ensure data integrity, quality, and security across the pipelines and processes.
  
• Document all processes and changes in accordance with organizational standards.
  

Required Mandatory Skills

• PL/SQL Development

  Minimum 6 Years (Mandatory)
• Strong command of SQL, PL/SQL, and performance tuning.
  
• Experience with Oracle databases.
  

• Informatica

  Minimum 5 Years (Mandatory)
• ETL design and development, Data warehousing using Informatica PowerCenter.
  
• Data mapping, cleansing, and transformation.
  

• Control-M

  Minimum 5 Years (Mandatory)
• Job scheduling, automation, and monitoring.
  
• Solid understanding of Data Warehousing concepts and architecture.
  
• Ability to write optimized and reusable code.
  
• Strong analytical and debugging skills.
  

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
  
• Exposure to Agile/Scrum methodologies.
  
• Experience with version control systems like Git.
  

Job Type: Contractual with the Client for it's current project. Conversion/Extension will takes place basing on the Working performance.

Work Location

Notice Period

How to Apply

Interested candidates are encouraged to share their updated resume to the mail ID : prasanna.k@abacusservice.in