Informatica Developer

Key Responsibilities:

• ETL Pipeline Development: Design, build, and optimize ETL pipelines to load data from multiple source systems into the enterprise data warehouse.
• Stored Procedure Management: Create, optimize, and maintain PL/SQL stored procedures to support business needs and improve query performance.
• Informatica Development: Develop, troubleshoot, and optimize Informatica ETL workflows, including large-volume file processing and integrations.
• Ad-Hoc Data Requests: Support the Risk Department (Credit and Market Risk) by designing ETL solutions and delivering datasets as required.
• Collaboration: Work closely with Credit and Market Risk teams to gather requirements, implement changes, and streamline workflows.
• Scripting & Automation: Use Python for automation and file handling; develop and maintain Linux/Unix shell scripts for operational tasks.
• Server Administration: Perform routine server patching and maintenance for both Linux and Windows servers to ensure stability and security.
• Operational Support: Provide 24/7 production support for ETL pipelines, monitoring performance, and resolving issues promptly.
• Documentation: Create and maintain comprehensive documentation for ETL processes, workflows, and system configurations.

Required Skills & Qualifications:

• Strong hands-on experience with Informatica PowerCenter (or similar ETL tools).
• Proficiency in PL/SQL development and performance tuning.
• Solid understanding of data warehouse concepts and data modeling.
• Experience managing large data volumes with performance optimization.
• Proficiency in Python for scripting and data handling.
• Strong knowledge of Linux/Unix environments, including shell scripting and administration.
• Familiarity with Windows and Linux server patching/maintenance.
• Ability to provide 24/7 production support in a mission-critical environment.
• Excellent problem-solving, troubleshooting, and communication skills.
• Experience working with Risk Management (Credit/Market Risk) teams is a plus.

Job Type: Full-time

Application Question(s):

• How many years of hands-on experience do you have with Informatica Developement (PowerCenter)
• Can you describe a complex ETL pipeline you designed or optimized, and what challenges you solved?
• Have you worked with large-volume data processing in Informatica? Please provide an example.
• How many years of experience do you have writing and optimizing PL/SQL stored procedures?
• Can you explain a performance tuning technique you applied in SQL/PLSQL to improve query speed?
• Do you have practical experience with Python for automation or data handling? Can you share an example?
• What is your current monthly salary?
• What is your expected monthly salary?
• What is your notice period in days?