Aversan Inc.
7 years in ETL tools such as Microsoft SSIS, stored procedures (Must Have)2 Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have)2 years Python (nice to have)DatabricksSynapse (nice to have)SQL ServerOracleAbility to present technical requirements to the businessExperience:Experience of 7 years of working with SQL Server, ADF and T-SQL Development (Must Have)Experience working with building Databases, Data Warehouse and Data Mart and working with delta / incremental and full loads (Must Have)Experience with any ETL tools such as SQL Server, ADF, Cloud tools (Must Have)Experience working with MSSQL Sever on premise and within Azure Environment (Must Have)Experience on Data modeling, and tools – e.g. SAP Power Designer,Experience with snowflake and star schema model. Experience in designing data warehouse solutions using slowly changing dimensions.Experience working with SQL Server SSIS and other ETL tools, solid knowledge and experience with SQL, other RDBMS (SQL Server, SSIS)Understanding data warehouse architecture with a data vault, dimensional data and fact model.Analyze, design, develop, test and document ETL programs from detailed and high-level specifications, and assist in troubleshooting.Utilize SQL to perform tasks other than data transformation (DDL, complex queries)Good knowledge of database performance optimization techniquesAbility to assist in the requirements analysis and subsequent developmentsAbility to conduct unit tests and assist in test preparations to ensure data integrityWork closely with Designers, Business Analysts and other DevelopersLiaise with Project Managers, Quality Assurance Analysts and Business Intelligence ConsultantsDesign and implement technical enhancements of Data Warehouse as required.ETL
Source ⇲
