Technical Specialist

Experience: Not Available to Not Available years

Location: Bengaluru, India

Skills: Oracle PL/SQL, Informatica, Control-M, Unix, Unix/Linux, Shell scripting, Oracle SQL, Informatica PowerCenter, Informatica IICS

Job Summary
More than 10 years experience in designing, developing, and supporting enterprise data integration and ETL workflows using Oracle PL/SQL, Informatica, and Control-M, with strong Unix expertise. The role involves working closely with business, application, and data teams to ensure high-quality, performant, and reliable data pipelines.

Key Responsibilities
• Design, develop, and maintain ETL workflows using Informatica PowerCenter / IICS
• Develop and optimize Oracle PL/SQL procedures, packages, triggers, and complex queries
• Perform data extraction, transformation, and migration activities across systems
• Schedule, monitor, and manage batch jobs using Control-M or equivalent tools
• Develop and maintain Unix shell scripts for automation and batch processing
• Ensure data integrity, performance tuning, and optimization of ETL and database processes
• Troubleshoot and resolve production issues, incidents, and data discrepancies
• Collaborate with business analysts, architects, and QA teams for requirement analysis and delivery
• Participate in code reviews,



deployments, and continuous improvement initiatives

Mandatory Skills
Robust hands-on experience in:
• Oracle SQL & PL/SQL (advanced level)
• Informatica (PowerCenter / IICS)
• Control-M job scheduling
• Unix/Linux & Shell scripting

Good-to-Have Skills
Exposure to:
• Banking / Financial services domain
• Data warehousing concepts and architecture
• Agile / DevOps delivery models

Key Responsibilities
1. To architect| design and develop (through Team) solution for product/project & sustenance delivery
2. To support as an SME
3. To ensure knowledge up-gradation and work with new technologies so that the solution is current and meets quality standards and the client requirements
4. To train and develop team so as to ensure that there is an adequate supply of trained manpower in the said technology and deliver risks are mitigated
5. To gather specifications and deliver solutions to the client organization based on understanding of a domain or technology
6. To review project deliverables.
7. To recommend client value creation initiatives and implement industry best practices (on specific technology/product)
Skill Requirements
null
Other Requirements
null

📌 Technical Specialist (Bengaluru)
🏢 HCL Technologies
📍 Bengaluru