Role :

ETL Developer with strong experience in ETL development, SQL, and data warehouse & Data analysis. The candidate should have experience working in Agile projects, handling production support, and collaborating with business stakeholders.

Key Responsibilities :

- Participate in sprint planning and Agile delivery activities

- Develop and maintain ETL jobs using IBM DataStage, Snowflake, AWS

- Write and optimize SQL queries for data analysis and reporting

- Work with Snowflake database and support Lakehouse architecture initiatives

- Perform ETL and query performance optimization

- Work with Unix scripting and Autosys job scheduling

- Analyze production data issues and perform Root Cause Analysis (RCA)

- Support data validation, reconciliation, and troubleshooting activities

- Coordinate with business teams and stakeholders for requirement analysis and issue resolution

- Ensure data quality and timely delivery of data solutions

Tech Stack & Skills :

- ETL development : IBM DataStage, Snowflake, AWS

- Database : Strong SQL, Snowflake

- Scripting/Scheduling : Unix commands, shell scripting, Autosys

- Concepts : Lakehouse architecture, data warehousing, performance optimization

- Soft Skills : Analytical thinking, problem-solving, production support, stakeholder management

Domain Requirement :

- Good understanding of Asset Management domain and financial data terminology.