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
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
Required Skills
Strong ETL development experience using IBM DataStage, Snwoflake, AWS
Strong SQL knowledge
Experience with Snowflake database
Valuable knowledge of Unix commands and shell scripting
Experience with Autosys job scheduling and monitoring
Strong understanding of ETL and SQL performance optimization techniques
Understanding of Lakehouse architecture and data warehousing concepts
Good analytical thinking and problem-solving skills
Experience in production support and incident handling
Strong communication and stakeholder management skills
Domain Requirement
Good understanding of Asset Management domain and financial data terminology