ETL & Database Developer (Informatica / Greenplum / Cloud)

At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you're passionate about developing your career, while helping others along the way, come join the Broadridge team.

Job Title: ETL & Database Developer (Informatica / Greenplum / Cloud)

Job Description

We are looking for a seasoned Database & ETL Developer with strong SQL, Informatica, and MPP database experience (preferably Greenplum), along with exposure to cloud-based data platforms. The ideal candidate has experience working with large-scale datasets, designing scalable data pipelines, and supporting production systems in a financial services environment.

Key Responsibilities

Develop and maintain ETL pipelines and data workflows using Informatica.

Build, optimize, and tune SQL queries, stored procedures, and data models in Greenplum/PostgreSQL.

Work with cloud-based data platforms such as Amazon Redshift and Snowflake.

Ensure data quality, performance tuning, and compliance with data governance standards.

Troubleshoot ETL failures, analyze root causes, and provide timely fixes.

Perform application support activities including batch/job monitoring, incident triage, and resolution of job failures.

Collaborate with operations teams to ensure smooth execution of daily, weekly, and monthly data loads.

Identify recurring production issues and implement long-term preventive solutions.

Partner with cross-functional teams to support production releases and data pipeline enhancements.

Required Skills

8-10+ years of experience in Informatica ETL development, database engineering, or data integration roles.

Strong experience with Greenplum or other MPP (Massively Parallel Processing) systems.

Exposure to cloud data warehousing platforms (Redshift, Snowflake, etc.).

Experience in financial services or large-scale, data-intensive environments.

Linux shell scripting and familiarity with Git, CI/CD processes.

Experience with production support, job scheduling tools (Autosys/Control-M/Airflow), and incident management workflows.

Good to Have

Experience with Airflow orchestration, Kafka streaming, or enterprise data quality frameworks.

Knowledge of financial datasets such as Transactions, Positions, and Corporate Actions.

Exposure to monitoring tools (Splunk, Dynatrace, AppDynamics).

Familiarity with Agile methodologies and DevOps practices.

We are dedicated to fostering a collaborative, engaging, and inclusive environment and are committed to providing a workplace that empowers associates to be authentic and bring their best to work. We believe that associates do their best when they feel safe, understood, and valued, and we work diligently and collaboratively to ensure Broadridge is a company-and ultimately a community-that recognizes and celebrates everyone's unique perspective.

Use of AI in Hiring

As part of the recruiting process, Broadridge may use technology, including artificial intelligence (AI)-based tools, to help review and evaluate applications. These tools are used only to support our recruiters and hiring managers, and all employment decisions include human review to ensure fairness, accuracy, and compliance with applicable laws. Please note that honesty and transparency are critical to our hiring process. Any attempt to falsify, misrepresent, or disguise information in an application, resume, assessment, or interview will result in disqualification from consideration.