Informatica developer Jobs in USA

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 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.