Job Description

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?