Software Engineer Ii Data Warehouse
hace 3 semanas
Requirements:- English Level C1+ or B2+- Be able to rotative schedule- Bachelor of Systems Engineering, Computer Science or Related- Minimum 5+ years’ experience with star schemas, dimensional modeling, and extract transform load (ETL) design and development.- Minimum 3+ year experience on Microsoft SSIS.- Minimum 2+ year experience on Pentaho Data Integration.- Expert in Data Warehouse life cycle methodologies and BI best practices.- Expert tuning SQLqueries.- Experience developing PL/SQL packages, procedures, views and triggers.- Database Administration. Expertise working with various databases (Oracle, SQL Server)- Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.- Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.- SSIS Advanced component experience required (transformation objects in data flow).- Implementing ETL Packages using Data Transformation Services (DTS) and SSIS- Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.- The individual must have full technical knowledge for all phases of a software development lifecycle and must be able to analyze and solve complex problems in a dynamic environment.- This individual must have good oral and written communication skills.- This individual must have development experience with ETL tools.- Nice to have: Python, Azure Data factory, AWS RDW, API and S3 buckets**Responsibilities**:- Work with Business Analysts to correlate business requirements to domain entities and data elements- Design, develop and maintain an information architecture and conceptual models for industry specific domain area.- Lead/key contributor for development using ETL solutions like Pentaho PDI, SSIS.- Work independently in determining impacts to code as per the requirements updates and fixes required for fixing defects- Develops data and metadata policies and procedures for cross-functional software development teams to build, maintain and leverage the data model, ensuring integration with customer and industry data standards.- Work with Developers to design, implement and maintain scalable software solutions that use database structures designed and maintained by the Data Architect- Review and evaluate database performance, risk and financial analysis feasibility studies- Provides complete assessments of the technical characteristics of proposals and alternatives considered to optimize database performance.- Reviews and assesses technical proposals requesting changes or upgrades to the existing databases.- Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.- Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for the development work.**Salary**: $500,000.00 - $600,000.00 per month**Education**:- Bachelor's (required)**Experience**:- year experience: 3 years (required)**Language**:- English Level C1+ or B2+ (required)
-
Software Engineer II- Python
hace 2 días
Monterrey, México Confiz A tiempo completoJoin to apply for the Software Engineer II- Python role at Confiz4 days ago Be among the first 25 applicantsJoin to apply for the Software Engineer II- Python role at ConfizWe’re seeking a Python-focused DevOps Engineer with strong experience in MLOps.ResponsibilitiesBuild tools for automation around ML workflows orchestration and model deployments using...
-
Software Engineer II- Python
hace 2 días
Monterrey, México Confiz A tiempo completoJoin to apply for the Software Engineer II- Python role at Confiz4 days ago Be among the first 25 applicantsJoin to apply for the Software Engineer II- Python role at ConfizWe’re seeking a Python-focused DevOps Engineer with strong experience in MLOps.ResponsibilitiesBuild tools for automation around ML workflows orchestration and model deployments using...
-
Software Engineer II- Python
hace 2 días
Monterrey, México Confiz A tiempo completoJoin to apply for the Software Engineer II- Python role at Confiz 4 days ago Be among the first 25 applicants Join to apply for the Software Engineer II- Python role at Confiz We’re seeking a Python-focused DevOps Engineer with strong experience in MLOps.ResponsibilitiesBuild tools for automation around ML workflows orchestration and model deployments...
-
CI & Build Engineer II - Automotive Software
hace 3 semanas
Monterrey, México Aptiv A tiempo completoA leading automotive technology company in Monterrey, Mexico, seeks a Software Build-CI Engineer II. This role is pivotal for executing the integration strategy for advanced driver assistance software, involving responsibilities like software builds, integration tests, and continuous integration management. Applicants should have a Bachelor's in Engineering...
-
Data Engineer
hace 2 semanas
Monterrey, México DataArt A tiempo completoClient: Our client is a global investment firm that manages tens of billions of dollars in assets and provides advisory services focused on credit products.Position overview: We are looking for a skilled Data Engineer to join our team and support the design, development, and maintenance of data solutions that drive critical business insights. This role...
-
Senior Data Engineer
hace 2 semanas
Monterrey, México DataArt A tiempo completoClient: Our client is a huge investment company headquartered in New York City. Project overview: This exciting project's primary objective is to develop a cutting-edge Data Platform to empower business users with insights they need to make data-driven investment decisions. We've already successfully deployed the initial Data Warehouse into...
-
Senior Data Engineer
hace 3 semanas
Monterrey, México Intugo A tiempo completoSenior Data Engineer Intugo • Monterrey, Nuevo León, México Descripción del trabajo Our Data Engineering team plays a key role in a technology company that is experiencing exponential growth. The data pipeline processes over 80 billion impressions a day ( >20 TB of data, 220 TB uncompressed). This data is used to generate reports, update...
-
Data Engineer
hace 2 días
Monterrey, México Coderland A tiempo completoLocation: Monterrey, Mexico (on-site at clients office)Employment Type: Full timeThe client is seeking a skilled Data Engineer to design, build, and optimize scalable data pipelines and data infrastructure. This role involves close collaboration with cross-functional teams to ensure reliable, high-quality data delivery that supports analytics, machine...
-
Data Engineer
hace 2 días
Monterrey, México Coderland A tiempo completoLocation: Monterrey, Mexico (on-site at clients office)Employment Type: Full timeThe client is seeking a skilled Data Engineer to design, build, and optimize scalable data pipelines and data infrastructure. This role involves close collaboration with cross-functional teams to ensure reliable, high-quality data delivery that supports analytics, machine...
-
Software Engineer Ii
hace 4 semanas
Monterrey, México Blue Yonder A tiempo completoWe are looking for a Software Engineer II to extend the Blue Yonder Platform's identity, access, and API management services with IoT capabilities. This team, globally distributed across Mexico and India, designs, develops and operates critical services that provide a home to all Blue Yonder APIs and offer central management for all customer identities and...
