Informatica Developer

Talan Group; New York (NY); Hybrid; USD 90,000 - 135,000; Full time

Benefits offered by this job

Competitive salary between USD $90,000- US$135,000

401(k) retirement plan with company matching

15 days of paid vacation per year

8 paid holidays, 5 sick days, and 2 personal days

Company health, dental, and vision insurance

Job summary

A global consulting firm is seeking a talented Senior ETL Developer (Informatica) to enhance data integration initiatives in a leading financial services environment. This hybrid role in New York City requires extensive experience in Informatica PowerCenter and strong SQL skills. Responsibilities include designing ETL workflows, optimizing data pipelines, and ensuring data quality. The firm offers a competitive salary ranging from USD 90,000 to 135,000, along with comprehensive benefits, including a 401(k) retirement plan and health insurance.

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.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter and IICS.
• Translate business requirements into scalable technical solutions.
• Build and optimize data pipelines to ingest, transform, and load large datasets.

Skills

Informatica PowerCenter

SQL

Data warehousing

Data governance

Problem-solving

Tools

Git/SVN

Jira

Confluence

Job 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

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

• 💵 Competitive salary betweenUSD $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

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