Company: Mandali Consultancy Services
Job Type: Full-time
Experience: 5+ Years / 9+ Years
Notice Period: Immediate to 15 Days
Location: Multiple Locations

Job Description

Mandali Consultancy Services is looking for experienced PLSQL – Informatica Developers to join leading enterprise projects. The ideal candidate should have strong expertise in Oracle PL/SQL programming and Informatica PowerCenter with hands-on experience in designing, developing, and maintaining ETL solutions.

If you are passionate about building high-performance data integration solutions and working with large-scale enterprise systems, we would like to hear from you.

Key Responsibilities

- Design, develop, and maintain PL/SQL procedures, packages, functions, triggers, and cursors.
- Develop ETL workflows and mappings using Informatica PowerCenter.
- Analyze business requirements and translate them into technical solutions.
- Design reusable mappings, mapplets, workflows, and sessions.
- Perform data extraction, transformation, and loading (ETL) activities.
- Optimize SQL queries and PL/SQL programs for better performance.
- Troubleshoot ETL failures and production issues.
- Work with Oracle databases and ensure data integrity.
- Perform unit testing and support deployment activities.
- Collaborate with business analysts, developers, and QA teams.
- Prepare technical documentation and follow coding standards.
- Ensure timely delivery of assigned tasks.

Required Skills

- Oracle PL/SQL
- Informatica PowerCenter (9.x/10.x)
- ETL Development
- SQL Performance Tuning
- Oracle Database




- Stored Procedures
- Functions
- Packages
- Triggers
- Cursors
- Mapping Design
- Workflows & Sessions
- Parameter Files
- Reusable Transformations
- Data Warehousing Concepts
- Linux/Unix Basics
- Debugging & Troubleshooting

Preferred Skills

- Knowledge of Data Warehouse Architecture
- Experience with Performance Optimization
- Shell Scripting
- Production Support Experience
- Positive Communication Skills
- Team Collaboration
- Analytical and Problem-Solving Skills

Qualification

- Bachelor's Degree in Computer Science, Information Technology, Engineering, or any related discipline.

Why Join Us?

- Opportunity to work with leading enterprise clients.
- Challenging projects using modern data integration technologies.
- Career growth and continuous learning opportunities.
- Collaborative and professional work environment.
- Competitive compensation based on experience.

How to Apply

Interested candidates are requested to email their updated resume to [email protected] with the subject line:

PLSQL – Informatica Developer | Your Name

Please include the following details in your email:

- ✅ Updated Resume
- ✅ PAN Card Number
- ✅ Total Experience
- ✅ Relevant Experience (PLSQL & Informatica)
- ✅ Current CTC
- ✅ Expected CTC (ECTC)
- ✅ Notice Period
- ✅ Current Location
- ✅ Preferred Work Location
- ✅ Alternate Email ID
- ✅ Contact Number

Email: [email protected]

Pay: ₹80,000.00 - ₹100,000.00 per month

Work Location: In person

📌 PLSQL – Informatica Developer (Bengaluru)
🏢 Mandali Consultancy Services
📍 Bengaluru