Position : Azure Data Engineer
Location : Guadalajara, México??? ?
Ingredion is currently recruiting for the position of Azure Data Engineer. In this role, we are seeking a highly dedicated, enthusiastic and professional with more than 7 years of experience in creating, updating and maintaining physical, logical or conceptual data models.
This individual will also lead the effort for a business Glossary to empower Self-Service Analytics and leverage technical knowledge of data modeling and data integration best practices to make data-driven decisions.
Expertise in Data modeling for SQL Data Warehouse / Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP) / Business Intelligence (BI) applications.
Practical understanding of theData modeling( Dimensional & Relational )concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Comprehensive knowledge and experience in process improvement, normalization / de-normalization, data extraction, data cleansing, data manipulation.
Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.Good understanding of Views, Synonyms, Indexes, Joins and Partitioning .
Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Azure Data Factory ( ADF ).
Thorough understanding of Data Flows within Azure ADF and setup SSISIR to publish SSIS packages to Azure.Create, document and maintain logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise datastores within a metadata repository.
Designing and developing data mapping, error-free DDL scripts that best suits the requirements from the Logical Data ModelDeveloped Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP & OLAP
7 years of Microsoft SQL Server experience, including queries that reflect performance tuning tradeoffs and knowledge across the technology stack including ETL , data analysis, metadata, data quality, audit and designExperience or exposure to SAP Business Objects, Tableau / Power BI, Hadoop, and ErwinExperience in making hardware recommendations, sizing, and configuration for development systems2 years of experience in Microsoft Azure platform (ADF pipelines, Analysis services, Azure SQL Database) is a plus2 years of experience with SCRUM & AGILE methodologiesThorough understanding of star, snowflake schemas and data modeling conceptsExperience using version control software like GitHub , TFS, Azure DevOpsBusiness savvy, with excellent verbal, written, and interpersonal communication skills.
Ability to work in a fast-paced environment and meet tight deadlines for projects and assigned activities.Experience with Azure Functions, Python & other Scripting languages is a plusKnowledge of Azure API Management, Azure LogicApps, Azure Service Bus is a plus
AWS, Azure, HDFS, HIVE, SPARK, Scala, SQL, JSON, SSAS Tabular & Multi-Dimensional cubes, SQL / ETL, OLAP, GitHub, TFS, Azure (ADF, SQL Database, Databricks, Functions, Analysis Services, Data Catalog, Storage accounts, Apps), Azure DevOps, Python, T-SQL
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.