ETL Technical Architect

Required Experience: 8 - 12 Years
Skills : SQL related technologies. Data engineer supporting existing and net new data warehouse(s). , Data Warehouse, Data Modeling, SSIS ETL, TSQL, Azure Data Factory
·        Good Experience in SSIS packages and Azure Data Factory
·        Extensive working experience on SQL Server
·        Must be able to write good T-SQL code
·        Good knowledge of Data warehousing concepts
·        Experience in Dimension Modeling
·        Understanding of Agile methodologies
·        Excellent troubleshooting and communication skills
·        Experience with SSRS is desirable
·        Knowledge of Azure SSIS Preferable
Job Roles & Responsibilities
•                     Collaborate with internal teams to produce ETL and Report Design
•                     Write clean, scalable T-SQL code
•                     Test and deploy SSIS Packages
•                     Provide proper documentation as needed
•                     Advise client executives on planning and implementing enterprise-wide roadmap for Data warehouse design, development, and deployment
•                     Manage technical requirements gathering with business analysts and stakeholders