i3 Verticals

Data Conversion Engineer

i3 Verticals

full-time

Posted on:

Location Type: Remote

Location: Tennessee • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLSQLSSIS

About the role

  • Knowledge of ETL processes.
  • Understanding how to extract data from various sources, transform it to meet business needs, and load it into target systems.
  • Work with a variety of database and file formats, including SQL Server, dBase, Advantage, Excel, and text files.
  • Develop and execute SELECT, UPDATE, INSERT, DELETE, and ALTER queries and stored procedures for data cleansing and transformations.
  • Utilize SSIS for importing and managing data in test, development, and production environments.
  • Familiarity with core SSIS components such as Control and Data Flow tasks OLEDB and Flat File Sources OLEDB Destinations Derived Column, Data Conversion, Sort, and Lookup tasks Parameters
  • Use Crystal Reports and Visual Studio to customize reports tailored to specific requirements.
  • Work with VB, SQL, XML, and JSON to create and modify import scripts.
  • Analytical and detail-oriented, ability to identify patterns and trends, and ensure accuracy and consistency.
  • Experience setting up Windows scheduled tasks.
  • Create SQL Queries and test cases to validate post conversion data.

Requirements

  • Excellent verbal and written communication
  • Excellent time management skills
  • Experience in a client-facing role
  • Experience in stakeholder management
  • Experience of working in a diverse and challenging environment
  • Ability to determine estimates of effort and impacts on a variety of solutions
  • Ability to manage rapid change in a fast-paced environment
  • Ability to manage deliverables and provide support to multiple projects
  • Data Conversion experience
  • Knowledge of Microsoft Windows applications
  • Developed analytical and problem-solving skills
  • Meticulous attention to detail
  • Experience in testing and validation of output data including reports
  • Must have a minimum of two years of experience with SQL
Benefits
  • Equal Opportunity Employer
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETL processesSQL ServerdBaseAdvantageExcelSELECT queriesUPDATE queriesINSERT queriesDELETE queriesALTER queries
Soft Skills
verbal communicationwritten communicationtime managementstakeholder managementanalytical skillsproblem-solving skillsattention to detailability to manage changeability to manage deliverablesclient-facing experience