AutoZone | Lead Data Integration Engineer | Elk Grove, CA | United States | BigDataKB.com | 13 Oct 2022

0

Job Location: Elk Grove, CA

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




Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free

🔍 Explore All Related ITSM Jobs Below! 🚀 ✅ Select your preferred "Job Category" in the Job Category Filter 🎯 🔎 Hit "Search" to find matching jobs 🔥 ➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼

LEAVE A REPLY

Please enter your comment!
Please enter your name here