Role:
ETL Developer (Informatica PowerCenter)
Position Type:
Full-Time Contract (40hrs/week)
Contract Duration:
6 Months+ (Possibility of Extention)
Work Schedule:
8 hours/day (Mon-Fri)
Work Hours:
Central Time Zone (CST)
Location:
100% Remote - (Candidates can work from anywhere in LATAM Countries)
Job Summary
We are seeking a skilled ETL Developer with hands-on experience in Informatica PowerCenter to join our data engineering team. The ideal candidate will be responsible for designing, developing, and maintaining robust ETL workflows that support our data warehousing and analytics initiatives.
Key Responsibilities
Design, develop, and optimize ETL processes using
Informatica PowerCenter
.
Write and tune complex
SQL queries
to extract, transform, and load data from various sources into
Oracle databases
.
Implement and manage
Slowly Changing Dimensions (SCD)
, ensuring historical data integrity.
Develop and maintain
Fact and Dimension tables
in support of data warehouse architecture.
Collaborate with data architects, analysts, and business stakeholders to understand data requirements and translate them into technical solutions.
Monitor ETL jobs and troubleshoot performance or data quality issues.
Document ETL processes and maintain technical specifications.
Required Qualifications:
Proven experience with
Informatica PowerCenter
in a production environment.
Strong proficiency in
SQL
and experience working with
Oracle databases
.
Solid understanding of
data warehousing concepts
, including
Fact and Dimension tables
and
SCD Types 1, 2, and 3
.
Ability to analyze complex data sets and provide actionable insights.
Excellent problem-solving and communication skills.
Preferred Qualifications
Experience with performance tuning in Oracle.
Familiarity with data governance and data quality best practices.
Exposure to cloud-based data platforms is a plus.
📌 ETL Developer (Informatica PowerCenter)
🏢 SkySys
📍 Ciudad de México