Senior Consultant - Data Stage

Oracle; Chennai District; On-site; INR 12,00,000 - 18,00,000; Full time

Job summary

A global technology leader is seeking a DataStage Techno Functional Lead in Chennai. The role requires strong experience in DataStage, SQL, and PL/SQL, focusing on developing and optimizing ETL processes. The ideal candidate will have 6 to 10 years of relevant experience, with additional benefits offered.

Benefits

Flexible medical options

Life insurance

Retirement options

Qualifications

• 6 to 10 years of experience in DataStage development-based projects.
• Prior experience in FCCM or any other AML projects is advantageous.

Responsibilities

• Design, develop, and deploy ETL processes using DataStage.
• Monitor and troubleshoot DataStage jobs to ensure seamless data flow.
• Collaborate with data architects and business analysts for integration requirements.

Skills

DataStage development

SQL

PL/SQL

ETL processes

Problem-solving

Communication

Agile methodologies

Education

Bachelor’s degree in computer science, Information Technology, or a related field

Job description

2 weeks ago Be among the first 25 applicants

Job Description

Job Description: DataStage Techno Functional Lead

Role Overview: We are seeking a highly skilled DataStage Techno Functional Lead with strong hands-on experience in SQL, PL/SQL, and DataStage projects. The ideal candidate will design, implement, and optimize ETL processes to meet evolving business needs. Prior experience in FCCM or any other AML projects is a significant advantage.

Skills and Qualifications

Mandatory Skills:

• Strong hands-on experience with DataStage development and administration.
• Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
• Experience deploying and managing DataStage solutions.
• Deep understanding of ETL processes, data warehousing concepts, and data integration.
• Domain experience in FCCM or any other AML based projects.

Preferred Experience:

• Hands-on experience in banking domain projects, with knowledge of domain-specific data structures.
• Experience in integrating on-premise data sources.

Other Skills:

• Strong problem-solving and debugging skills.
• Excellent communication and teamwork abilities.
• Knowledge of Agile methodologies and DevOps practices.

Education and Experience:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 6 to 10 years of experience in DataStage development-based projects.

Responsibilities

• Design, develop, and deploy ETL processes using DataStage.
• Develop and manage DataStage jobs, sequences, routines, and parameters.
• Develop and optimize complex SQL and PL/SQL scripts for data extraction, transformation, and loading.
• Implement data integration solutions, connecting diverse data sources on-premise systems, APIs, and flat files.
• Monitor and troubleshoot DataStage jobs to ensure seamless data flow and resolve issues promptly.
• Collaborate with data architects and business analysts to understand integration requirements and deliver robust solutions.
• Conduct performance tuning of ETL processes, SQL queries, and PL/SQL procedures.
• Prepare and maintain detailed technical documentation for developed solutions.
• Adhere to data security and compliance standards.
• Provide guidance and best practices for DataStage projects.

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [e-mail] or by calling [phone] in the United States. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Consulting
• Industries IT Services and IT Consulting

Data Management Workbench and Veeva CDB (ISG)

Product Data Management - GO/JC/1144/2025

Senior Data/Information Management Analyst

Senior Data/Information Management Analyst

Supply Chain Analyst / Data Management Analyst

Senior Data/Information Management Analyst

Senior Data/Information Management Analyst

Data Governance Consultant (Supporting Business, Control and Support Functions)