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.
nKey Responsibilities
n
n
1. Participate in sprint planning and Agile delivery activities
n
2. Develop and maintain ETL jobs using IBM DataStage, Snowflake, AWS
n
3. Write and optimize SQL queries for data analysis and reporting
n
4. Work with Snowflake database and support Lakehouse architecture initiatives
n
5. Perform ETL and query performance optimization
n
6. Work with Unix scripting and Autosys job scheduling
n
7. Analyze production data issues and perform Root Cause Analysis (RCA)
n
8. Support data validation, reconciliation, and troubleshooting activities
n
9. Coordinate with business teams and stakeholders for requirement analysis and issue resolution
n
10.
Ensure data quality and timely delivery of data solutions
n
nRequired Skills
n
n
1. Robust ETL development experience using IBM DataStage, Snwoflake, AWS
n
2. Strong SQL knowledge
n
3. Experience with Snowflake database
n
4. Good knowledge of Unix commands and shell scripting
n
5. Experience with Autosys job scheduling and monitoring
n
6. Strong understanding of ETL and SQL performance optimization techniques
n
7. Understanding of Lakehouse architecture and data warehousing concepts
n
8. Good analytical thinking and problem-solving skills
n
9. Experience in production support and incident handling
n
10. Strong communication and stakeholder management skills
n
nDomain Requirement
nGood understanding of Asset Management domain and financial data terminology