Informatica Developer

Company Description

Talan is an international consulting and technology expertise group supporting high regulatory industry such as Corporate and Investment Banking, Hedge Funds, and Energy clients through large-scale transformation programs driven by data, technology, and innovation.

In North America, Talan delivering high-value expertise across front-office, risk, finance, regulatory, and technology domains.

With over 20 years of experience, a presence across five continents and 21 countries, and Great Place to Work® certification, the Group is on track to reach 8,000 employees worldwide, including 600 in North America.

Job Description

Location: NYC (Hybrid – at least 3 days onsite/week)

Visa Sponsorship: Talan does not sponsor U.S. work permits or employment visas.

We are seeking a talented Senior ETL Developer (Informatica) to join our team and support data integration initiatives within a leading financial services environment. The ideal candidate will have strong expertise in Informatica PowerCenter and IICS, with a solid background in data warehousing and ETL design.

Role and responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter and IICS to support data warehouse and data lake initiatives
• Translate business requirements into scalable technical solutions, including mappings, workflows, and data models
• Build and optimize data pipelines to ingest, transform, and load large datasets from multiple sources
• Implement data quality checks, error handling, and monitoring to ensure data integrity and reliability
• Tune and optimize ETL performance (partitioning, pushdown optimization, caching)
• Collaborate with cross-functional teams and support testing (UAT, production validation) and deployment processes

#LI-ASD

Qualifications

• 7+ years of experience with Informatica PowerCenter and 2+ years with IICS or similar cloud ETL tools
• Strong SQL skills and experience with relational databases (SQL Server, Sybase, or similar)
• Solid understanding of data warehousing concepts, dimensional modeling, and data governance
• Experience with CI/CD, version control tools (Git/SVN), and ETL deployment processes
• Strong problem-solving skills with the ability to work independently in a fast-paced environment
• Excellent communication skills and ability to interact with both technical and business stakeholders

Preferred Qualification

• Experience working in Agile environments (Scrum/Kanban) with tools such as Jira and Confluence
• Informatica certifications (PowerCenter and/or IICS) are a plus
• Prior experience in similar enterprise data environments is a plus

Company’s Benefits

At Talan, we invest in our employees' well-being and empower them with benefits, including:

• 💵 Competitive salary between USD $90,000 - US$135,000
• 💸401(k) retirement plan with company matching
• 🌴15 days of paid vacation per year at hire and up to 27 according to seniority (annual untaken vacation days are cashed out)
• 📴8 paid holidays + 5 sick days + 2 personal days per year
• ❤️‍🩹Company health, dental, and vision insurance plans + FSA
• 🦺Voluntary STD and LTD
• 🚍 Commuter/transit benefits

All your information will be kept confidential according to EEO guidelines.