Informatica ETL Developer: Agile Dev Team Member IV

The ideal candidate will be responsible for designing, developing, and deploying scalable ETL processes using Informatica PowerCenter to support our data warehousing and analytics initiatives. You will collaborate with business and technical stakeholders to ensure high data quality, availability, and performance.

Key Responsibilities:

Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).

Extract, transform, and load data from various source systems (e.g., SQL Server, Oracle, flat files, cloud APIs) into data warehouses or operational data stores.

Optimize ETL performance, conduct tuning, and ensure error handling and logging.

Collaborate with data architects and analysts to understand data requirements and deliver high-quality data solutions.

Work with QA teams to support data validation and testing efforts.

Support data integration, migration, and transformation initiatives.

Document ETL processes, data flows, and job schedules.

Monitor daily ETL jobs and resolve production issues in a timely manner.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).

3+ years of experience with Informatica PowerCenter or Informatica IICS.

Strong SQL skills and experience with relational databases (e.g., Oracle, SQL Server, PostgreSQL).

Solid understanding of data warehousing concepts and dimensional modeling.

Experience in performance tuning and troubleshooting ETL processes.

Hands-on experience with job scheduling tools (e.g., Autosys, Control-M, Tidal).

Familiarity with version control systems and DevOps practices.

Preferred Qualifications:

Experience with cloud data platforms (e.g., Snowflake, AWS Redshift, Azure Synapse).

Exposure to data governance and data quality tools.

Knowledge of scripting languages (e.g., Shell, Python).

Experience working in Agile/Scrum environments.

Familiarity with BI tools (e.g., Tableau, Power BI) is a plus.

Benefits

This position comes with competitive compensation and benefits package:

1. Competitive salary and performance-based bonuses
2. Comprehensive benefits package
3. Home Office model
4. Career development and training opportunities
5. Flexible work arrangements (remote and/or office-based)
6. Dynamic and inclusive work culture within a globally known group
7. Private Health Insurance
8. Pension Plan
9. Paid Time Off
10. Training & Development
11. *Note: Benefits differ based on employee level