ETL Developer (Oracle)

TL;DR

ETL Developer (Oracle): Designing, developing, and implementing Oracle ETL processes for data integration and migration with an accent on data profiling, cleansing, and quality checking. Focus on optimizing SQL queries, troubleshooting ETL job failures, and ensuring data accuracy and integrity for large datasets.

Location: Flexible (Bangalore, India), offering remote, onsite, or hybrid options.

Company

hirify.global is a fast-growing company focused on digital transformation, partnering with Fortune 500 brands to improve business outcomes.

What you will do

• Design, develop, and implement Oracle ETL processes for data integration and migration.
• Collaborate with cross-functional teams to gather and understand data requirements.
• Perform data profiling, cleansing, and quality checking to ensure data accuracy and integrity.
• Develop and optimize SQL queries and scripts for data manipulation and reporting.
• Troubleshoot and resolve ETL job failures and data issues in a timely manner.
• Create and maintain documentation for ETL processes, data mappings, and data dictionaries.

Requirements

• 5 to 9 years of experience.
• Bachelor's degree in Computer Science, Information Technology, or relevant field.
• Proven experience working with Oracle databases and ETL tools like Informatica, ODI, or SSIS.
• Strong understanding of data warehousing concepts and methodologies.
• Proficiency in writing complex SQL queries and PL/SQL scripts.
• Experience in performance tuning of ETL processes for large datasets.

Nice to have

• Relevant certifications like Oracle SQL Expert or Oracle Data Integrator.

Culture & Benefits

• Enjoy an award-winning culture fostering creativity, collaboration, and belonging.
• Access professional growth opportunities, on-the-job mentoring, and learning assistance.
• Receive competitive benefits supporting personal and family needs.
• Engage with world-class, Fortune 500 clients.
• Benefit from flexible working options: work from home, office, or hybrid.
• Participate in corporate social responsibility programs.