Requisition ID: 217401 We are committed to investing in our employees and helping you continue your career at ScotiaTech.PurposeThe ETL Developer will contribute to the overall success of the Global Enterprise Technology – Corporate Security globally by designing and implementing end to end ETL solutions from data analysis, data modeling to ETL.AccountabilitiesChampions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.Build best in class ETL solutions, and will be working closely with Product Owners, Developers, Scrum Masters, Project Management and Stakeholders.Analyze highly complex business rules and logic and translating those into technical implementationsPerform data wrangling to merge disjointed data sources and implement complex data transformationDevelop ETL process using MS SQL Server BI stack, SQL Server Integration Services and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server 2017, 2019 and/or Azure SQL DBConduct source data analysis and profiling to complete source to target mappingLogical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data • Assure data quality, security, and compliance requirements are metProvide proactive support and maintenance to the existent ETL solutions to keep them at its best of qualityTake ownership of bugs, defects, enhancements or any assignment end to endUnderstand how the Bank’s risk appetite and risk culture should be incorporate into in day-to-day activities and decisions.Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.Champions a high-performance environment and contributes to an inclusive work environment.Education / Experience / Other InformationBachelor's degree in a technical field such as computer science, computer engineering or related field required3 years of experience in designing, developing, and deployment of large-scale data warehouse projects from end to endExpert knowledge and hands on experience with SQL Scripting: 3 yearsExpert knowledge working with SQL Server SSIS, Integration Services Catalog and project deployment and Azure Suite – 3 yearsExperience working with Agile methodology – 3 yearsExperience working with BitBucket or TFS, and creating DevOps pipeline (preferred)Working knowledge of dimensional data modeling methodologyStrong English verbal and written communication skillsNice to have Skills:Experience working with data warehouse within Google Cloud Platform Degrees or certificationsExperience in Splunk (SPL)Power BIB1+ level of English.Working ConditionsWork in a standard office-based environment; non-standard hours are a common occurrence.#LI-HybridUbicación(s): Colombia : Bogota : Bogota ScotiaTech es una unidad de negocio de ScotiaGBS, un grupo de empresas de Scotiabank, ubicado en Bogotá, Colombia. ScotiaTech fue creado para apoyar diversos sistemas y procesos tecnológicos del Banco.Ofrecemos un entorno de trabajo inclusivo y positivo, además de ventajas competitivas. En ScotiaTech, valoramos las habilidades y experiencias únicas que cada persona aporta y nos hemos comprometido a crear y mantener un entorno inclusivo y accesible para todos. Los candidatos deben postularse directamente en línea si desean ser tomados en cuenta para este puesto. Agradecemos a todos los candidatos por su interés en esta oportunidad profesional en ScotiaTech; sin embargo, solo contactaremos a quienes hayan sido seleccionados para una entrevista. #J-18808-Ljbffr