Job Role: Senior ETL Developer

Job Description:

The Senior ETL Developer is responsible for designing, developing, and maintaining robust, scalable, and secure data integration solutions that support enterprise management information, reporting, analytics, and regulatory needs. This role focuses on end-to-end ETL design and implementation, ensuring high-quality, reconciled, and well-governed data pipelines across cloud-based data platforms.

The position requires strong expertise in ETL tools, cloud data ecosystems, data modeling, and orchestration, with close teamwork across reporting, analytics, and governance teams to enable trusted enterprise data consumption.

Key Responsibilities:

Data Acquisition, Transformation & Integration

• Design, develop, and enhance complex ETL workflows to acquire, transform, and load data from diverse source systems into enterprise data platforms such as Snowflake

• Use enterprise ETL tools (e.g., AWS Glue, Ab Initio, Matillion, DataStage) to build scalable and reusable data pipelines

• Implement robust data reconciliation, validation, and error-handling processes to ensure accuracy and completeness

• Maintain strong data lineage and traceability across all ETL processes

Data Modeling & Performance Optimization

• Design and implement unified data models, including star schemas and dimensional models, to support reporting and analytics

• Optimize data structures and ETL logic to improve performance, scalability, and cost efficiency in cloud data environments

• Partner with reporting and analytics teams to ensure ETL outputs align with downstream consumption needs

Cloud & Platform Engineering

• Develop and operate ETL solutions within cloud environments (AWS and Azure)

• Leverage cloud-native storage and compute capabilities while ensuring performance and reliability

• Use Control-M to schedule, orchestrate, and monitor ETL jobs and dependencies

Governance, Security & Compliance

• Apply data governance, security, and access control standards within ETL design and execution

• Maintain metadata, documentation, and operational run books for all ETL assets

• Support audit, regulatory, and compliance requirements through repeatable and well-documented data pipelines

• Ensure audit trails and reconciliation controls are embedded within ETL processes

Collaboration & Continuous Improvement

• Translate business and reporting requirements into detailed ETL technical designs

• Work closely with data designers, MI/reporting teams, and platform engineers

• Support production deployments

• Mentor junior ETL developers

Required Skills & Experience

Technical Skills

• Strong hands-on experience with ETL tools such as Ab Initio, Matillion, DataStage (or equivalent enterprise ETL platforms)

• Advanced SQL skills with performance tuning experience

• Experience working with Snowflake as an enterprise data warehouse

• Solid grasp of data modeling concepts, including star schema and dimensional modeling

• Experience with job scheduling and orchestration using Control-M

• Familiarity with cloud platforms (AWS and/or Azure) for data solutions

Governance & Data Management

• Knowledge of data governance, metadata management, and data security standards

• Ability to design and detail out end-to-end data flows ensuring lineage

• Experience embedding data quality and reconciliation controls in ETL pipelines

Preferred Qualifications

• Experience in financial services, risk, regulatory, or management reporting environments

• Familiarity with data cataloging tools and data quality frameworks

• Experience supporting reporting tools such as Power BI (from a data producer perspective)

• Strong analytical and problem-solving skills with high attention to detail

Career Level / Role Characteristics (for Design Alignment)

• Role Type: Senior Individual Contributor Data Engineering

• Primary Capability: ETL Development & Data Integration

• Complexity: Designs and delivers complex, enterprise-scale data pipelines

• Autonomy: Works independently with limited supervision; provides guidance to others

• Customer Impact: Supports enterprise MI, analytics, and regulatory reporting

Benefits

• We are equal employer with hybrid working

• Annual Leave, Parental Leave benefits

• Upskilling opportunities with job relevant training and certifications

• Dedicate Employee Helpline

Proud to share LSEG in the India is Great Place to Work certified (Jun 25 Jun 26).

Learn more about life and purpose of our company directly from India colleagues video: Bengaluru, India | Where We Work | LSEG

Career Stage:

London Stock Exchange Group (LSEG) Information:

Join us and be part of a team that values innovation, quality, and continuous improvement. If you're ready to take your career to the next level and make a significant impact, we'd love to hear from you.

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership, Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyones race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs.

You will be part of a collaborative and creative culture where we encourage new ideas. We are committed to sustainability across our global business and we are proud to partner with our customers to help them meet their sustainability objectives. Our charity, the LSEG Foundation provides charitable grants to community groups that help people access economic opportunities and build a secure future with financial independence. Colleagues can get involved through fundraising and volunteering.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what its used for, and how its obtained, your rights and how to contact us as a data subject.

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.

Location: IND-BLR-Divyasree Technopolis, IND-Hyderabad-CapitaLand

Time Type: Full time