Senior ETL Developer, Data Management

Jobtailor; Pune District; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Jobtailor in Pune, India is seeking an experienced ETL Developer to design and implement ETL processes using Informatica, write advanced SQL queries, and ensure data quality across multiple data sources.

You will collaborate with stakeholders, participate in production support rotations, and follow SDLC/Agile methodologies to deliver reliable data solutions.

Qualifications

• BE/BTech/MSc/MCA with specialization in Computer Science/Information Systems.
• ~ 4 yrs of experience in Informatica Data Integration Tool.
• ~ 4 yrs of experience in writing SQL queries, Oracle database.
• ~ 4 yrs of experience in Shell scripting.
• Exposure to scheduling tools such as Control-M/Autosys.
• Exposure to Data Quality Processes or Informatica Data Quality (IDQ).
• Strong communication skills and ability to work in teams.

Responsibilities

• Getting the requirement from stakeholders and seeking clarification to the lowest detail.
• Plan and execute ETL scripts using Informatica.
• Highlight risks or concerns to the supervisor as needed.
• Perform unit testing of ETL processes to ensure quality.
• Support project delivery teams in adopting data management processes.
• Identify and resolve data quality issues (uniqueness, integrity, accuracy, consistency, completeness).
• Perform production support rotations for escalations.

Skills

Informatica Data Integration

SQL queries

Shell scripting

Communication skills

Education

BE/BTech/MSc/MCA – CS/IS

Tools

Informatica

Oracle Database

Control-M

Autosys

Job description

Responsibilities

• Getting the requirement from the stakeholders and seeking clarification up to the lowest detail.
• Planning & execution / develop ETL scripts using Informatica.
• Highlight / escalating risks / concerns with respect 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 managing 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.

Requirements

• BE/B Tech/MSc/MCA – with Specialization in Computer Science/Information Systems.
• ~ 4 yrs. of experience in Informatica Data Integration Tool
• ~ 4 yrs. of experience in writing SQL Queries, Oracle database.
• ~ 4 yrs. of experience in Shell scripting.
• Exposure to one of the scheduling tool (Control-M/Autosys Etc)
• Exposure to Data Quality Processes or Informatica tool component such as IDQ Informatica Data Quality (Developer & Analyst tool)
• Strong Communication skills with excellent track of working in and with teams.
• Self-starter and Experience in prioritizing and managing a complex and changing workload.
• Interpersonal and relationship management experience with strong organizational skills.
• Capacity to gain a thorough knowledge of the relevant Business area.
• Ability to work as part of a team.
• Follows both SDLC life cycle/Agile Development life cycle as per the requirements.

Core Competencies

Demonstrates expertise in ETL development using Informatica, SQL query writing, and data quality management. Proficient in managing data integrity and supporting project delivery teams while adhering to SDLC and Agile methodologies.

Tools & Technologies

• Informatica
• Oracle Database
• Control-M
• Autosys