Custom Software Engineering Lead

Project Role :Custom Software Engineering Lead


Project Role Description :Own the technical direction and architecture of custom software solutions, leading teams through design and delivery. Set development standards and ensure code quality, scalability, and performance aligned to business objectives.
Must have skills :Informatica PowerCenter

Good to have skills :Oracle Procedural Language Extensions to SQL (PLSQL)
Minimum 5 year(s) of experience is required

Educational Qualification :15 years full time education

Job Summary :
Looking for an experienced Informatica PowerCenter Oracle PL-SQL Developer with strong expertise in ETL development, data warehousing, and database programming. The candidate should have hands-on experience in designing, developing, and supporting enterprise data integration solutions. Ability to work independently and mentor junior team members.


Key Responsibilities :
Design, develop, and maintain Informatica PowerCenter mappings, workflows, sessions, and transformations.
Develop and optimize Oracle PL-SQL procedures, packages, functions, and complex SQL queries.
Perform source-to-target mapping, data validation, and performance tuning.
Analyze business requirements and translate them into ETL solutions.
Troubleshoot ETL data issues and provide production support.
Knowledge of Unix Shell scripts for automation and monitoring.
Participate in code reviews, testing, deployments, and documentation.

Required Skills

Must have
Informatica PowerCenter (5+ years)
Oracle PL-SQL
SQL Performance Tuning
Unix Shell Scripting
ETL Data Warehousing
Autosys-Control-M
Git-Version Control

Good to Have
Informatica IICS
Banking or Financial Services domain experience


Qualifications
The candidate should have minimum 5 years of experience in Informatica PowerCenter.
This position is based at our Mumbai office.
A 15 years full time education is required.

Notice Period Preference:Immediate 45 Days.
Qualification15 years full time education