Data Engineer with SQL and Snowflake

Role :Data Engineer with SQL and Snowflake
Duration: 6 months
Location: Edinburgh(Hybrid)

Required Skills and Qualifications:

• Proven experience working with SQL Server (e.g., T-SQL, Stored Procedures, Indexing, Query Optimization, System Catalog Views).
• Strong experience in Snowflake architecture, including data loading, transformation, and performance tuning.
• Proficient in ETL processes using tools such as Informatica PowerCenter and BDM, AutoSys, Airflow, and SQL Server Agent.
• Experience with cloud platforms preferably AWS.
• Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Redshift Athena, S3, and IAM.
• Solid understanding of data warehousing principles and best practices.
• Strong proficiency in SQL for data manipulation, reporting, and optimization.
• Knowledge of data modeling and schema design.
• Experience working with large, complex datasets and implementing scalable data pipelines.
• Familiarity with version control tools such as GitLab.
• Experience with data integration, data governance, and security best practices.