Must-Have:
- 12+ years of experience in Snowflake lead/Architect.
- Hands-on experience Architecting and delivering solutions using the Snowflake, AWS, Azure.
- Experience in Data Profiling, Data Quality, Meta Data Management and Data Governance.
- Assessed business rules; performed source-to-target data mapping; designed, reviewed, implemented and optimized
- Extract, Transform and Load (ETL) processes
- Understood and translated business requirements into Data Warehouse solutions; created data models and designs to
- meet specific business needs that required sourcing data from multiple source systems
- Designing enterprise data warehouse architecture using Azure Data Lake, Azure Data factory, Azure synapse analytics
- Extensive discussion with SMEs, Identifying Subject areas and KPIs as per the business requirement.
- Defined High level data architecture for the HR analytics.
- Worked with Data Governance team in data Profiling, data cleansing and data quality activities.
- Worked closely with Data analyst and system SME`s during source system analysis and raised data quality issues.
- Worked closely with Business Analyst in understanding the Dashboard Mock-ups during requirement gathering.
Role & Responsibilities :
- Responsibilities:
- Worked as Data Architect for Bata Project. Involved in the implementation for Global implementation
- Designing enterprise data warehouse architecture using Azure Data Lake, Azure Data factory, Azure synapse analytics
- Worked with the ETL team in developing the pipelines using Azure Data Factory.
- Performed Data quality on various sources and developed data quality metrics.
- Worked with Data Stewards to finalize data quality rules.
- Performed data profiling and Meta data management and lineage for the project.
- Data Model Standardization.
- Performed Meta data management.
- Extensive discussion with SMEs, Identifying Subject areas and KPIs as per the business requirement.
- Preparation of Bus Matrix.