ElkGroveRecruiter Since 2001
the smart solution for Elk Grove jobs

Lead Data Integration Engineer

Company: AutoZone
Location: Elk Grove
Posted on: November 26, 2022

Job Description:

Position Summary: The Lead 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.Position Responsibilities:

  • 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).
  • 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

Keywords: AutoZone, Elk Grove , Lead Data Integration Engineer, Engineering , Elk Grove, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Elk Grove RSS job feeds