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