Lead Data Integration Engineer - Long Term Project - Remote (US/PST)

Company: Genuent
Location: Elk Grove
Posted on: June 19, 2022

Job Description:

Senior Data Integration Engineer - Long Term Project - Remote (US/PST)

Genuent Global, LLC is currently seeking a Senior Data Integration Engineer for a 6 month contract with possible extension and POSSIBLE contract-to-hire opportunity for our client in Elk Grove, CA. This position will be on a hybrid schedule, 3 days a week on-site and 2 days remote if you were to go full time. However, we are open to remote candidates. If you're a match or know anyone that may be interested, please apply or contact slim@genuent.com.

Position Summary

The Senior Data Integration Engineer, specializing in database migrations and development, will be an experienced technical generalist familiar with a wide assortment of leading database technologies and methods. The qualified candidate must possess a thorough understanding of advanced database concepts relational DBMSs, SQL programming, ETL scripting, performance, and scalability, with a working knowledge of web services, business intelligence, data warehouses, and operational data stores.

In this role you will work independently with limited supervision and with other department personnel; this is an individual contributor position with no direct reports.

Primary daily activities: Data Migration: Apply best practices in ETL processes involving disparate data sources, both third-party and proprietary to create migration tools for customer migrations from one product to another, as well as transformations for specific high-value enterprises.
Database Development: Active with database development IDEs such as Oracle PL/SQL (SQL Developer), MySQL workbench, Toad, Squirrel, and including ETL job construction for data migrations between products, systems, and enterprises (Talend preferred, alternatively Microsoft Data Studio, Informatica, SSIS).

Position Responsibilities:

Develop and maintain custom database tools and scripts that can be run either by our Customer Support Team or via scheduled automation, enabling the export/import or migration of entities such as customers, work orders, etc. from one system to another, while accounting for data quality and mapping challenges
Define the development tasks and estimates for completion (including story writing)
Manage the database lifecycle and data migrations through multiple environments
Participate in the scrum team ceremonies: stand-up, planning, grooming, demo, retro

Position Qualifications:

B.S. in Computer Science
10+ years working in a database environment with data integration tools
High competency in entity-relationship analysis from requirements to diagramming
Logical and physical data modeling; solid ERD skills using Erwin, Visio or similar
Background of ETL migration of user data from one product to another, with examples
RESTful API call experience in an ETL package; JSON/XML parsing and serialization
Extensive Oracle, MySQL, Microsoft SQL Server experience
SQL development, optimization, performance tuning
Programming languages (besides SQL): Java, Python, .NET/C#
Exceptional communication, organization, and time management skills
Strong analytical problem-solving skills with a high attention to detail
Track record as a self-starter, results-oriented, and delivery-focused contributor
This person will be the person doing the job, not leading/guiding others to do the work. At a high level they're going to be the person in charge of taking information from our legacy products, customer facing products and different systems and moving them under one unified format. Someone that uses Talend Developer would be the best but similar programs for data integration is anyone with experience with Informatica and Data Studio.

Keywords: Genuent, Elk Grove , Lead Data Integration Engineer - Long Term Project - Remote (US/PST), Engineering , Elk Grove, California