This site uses cookies. To find out more, see our Cookies Policy

Data Integration (ETL) Engineer in Tampa, FL at Vaco

Date Posted: 2/21/2019

Job Snapshot

Job Description

Knowledge

  • Extensive knowledge of the integration technology in use on the project.
  • Strong understanding and knowledge of: Database concepts, Interfaces to data, Rules and routing, Data mediation and transformation, Performance, Security and Data governance.
  • Fundamentally aware of enterprise application integration, enterprise information integration and enterprise service bus architectures.

Technology Skills

  • Previous experience with data integration systems.
  • Degree level or equivalent experience of manipulating and analyzing complex data sets.
  • A strong background in algorithms and data structures.
  • Experience of analyzing and breaking down problems and information using structured frameworks and methodologies.
  • Experience in standard integration technologies such as exchange of flat files locally or via FTP, API, ETL, web services and the off-the-shelf tools that support these technologies.
  • Experience with bulk integrations and fundamentally aware of real time integration techniques.
  • An understanding of FTP and FTP clients.
  • Experience using third party APIs and products.
  • Solid understanding of database theory and hands on experience of relational databases, SQL, efficient statement structure and XML, and knowledge of NoSQL database engines.

Planning and Project Management

  • Understand agile project management (i.e., understanding what needs to happen in a project and when).
  • Experience in project coordination / management and of working closely with users throughout the full implementation of the project ensuring that deliverables are met on time.
  • Ability to prioritize in the face of demanding time frames.

Work Experience

  • 5+ years of hands-on experience in a data integration environment part of applications platform development.
  • More than 5 years of experience in data warehouse concepts, practices, and procedures.
  • More than 2 years of experience performing data analysis and profiling, as well as designing ETL systems/programs.
  • Expert SQL skills.
  • In-depth understanding of data integration best practices and leading industry applications and features such as master data management, entity resolution, data quality assessment, and metadata management.
  • NoSQL/in-memory transformation experience or knowledge.
  • Technical, hands-on experience implementing data warehouse solutions.
  • 8+ years of experience with ETL tools or ETL programming.
  • Experience with relational database concepts, service-oriented architecture (SOA), ESB, and portal technologies.
  • 5-10 years of experience with IT projects and information development.
  • Expert experience with the ETL product being used.
  • Expert experience with the database tool being used.
  • Expert experience with Database Modeling and Design Tools (e.g., Erwin, Oracle Designer, etc.).
  • Expert experience with Report Analysis and Tool Usage (e.g., SSRS, SSAS, SSMS, Crystal Reports, etc.).
  • Expert experience with the Microsoft development environment (Visual Studio, Team Foundation Server).
  • Expert experience with RedGate SQL tools and other SQL Source control tools.

Training and Devleopment

  • Continued development of data integration skills; keep abreast of latest techniques, best practices and trends and able to apply to project work.
  • Expert in ETL techniques, processes and best practices and able to provide guidance to other development teams (BI, ETL, Application Development, etc.).
  • Take all required UMA training by required deadlines.

Data Analysis and Quality Control

  • Accuracy in all tasks.
  • Ability to work on multiple projects.
  • Follow through with project tasks/strict adherence to timeline.
  • Review and analyze source data, analyze and document data flows, and validate mapping specifications and business rules from data source to target.
  • Develop SQL queries/scripts and similar artifacts to validate the completeness, integrity and accuracy of data within a data integration/ETL process testing cycle.
  • Highly involved in and lead data analysis efforts to resolve complex data issues.
  • Design and develop automated solutions (scripts, functions, programs, processes) to increase the efficiency of the data integration/ETL and other testing processes.
  • Advanced ability to write Test Cases and Test Scripts based on Requirements, Design documents, and other project inputs.
  • Analyze stability of new data integration implementations.

Reporting and Analytics

  • Expert experience in designing and authoring reports using SQL Server Reporting Services, Crystal Reports, as well as other report authoring tools.
  • Ability to analyze business requirements, make recommendations to improve insight into the requested data/analysis, convert to functional design and implement the design to meet the user requirements.
  • Achieve accuracy in all data, metrics and labels for report and file outputs.
  • Expert proficiency in SSAS setup and use.