100% Remote Data Integration Engineer for case management and fraud detection

Home / Georgia / Atlanta / Et cetera / 100% Remote Data Integration Engineer for case management and fraud detection

100% Remote Data Integration Engineer for case management and fraud detection

29 Nov 2024
Georgia, Atlanta, 45201 Atlanta USA
Report job

100% Remote Data Integration Engineer for case management and fraud detection

Vacancy expired!

QAT Global, a 25 year IT Consulting firm, is seeking a highly skilled Data Integration Engineer. Position will join the QAT/HES team. Our client provides a better pharmacy and ancillary benefits management experience for all workers compensation stakeholders. Position is 100% Remote.
Data Integration Engineer will be responsible for the analysis, design, documentation, development, unit testing, and support of data Integration and database objects development for software applications. Managing and integrating data between operational systems and data repositories. This includes but is not limited to ETL, stored procedures, views, and functions.
Recommends and provide guidance regarding Data Integration and database development, T-SQL best practices, and standards to the development team members as needed.

Specific Tasks:
  • Code complex T-SQL Select statements joining data columns from 3 or more tables.
  • Execute transactional CRUD statements against a SQL table.
  • Recommend SQL data types and transformations requirements.
  • Identify need for keys on a SQL table.
  • Open and analyze complex SQL stored procedures logic.
  • Execute nested stored procedures.
  • Run SQL tools to analyze query performance and propose solutions for improvement.
  • Use SQL SSMS to research SQL components and generate SQL scripts.
  • Create or modify SQL components and store on repositories.
  • Analyze data needs and design tables and views or any other component related to the table.
  • Open SSFT to research SSIS Packages, create new projects and parameters.
  • Create master SSIS packages calling SSIS subprograms.

QUALIFICATIONS:
3-5+ years SQL Server 2008/2014+
2+ years Data Integration technologies and principles
Advanced knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) T-SQL performance tuning and best practices
Experience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL
We provide a competitive benefits package to include, Medical, Dental, 401k with match, Short/Long Term Disability and Life Insurance.
Interested parties apply and Brent will be in contact.
QAT Global provides a comprehensive range of technical and strategic consulting services; we focus on how IT can make a real difference to client s businesses by building in agility, streamlining business processes, integrating data assets in new ways, and transforming technical assets. We also help our clients quickly get to market with new or enhanced products including custom software solutions, web software, desktop software, line of business applications, mobile applications, third-party integrations, e-commerce solutions, content management systems, rich internet applications, and mainframe applications.
QAT Global is an Equal Opportunity Employer

Related jobs

Job Details

  • ID
    JC23618829
  • State
    Georgia
  • City
    Atlanta
  • Job type
    Permanent
  • Salary
    $80,000 - $100,000
  • Hiring Company
    QAT Global
  • Date
    2021-11-26
  • Deadline
    2022-01-25
  • Category
    Et cetera
  • Print

Jocancy Online Job Portal by jobSearchi.

Navigation
Vacancies
© Copyright 2024 jocancy.com. Developed by MicroPHP