Senior ETL Developer: Informatica PowerCenter Specialist

act digital; Porto; On-site; EUR 60,000 - 90,000; Full time

Job summary

act digital is seeking a Senior ETL Developer with strong Informatica PowerCenter expertise to design, develop and optimize complex data integration solutions. You will lead the full ETL lifecycle, from technical design to production support, acting as a technical reference within the team.

You will design architectures for ETL processes, develop robust solutions, optimize SQL queries, and work with diverse data sources including APIs, XML/JSON and cloud environments.

Qualifications

• 7+ years of professional experience as an ETL Developer with strong hands-on experience in Informatica PowerCenter.
• Advanced knowledge of Informatica PowerCenter components: Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Strong experience designing complex mappings and workflows, performance tuning and partition management.
• Advanced SQL skills with databases such as Oracle, SQL Server, Teradata or PostgreSQL.
• Shell scripting skills in Bash, Unix or Linux environments.
• Solid understanding of Data Warehousing concepts including star/snowflake schemas and SCDs (Kimball/Inmon).
• Experience troubleshooting complex ETL and production issues and providing Level 3 support.

Responsibilities

• Analyze requirements and translate them into scalable data integration solutions.
• Design ETL architectures including mappings, mapplets and workflows.
• Develop, test and deploy ETL solutions using Informatica PowerCenter.
• Create technical specs and maintain documentation.
• Develop and optimize SQL queries, stored procedures and shell scripts.
• Integrate data from heterogeneous sources (relational DBs, flat files, APIs, XML/JSON, cloud).
• Perform ETL performance tuning and partition management.
• Provide production support and resolve complex issues; ensure data integrity and security.
• Implement workload automation using Control-M, AutoSys or Dollar Universe.
• Act as technical reference and participate in code reviews to uphold quality.

Skills

ETL Development

Informatica PowerCenter

SQL

Shell scripting

Data Warehousing

Performance tuning

Troubleshooting

Tools

Control-M

AutoSys

Dollar Universe

Job description

act digital is seeking a Senior ETL Developer with strong Informatica PowerCenter expertise to design, develop and optimize complex data integration solutions. You will lead the full ETL lifecycle, from technical design to production support, acting as a technical reference within the team.

You will design architectures for ETL processes, develop robust solutions, optimize SQL queries, and work with diverse data sources including APIs, XML/JSON and cloud environments.