Etl Developer

Role & responsibilities

- Gather, clean, and structure raw data from multiple sources (internal systems, APIs, third-party data)

- Design & Develop optimized SQL queries, ETL jobs using DataStage, Talend framework to extract, transform, and load data from multiple sources.

- Support processes to improve data quality, consistency, and accessibility.

- Ensure data integrity, perform validation checks, and resolve discrepancies for reporting and analytical teams.

- Design and develop interactive dashboards and reports using tools such as cognos, Qlikview, Business Object, Power BI and Tableau

- Translate complex datasets into easy-to-understand visualizations for business users.

- Optimize dashboard performance and automate reporting processes.

- Collaborate with stakeholders to define KPIs and key business metrics.

- Provide ad hoc analysis and support for strategic initiatives by utilizing clear data storytelling to drive business insights.

- Support the transition from legacy reporting solutions to scalable automated BI solutions.

- Implement best practices for data integration and management to support long term business intelligence initiatives.

Preferred candidate profile

- 10+ years of experience in data warehouse concept, ETL processing, Data analysis and visualization within financial services strong preference for life &

Retirement insurance experience.

- Proficiency in SQL, Python, Unix shell scripting or other programming languages for data manipulation and analysis.

- Experience with cloud platforms (AWS, Azure) and data warehouses, esp. Snowflake.

- Expertise in BI tools such as Cognos, Qlikview, Power BI, Tableau, Business Object etc.

- Strong understanding of ETL processes and data pipeline development.

- Proficiency in design and development of ETL jobs using datastage and Talend Framework

- Working experience with various Databases like Oracle, SQL server, snowflake. Familiarity with ODBC connections, data sources, and working with large

datasets across multiple platforms.

- Experience with data governance frameworks and tools

- Ability to work with large datasets and develop insights that drive business strategy.

- Strong problem-solving skills and the ability to work independently and in cross-functional teams.