Senior ETL (Informatica) & SQL Engineer

Broadridge Financial Solutions; Mumbai; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Broadridge Financial Solutions in Mumbai is seeking an experienced ETL Developer to design, build, test, and support Informatica workflows, mappings, and scheduling processes, ensuring data quality and performance across operational data stores and analytics environments.

The role emphasizes SQL development (MySQL, T-SQL, PostgreSQL), data modeling, and collaboration with database, application, QA, and business teams throughout the SDLC, with a focus on reliability, scalability, and strong

Qualifications

• 5+ years of ETL development and SQL/database experience.
• Informatica design of workflows, mappings, sessions, and lookups.
• Strong SQL and query optimization skills with MySQL.

Responsibilities

• Analyze requirements and design ETL workflows and data mappings.
• Develop and optimize ETL processes and SQL queries.
• Collaborate across DBA, application, QA, and client teams.
• Ensure data quality, error handling, and system reliability.

Skills

ETL development

SQL development

data modeling

analytical skills

collaboration

communication skills

Education

Bachelor's degree in Computer Science/Engineering or related field

Tools

Informatica

MySQL

UNIX shell scripting

Git

PostgreSQL

XML/JSON

Job description

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.

Key Responsibilities

Analyze business and data-aggregation requirements, including source-to-target mappings, transformations, lookups, business rules, and data-quality needs. Design, develop, test, implement, and support Informatica ETL workflows, mappings, sessions, transformations, and scheduling processes. Develop extract, transform, and load processes to support operational data, reference data, data warehouses, reporting, and analytics environments. Develop and optimize SQL queries, stored procedures, database code, and data-processing logic using MySQL and other applicable SQL technologies. Design and enhance physical and logical data models, database tables, relationships, and data structures to support application and reporting requirements. Apply Informatica capabilities such as Workflow Monitor, Scheduler, gpLoad, pushdown optimization, and parallelization to improve ETL efficiency and reliability. Establish transformation logic, exception handling, reconciliation processes, and operational controls to promote data accuracy and system performance. Troubleshoot and resolve data issues, ETL failures, slow-running jobs, SQL performance concerns, and production incidents. Translate business requirements into technical designs and specifications; document interfaces, workflows, conversions, reports, and technical solutions. Work closely with database development, application development, QA, client implementation, client support, and business teams throughout the software development lifecycle. Participate in requirements workshops, technical design sessions, code reviews, test planning, and QA/UAT support activities. Provide effort estimates, identify delivery risks and dependencies, and recommend scope or schedule adjustments when appropriate. Follow Broadridge SDLC, security, coding, source-control, and technical standards while delivering high-quality work on schedule. Collaborate with team members, communicate effectively with technical and business stakeholders, and support junior associates through established development processes.

Required Qualifications

Bachelor's degree in Computer Science, Computer Engineering, or a related discipline; equivalent experience may be considered. 5+ years of experience in ETL development, SQL development, database development, application development, or a comparable technical environment. Hands-on Informatica application-development experience, including designing workflows, mappings, sessions, transformations, and lookups. Experience with Informatica performance and operational features, including pushdown optimization, parallelization, gpLoad, Workflow Monitor, and Scheduler. Strong SQL development and query-optimization skills, including experience with MySQL. Working knowledge of T-SQL, PostgreSQL, PL/SQL, XML, JSON, and UNIX shell scripting. Experience with ETL techniques, data warehousing, operational data stores, data modeling, data aggregation, and analytical data systems. Experience identifying and resolving ETL and SQL performance issues. Working knowledge of Git or comparable source-code version-control tools. Familiarity with Agile and Waterfall development methodologies, system design, and software delivery practices. Strong analytical, problem-solving, written communication, and collaboration skills.

Preferred Qualifications

Experience developing data solutions for financial software or the banking, mutual fund, investment accounting, asset management, wealth management, or portfolio-management industries. Experience supporting enterprise data platforms and client-facing applications. Experience facilitating technical workshops and communicating requirements, designs, and issue resolution with users at all organizational levels. Knowledge of additional relational or NoSQL technologies, such as PostgreSQL or MongoDB. Experience with DevOps practices, deployment automation, and automated testing for data applications.

Company Culture

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

Broadridge Financial Solutions (NYSE: BR)

Broadridge Financial Solutions (NYSE: BR) is a global technology leader with trusted expertise and transformative technology, helping clients and the financial services industry operate, innovate, and grow. We power investing, governance, and communications for our clients - driving operational resiliency, elevating business performance, and transforming investor experiences. Our technology and operations platforms process and generate over 7 billion communications annually and underpin the daily average trading of over $15 trillion in equities, fixed income, and other securities globally. A certified Great Place to Work®, Broadridge is part of the S&P 500® Index, employing over 15,000 associates in 21 countries.

LinkedIn Facebook Instagram Twitter YouTube Glassdoor The Muse

Broadridge is committed to creating an engaging workplace for the most talented associates in our industry. We are dedicated to fostering a collaborative, inclusive, and healthy environment that promotes flexibility and accountability.

As a leading provider of technology, communications, and data and analytics solutions to businesses around the world, it is critical that we understand, embrace, and operate in a multicultural environment.

Every associate has unique strengths, which, when fully appreciated and embraced, allow individuals to perform at their best, leading to our success. We believe that our associates are our most important asset.

Encouraging professional development opportunities is a core part of our culture. Broadridge provides educational opportunities, including formal classes, training programs and events. To enable learning in our hybrid working model, Broadridge has redesigned all development programs for 100% virtual delivery. Our associates have access to 8,500+ online courses covering business, leadership, technical, and function-specific topics through our LinkedIn Learning program.