Sql warehouse schema työt
...SUPPORT ROLE Exp - 7+ years of exp in GCP GCP bigquery, looker, pubsub, composer, kubernetes, dataflow Data build tool(dbt) Python, advanced sql 5 days in a week Remote support role You will have to help developer for completing the task Timings - 9 to 11 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 500 INR /hr I'm on the lookout for an Expert level GCP Data Engineer with at least 7+ years in the field. While the specific skills weren't marked, we'll need someone with a good blend of: - Data modeling and schema design, - ETL/ELT pipelines, and - Data warehousing. Our project has some specific requirements...
I need an experienced Azure Function Developer. This project involves creating a function that is triggered by Azure SQL Database. Key features required include: - Triggering of Azure Function: The Azure Function should be set up to be triggered by a Azure SQL Database insert - HTTP Post Request: Post an HTTP request upon triggering and have specific column data from the trigger sent in the request body. - Updating Azure DB: The Azure Database should be updated based on the result after HTTP Post. The ideal candidate should have demonstrable skills in building Azure Functions and SQL Database integration, solid background in backend development and HTTP Protocols. Quick turnaround, focus on detail and ability to test before delivery are also important. A system tha...
Hello We are seeking a s...standards. Conduct thorough testing to identify and resolve any bugs or issues. Provide technical support and training to end-users. Requirements: Proven experience in developing HRMS software with a portfolio of past projects. Proficiency in front-end technologies (e.g., HTML, CSS, JavaScript) and back-end technologies (e.g., Node.js, Python, Ruby on Rails). Strong database management skills (SQL, MongoDB, etc.). Knowledge of HR processes, compliance, and best practices. Excellent problem-solving and debugging skills. Ability to work collaboratively with a team and communicate effectively. Up-to-date knowledge of industry trends and emerging technologies in HRMS. At least 5+ year experienced required. Follow all programming standards , code must be cl...
We are in need of a Freelancer to carry out a simple task. No previous experience required, training will be provided. The service consists of a cargo and documentation audit. The freelancer must visit a factory and/or warehouse to complete this task in person. The process consists of taking photos of the products, confirming quantities, verifying documents, and supervising loading. Documentation must be carefully filled in throughout the process. Fluency of the local language is required. You must have full availability all day on inspection date. The training session is 1 hour and will be scheduled for the day prior to the first task. Exact date will be confirmed before inspection. This is a recurring task based on performance. >> Inspection location is Sri City but if ...
I'm searching for a mid-level .net C# programmer to complete an online Vedic astrology application. We already have stuff set up with bootstrap 5, SQL Server, C#, asp.net, and web forms. A test server is already hosting it. Thus, we require someone who can get to work right away. Perfect Skill Set: - Need to have strong math skills - command of C# and ASP.NET - Strong on Excel VBA - Previous web application development experience - Good understanding of terms linked to Vedic astrology is a MUST. part-time work If you are unfamiliar with astrology beyond your sun sign, please do not apply.
I am looking for a technichal writer who can write an article having 1000-1200 words about database structures in SQL. He will do research and write the article according to given outline.
... We are thrilled to extend an invitation to join our team as a salesperson! We are in search of someone enthusiastic and driven to help us connect with new clients interested in utilizing our cutting-edge and roboust Warehouse Management System software. Your efforts will be duly rewarded through a commission-based payment structure, ensuring your hard work is recognized and compensated fairly once the deal is successfully concluded. The specifics of this rewarding opportunity will be further discussed over our personal message board. Join us in revolutionizing the warehouse management landscape and be a part of our journey towards growth and success! We eagerly await your collaboration in propelling our software to new heights while you reap the benefits of your dedicat...
hello freelancer i m new on this website first sorry for bad english i looking for expert php and sql to help me to create giftcode function for my game what i have right now - backend website for GM(only me) fuction can send coin,ban,send item,send mail in game(not working) can access all item in game subdomain is gm.mywebsite.c - website for player : user can check coin that they have purchase with irl money and one button that they can claim new player bundle subdomain is spin.mywebsite.c what i looking for right now - another page for GM website backend that can create giftcode , can add many item,amount,expired giftcode,item must be list(check image) can remove giftcode or edit - add giftcode fucntion on player website, move textinput to buttom and have giftcode history th...
We are seeking a skilled Python developer with expertise in Google Shopping price scraping to enhance our existing scraper or build a new one. The current scraper we have, which successfully imported data into an SQL database, scraped prices on Google Shopping using EAN/barcode for The Netherlands. However, recent changes implemented by Google now restrict scraping/searching solely based on EAN code. Our attempts to replace the EAN code with the product name have resulted in unreliable results. What we need: Dashboard with WYSIWYG Interface: Develop a scraper with a user-friendly dashboard to cater to both technical and non-technical users. The dashboard should facilitate easy input and configuration. Input Data: Utilize a provided CSV file (see attachment '')
I'm seeking an adept developer, knowledgeable in C#, HTML, PHP, and SQL. This project involves: - Software Development: You'll be primarily building, designing, and maintaining software that would be working on a Windows operating system. - Web Application Creation: We're not just aiming for a regular website, we're developing a web application to serve the core purpose of our project. - OS Compatibility: Although the focus is majorly on Windows, a broad understanding of varying operating systems is a plus. Ideal skills and experiences: Competency in C#, HTML, PHP, SQL languages, software development, Windows operating systems, and experience in creating web applications.
I'm seeking a knowledgeable Microsoft Azure specialist to help me prepare for a technical job interview. My primary need is understandi...Amazon EKS to Azure AKS - I need to learn the intricacies of provisioning and configuring nodes, deploying and managing applications, and integrating with other Azure services. • Transitioning from CloudWatch to Azure Monitor. • Moving load balancers and Network Security Groups (NSGs). • SQL migration from AWS to Azure. • Logistics of migrating EC2 instances, S3 buckets, and RDS databases from AWS to Azure, with no special requirements. Ideal candidates should have extensive experience in AWS, Azure, SQL migration, and load balancing. Skills in CloudWatch, EKS, AKS, EC2, S3, and RDS are also critical for a succ...
I am looking for a skilled developer who can help me create a dynamic database in SQL Server from a VB.NET Windows Form application. Requirements: - Experience with SQL Server and VB.NET - Ability to create a database dynamically with another name - Knowledge of schema creation - Familiarity with the Freelancer.com Messaging System for communication throughout the project
I ALREADY HAVE MOST OF THE APPLICATION. I JUST NEED YOU TO PROPERLY CONNECT THE CONTROLLERS TO THE DATABASE. In this project, the primary task is the development of a web application specifically tailored for individual consumers. The web application requires implementation using mainly React, JavaScript, and Spring ...effectively serves the intended audience. Preferred Skills: - Strong proficiency in React, Spring Boot, and JavaScript. - Proven experience in developing web applications for individual users. - An excellent understanding of consumer-centric design and functionality. the database needs to match the variables in the documented frontend Frontend : react (JavaScript on vscode) Backend : Java (sts) and sql (MySQL workbench) The current react file is 64 mb so I can�...
I am looking for an experienced mobile app developer who is proficient in Dart language. The task involves an update to my existing app, wherein the backend runs on ElectricSQL () and the mobile using Electric Dart () with resources as provided (, ). Key Skills: - Expert knowledge in Dart. - Working experience with ElectricSQL on both backend and mobile. - Experience in bug fixing, new feature addition, and performance improvement. Budget around 6$/hr time
...Saturday 10AM to 12PM EST ? Responsibilities: - Deliver engaging and informative data engineering lectures. - Design and implement hands-on exercises and projects. - Provide constructive feedback and support to students. - Stay updated on industry trends and technologies. ? Requirements: - Proven experience in data engineering. - Strong knowledge of relevant tools and languages (e.g., Python, SQL, ETL, Tableau, Power BI, Machine learning) - Excellent communication and teaching skills. - Bachelor's degree in a related field (Master's preferred). ? Benefits: - Flexible schedule. - Opportunity to impact and inspire future data engineers. - Stay connected with industry professionals. Together, we will empower students with the knowledge and skills they need to succeed ...
We are looking for a PHP Developer responsible for managing back-end services and the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, definition and maintenance of the central database, and ensuring high p...solutions Understanding fundamental design principles behind a scalable application User authentication and authorization between multiple systems, servers, and environments Integration of multiple data sources and databases into one system Familiarity with limitations of PHP as a platform and its workarounds Creating database schemas that represent and support business processes Familiarity with SQL/NoSQL databases and their declarative query languages Proficient understanding of code versioning tools, s...
Project: I need 40 hours of your time to help/teach me to build a social community and dating website OS: Windows 11 Framework / CRM: Laravel 10 / Filament 3 Development solution: TALL stack Database engine: MySQL Start date: As soon as you are available Working hours: Flexible, upon a mutual agreement Development environment: You will be connecting to my comp...dating website OS: Windows 11 Framework / CRM: Laravel 10 / Filament 3 Development solution: TALL stack Database engine: MySQL Start date: As soon as you are available Working hours: Flexible, upon a mutual agreement Development environment: You will be connecting to my computer remotely via TeamViewer, Microsoft teams, etc. FYI, I have gained some experience with the Laravel 10 framework, XAMPP, SQL Server, MySQL Kind regar...
I am in need of strategic SQL DBA scripts to ensure comprehensive performance validation. These scripts should be focused on three principal tasks: 1. Query Optimization: Fine-tuning scripts for a small, simple database. This will enhance efficiency and conserve system resources. 2. Index Management: Manage indexes to improve SQL Server query performance. Capable of dexterous index manipulation specifically with Microsoft SQL Server. 3. Database Backup and Restore: Robust scripts to backup and securely restore our database to safeguard our precious data. Additionally, I am also interested in scripts that can help with end to end server related queries. Ideally, the freelancer for this project should possess in-depth knowledge of Microsoft SQL Server, query o...
Hi everyone, I'm looking to hire an expert for a project requiring a skilled freelancer that has in-depth knowledge and experience of data harvesting and warehousing using SQL, MongoDB and Streamlit. My goal is to harvest specific data from YouTube, store the data using MongoDB and finally visualize it using Streamlit. The data that needs to be harvested is related to channel statistics and subscriber information. Additionally, the candidate must have the necessary expertise to use Streamlit for in-depth data analysis and be able to showcase the trends and insights. The scope of the project also includes the ability to generate reports accurately that will provide helpful insights which can be used for decision making. A successful execution of this project is critical for the ...
I am seeking a knowledgeable freelancer to carry out data warehousing on Azure Synapse. This will involve: - Cleaning and transformation of data from internal databases. - The creation of an optimized structure for data storage and retrieval. To complete this project efficiently, an understanding of Azure Synapse is required and a background in data analytics. Proven experience in handling large data cleanses and transformations is vital, along with a keen attention to detail to ensure data quality and accuracy. Familiarity with internal databases is also necessary.
I'm seeking a knowledgeable individual who can produce building drawings for a 40 x 100 ft storage warehouse w/ a materials list. The warehouse will specifically serve the purpose of storing non-perishable goods, mostly wine after bottling and pallets of supplies to include empty bottles. The building is on agricultural property in Tennessee and building permits and building codes do not apply. An electrical permit will be required. Requirements and features are: - Incorporating high ceilings, 16 feet, for effective stack storage. - Concrete floor, Stick frame construction, 2x6 studs, roof trusses w/ 4/12 pitch, OSB interior, HVAC, LED lighting, metal roofing and sides, two 10 foot openings (drive-in) and a 36 in. entrance door. R21 walls and R30 ceiling. - Abilit...
php my sql dating website template - must have a sample of one you have done before and a link to that site live.
I need an experienced contract drafter to create an End User License Agreement (EULA) and Non-Disclosure Agreement (NDA) for my B2B software technology product (data warehouse). This software is designed for small businesses, providing features such as: - User authentication and access control - Data analytics and reporting - Integration with third-party platforms - Data warehouse Ideal candidates should have comprehensive knowledge of software contracts and NDA regulations, as well as a strong understanding of user rights related to software technology. Experience in working with small business software is also essential.
...defined category. Assistance is needed to organize the products into appropriate categories, ensuring a user-friendly shopping experience. 3. **Drop Shipping Clarity:** My understanding of drop shipping is still very basic. I need someone to explain the best way to facilitate the drop shipping process on my website. Whether it's an integrated system, direct merchant-to-customer shipping, or warehouse-based shipping, I am open to expert advice. The ideal freelancer for this job will have experience in e-commerce website development, a deep understanding of drop shipping, and excellent communication skills to educate me on best practices for drop shipping. They should also have a keen eye for website design and navigation, with a proven record of creating user-friendly onli...
...installed directly on this single VM. Docker should not be used. 2. Install Microsoft SQL 2022 Developer Edition. Must be Microsoft SQL, but also must be "free". The avoidance of paying licensing fees is key for this. Explain exactly how to do this in Microsoft Azure to a "junior IT worker". 3. Install Microsoft SQL Server Management Studio on Windows Client PC, or alternate solution on an Ubuntu machine. Simply need to be able to see the database and validate we have access to it. Also, this ensure the need ports are open in MS Azure to allow this access. 4. Install Nginx version 1.20.2 . Must be this exact version. 5. Install PHP version 7.4.33 . Must be this exact version. 6. Configure Drupal driver for Microsoft SQL per . Explain al...
...our warehouse and POS system. - Automated product data updates: The system should be capable of automatically updating our product data. - Customer and order data management: The module should synchronize customer data with our warehouse and POS system, retrieve customer orders from these systems, and track order status in real time. We're using that POS and warehouse system to control stocks and making sales over POS in our physical stores. That system also collect information about our customers and their orders. Need to make synchronizing that dates between Prefix CRM and that system. Finally Prefix CRM should collect and make them always up to date, all datas (warehouse: items and stock; customers and their orders). The communication between the mo...
...ROLE Exp - 7+ years of exp in GCP GCP bigquery, looker, pubsub, composer, kubernetes, dataflow Data build tool(dbt) Python, advanced sql 5 days in a week Remote support role You will have to help developer for completing the task Timings - 8:30 to 10:30 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 500 INR /hr I'm on the lookout for an Expert level GCP Data Engineer with at least 7+ years in the field. While the specific skills weren't marked, we'll need someone with a good blend of: - Data modeling and schema design, - ETL/ELT pipelines, and - Data warehousing. Our project has some specific requirements....
...keywords, readability, and relevance. - Schema Implementation: Implement structured data (schema) to boost the website's visibility on SERP. - Off-Page SEO: Conduct an off-page SEO campaign to further establish the site's credibility, increasing organic backlinks and mentions from trusted domains. Main Goal: The overall goal of this campaign is to increase organic traffic to the website. A successful campaign will attract a greater number of users from organic search results, boosting overall website visibility and engagement. Ideal Candidate Experience: The ideal candidate for this job will have a proven track record in executing comprehensive SEO strategies, with particular strengths in keywords optimization, link building, content SEO, schema implem...
...and be familiar with SQL databases. Specifics: - The project involves scraping website URLs. - The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously (Every second), on an ongoing basis. Nature of Work: - Retrieve Data (15 mins & Hourly Table) - Add option to change MSSQL login & pwd details - Attached Screenshots for Reference data Tables - Retrieve data continuously (every second) from below url's ,69,1081628,160,1,49776&curr-name-color=%230059B0&fields=15m,1h Gold & Silver Ratios Data from Kitco url (attached screenshot) : Skills and Experience: - Proficient in web scraping techniques and tools. - Experience with MS SQL databases. - Strong
I'm s...methodologies such as Manual Testing, Automated Testing, and Load Testing using Jmeter. The project will mainly focus on Functional, Database, and both Web and Mobile Testing, specifically tailored for Android platform. Proficiency in API Testing and experience with Sauce Lab is a significant advantage. The key components to be tested include: - HRMS system: Requires extensive functionality testing - SQL Database: Experience with MySQL is essential - Unix Systems: Fundamental understanding of Unix systems will be needed - Mobile Testing: For Android platform specifically Finally, the ability to perform Automated Testing and Load Testing will be the cherries on the top. If you consider yourself adept in these domains, I look forward to potentially working with you o...
I need a proficient chatbot developer skilled in Langchain and MSSQL integrations. The main objective is to implement a Chatbot that will effectively handle and respond to customer queries. Its existing code and needs to improve. Key project elements: - Retrieving undefined information from the database as part of its response capability. - Developing a robust language translation feature within the chatbot. - Integrating a system to collect and store customer feedback.
I'm in need of an experienced back-end developer with extensive knowledge in SQL, specifically MySQL databases. The project will involve: - Database Integration: Integrating an SQL database into my small project. I have already chosen MySQL as the preferred database. Ideal Skills and Experience: - Extensive experience with database integration, particularly in MySQL. - Proven track record in back-end development. - Strong problem-solving abilities and attention to detail. - Experience in API development and user authentication is a plus, although not a primary requirement for this particular project. It is crucial that the database integration is seamless and efficient, ensuring optimal operation of my project. I look forward to seeing your proposals.
looking for develop whole project: web app chatbot engine llama 2 redis cache db postgres sql db dockerized and build around a strong backend in node.js (i have already a draft) with: NLP Machine Learning Kibana Grafana with api connection and documentation Frontend react.js clean and modern with all featured like the file add. The scope of my project is to use that chatbot like user support chat. Must respect time delivery, cost and guide-lines of the project
...out to have this task completed as soon as possible. 1- We need to install freeswitch on Linux server using putty access. 2- MySQL Db will be installed and used. 3- customer and status (Active/Inactive) B. Insert DID C. Routing DID D. Enable/Disable recording on specific numbers. E. Caller ID set/modify for specific numbers. F. CDR synchronization from Freeswitch to the SQL-based application. G. Delete DID (When DID is going to be deleted then we will delete routing as well). H. Update DID. Note:- Primary key we will use customer ID in all tables. If a customer is inactive then the server will drop the call with the CDR status account inactive. It's crucial to note that all these tasks will initially be carried out on test DIDs. Once testing is su...
I am seeking a Python data engineer who can efficiently translate SQL scripts into Python to automate processes. Given 4 csv input files and a SQL script that transforms and builds data model off of the input data, I want an expert data engineer to convert the SQL codes into Python that to perform the exact same job. The project shouldn’t take more than 4/5 hours and needs to be delivered by Sunday noon. You NEED to have advanced expertise of both Python and SQL! If you are a beginner or intermediate, please don’t apply! $100 bonus for outstanding quality work!
I'm looking for a C# programmer to design and develop a web application devoted to KP astrology. We already have something already built using asp.net , c# , web form, Sql server. It is already hosted on a test server. So we need some one that can start hitting the ground on day one. Ideal Skill Set: - proficiency in C#, asp.net - Previous experience with astrology-based software development and testing. - Prior experience with developing web applications - understanding of KP astrology ( cusp, star lord , horary etc.) Do not apply if you do not have KP astrology knowledge.
I'm in dire need of an expert in web security. My website's security is currently compromised as it's vulnerable to Cross-site scripting (XSS), SQL injection and Cross-site request forgery (CSRF). I urgently require a professional to help address these vulnerabilities. Skills and Experience - Proficient in Network Security, Application Security and User Authentication - Proven knowledge in tackling XSS, SQL injections, and CSRF - Previous experience in web security is a must-have Your role would predominantly involve the mitigation and fixing of these existing issues to improve website application security. This role does not require regular maintenance or monitoring.
I have a Windows application connected to a Microsoft SQL Server where the server and database names in the VB.NET connection string need to be altered. Currently, application connects to SQL Server using SQL Server Native Client 11.0 that cannot be installed on Windows 11 due to compatibility issues. So I need to replace it either with : - Microsoft OLE DB Driver for SQL Server OR - Microsoft ODBC Driver for SQL Server I am not sure which way would be better. I need to replace connection string. Code can be reused and I would not change except where is needed. I have form where I choose to connect to database. This connection string is saved to XML file. This part I would not change except whats needed. Their task would involve: - Changing both the ...
I'm looking for a professional with a strong understanding of PySpark to help transform a dataframe into JSON following a specific schema. This project's main task is data transformation to aid in data interchange. The project requires: - Expertise in PySpark - Proficiency in data transformation techniques - Specific experience in data aggregation For the transformation, I require the application of an aggregation method. In this case, we will be sorting the data. It's crucial that you are skilled in various aggregation methods, especially sorting. Your knowledge in handling critical PySpark operations is crucial for this job's success. Experience in similar projects will be highly regarded.
We are currently seeking a Joomla developer of intermediate experience level. Need joomla developer upgrading joomla 2.8 website to latest one along with latest compatible my sql version same will be deployed on hostinger
I'm in need of a professional who can conduct security testing for my web application. * The system to test is a progressive web application built with Visual Studio (Blazor & C#), paired with SQL Server. * You are expected to perform comprehensive security tests, identifying potential vulnerabilities and suggesting robust solutions. * Ideal candidates should have extensive experience in security testing, preferably with a background in testing applications in similar tech stacks. * Familiarity with Blazor, C#, SQL Server and a deep understanding of security principles are crucial for this role.
Looking for a quick build of an eCommerce site. We have a large amount of ex-stock items that we want to sell in a 'warehouse' online where customers can order and purchase old stock at a large discount. We have 56 products in total which will need to be captured and images created for (all freely available on the internet) with a short product description. Candidates must be able to: 1 - Design the store and assist with a basic logo and theme 2 - Capture each of the items from a spreadsheet into the store 3 - The layout/theme needs to be clean and fast and simple 4 - MUST be optimised for google to search. We will not be promoting the site, so crawlers need to be able to find it and rank it up based on the product type and the fact that it is cheap/discounted heavily. 5 ...
...designing and implementing reports and visualizations using latest technology standards, as well as develop and implement innovative techniques for measuring, analyzing, and reporting on project and various Studios financial data in an agile team environment. Responsibilities - Proficient with Power Query, DAX, and MDX for complex data projects - Experienced in authoring, diagnosing, and altering SQL Server and Postgres objects - Experience creating and maintaining reporting assets in Power BI - Analyze business requirements into technical requirements for reporting/visualizations, data models, and databases - Review technical specifications derived from technical requirements - Develop reporting for business consumption using a variety of BI tools - Work on drill-through reports...
Hello! I'm looking for a back-end developer to create some functionality. You'll recieve a non-functional GUI design interpretation in HTML and functional JS to send it to the backend. The backend must be coded manually; no database will be provided; however the column keys will be mentioned. I have plenty of work if you are keen for the job! Please no automated quotes!
I need an SQL expert to modify an existing T-SQL stored procedure. The task primarily involves tweaking the query logic. To be specific, I'm looking for someone who can: - Insert and add more tables/joins to enhance the complexity and robustness of the existing procedure. - Modify some of the current conditions to align with business dynamics and needs. The ideal candidate should have extensive experience with T-SQL, and a good understanding of complex query logic and stored procedure optimization. Your experience with SQL server optimization will be a plus.
We are in need of a Freelancer to carry out a simple task. No previous experience required, training will be provided. The service consists of a cargo and documentation audit. The freelancer must visit a factory and/or warehouse to complete this task in person. The process consists of taking photos of the products, confirming quantities, verifying documents, and supervising loading. Documentation must be carefully filled in throughout the process. Fluency of the local language is required. You must have full availability all day on inspection date. The training session is 1 hour and will be scheduled for the day prior to the first task. Inspection date is January 22. This is a recurring task based on performance.
I am in immediate need of a database expert to develop a relational database for me. I'm unsure of the particular platform it should be on, such as Oracle, MySQL, or SQL Server. Perhaps after a brief discussion about my specific needs, you could guide me towards the most suitable option. Ideal qualifications: - Strong expertise in building relational databases - Ability to suggest the most suitable platform based on project needs - Excellent communication skills to explain technical specifics in layman's terms - Ability to start immediately and complete the project in a timely manner.
...organizations that license to use our database and we maintain their data. Our database is SQL Server and our reports database is currently using the SQL Reporting structure. We are looking to update our reports database and integrate it with Power BI for more flexibility with data visualization and publishing. We hope to set it up so our internal data analysts can build and publish reports for licensees, but also so our third-party licensees can build and publish their own reports. The tutoring must cover the following Power BI areas: • Getting started with Power BI and our use case • Infrastructure and setup knowledge for our Database Administrator and two other programmers • Data modeling • SQL Server Database Integration • Trainin...
I have an MS Access DB along with an SQL server. I need someone to help me update, extend and refresh some parts of it. I would like to find a programmer with MS Access skills.
