SQL Jobs

I keep a collection of text-only records in several CSV files and need a solid validation pass before the next release cycle. The task is to build and run checks that confirm each field adheres to agreed formats, catches missing or duplicate entries, flags unexpected characters or line breaks, and produces a concise report of every issue found. You are free to use Python (pandas, Great Expectations, or similar), Bash + awk, SQL import routines—whatever gets reliable, repeatable results. Everything must run headless on Ubuntu 22.04 and be callable from the command line so it can slip into our existing CI pipeline. Deliverables: • A runnable script or notebook with clear setup instructions • A summary report (CSV or Markdown) listing all validation errors and their loca...

I’m expanding our delivery team at IMTS Enterprise Solutions Pvt. Ltd. and need Certified SAP Business One professionals who can step into assignments on a freelance, part-time, or project basis. A current SAP B1 certificate is non-negotiable because every engagement we take on requires recognised, up-to-date expertise. The work itself varies from green-field roll-outs to post-go-live support tickets and optimisation workshops, so I’m interested in consultants who are comfortable with all three core areas: • Implementation • Support • Consulting If your experience spans functional setup, technical development, or a mix of both, I can match you with projects that fit your strengths. Typical tasks include preparing project blueprints, configuring modules, ...

**Project Title: Python Data Mapping and Data Transformation Automation** I am looking for a Python developer to build a data mapping and transformation solution that can read data from CSV, Excel, JSON, or SQL sources, map source fields to target fields, transform data according to predefined business rules, and generate clean output files or load the results into a database. **Requirements:** - Develop Python scripts using Pandas for data mapping and transformation. - Map source columns to target columns based on mapping rules. - Handle missing values, duplicate records, data type conversions, and invalid data. - Perform data cleansing, validation, and error handling. - Support CSV, Excel, JSON, and SQL data sources. - Generate transformed output files and validation reports. - Write r...

I need a Python developer who is comfortable living inside Microsoft SQL Server data and turning that structured information into clean, well-documented outputs. The immediate milestones are: • Build a repeatable mapping routine that pulls source tables from SQL Server, aligns every field to a target schema, and flags any unmapped or ambiguous values for review. • Implement allocation logic so amounts, quantities or percentages are distributed across multiple target records according to business rules I will supply. Everything should run in Python 3.x, ideally using pandas and SQL-Alchemy (or pyodbc) to keep the workflow fast and transparent. Clear comments, minimal external dependencies, and a short README are part of the hand-off. I will verify the work by running your sc...

I have a volume of plain-text documents that need to be converted into structured records and uploaded directly into a database. The core of the job is straightforward: extract the relevant fields from each text file, map them to the correct columns, and load the finished records. Key points you should know: • Task focus: uploading data to a database (the extraction step is already outlined in each file). • Source format: simple text documents—consistent layout, no complex parsing required. • Database platform: I’m flexible; if you’re comfortable with SQL, NoSQL, or any reliable cloud-hosted alternative, we can work with that. Deliverables I expect: • Clean, validated records fully inserted into the target database. • A brief log o...

Looking for an experienced Power BI developer to build an interactive dashboard for project schedule performance, using monthly Microsoft Project exports to Excel.

I'm seeking an experienced developer to review SQL code for a healthcare dashboard. The dashboard is primarily focused on EOB (Explanation of Benefits) management. Key Tasks: - Review existing SQL code for logic accuracy and completeness - Ensure code meets industry best practices - Provide actionable feedback for any identified issues Ideal Skills: - Proficiency in SQL - Strong understanding of healthcare data and EOB processes - Experience with code review and optimization - Attention to detail and problem-solving skills

I have several datasets coming in from different systems where the numeric fields are stored as plain ASCII files in some cases and UTF-8 exports in others. My goal is to run solid, reproducible data analysis on them, but first they need to be cleaned and standardised. Here is what I need from you: • Build a repeatable cleaning pipeline in Python (Pandas, NumPy) that detects the file encoding, converts everything to UTF-8 where necessary, and validates that all numeric columns are truly numeric—no stray characters, misplaced separators, or locale-specific quirks. • Where the raw files already sit in SQL Server, create T-SQL or Python-based routines that achieve the same checks and corrections in-database so I can schedule them in an Agent job. • Document each s...

