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
- Good 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
