Stored procedures. Matching Keys and merging function

50.0 EUR

50.0 EUR peopleperhour Technology & Programming Overseas
704 days ago

Description

I need the following;
1/ a stored procedure that will extract records from a csv file and insert into a table, configured to run once a day, when sql server starts up, but not as a job.
2/ To merge two client profiles in sql server using matching keys.

Go Now
关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

The Task (Let’s Start Here) We’re starting with a task: build backlinks to one of our AI-focused landing pages. You’ll propose how you'd approach it, and if your plan + execution make sense, we’ll move forward to a long-term role. We’re not looking for: - Fluffy “I ran a campaign” claims - Purchased link lists - Vague talk about DR/DA We’re looking for: - Real strategies - Real execution - Real results — even small wins, if clearly explained Who You Are (Ideally) - You’ve built backlinks from scratch - You can explain exactly where you posted, how, and why - You focus on results: traffic earned, rankings improved, domains won - You can show links or screenshots (even if anonymized) - You can speak to what worked, what failed, and what you changed How to Apply Send a short proposal telling us: - Your link-building approach - A real example of how you got results - Mistakes you made and what you’d do differently - A realistic goal you’d aim for on a single page (e.g., “5 solid links in 10 days”) If it looks good, we’ll send you a short form to go deeper. What’s In It For You - Long-term SEO/link-building role possible - Async work with a small team that values results - No fluff, no bloated processes — just traffic that moves the needle
20.0 USD Technology & Programming peopleperhour Overseas
2 days ago
Advanced Web Scraping Specialist for Amazon Price Monitoring and Notification System Duration: 3 - 6 Months (Possibly Longer) Start Date: ASAP Overview: We are seeking an experienced and highly skilled freelancer to create a complex web scraping system that will monitor product prices on Amazon in real-time. This system must be able to efficiently scrape Amazon's product listings, detect price changes, and notify users of these changes with high accuracy and speed. This project requires a strong understanding of web scraping, API integration, and advanced data handling techniques. You should be comfortable with large-scale data extraction, working with multiple product categories, and managing frequent updates. Key Responsibilities: Web Scraping: Build a scalable web scraper to extract product data (price, title, product description, reviews, etc.) from multiple Amazon product pages. This includes handling pages with dynamic content and CAPTCHAs. - Price Change Detection: Implement a robust system to track price changes for thousands of products on Amazon in real-time. Ensure that the system can identify price fluctuations, including minor adjustments. Notification System: Develop a user-friendly notification system that alerts users when a product price changes. Notifications should be sent via email or push notifications (based on user preference). - Data Storage: Build an efficient data storage solution for the scraped data, ensuring historical price tracking is available. You must optimize storage and retrieval of large volumes of data. Scaling: Ensure that the scraper can scale effectively, with the ability to handle high volumes of products and frequent price updates. - Accuracy & Reliability: The scraper should minimize errors (false positives/negatives) in price change detection and be able to handle rate-limiting and anti-scraping mechanisms implemented by Amazon. - User Interface (Optional): If feasible, create a simple front-end interface where users can track their selected products, receive notifications, and customize their preferences. Follow best practices to avoid being blocked or banned by Amazon. - Required Skills & Experience: Advanced Web Scraping: Proven experience with advanced scraping techniques using tools like BeautifulSoup, Scrapy, Selenium, or Puppeteer. - API Integration: Strong experience with integrating third-party APIs, especially for notification systems (e.g., SendGrid, Twilio). - Real-Time Data Processing: Expertise in setting up real-time data pipelines and event-driven architectures. - Cloud Infrastructure: Knowledge of cloud platforms (AWS, GCP, Azure) to deploy the system and manage resources efficiently. - Data Storage & Databases: Proficient in designing and maintaining databases, with experience in relational and NoSQL databases (PostgreSQL, MongoDB, etc.). - Programming: Strong knowledge of Python, JavaScript, or other relevant languages. Experience with multithreading, async programming, and handling large-scale data. - Anti-Scraping Measures: Deep understanding of IP rotation, proxy servers, CAPTCHAs, and other countermeasures to avoid being blocked by Amazon’s anti-scraping mechanisms. - Attention to Detail: Ability to deliver accurate and well-tested solutions with minimal oversight. Nice-to-Haves: - Experience with Headless Browsers: Familiarity with using headless browsers (e.g., Puppeteer, Playwright) to interact with dynamic Amazon pages. - Machine Learning: Experience with machine learning for detecting patterns in price changes or predicting future price trends (optional but a plus). - Prior Amazon Scraping Projects: Any prior experience scraping Amazon and handling its anti-scraping protocols will be an advantage. Start your Proposal with "My Prior Experience in this" Deliverables: - A fully functional Amazon price monitoring system that tracks price changes and notifies users. - A detailed report of the system architecture, installation guides, and any relevant documentation. - Source code and technical documentation for future updates or changes. Why Work With Us: - Challenging Project: You’ll be tackling a high-complexity project that will require innovation and technical expertise. - Collaborative Team: You’ll work closely with a team of developers and product managers to bring this project to life. - Long-Term Opportunity: A successful completion could lead to more projects in the future as we expand our platform. If you are an experienced, detail-oriented developer who enjoys tackling complex challenges and building scalable systems, we want to hear from you! How to Apply: Please provide: 1. A brief description of similar projects you’ve worked on. 2. A portfolio of relevant work or Resume + Linkedin/GitHub repositories. 3. Your approach to handling large-scale web scraping and price monitoring systems. 4. Estimated timeline for completing the project. 5. Hourly rate or project rate. Looking forward to working with you!
750.0 USD Technology & Programming peopleperhour Overseas
6 hour ago
We’re looking for a Puppeteer expert whose core strength is evading automation defenses—especially in Google Meet—by deploying stealth headless-Chrome at scale on Kubernetes. Must-Have Skills & Experience Puppeteer/Playwright Mastery 3+ years building production-grade scripts In-depth knowledge of Chrome DevTools Protocol and browser contexts Anti-Blocking Techniques Fingerprint spoofing (Canvas, WebGL, AudioContext) User-agent rotation, header & timing obfuscation WebRTC leak mitigation, proxy integration (residential/rotating) Experience with puppeteer-extra stealth plugins or custom evasion code Containerized Orchestration Packaging headless-Chrome in Docker Helm charts & Kubernetes manifests (Deployments, Jobs, HPA) Liveness/readiness probes, resource tuning CI/CD & Monitoring Automated build/test/deploy (GitHub Actions, Jenkins, etc.) Log/metrics pipelines (Prometheus, Grafana, ELK/EFK) Troubleshooting & Optimization Debugging flaky headless sessions under resource constraints Network latency management, TURN/STUN server configuration Bonus Open-source contributions to Puppeteer/Kubernetes tools Deep familiarity with Google Meet’s detection signals
25.0 GBP Technology & Programming peopleperhour Overseas
1 days ago

HuntsBot,a one-stop outsourcing task, remote job, product ideas sharing and subscription platform, which supports DingTalk, Lark, WeCom, Email and Telegram robot subscription. The platform will push outsourcing task requirements, remote work opportunities, product ideas to every subscribed user with timely, stable and reliable.

简体中文 English

Platform

Support

Links

Contact US

Any questions or suggestions during use, you can contact us in the following ways:

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.