I’d like a crisp, recruiter-friendly LinkedIn “About” section that distills my CV into a short, formal narrative. The piece should spotlight my 5 + years in FP&A and accounting, placing particular emphasis on my budgeting and forecasting achievements while still signalling solid capability in financial reporting, reconciliations, and real-estate finance. Please weave in my hands-on expertise with Power BI, SQL, and Advanced Excel so those keywords surface naturally for both human readers and algorithmic searches. The tone must stay formal—think concise, confident, and metrics-oriented—without slipping into buzzwords or jargon overload. Deliverable • One LinkedIn summary of roughly 80–120 words that is ready to paste directly into my profil...

I’m preparing a full core-banking replacement and need a specialist who can take ownership of two critical streams: the end-to-end data-mapping strategy from our legacy systems into the new relational model and the final financial-statement reconciliation that proves every cent lands in the right place before we go live. You will design and document the mapping logic, build the ETL pipelines, and work side-by-side with our Portuguese-speaking finance and IT teams to validate each rule. Once the pipelines run, I’ll look to you to reconcile GL balances, customer positions, and every subsidiary ledger until we hit 100 % accuracy. Mock migration cycles are already planned by the wider programme team; your outputs must plug straight into those rehearsals so the data track never b...

Solutions / Integration Architect Job Title: Enterprise Solutions & Integration Architect (Core Banking / Legacy Migration) Overview: Seeking a veteran Solutions Architect to support the technical evaluation of core banking vendor proposals, handle complex infrastructure sizing (sizing), and govern middleware/API integrations during a major banking technology overhaul. Key Responsibilities: Validate and refine technical ToR requirements, removing ambiguities and optimizing vendor specifications. Architect hardware/cloud infrastructure sizing, database footprints, and middleware/SOA/Microservices connections. Oversee cybersecurity testing, system integration designs, and API orchestration with satellite systems. Required Skill Set: Extensive background in legacy-to-modern core b...

I have a live database that draws its records from several Excel and Google Sheets files. Both numeric fields (prices, quantities, IDs) and text fields (names, descriptions, notes) need to be entered, verified, and kept in sync so the system stays reliable for day-to-day operations. Everything is already digital—no papers to scan—so the job is strictly about opening the spreadsheets, comparing them against the existing tables, and keying in or correcting any missing or outdated information. Consistent formatting, strict attention to typos, and an eye for duplicate records are essential because the goal here is ongoing database updating and maintenance rather than a one-off import. You are free to use the tools you’re fastest with—Excel formulas, Google Sheets, o...

We need ongoing help expanding our existing .NET-based web application. We use MVC, C++ and SQL. The full development of this project can start any time between November 10 and January 15, but we need to finalize the concepts now and hire a developer now. Your first task will be to determine which AI tool is best suitable since our code is on a local server and not on Github. We need to add new functionality and then new reports. I want to weave AI capabilities into the product, not to replace coding effort but to speed up our development that would otherwise take longer to build. Also I want to learn from you how to use these AI tools myself. I’m counting on your experience to propose the most appropriate stack for each use case and then implement it. The immediate roadmap inc...

I have a long-running Visual Basic application that functioned perfectly until I migrated its back-end from one SQL Server instance to another. The schema, tables, and data definitions remain unchanged, yet the moment the app points to the new SQL Server database it throws a null-reference error and halts. Point it back to the original database and everything works, so the fault lies somewhere in how the code interacts with this new connection. Your task is to trace and eliminate that null error. I will supply the source code, the existing connection details, and access to both the old and new SQL Server databases so you can compare behaviour side by side. Once the fix is in place the program must compile and run without exceptions on the new database and continue to operate as it always ...

I'm looking for a developer to port existing VB6 code for a visitor management software specifically for an office building. The main function of this software is to automate the creation of visitor badges. The badges should include: - Visitor's name and photo - Company name and appointment time - Purpose of visit Ideal skills and experience: - Strong background in software development - Familiarity with SQL - Ability to integrate security features

I am looking for a specialist in ransomware recovery and Microsoft SQL Server database recovery to assess and recover an encrypted database backup. Available files: Four successive ZIP backups of the same SQL database, approximately 53 MB each. All four files were affected by ransomware and now have the extension .zip.spider50. The attackers’ ransom note, RANSOM_NOTE.html. Important limitations: The files available are the encrypted backups themselves. I do not have any unencrypted backup copies, other backup files, or the original MDF and LDF database files. Assessment and recovery must therefore be based on the four encrypted ZIP files and the ransom note, without remote access to the affected computer. Required outcome: I need ONE complete, usable database backup recovered s...

