...Providing guidance on suitable options, designing, and creating data pipeline for the analytical solutions data lake / data warehouses to specific micro services ▪ Building ETL jobs based on jointly defined requirements along the data pipeline ▪ Works closely with both the backend developers as well as the IT data architecture group ▪ Supporting the
...SharePoint online (cloud). Want to connect using VS2017 package, SSIS. I want to connect to my SharePoint list (svc - I have the URL and can see the download) with an Odata source. Want to then load all this data into an SQL table. Only apply if you have had extensive knowledge with this SSIS and have used to odata connection for a shareoint integration
I have an existing MongoDB app that is used by a Spring Boot App to provide REST services to Front End (Angular) clients. Need t...MongoDB app that is used by a Spring Boot App to provide REST services to Front End (Angular) clients. Need to port the MongoDB schema over to Apache Cassandra and Port the ETL logic from Spring Boot over to Apache Storm
I have a scenario and a use case diagram alread...case diagram already done. I will need someone to design a class diagram in StarUML/Visio to match the given scenario and use case diagram. Sequence Diagram and use case description (template provided) also need to be done for one use case (I will choose it). 2-3 hours maximum time delivery. Thank you!
Res...experience in application development in .Net/Azure/MSFT office product 11. Should have strong knowledge of SDLC. 12. TFS - Team Foundation Server – Good to have. 13. SSRS, SSAS, SSIS – Good to have. 14. Excellent Communication and Interpersonal Skills 15. Bachelor’s degree in Information Technology, Information Systems or Computer Science
Need to pa...wrangling in Amazon Web Services. Time zone is in UTC +8 area or if you can do these times. Maybe an hour a day weekly or more time depending on workload. Tools used: Python, SQL, ETL, lambdas, Redshift, Mysql When bidding on this project let me know what number is a baker's dozen so I know you can speak English and you are not a robot.
...Strong knowledge of software architecture and OOP - Strong knowledge of database relational models - Strong knowledge of SQL Server; 2008 R2 or greater, SQL Query Language, SSIS, SSRS - Should have problem-solving capabilities, programming logics and a team player. - Ability to gather requirements and provide solutions to business problems. -
...sites have SSI (server side include) files which means you don't necessarily have to enter each webpage of the site and make manual changes. Changes can be done through the SSIs. Only one website is Mobile responsive. We need to convert the others so they are also mobile responsive. We look forward to your bids and questions....
Help on the existing application in .Net, SQL Server, SSIS
Develop SSIS package, data from json api (REST) into sql. 1. I have a URL (which requires authentication) which accesses the JSON header. 2. This json header data will need to be stored into an sql table 3. A loop will need to be created to go through the JSON header sql table (to find the line url data) 4. This json line data will need to be stored
...data scientist currently working on a data engineering task and I would need some assistance. I have the data on S3 in 7z JSON, which I would like to convert to Parquet run ETL jobs and finally create a dashboard. I am trying the following: Glue -> Parquet -> Athena or Batch -> docker image -> R jobs I am running into issues and would need someone
...It would be a big plus if you enjoy this content or are familiar with this niche. Titles: will be 5 to 10 words long and should contain at least one relevant keyword. Description: will be at least 30 words long and appear catchy / attention getting with relevant keywords. Tags: There a list of about 500 tags, try to select as many as possible that
good morning, we have an SQL server 2008 R2 on windows 2008 R2, it has an ETL process that builds a Cube. The ETL has worked fineso far, but now it does not complete (continues forever). would you be interested in taking a look, launching it in debug mode and see what is the problem?
Process and clean a list of large amount of raw data (export and import data) obtained from trade facilitation companies. Build a framework and process for data cleaning. Some level of text cleaning and API call is needed to successfully map each row of data into a correct category (eBay or Google API). Develop a program to process more similar raw data files in the future, and facilitate sto...
Transition 15 fields and 1 million records from source 1 to source 2. More information and attachments will follow after your bid.
We have a need for someone to help in development and operations work. Initially some ETL development using Python/pandas. Knowledge of cassandra/nosql databases, Ubuntu, virtual environments (docker), and parallel/distributed programming is required.
Hello, i need 3 images illustrated/created representing the following : 1. Stickers, Labels 2. Canvases 3. Vinyl Stickers They are for a website selling custom products and these images will be representing the category the client will be clicking on . Some examples have been uploaded of the style i am looking for . The examples are from a sticker/label website i would like a combination of a f...
hello i need help in writing SSIS package without sorting header record and trailer record. only actual data should be sorted on 1st column which has length 1 character. sample Input File([login to view URL]) H1020XXXXXXXXXX 509090909092343 132423423432434 343242342342343 T12295834958 sample output file([login to view URL]) similar to below: H1020XXXXXXXXXX
Hi Team, I want to search some part time work on BI technologies like Power BI/ MSBI (SSRS/Ssas/Ssis) Also worked on Cloud computing like Azure/AWS and Database Migration. Please find the below link so that I have created some Power BI Dashboard/Reports:-- Please find below Power BI Dynamic Dashboard. [login to view URL] Details [login to view URL]
We're looking for experienced Telegram API developer to programmatically check if a phone number is registered in the Telegram. So the developer can check if phone number is registered in the Telegram, then if exist, just get the username. If you can do it, please add "It's easy to do it" on your head of proposal. Thank you
I want to customize an open source ETL in order to made some changes and integrate some new features/Solve bugs and trace/debug errors.
HI I need a simple solution to load xml file with multiple namespaces to sql table , Ideally via SSIS but stored procedure will also be ok . As file contains multiple namespaces with various depth standard SSIS XML data flow task is failing to import all the data. XML file is the response from ebay api LMS saved on local PC.
I'm working on a SSIS package, need help to build through the tasks, could be quite simple for SSIS developer. We can finish it quickly where going over it together online (Webex). The package needs to: get a table object variable, use foreach loop to process each row, each row has components of a custom sql, run the custom sql and store end result
I am working as Data Warehouse Engineer. And I need some support(proxy) to help in my work. Its related to Data M...Data Warehouse Engineer. And I need some support(proxy) to help in my work. Its related to Data Migration and requires creating ETL mapping documents, maintaining them, ER diagram development, writing SQL queries, creating SSIS packages.
...product description that entices the consumer to click on that buy button. My product description is really basic with information about what it can be used for, dimensions, color & fabric info. I need a writer that can help me sell my product with their words but not be a car salesman. I have a few photos of what I need a product description. If you
Small work. Issue in oracle database integr...oracle database integration unable to solve it because of lack of knowledge in SSIS. should be like 10 mins work for experts. Recently Domain of BI server was modified then we started to have this issue. I don't know the username and password of userID used in scheduled job, wanted to make it work again.
Need a female proxy with good knowledge of hadoop ecosystem such as hive, mapreduce, hdfs, hbase. should know spark [login to view URL] that would be good to...with good knowledge of hadoop ecosystem such as hive, mapreduce, hdfs, hbase. should know spark [login to view URL] that would be good to know - java, scala, python. knowledge of ETL processes are a plus
I started building a visual ETL tool but now lacking the time to finish it up. I need a strong WPF and C# developer to help me cross the finish line. Skillset includes the following: - C# WPF view/layer - Data mapping technical and best practice with SQL Server in the backend
I'm looking for a python expert who deep knowledge of AWS S3, data warehouse including obtaining data with external APIs. You should be python expert with knowledge of ETL and Mongo. This is long-term task, so you need to commit everyday and update me via call. Hope to hiring python guru. Thanks.