Hello , This is Mohammed from Tranzeal Incorporated request you to share your resume on msami@tranzeal.com or call me on 669-369-5556 Only Green Card and US Citizen Job Title: Data Engineer Location: Rancho Cordova, CA Oakland/Rancho Cordova/Alpharetta Duration: Long Term Contract Phase 1: Please ensure resource will not require sponsorship upon FTE conversion and resides locally to Oakland/Rancho Cordova/Alpharetta Pre-Screen Questions 1. Explain where Candidate obtained Data Engineer Experience? 1. Do can have the following experiences? TL tool, SAP BusinessObjects Data Services preferred 1. Will resource require sponsorship upon FTE conversion at Delta Dental? Job Information JOB SUMMARY The Senior Data Engineer will design, build, and implement data integration solutions, including data pipelines, data API's, and ETL jobs, to meet the data needs of applications, services, micro services, data assets, and business intelligence and analytical tools. Working with data architects, application development teams, data analytics teams, business analytics, product managers, and the data governance COE, the Senior Data Engineer will design and develop interfaces between applications, databases, data assets, external partners, and third-party systems in a combination of cloud and on-premise platforms. • Develops and maintains scalable data pipelines and builds out new integrations to support continuing increases in data volume and complexity • Designs and develops scalable ETL packages for point to point integration of data between source systems, extraction and integration of data into various data assets, including data warehouse and fit for purpose data repositories, both on prem and cloud • Designs and develops scalable data APIs to provide data as a service to microservices, applications, and analytical tools • Designs and develops data migrations in support of enterprise application and system implementations from legacy systems • Writes functional specifications for data pipelines and APIs and writes and performs unit/integration tests • Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues. • Assists in planning, coordinating, and executing engineering projects • Supports and collaborates with other Engineers through evaluation, design analysis, and development phases • Maintains knowledge, ensures competency and compliance with policies and procedures, in order to be the technical expert while collaborating with cross-functional teams • This list is not all-inclusive and you are expected to perform other duties as requested or assigned ESSENTIAL DUTIES • Develops and maintains scalable data pipelines and builds out new integrations to support continuing increases in data volume and complexity • Designs and develops scalable ETL packages for point to point integration of data between source systems, extraction and integration of data into various data assets, including data warehouse and fit for purpose data repositories, both on prem and cloud • Designs and develops scalable data APIs to provide data as a service to microservices, applications, and analytical tools • Designs and develops data migrations in support of enterprise application and system implementations from legacy systems • Writes functional specifications for data pipelines and APIs and writes and performs unit/integration tests • Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues. • Assists in planning, coordinating, and executing engineering projects • Supports and collaborates with other Engineers through evaluation, design analysis, and development phases • Maintains knowledge, ensures competency and compliance with policies and procedures, in order to be the technical expert while collaborating with cross-functional teams • This list is not all-inclusive and you are expected to perform other duties as requested or assigned • 5+ w/Bachelors degree Skills/Experience: • Meet with the Product Owner to gather requirements • Experience building ETL for analytical models • Design and Develop Matillion orchestration jobs to integrate the data and Compare the results of the Data integration between the Source and Target • Experience in implementing frame work solutions for data reconciliation • Evaluate Results and discuss discrepancies with the Product Owner and Business and bring closure to the discrepancy • Deploy code to Production Matillion and Snowflake are the key requirements Thanks & Regards Mohammed Samiuddin Phone: +1 669.369.5556 Email: msami@tranzeal.com Tranzeal Incorporated 2107 N. 1st Street. Suite 500 | San Jose, CA 95110 Tranzeal Incorporated is a Certified SAP Services Partner