Senior ETL Developer

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

Key Responsibilities

1. Participate in sprint planning and Agile delivery activities
2. Develop and maintain ETL jobs using IBM DataStage, Snowflake, AWS
3. Write and optimize SQL queries for data analysis and reporting
4. Work with Snowflake database and support Lakehouse architecture initiatives
5. Perform ETL and query performance optimization
6. Work with Unix scripting and Autosys job scheduling
7. Analyze production data issues and perform Root Cause Analysis (RCA)
8. Support data validation, reconciliation, and troubleshooting activities
9. Coordinate with business teams and stakeholders for requirement analysis and issue resolution
10. Ensure data quality and timely delivery of data solutions

Required Skills

1. Strong ETL development experience using IBM DataStage, Snwoflake, AWS
2. Strong SQL knowledge
3. Experience with Snowflake database
4. Good knowledge of Unix commands and shell scripting
5. Experience with Autosys job scheduling and monitoring
6. Strong understanding of ETL and SQL performance optimization techniques
7. Understanding of Lakehouse architecture and data warehousing concepts
8. Good analytical thinking and problem-solving skills
9. Experience in production support and incident handling
10. Strong communication and stakeholder management skills

Domain Requirement

Good understanding of Asset Management domain and financial data terminology