companyCareer Guidant logo

Oracle RDBMS Developer

On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Unlock Your Potential

Generate Job-Optimized Resume

One Click And Our AI Optimizes Your Resume to Match The Job Description.

Is Your Resume Optimized For This Role?

Find Out If You're Highlighting The Right Skills And Fix What's Missing

Experience Level

Mid to Senior

Qualifications

Basic Qualifications• A Bachelor’s degree or its foreign equivalent from an accredited institution is required. Alternatively, three years of progressive experience in the specialty may be considered in lieu of each year of education.• At least 2 years of experience in Information Technology is required.

About the job

Preferred Qualifications

• A minimum of 2 years of hands-on experience in back-end RDBMS, particularly with Oracle and DB2, focusing on data modeling and database design.
• Over 2 years of experience in the design, development, and implementation of ETL projects using IBM Datastage (version 8.5 or later).
• Proficient in the software development life cycle with at least 2 years of experience.
• A strong background in data warehousing (DW) and business intelligence (BI) technologies and tools is essential.
• Experience through all phases of project life cycle activities related to DW/BI development and maintenance, with a minimum of 2 years.
• At least 2 years spent in design and architecture reviews.
• Familiarity with IBM Datastage architecture, including stages and transformations, ETL flow design, and advanced SQL queries.
• Proven skills in data loading techniques using Datastage.
• Development of Datastage Parallel Extender jobs utilizing various stages such as Aggregator, Join, Merge, Lookup, External Filter, and more.
• Proficient with Datastage Director for job execution and monitoring.
• Experience in creating Datastage sequences for batch job execution.
• Knowledge of best practices in Datastage, performance enhancements, and implementing Change Data Capture (CDC) and User Defined Functions (UDFs).
• Understanding of Unix/Linux systems, file systems, and shell scripting.
• Strong familiarity with scheduling tools such as Autosys, Control-M, and Tivoli.
• Solid knowledge of mainframe file structures alongside RDBMS.
• Expertise in determining strategic technical direction and system architecture for various initiatives.
• A hands-on development approach, with a readiness to troubleshoot and resolve complex issues.
• Extensive experience in Oracle SQL and PL/SQL.
• Proficient with database development tools including Oracle and Toad.
• Good understanding of partitioning, indexing techniques, bitmap indexes, triggers, and materialized views.
• Experience in query tuning and analyzing execution plans.
• Background in the financial domain is a plus.
• Ability to work effectively in a team-oriented environment with strong client interfacing skills.
• Excellent analytical skills and a desire to operate in a global delivery context.

This position may require extended periods of sitting and working at a computer. Strong communication skills are essential, whether by phone, email, or face-to-face interactions. Travel may be necessary based on job requirements.

About Career Guidant

Career Guidant is a globally recognized, trusted multi-faceted organization specializing in Information Technology Custom Learning Services, Lateral Staffing Solutions, IT Development & Consulting, Infrastructure Management, and Technical Content Development. Our seasoned professionals deliver exceptional quality and results through proven methodologies, prioritizing client satisfaction. With a vast network of delivery centers, support offices, and partners across India, Asia Pacific, the Middle East, the Far East, Europe, and the USA, Career Guidant is dedicated to providing top-notch services that ensure our clients' operations run smoothly.

Similar jobs

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.