Data Engineer with Metadata- 9+ Years

Job summary

Design, develop, and maintain enterprise data engineering solutions, including metadata, lineage, reference data, database, API, and data integration capabilities. Support ETL and data warehousing activities throughout the SDLC, collaborating with cross-functional teams and ensuring performance, accuracy, and reliability.

Job details

Role: Data Engineer Location: Mississauga Canada Job Summary: We are seeking an experienced Data Engineer with 9+ years of experience in designing, developing, and implementing enterprise data solutions. The ideal candidate should have hands-on experience in data engineering, metadata management, data lineage, reference data, database development, and programming using technologies such as Oracle SQL/PLSQL, Python, or Java. Key Responsibilities - Design, develop, and maintain scalable enterprise data engineering solutions. - Work on data lineage, metadata management, and reference data solutions. - Develop and optimize database objects, queries, and stored procedures using Oracle SQL and PL/SQL. - Build data processing and integration solutions using Python or Java. - Develop and integrate APIs to support data exchange across enterprise applications. - Support ETL processes, data warehousing, and data transformation activities. - Collaborate with architects, business analysts, and cross-functional engineering teams to understand requirements and deliver solutions. - Participate in all phases of the SDLC, including design, development, testing, deployment, and maintenance. - Troubleshoot performance issues and ensure data accuracy, consistency, and reliability. Required Skills - 9+ years of experience in software development, data engineering, or data integration. - Hands-on experience with metadata management, data lineage, or reference data solutions. - Strong experience in Oracle SQL and PL/SQL. - Proficiency in Python or Java programming. - Experience developing and integrating APIs. - Knowledge of ETL processes, data warehousing, and data processing. - Understanding of software development lifecycle (SDLC). - Strong analytical, problem-solving, and debugging skills. Preferred Skills - Experience with enterprise metadata management and data governance. - Knowledge of data architecture, data modeling, and data quality. - Experience working with SDKs, frameworks, and enterprise application integrations. - Exposure to cloud-based data platforms and modern data engineering technologies.

What you’ll do

Design, develop, and maintain enterprise data engineering solutions, including metadata, lineage, reference data, database, API, and data integration capabilities. Support ETL and data warehousing activities throughout the SDLC, collaborating with cross-functional teams and ensuring performance, accuracy, and reliability.

Requirements

Requires 9+ years of experience in software development, data engineering, or data integration, with hands-on metadata, lineage, or reference data experience. Candidates should have strong Oracle SQL and PL/SQL skills, proficiency in Python or Java, API integration experience, and knowledge of ETL, data warehousing, and the SDLC.

Listed skills

• Python · Preferred
• Java · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Engineering
• Metadata Management
• Data Lineage
• Reference Data
• Oracle SQL
• PL/SQL
• Python
• Java
• API Development
• ETL
• Data Warehousing
• Data Integration
• Data Modeling
• Data Governance
• Data Quality
• SDLC

Job areas

• Data & Analytics
• Technology
• Software
• Engineering

More jobs from J2B Global LLC