Informatica Developer at Talan

New York, New York, United States -

Full Time

Start Date

Immediate

Expiry Date

17 Jun, 26

Salary

135000.0

Posted On

19 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Informatica PowerCenter, IICS, ETL, Data Warehousing, Data Lake, SQL, SQL Server, Sybase, Data Modeling, Data Pipelines, Data Quality, Performance Tuning, CI/CD, Git, SVN, Jira

Industry

IT Services and IT Consulting

Description

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. Contract Type: Permanent contract

Responsibilities

The role involves designing, developing, and maintaining ETL workflows using Informatica PowerCenter and IICS to support data warehouse and data lake initiatives. Responsibilities also include translating business requirements into scalable technical solutions and optimizing data pipelines for large datasets.