I need a desktop application built from scratch whose core purpose is solid, reliable gerenciamento de banco de dados. Think of a lightweight but professional tool where I can create, edit and maintain records through an intuitive interface rather than raw SQL commands. Scope • Platform: desktop only (choose the language or framework you feel delivers the best performance and long-term maintainability). • Primary feature set: full CRUD operations, data import/export, simple search and filter, user access control and backup/restore. • Architecture: local database is fine (SQLite, PostgreSQL or similar), yet I’m open to your recommendation if you can justify advantages. • Nice-to-have add-ons later could include API integration or reporting, so structuring ...

Turn your raw sales data stored in SQL databases into interactive, executive-ready Power BI dashboards that drive decisions and provide total clarity into your performance. What I Will Deliver: • Direct & Efficient SQL Integration: Querying your database directly or building automated ETL pipelines (using SQL/Python) for seamless data refreshes. • Robust Data Modeling: Building clean Star Schema models with well-structured, optimized DAX measures. • Executive & Drillable Dashboards: Designing clean, intuitive visual layouts with revenue trends, conversion funnels, AOV (Average Order Value), and region/product filters. • Interactive UX Features: Adding custom Tooltips, Drill-Throughs, and Bookmark navigations for non-technical leadership. • Cross-Device Opt...

We are a recruiting and staffing firm finishing a move from Bullhorn to Crelate. We have Bullhorn's final full database backup (SQL Server 2022, encrypted, about 1.8 GB) and need an experienced SQL Server person to restore it, extract specific data, match it to our existing records, and import it into our Crelate account. WHAT YOU WILL DO 1. Restore the encrypted backup on your own SQL Server instance and confirm it opens. 2. Send us record counts for contacts, companies, jobs, and notes/activities. 3. Export contacts with their email addresses and phone numbers, and export contact notes with the original author and date. 4. Match Bullhorn contacts to our existing Crelate contacts (email first, then name plus company) and create import-ready files that fill only blank emails and phon...

I manage a product team that logs every engineering and analytics task as a Jira ticket. I need a reliable specialist who can step in on a ticket-by-ticket basis and close work related to both AWS data engineering and Power BI dashboard development. On the AWS side the tickets you will pick up revolve around building or extending data pipelines and handling the transformation / ETL layers that feed our analytics stack. Expect hands-on work with typical services—think S3, Glue, Lambda, Redshift or Athena—and plenty of Python or SQL scripting to keep things automated and testable. Once the data is landed, many tickets jump straight into Power BI. Your focus there will be on stitching new data sources into existing models and turning those datasets into polished, well-documented...

The Sales Performance Dashboard provides an executive summary of business insights and interactive performance metrics. Overall, the company achieved a total revenue of $63,525.00, a total profit of $27,464.50, and a profit margin of 43.2% from a total of 372 units sold. Regionally, sales and profits vary across the East, North, South, and West territories. The South region performs the strongest with $6,915.00 in profit and 82 units sold, closely followed by the East region with $12,800.00 in sales revenue and 98 units sold. The North region accounts for $13,140.00 in sales revenue across 26 units, while the West region records the lowest overall performance with $6,900.00 in sales revenue and 53 units sold. Product distribution is categorized into three main segments: Electronics, Ho...

This project centers on designing, building, and maintaining production-grade data pipelines that move and transform large volumes of structured data. I’ll rely on your expertise in SQL, Python, and modern ETL orchestration to collect, process, and serve datasets reliably, while enforcing rigorous data quality and governance standards. Infrastructure expectations • Cloud: the core deployment targets are AWS and Google Cloud Platform, so solutions should align with services such as S3, RDS, Lambda, BigQuery Storage API, or similar offerings on those clouds. • Warehouse layer: Snowflake will be the single source of truth; pipelines need to load, model, and optimize data within that environment. • Workflow optimisation: automated monitoring, logging, and alerting sho...

I need a purpose-built system that lets our firm track the financial health of several simultaneous infrastructure projects while also keeping each partner’s stake crystal-clear. The heart of the platform must be a robust General Ledger tied directly to live Accounts Payable/Receivable activity and an always-updating Budget Tracking module. Every transaction should post once and ripple through job cost reports, cash-flow views, and partner-specific statements without manual re-entry. On the project-controls side, I want to see Resource Allocation and Progress Tracking woven into the same database, so labour hours, equipment usage, and materials consumed update cost codes automatically and flag overruns before they bite. The system has to let me switch between a portfolio overview an...

Please Sign Up or Login to see details.

