Remote Network And System Administration Job In IT And Networking

Looking for Java, VBA, SQL Server PL/SQL expertie

Find more Network And System Administration remote jobs posted recently Worldwide

What I have:

1. Different kinds of source files needs to loaded into database tables.
2. Source file may be a flat file or excel or xml etc. with different kinds of delimiters.

What I need for the above requirement:

1. Source files information needs to be maintain in metadata table ex: Source file name, file type, delimiter, no of columns etc.
2. Based on the above information, Database table needs to be created dynamically or automatically using Java script.
3. In future if file may add some additional columns or removal of columns, table to be created dynamically. Adding new column or removing new column options to be provided to user to key in web based application.
4. Dynamic table creation and load the source data into table based on the source file.
5. Web based application or page for users to add metadata of source file information. Some additional button like create to create table. Load for data load from file to table.

Skill set: Java, SQL Server, Excel - VBA
About the recuiter
Member since Mar 14, 2020
Abu Bakar
from Lasithi, Greece

Skills & Expertise Required

"Extract, Transform and Load (ETL)" sql 

Candidate shortlisted and hiredHiring open till - Apr 28, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$95.83

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Python Scraping Pro Needed for Sportsbook scraping site

Want to create a website similar to (Removed by Toogit Admin) with odds for NBA, NFL, MLB, NHL and maybe more.

Would need to pull data from same sportbooks listed in link.

End goal is being able to display the data via wodpress site...read more

Data Engineer with MS SQL expertise

Data Engineer:

We are looking for a SQL developer in Microsoft Technology stack. High level of expertise in MS SQL, ETL, Azure Data Factory (nice to have). Any individual who is pursuing fulltime freelancing would be preferable.

SQL-Vacuum Expert needed

We have a Ruby code base that runs multiple jobs on our website. We deployed a piece of code and saw that it bloated up one table in our database because of several updates that happened in this table - We checked that database table and server logs....read more

Web Application Architecture with cloud CRM integration

Deliverable is to create a design document with following content.

Solution Architecture for an could (AWS or Azure) web application with:
- SQL backend with user data is master
- API for web fronted (webiste)
- API for CRM and 3...read more

Erwin tool

Erwin data modeler, SQL queries, skills on oracle developer, and skills on SQL server studio.
At least 7 years of experience