Etl Informatica Developer

Ocwen Financial Corporation; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Ocwen Financial Corporation is seeking an experienced ETL specialist to design and implement data integration solutions using Informatica. The role focuses on delivering high-quality ETL pipelines, writing efficient SQL for Oracle databases, and supporting data management initiatives with a strong emphasis on data quality.

The candidate should have about 6 years of experience in Informatica and SQL/Oracle, with a BE/BTech/MSc/MCA in CS or Information Systems.

Qualifications

• BE/BTech/MSc/MCA with Specialization in Computer Science/Information Systems.
• ~6 years of experience in Informatica Data Integration Tool.
• ~6 years of experience in writing SQL queries and Oracle database.

Responsibilities

• Gather requirements from stakeholders and clarify details to the lowest level.
• Plan and execute ETL scripts using Informatica.
• Highlight risks or concerns to the immediate supervisor as needed.
• Perform unit testing of ETL processes to ensure quality output.
• Support project delivery teams in data management adoption and execution.
• Identify and resolve data quality issues with cost-effective timely actions.
• Perform production support for escalations on a rotational basis.

Education

BE/BTech/MSc/MCA (CS/IS)

Tools

Informatica Data Integration Tool

SQL Queries

Oracle database

Job description

JOB FUNCTIONS AND RESPONSIBILITIES

• Getting the requirement from the stakeholders and be able to seek clarification up to lowest detail.
• Planning & execution / develop ETL scripts using Informatica.
• Highlight / escalat risks / concerns w.r.t to the tasks assigned as needed to the immediate supervisor
• Perform unit testing of the ETL processed to ensure quality of work output
• Supporting project delivery teams in their effort to adopt and execute on data management processes.
• Identifying and manage the resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency, and completeness in a cost-effective and timely fashion.
• Performing the production support role for any escalations on a rotational basis.

EDUCATION / EXPERIENCE

BE/B Tech/MSc/MCA with Specialization in Computer Science/Information Systems.

• ~ 6 yrs. of experience in Informatica Data Integration Tool
• ~ 6 yrs. of experience in writing SQL Queries, Oracle database.

WORK SCHEDULE OR TRAVEL REQUIREMENTS

Mid Shift, No Travel required