Our online betting platform is built on ASP.NET with a SQL Server back-end. I need the account statement module modified so that user balances reliably display as profitable and the same figures are reflected in the master / admin panel for auditing. You’ll be working directly in the existing codebase, updating database procedures or C# business-logic layers as required. Clean, traceable changes are essential; after deployment I should be able to track every adjustment to the statement through the admin interface and confirm totals against the underlying transactions. Please respond with a brief outline of related ASP.NET + SQL Server experience and how you would approach updating financial calculations or data presentation while keeping historical data intact. I’ll grant a...

I have a single 105 GB Oracle Data Pump backup (.dmp). Using only the regular database account that came with the file (no system or admin user) I want to expose about twenty-five specific tables through a simple web interface and run it on my Windows server. The solution has to be written in ASP.NET Core MVC with or a comparable Oracle driver so I can extend it later. For now the interface only needs to display the data: clean grid, quick pagination, optional column sorting—no editing required at this stage. Because I am uncertain of the dump’s original Oracle version, part of the work will be getting the file imported or otherwise made readable under a current Oracle installation without requiring SYS privileges. I will provide: • the .dmp file, • the user na...

I’m putting together a fundamentals-level SQL program for an international group of beginners and I need an instructor who has real-world experience writing queries day-to-day. The goal is to walk participants through core concepts—tables, SELECT statements, WHERE, JOIN, GROUP BY, simple subqueries—so they leave confident enough to explore data on their own. All sessions will be delivered live online in English, so you should be comfortable presenting over Zoom or a similar platform, fielding questions on the spot, and adapting your pace if the group needs extra clarification. I will handle scheduling and participant logistics; you bring engaging explanations, clear slides, and practical demos that work on any standard SQL engine (MySQL, PostgreSQL, SQL Server, or SQLite...

Project Title: Informatica IDMC/CDI Oracle Cloud ERP Data Migration – Technical Job Support I am looking for an experienced Informatica IDMC/IICS CDI professional to provide hands-on technical guidance and job support for an Oracle Cloud ERP data migration project. Required Skills: - Strong experience in Informatica IDMC/IICS Cloud Data Integration (CDI). - Creating and troubleshooting mappings, mapping tasks, and taskflows. - Strong Oracle SQL and PL/SQL knowledge. - Experience with Oracle EBS 11i/R12 and Oracle Fusion Cloud ERP. - FBDI file generation and data migration. - Data validation, reconciliation, error handling, and troubleshooting. - Experience migrating data from legacy ERP systems to Oracle Cloud ERP. Expected Support: - Practical, hands-on technical guidance. - As...

Our online education portal, , is powered by Python—primarily Django with a couple of small Flask services—and everything funnels through a single PostgreSQL instance. Traffic and course data have grown quickly, and the database layer is now the clear bottleneck. What I need is a specialist who can dive into our existing REST-driven codebase, profile the slow spots, and leave us with a noticeably faster, more stable platform. You’ll be looking at query plans, indexes, connection pooling, and any ORM patterns that might be hurting us. If you prefer working directly in SQL rather than through Django’s ORM when performance calls for it, that’s fine; the end goal is speed and reliability. While the stack is firmly Python/PostgreSQL, I’m open to discussing...

My production backend, built with Node.js and Express, has begun throwing API-level errors whenever it calls certain third-party services. I need someone who can dive into the existing SQL-based data layer, trace the root cause, and then patch or rewrite the integration logic so responses return cleanly and consistently. The work will involve tracing stack traces, profiling slow SQL queries that may be compounding the issue, refreshing outdated code that interacts with external APIs, and writing automated tests to confirm nothing else breaks once the fixes go live. You are free to recommend better patterns, libraries, or small architectural tweaks as long as they stay compatible with the current stack. Because the exact scope may expand once we uncover hidden bugs, I’m open to eith...

I’m setting up a training wing for my new start-up in Tamil Nadu and need seasoned instructors who can take full ownership of course creation and delivery. Right now the priority subjects are Power BI with SQL, Artificial Intelligence, and Python, but I’m happy to speak with professionals in any modern software stack that could enrich our catalogue. Your role is to design an engaging syllabus, run live sessions (online, on-site, or blended), and make sure every learner walks away able to solve real-world problems with the tools you teach. Deliverables • Detailed course outline with learning outcomes • Slide deck, hands-on labs, sample data/code, and assignments • Live training sessions scheduled in mutually convenient slots • Short quizzes and a ca...

I’m preparing a predictive analytics initiative for a finance-focused dataset stored in traditional relational tables and well-formatted spreadsheets. The core objective is to turn this structured historical information into forward-looking insights—think probability scores for default, churn, or other key risk and revenue indicators. You will take ownership of the full machine-learning pipeline: data ingestion from CSV/SQL sources, exploratory analysis, feature engineering, model selection and training, validation, and a concise performance report. I expect reproducible Python code (preferably using pandas, scikit-learn, XGBoost or similar), clear comments, and a short write-up that explains both the methodology and how to refresh the model with new data. Deliverables: &bull...

I need an SSRS specialist to create production-ready tabular reports that pull live data from our SQL Server database. You will work from an existing schema, write or refine the underlying T-SQL, and build clear, parameter-driven layouts that can be deployed straight to our Reporting Services instance. Key deliverables: • RDL files for each finished report • Associated SQL scripts or stored procedures • Brief deployment notes and usage documentation Each report must render quickly, show accurate aggregates, and respect our existing security model once published to the server. If you have solid experience with SQL Server Reporting Services and enjoy turning raw tables into clean, consumable output, let’s get started.

Developed a Pharmacy Management System using SQL to design and build a relational database for managing essential pharmacy operations and data. The project includes tables for Suppliers, Drug Categories, Medicines, Pharmacists, Invoices, and Invoice Details, with properly defined Primary Keys, Foreign Keys, and relationships between tables. Implemented data insertion, retrieval, filtering, sorting, and modification using SQL queries, including Aggregate Functions, GROUP BY, JOINs, and Subqueries, as well as INSERT, UPDATE, and DELETE operations. Technologies: SQL Server, Database Design, Relational Databases, SQL Queries.

I need help moving a collection of existing Excel spreadsheets—containing both text and numerical fields—into my central database. Your task is to take each file, check that every value matches the column headers provided, correct simple inconsistencies where they appear, and then import the cleaned data so it sits exactly where it belongs in the target tables. Deliverables: • Cleaned, validated versions of the original Excel files • An import script or step-by-step notes showing how you loaded the data into the database • A brief completion report confirming record counts before and after the migration If you are comfortable working with mixed data sets and have solid experience in Excel plus any mainstream SQL database, this job should be straightfo...

I need help moving a collection of existing Excel spreadsheets—containing both text and numerical fields—into my central database. Your task is to take each file, check that every value matches the column headers provided, correct simple inconsistencies where they appear, and then import the cleaned data so it sits exactly where it belongs in the target tables. Deliverables: • Cleaned, validated versions of the original Excel files • An import script or step-by-step notes showing how you loaded the data into the database • A brief completion report confirming record counts before and after the migration If you are comfortable working with mixed data sets and have solid experience in Excel plus any mainstream SQL database, this job should be straightfo...

I need my application wired to a back-end database so that every new or changed record is reflected instantly on the front-end dashboards. Real-time updates are the only reporting style I will accept; batch or scheduled exports will not meet the requirement. The core work involves: • Connecting the chosen data store to my existing codebase (language-agnostic at this stage; you may recommend SQL, NoSQL, or an in-memory solution after reviewing my load profile). • Building the live data pipeline—triggers, change streams, or pub/sub—as appropriate. • Rendering the real-time views in a lightweight reporting layer so end-users see changes within seconds. • Supplying clean, well-commented code and a short deployment guide that lets me reproduce the setu...

I need a specialist who can wire several production-level databases together so that information flows in real time, is captured accurately, and remains easy to trace long after it lands in storage. The job starts with building the live integration layer: connections, transforms, and routing must update immediately as changes occur in the source databases (no batch or nightly jobs). Once the stream is flowing, I want a solid verification routine to run alongside it. Data consistency checks should flag mismatches, duplicates, or missing fields the moment they appear, then write clear exception logs I can review. This audit trail will be the backbone of weekly compliance reviews. All incoming files—whether produced by the integration or uploaded manually—should sit in an organi...

busco un mentor virtual que me ayude a acprender a utilizar PowerBI. Mi objetivo es: • Crear dashboards completos y pulidos basados en datos de operaciones de la empresa Necesito sesiones remotas programadas, ejercicios prácticos con archivos .pbix de ejemplo y retroalimentación clara después de cada actividad. Valoro una metodología que combine explicación teórica breve con práctica inmediata sobre mis propios conjuntos de datos operativos. Espero que el mentor proponga un plan de estudio progresivo, provea recursos adicionales (plantillas, enlaces oficiales, mejores prácticas) y mida mi avance con pequeños retos o mini-proyectos. Experiencia demostrable enseñando Power BI a usuarios basicos e intermedios...