En cours

Data file batch processing

Looking for database/stored procedure developer to understand and tranfer data from flat file to database tables.

Technology

[url removed, login to view] Server 2008

2.T-SQL

DOcumentation Requirement

1. High Level Design, Error handling and data processing Workflow.

2. Data archival strategy.

2. Testing scripts/scenarios

Development

[url removed, login to view] flat file data (Correlation between rows in flatfile)

[url removed, login to view] data from flat file into staging database tables and from staging to reporting tables.

[url removed, login to view] are approx 2-3 stage table and 6-7 reporting tables

[url removed, login to view] error handling and error data reprocessing.

[url removed, login to view] data archival code.

[url removed, login to view] jobs to schedule data loading process.

Compétences : Microsoft, SQL

Voir plus : sql 2008, sql batch processing, t sql jobs, t sql developer jobs, technology testing jobs, sql server developer jobs, Sql developer jobs, sql database developer jobs, process technology jobs, microsoft sql developer jobs, microsoft jobs, level design jobs, jobs in technology, jobs in strategy, jobs for technology, jobs documentation, documentation jobs, data handling jobs, database testing jobs, database developer jobs, data file processing sql, SQL Database Developer, sql server 2008, reporting jobs, process server jobs

Concernant l'employeur :
( 0 commentaires ) King of Prussia, United States

N° du projet : #1612871

Décerné à :

suprja

Hi,I am interested in this project. Please read PM for more information.

150 $ USD en 7 jours
(1 Commentaire)
1.4

9 freelance ont fait une offre moyenne de 245 $ pour ce travail

takman

Hi, I've been working with SQL SERVER (2000,2005 and 2008) and Transact-SQL. I can handle this job trought external script (can be scheduled) that processes the flat file and then inserts well formatted data into di Plus

96 $ USD en 2 jours
(3 Commentaires)
3.2
puneethmech

Lets start working!!

75 $ USD en 5 jours
(2 Commentaires)
2.9
Krusche

Hello. Working with SQL, T-SQL technologies in the job we are good at. Please check our reviews and examples in your PMB.

480 $ USD en 2 jours
(2 Commentaires)
2.8
sccitino

I have more than 12 years of experience in design, archietecture, development and implementation of Microsoft SQL Server OLTP and OLAP solutions. I would consider myself an expert in data migration and ETL. I work qu Plus

250 $ USD en 5 jours
(0 Commentaires)
0.0
nish20in

Hi, I am Database/SQL Server Expert having more than 6 years hardcore experiance in the above mentioned technologies. Please check your Private message for more details. Regards Nish

200 $ USD en 5 jours
(0 Commentaires)
0.0
SqlServerDba

Hi, I can build transfer using SSIS,or TSQL script with bcp or dos command(loading and parsing from file data into staging) process will be scheduled to run from bat files or sql agent Alex

250 $ USD en 3 jours
(0 Commentaires)
0.0
epuignouselles

Hi, I'm an expert in SQL Server and i can get done your project with good quality and best practices. To solve this problem we can use SSIS technologies and T-SQL.

400 $ USD en 5 jours
(0 Commentaires)
0.0
viney00

I am working as DB/BI Architect and can develop ETL using SSIS for this requirement.

300 $ USD en 10 jours
(0 Commentaires)
0.0