MUST TO HAVE :
4-6 years’ experience with DW design methodologies - Dimensional and relational Strong foundation of dimensional data models and data warehouse on cloud
Minimum of 1 year of experience designing and implementing a full-scale data warehouse solution based on Snowflake.
Exp in developing production-ready data ingestion and processing pipelines using Java, Spark, Scala, Python.
Experience with complex data warehouse solutions with 2 years of hands-on experience
Experience in working with stored procedures. Good knowledge of cursors and exception handling
Extensive experience with building data ingestion pipelines, with meta driven approach
Expertise with Amazon Web Services, Microsoft Azure and Google Cloud.
A highly effective communicator, both orally and in writing
Problem-solving and architecting skills in cases of unclear requirements.
GOOD TO HAVE:
Experience in Talend tool
Experience in building framework based data integration using Talend tool
Experience in building Talend based ETL workflow to ingest, transform and aggregate data
Provide technical support, guidance, and consultation with the issues relating to supported applications
Extensive experience in ETL methodology for performing Data Profiling Data Migration
Extraction Transformation and Loading using Talend
Solid experience in implementing complex business rules by creating reusable transformations and robust mappings using Talend transformations