Offer summary

Qualifications:

Bachelor's degree in Computer Science, Information Technology, or related field., Minimum of 3 years of experience as an ETL Developer with strong experience in Informatica PowerCenter., Proficient in writing complex SQL queries and familiar with data warehousing concepts., Excellent problem-solving, analytical, and communication skills..

Key responsabilities:

Design and develop ETL workflows using Informatica PowerCenter and write complex SQL queries.

Collaborate with data architects and cross-functional teams to gather and define data requirements.

Monitor ETL jobs, troubleshoot issues, and optimize existing processes for performance efficiency.

Implement data quality checks, maintain documentation, and participate in system design discussions.

Job description

Informatica ETL Developer

Experience: 7-8 years

Overview

The Informatica ETL Developer plays a critical role in the data management strategy of the organization. This professional is responsible for designing, developing, and implementing ETL processes that extract, transform, and load data from various sources into data warehouses or data lakes. By leveraging their expertise in Informatica PowerCenter and SQL, they ensure that data pipelines are efficient, reliable, and scalable. This position is essential for maintaining the integrity of data systems, enabling accurate reporting and analysis, and ultimately influencing strategic decision-making within the organization. The ideal candidate will collaborate closely with data analysts, data architects, and other stakeholders to understand data requirements, troubleshoot issues, and implement solutions that enhance data accessibility and usability. Strong analytical skills, a solid understanding of data architectures, and the ability to work with large datasets are paramount for this role.

Key Responsibilities

Design and develop ETL workflows using Informatica PowerCenter.
Collaborate with data architects to understand data integration needs.
Write complex SQL queries for data extraction and manipulation.
Perform unit testing and validation of ETL processes.
Monitor ETL jobs and troubleshoot any issues that arise.
Optimize existing ETL processes for performance efficiency.
Maintain documentation for ETL processes and workflows.
Implement data quality checks and validations.
Ensure compliance with data governance protocols.
Work with cross-functional teams to gather and define data requirements.
Participate in system design discussions to improve data architecture.
Conduct code reviews and provide constructive feedback to peers.
Implement best practices in ETL development and performance tuning.
Investigate and resolve data inconsistencies or discrepancies.
Stay updated with the latest ETL technologies and industry trends.

Required Qualifications

Bachelor's degree in Computer Science, Information Technology, or related field.
Minimum of 3 years of experience as an ETL Developer.
Experience with the tool, building CDC pipeline.
Experience with power exchange is a plus.
Experience with IBM iSeries AS400 database.
Strong experience with Informatica PowerCenter (versions 9.x and above).
Proficient in writing SQL queries and using relational databases.
Familiarity with data warehousing concepts and methodologies.
Experience in performance tuning and optimization techniques.
Knowledge of data quality standards and best practices.
Ability to work in a fast-paced environment and meet deadlines.
Excellent problem-solving and analytical skills.
Strong communication and collaboration skills.
Familiarity with Agile methodologies is a plus.
Experience with Unix/Linux scripting is preferred.
Understanding of cloud data integration tools is a plus.
Certification in Informatica or related ETL tools is an advantage.
Prior experience in a business intelligence environment is a plus.
Detail-oriented with a strong commitment to data accuracy.