Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter.
Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments.
Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions.
Optimize ETL processes for performance, scalability, and maintainability.
Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity.
Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents.
Participate in code reviews, unit testing, and UAT support.
Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements.
Provide production support and resolve data-related issues in a timely manner.

Requirements

Bachelor’s degree in Computer Science, Information Technology, or a related field.
5+ years of experience in ETL development using Informatica PowerCenter.
Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
Experience with SQL, PL/SQL, and performance tuning of database queries.
Knowledge of data quality, data governance, and best practices in ETL development.
Strong analytical, problem-solving, and communication skills.
Experience with version control systems and ETL deployment processes.

Benefits

Health & Welfare Benefits: Comprehensive plans tailored to your needs, effective from day one.
Retirement Savings: Robust programs to help you secure your financial future.
Employee Discounts: Access to a wide range of discounts on merchandise, services, travel, and more.
Career Growth Opportunities: Paths for advancement within a global organization.
Paid Training: Learn while you earn with award-winning learning platforms.
Paid Time Off: Competitive PTO packages to help you recharge.
Great Work Environment: Join an award-winning culture that values diversity and inclusion.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL developmentInformatica PowerCenterSQLPL/SQLdata warehousingdimensional modelingstar schemasnowflake schemaperformance tuningdata validation

Soft Skills

analytical skillsproblem-solvingcommunication skills

Certifications

Bachelor’s degree in Computer ScienceBachelor’s degree in Information Technology