Informatica IDMC ETL Engineer

Senior Associate – Informatica IDMC ETL Engineer

State Street Investment Management

Job Description

About the job

State Street's Data, Analytics & AI Services (DAAIS) team is seeking a Senior Associate, Informatica ETL Engineer for our Bangalore, India office. This role is responsible for developing, enhancing, and supporting enterprise Informatica Intelligent Data Management Cloud (IDMC) ETL capabilities that enable trusted, high-quality data across business and technology functions.

The successful candidate will have hands-on experience with Informatica Intelligent Data Management Cloud (IDMC), including data integration, data quality, reference data management, and operational support. In collaboration with data engineers, architects, governance teams, and business stakeholders, this individual will help design, develop, test, modernize, and support scalable master data solutions across the enterprise data ecosystem.

Why This Role Is Important

Data platforms are central to State Street Investment Management’s ability to serve clients, meet regulatory obligations, and run daily investment operations. The Senior Associate role in this space ensures these platforms remain stable, trusted, and continuously improving, while protecting the firm from unnecessary operational and regulatory risk.

Key Responsibilities

• Design, build, and maintain data integrations using Informatica IDMC ETL.
• Troubleshoot complex production issues, conduct root cause analysis, and implement lasting remediation solutions.
• Support application enhancements, platform upgrades, releases, and business-as-usual (BAU) operations.
• Partner with business users, data governance teams, and application owners to define data requirements and deliver scalable solutions.
• Create and maintain technical documentation, operational runbooks, and support procedures.
• Contribute to code reviews, testing, deployments, and production support.
• Monitor platform performance and identify opportunities to improve automation, optimization, and operational efficiency.
• Learn and contribute to cloud migration and data modernization initiatives aligned with the organization's future-state data strategy.

Required Qualifications

• 4–7 years of hands-on experience in data management, data integration, master data management, or a related technical role.
• Bachelor’s degree in Computer Science, Information Systems, or a related discipline.
• Hands-on experience with Informatica Intelligent Data Management Cloud (IDMC) is required.
• Hands-on Experience supporting Informatica-based ETL/ELT and data integration platforms is required.
• Experience in the following areas:
  • Match and merge configuration
  • Data Quality Management
  • Management of data hierarchies
  • Data Stewardship
  • Reference data Management
  • Batch processing and data integration workflows
• Strong SQL and database expertise, with experience in Oracle, SQL Server, PostgreSQL, or comparable platforms.
• Proven ability to troubleshoot and support enterprise production environments.
• Solid understanding of the software development lifecycle and Agile delivery practices.
• Strong analytical, problem-solving, and communication abilities.

Preferred Qualifications

• Knowledge of data governance, metadata management, and data lineage concepts.
• Experience working in large-scale enterprise or financial services environments.
• Exposure to AWS, Azure, Oracle Cloud, or other cloud platforms.
• Experience with automation, CI/CD, and DevOps practices.
• Familiarity with Python and modern data lake and enterprise data platform architectures.

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement