Highly skilled and motivated Digital Engineering Analyst with 2 years of experience in ETL development and data engineering. Possessing a Bachelor of Science in Computer Science, I am well-versed in designing, developing…
Highly skilled and motivated Digital Engineering Analyst with 2 years of experience in ETL development and data engineering. Possessing a Bachelor of Science in Computer Science, I am well-versed in designing, developing, and maintaining data pipelines and ETL processes for seamless data integration. Proficient in SQL, Python, JS, and ETL architecture, I have a strong foundation in data management and analysis. Throughout my career, I have worked extensively with a wide range of ETL tools, including Snowflake, Microsoft SQL Server, Matillion, Fivetran, DBT, Databricks, and Microsoft SSIS. I hold a deep understanding of data warehousing concepts and place great emphasis on ensuring data quality and accuracy. I excel in collaborating with cross-functional teams, working closely with business analysts, data architects, and database administrators to achieve data-driven solutions. My notable achievement includes implementing the CDC framework in Matillion and Snowflake for a waste management project, leading to improved data quality and significant cost savings.
As a highly skilled and motivated Digital Engineering Analyst with 2 years of experience in ETL development and data engineering, I have a strong foundation in data management and analysis. I have worked extensively with a wide range of ETL tools, including Snowflake, Microsoft SQL Server, Matillion, Fivetran, DBT, Databricks, and Microsoft SSIS. My notable achievement includes implementing the CDC framework in Matillion and Snowflake for a waste management project, leading to improved data quality and significant cost savings. I excel in collaborating with cross-functional teams, working closely with business analysts, data architects, and database administrators to achieve data-driven solutions. Passionate about continuous learning, I actively seek out opportunities to stay up-to-date with the latest developments in data integration.
<p>Transformed SSIS package scripts into SnowSQL scripts for seamless migration to Snowflake platform.<br>
Developed efficient stored procedures in Snowflake based on existing SQL Server stored procedures.<br>
Implemented Change Data Capture (CDC) framework for over 60 data integration packages in Matillion.<br>
Enabled efficient data transformation from source to target while capturing changed data.<br>
Conducted thorough comparisons between SQL Server and Snowflake databases to ensure data accuracy and consistency.<br>
Utilized Matillion's Github deployments and component handling for code versioning and management.<br>
Conducted Metadata validation and DDL validation for both SQL Server and Snowflake.<br>
Leveraged Python for data extraction to efficiently retrieve and process data for integration tasks.<br>
Utilized Snowflake's time travel and cloning features for data recovery and creating copies of databases for testing and analysis.<br>
Conducted data transformations, data cleansing, data enrichment, and data aggregation using Matillion components.<br>
Demonstrated proficiency in error handling, debugging, and troubleshooting data integration issues in Matillion workflows.<br>
Successfully connected Matillion to various data sources and target systems.</p>
<p>Utilized Snowflake's SQL capabilities to query and analyze large datasets, generating actionable insights and reports for stakeholders.<br>
Designed and implemented data warehousing concepts, including star schemas and data modeling, to optimize data storage and improve query performance in Snowflake.<br>
Implemented robust security measures in Snowflake, managing user access, roles, and privileges to ensure data protection and compliance with industry regulations.<br>
Led data integration efforts, developing ETL pipelines to extract, transform, and load data from different sources into Snowflake.<br>
Worked with semi-structured data formats like JSON and Avro, processing and analyzing complex data structures in Snowflake for advanced analytics.<br>
Managed Snowflake's virtual warehouses, provisioning and scaling compute resources to meet fluctuating data processing demands efficiently.<br>
Developed and managed data pipelines from multiple sources using Fivetran, automating the extraction and loading of data into the data warehouse.<br>
Leveraged AWS to deploy and manage Matillion in the cloud environment, enabling scalable and cost-effective data integration.</p>
نظام التوظيف التشغيلي المعتمد على الذكاء الاصطناعي أولاً، الذي يوحّد ويؤتمت دورة التوظيف بالكامل للمؤسسات الحديثة حول العالم.
د.جوب منطقة حرة ذ.م.م. 2026 © جميع الحقوق محفوظة
