Ssis microstrategy일자리

필터

내 최근 검색 기록
필터링 기준:
예산
최대
최대
최대
유형
보유 기술
언어
    프로젝트 진행 단계
    2,000 ssis microstrategy 건의 일자리 확인, 급여 기준: USD

    Looking for an experienced MSBI and powerbi developer. You would be working with me to troubleshoot and optimize an existing MSBI solution and powerbi report. Your tasks include but are not limited to: - Data Modeling - ETL Development - Report Development For this project, your primary tools would be: - SQL Server Integration Services (SSIS) - SQL Server Analysis Services (SSAS) - power bi Your experience and skills in these areas will be critical to the success of our project. Only serious and high-quality professionals need apply. This is a challenging role and previous experience in the given areas is a must. Let's enhance our MSBI solution together and make it the best it can be.

    $147 (Avg Bid)
    $147 (평균 입찰가)
    2 건의 입찰

    I need an SQL and SSIS developer for my personal project. My primary goal is to optimize my SQL database, which is currently facing several performance issues. Key Problems: - Slow query execution - High resource consumption - Inefficient indexing The ideal candidate should have a strong background in SQL and SSIS for database optimization. A thorough knowledge of SQL query optimization, resource management, and indexing is essential. I am seeking an expert who can effectively address these specific issues and enhance the overall efficiency of my SQL Server development. Any suggestions for further improvements are also welcome.

    $166 (Avg Bid)
    $166 (평균 입찰가)
    18 건의 입찰

    As the project owner, I urgently need a skilled SQL Server and SSIS (SQL Server Integration Services) Developer to propel my database optimization objectives. Your primary tasks will focus on: - Fine-tuning SQL queries - Carrying out schema optimizations - Development using SQL I'm currently dealing with several performance issues, including slow query execution, high disk I/O, and index fragmentation. Therefore, for this task, the ideal candidate should possess a sharp understanding of query tuning and optimization, as well as practical experience with complex SQL Server and SSIS development projects. If you have proven experience in eliminating these types of issues and know how to implement effective optimizations, I am eager to work with you. Your high-level SQL...

    $103 (Avg Bid)
    $103 (평균 입찰가)
    21 건의 입찰

    I'm seeking a developer skilled in SSIS, C# and SQL for this project. The task involves fetching JSON data from an API using oauth with a username and password. This data will then need to be written to a SQL table. The main specifications are: - API provides JSON data - Only specific fields are required from the JSON data for the SQL table write operation - These fields are constant and will not change in the future Confident understanding and experience with JSON, C#, API fetch, SSIS, and SQL are paramount. The ideal candidate will be adept at creating smooth integrations, dealing with API provided data and handling SQL scripts.

    $197 (Avg Bid)
    $197 (평균 입찰가)
    15 건의 입찰

    As an organization, we are aiming for proficient data analysis and reporting using the SQL database, which is below 1GB. We need an experienced professional with skills in: - Writing strong SQL queries - Developing effective SSIS packages - Creating insightful SSRS reports This project primarily focuses on enhancing our data comprehension and subsequent reporting, thus requiring a thorough command of SQL related tasks. The suitable freelancer for this job should possess strong analytical skills and have a proven track record of database management and optimizing results.

    $31 (Avg Bid)
    $31 (평균 입찰가)
    28 건의 입찰

    For my project, I require a senior MSBI developer well versed in both SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services). The main focus of the project will be: - Data Integration: Consolidating and transforming data from various sources - Data Analysis: Interpreting the integrated data and turning it into insightful information The ideal candidate should have: - More than five years of experience, with specific skills in SSIS and SSAS - A proven track record of handling complex data integration and analysis efficiently - Demonstrated proficiency in translating business requirements into solutions - Excellent problem-solving skills and the ability to work under stringent timelines.

    $15 (Avg Bid)
    $15 (평균 입찰가)
    5 건의 입찰

    ...messages in designated conversation threads on the Feishu chat application. Key job requirements include: * In-depth knowledge of Feishu API integration * Experience with server-side scripting for automated messaging systems * Familiarity with Feishu chat workspace, channels, and threads The system should be able to send: * Regular text messages * File attachments * Notifications regarding SSIS Job Failure or Success Your work will be instrumental in improving team communications by establishing instant Feishu alerts for both successes and failures. Please take into account that this system must support continuous, long-term operation. Please bid if you can confidently meet these requirements. Your proposal should detail your previous experience and the strategy you propose...

    $75 (Avg Bid)
    $75 (평균 입찰가)
    2 건의 입찰
    SSIS Expert 종료 left

    I am in need of an SSIS expert to assist me. I have multiple packages and I am unable to find out which package is loading my main table. Also I need to know the need for service account in running a job. Few other queries related to ssis jobs and package deployment. Can specify the details over call.

    $12 (Avg Bid)
    $12 (평균 입찰가)
    12 건의 입찰

    I'm in need of experienced assistance for my SSIS 2019 as I'm encountering a buffer allocation error during my data loading activities. Despite having no recent changes to the SSIS package, this persistent issue has perplexed me. I'm in need of a proficient SSIS developer that can: - Diagnose the buffer allocation error - Resolve the issue proficiently to avoid recurrence - Ensure smooth data loading operations in SSIS Your deep-rooted knowledge in SSIS and its working will be critical in solving this complex issue. Any specific experience in dealing with buffer allocation errors in SSIS 2019 would indeed be a plus. You should be able to work without supervision to rectify this issue. Let's collaborate if you fit these requir...

    $20 (Avg Bid)
    $20 (평균 입찰가)
    8 건의 입찰
    DB Architect: 종료 left

    ...ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ü Must have ability to conceptualize ideas and data streams to schemas. ü Expert at ETL transformations using SSIS. ü Good knowledge of analytics tool like AWS Quick Sight. ü 4+ Years of proven experience working with high volume multi-client SAAS solutions. ü Must be expert at communicating technical issues to non-business users. ü Must have business-oriented thought process. ü Proven expert at setting up standards and coding process ü Must h...

    $1544 (Avg Bid)
    $1544 (평균 입찰가)
    15 건의 입찰

    ...must. - Extensive experience with **.Net Core** and **Entity Framework** to efficiently manage our project needs. - Strong knowledge of both **MySQL and SQL** for effective database management. - Fluent in **Bootstrap**, **HTML5/CSS3** to ensure our applications are responsive and visually appealing. - Capable of utilizing **Jquery** and **Angular** for front-end development. - Experience with **SSIS** and **SSRS** for SQL server integration and reporting services. - Proficiency in developing **web services** and willingness to learn or work with **3rd party APIs** as per project needs (precise APIs will be discussed later). **Project Goals:** We aim to enhance our current applications and possibly integrate new functionalities to improve our services. The ideal candidate should...

    $15 / hr (Avg Bid)
    $15 / hr (평균 입찰가)
    50 건의 입찰

    ...Services (SSIS,SSRS,SSAS). While expertise in other MS BI areas is appreciated, SSIS should be your main strength. Tasks will revolve around data modeling and visualization, report creation and customization, as well as data integration and ETL processes depending upon the demand of the projects on hand. Please note, however, that all the mentioned tasks are equally important in this role. Ideal candidate should: - Have proven experience with Power BI and SSIS,SSRS - Be comfortable tackling both the big picture and diving into the details - Provide examples of past work showcasing their expertise in these areas The key to a successful application is a concise, detailed description of your experience with the aforementioned technologies. Draw emphasis on your wor...

    $2409 (Avg Bid)
    $2409 (평균 입찰가)
    3 건의 입찰

    Hello, I've been working as a data engineer at a technology consultancy firm for a year. I'm looking for a men...situations. Apart from that, I will handle the jobs on my own. My goal is to create a win-win strategy by combining the mentor's knowledge with my dedication to work and learning. If interested individuals reach out, we can discuss the details, and I am open to different offers. Regarding my expertise, I have worked on ETL, ELT, and DWH projects. The tools I have used so far include SQL Server, T-SQL, SSIS, Azure Data Factory, Oracle SQL, Apache Airflow, Apache Spark, Power BI, etc. I am an open-minded person eager to learn and extremely enthusiastic about personal development. I believe that by finding the right mentor, we can achieve great things togeth...

    $30 (Avg Bid)
    $30 (평균 입찰가)
    4 건의 입찰

    I need a proficient freelancer who exhibits excellent expertise in SQL Server and SSIS. Key tasks include: - Writing intricate SQL database queries - Designing and implementing ETL processes Specific features for these tasks must include data validation and cleansing to ensure the highest quality and most reliable data possible. You'll be handling structured data such as SQL and spreadsheets. The ideal freelancer would have extensive experience in handling and manipulating structured data, with a strong foundation in error handling, logging, and performance optimization.

    $41 (Avg Bid)
    $41 (평균 입찰가)
    36 건의 입찰

    We are looking for a . Net Developer with min 5+ of experience, for 06 months contract, who can support us for 8 hours in a day over fixed schedu...package/system evaluation, back-end and front-end development. Nice to have 1-year experience on Angular 2+. Nice to have experience working with MS Azure. C#, Web API Web service .NET core .Net with Web API C# LinkQ Entity framework 6.0 Mock unit testing .Net Framework 4.0 and above, Visual (2019) SQL Server 2016 and above HTML/CSS, AJAX, jQuery, JSON, JavaScript GIT repository, BitBucket SSIS (SQL Server Integration Services) packages Experience working in Scrum teams Familiar with Design patterns. Hands on experience with design pattern will be plus. A Good understanding of OOP principles A good understanding of N-tier architecture

    $1813 (Avg Bid)
    $1813 (평균 입찰가)
    53 건의 입찰

    I am in need of a skilled tutor who can help me enhance my abilities in data integration and ETL (SSIS), reporting and visualization (SSRS), and database querying and management (TSQL). My main goal is to improve data integration processes. In this project: - You will support my learning to drive more efficient data integration operations. - In-depth knowledge and practical training on how to generate insightful reports and visualizations will be expected. - The training must cater to an intermediate level familiarity with SSIS for data integration. Ideal Skills and Experience: - Experience in SSIS, SSRS, and TSQL. - Ability to impart knowledge effectively. - Experience working with intermediate learners. - Familiarity with different learning styles.

    $14 / hr (Avg Bid)
    $14 / hr (평균 입찰가)
    16 건의 입찰

    ...with a size of less than 100MB. Preferred Method for Data Import: - I don't have a specific preference for the method of data import. The freelancer can choose between SQL Server Integration Services (SSIS) or Bulk Copy Program (BCP) based on their expertise and recommendation. Project Completion Timeframe: - I need this project to be completed as soon as possible (ASAP). Skills and Experience Required: - Proficiency in working with MS Access and SQL Server databases. - Experience in importing and migrating data from MS Access to SQL Server. - Knowledge of SQL Server Integration Services (SSIS) and/or Bulk Copy Program (BCP) would be beneficial. - Attention to detail and ability to ensure data integrity during the import process. If you have the required skills an...

    $93 (Avg Bid)
    $93 (평균 입찰가)
    31 건의 입찰

    Hi All, We are looking for resources who can help us with our client project. Requirement 1:- Experience – 12 + yrs Contractor – Long term Start Date – Immediate Budget - 80k Mandatory Skills – Power BI, SSIS,SSRS, CRM application ( Finance , payment gateway modules ) pref MS Dynamics, good knowledge in Snowflake,SQL Requirement 2:- Role 2: SAP Vertex Consultant Type: Contract; 6+ months Location: Remote Exp: 10+Yrs 5PM to 1AM IST Budget - 80k JD: Roles & Responsibilities: Configure and implement SAP Tax Vertex solution to meet the organization's tax compliance requirements. Collaborate with cross-functional teams to gather tax-related requirements and provide expert guidance on tax solutions. Maintain and enhance tax-related configurations withi...

    $2025 (Avg Bid)
    $2025 (평균 입찰가)
    11 건의 입찰

    PLEASE READ ATTCHCHD FILE. I am looking for a freelancer who can help me with SSIS and SSRS tasks. Specifically, I need assistance with designing and developing ETL packages. Ideal Skills and Experience: - Strong knowledge and experience with SSIS and SSRS - Proficiency in SQL Server 2019 - Experience in designing and developing ETL packages - Familiarity with creating and managing data sources and reports - Ability to troubleshoot and optimize existing packages and reports In this project, I have existing databases that need to be integrated. Therefore, the freelancer should be able to work with existing databases and ensure smooth integration with the ETL packages and reports.

    $186 (Avg Bid)
    $186 (평균 입찰가)
    17 건의 입찰

    I am looking for a skilled SSIS developer to assist me with loading data from a CSV flat file into a SQL database. i am Doing first time in my PC and I am getting Error, I am looking some to take my remote and load it. also can understand me why this error was showing so wants to learn as well. Have around 5 table around 200 Mb Size File Format: CSV & Flat File Transformations and Data Cleansing: None required Database Size: Small (less than 1GB) Skills and Experience: - Proficiency in SSIS (SQL Server Integration Services) - Strong knowledge of ETL (Extract, Transform, Load) processes - Experience in loading data from CSV files into SQL databases - Familiarity with data mapping and data validation - Understanding of database structures and SQL queries - Attenti...

    $16 (Avg Bid)
    $16 (평균 입찰가)
    22 건의 입찰

    I am in need of help with a SSIS deployment. Specifically, I need help setting up the deployment environment. I have an existing setup of SSIS 2014 or later already set up. I need help troubleshooting any deployment issues, and optimizing performance. Please help me with this project.

    $6 / hr (Avg Bid)
    $6 / hr (평균 입찰가)
    11 건의 입찰

    I am looking for an experienced MicroStrategy Developer to assist with finalizing a messy/unfinished BI implementation. The database structure is highly complex, and the work will involve troubleshooting and fixing errors in the existing implementation. I have access to the necessary documentation and resources for the project, so more advanced skills may not be needed for this particular task. However, I am open to hearing from any applicants who feel that they can offer a valuable contribution to the project.

    $55 / hr (Avg Bid)
    $55 / hr (평균 입찰가)
    13 건의 입찰

    ...service account called 'saCassAppsPrd' SQL Server, SSIS and SQL Agent services run with this service account. This service account has access network drive where input files are placed. When I run the SSIS package which reads an excel from the network drive, it returns an error message . File System Task:Error: An error occurred with the following error message: "Access to the path ' corpIOOFOperationsMelbourneComplaintsP&I ComplaintsReporting & InsightsConnected Data Sets AtlasDaily_Output' is denied.". Is there anything am I doing wrong, how can I fix this error? Specific requirements for the project include: - Importing data from files using SSIS - Preferred method for importing data is SSIS, specifical...

    $20 (Avg Bid)
    $20 (평균 입찰가)
    19 건의 입찰

    I am looking for a skilled developer who can recreate an old SSIS package that was originally created on SSIS 2008. I have the original source code available for reference. Project Requirements: - Expertise in SSIS 2008 - Ability to recreate the package based on the provided source code - Familiarity with improving efficiency in SSIS packages The desired outcome of the project is to have an updated SSIS package that demonstrates improved efficiency compared to the original version. If you have experience in SSIS 2008 and are confident in your ability to recreate and optimize the package, please submit your proposal.

    $135 (Avg Bid)
    $135 (평균 입찰가)
    2 건의 입찰

    Interfell CORP está buscando un desarrollador SQL (Bilingüe) Conectamos profesionales de TI con las mejores empresas de Latinoamérica, USA y Europa. ?Compensación: USD 3.3k-3.75k / mes ?Ubicación: En remoto. Lunes a Viernes de 9am a 5pm (US/Eastern) ?Habilidades: ·SSIS (SQL Server Reporting Services) ·Transact-SQL ·Recuperación de datos ·Trabajo en equipo ·Resolución de problemas ⭐Requerimientos: ·Mínimo de 3 años de experiencia trabajando como MS SQL Server Developer ·Dominio avanzado del idioma inglés y español (Excluyente) ·Aplica aquí:

    $5350 (Avg Bid)
    $5350 (평균 입찰가)
    7 건의 입찰

    ...platform, Student Information System, and related web products such as JICS and eLearning. working with an academic learning management system (LMS) such as Canvas or Blackboard. developing/integrating with Web Services using REST APIs or other web protocols (SOAP, HTTP). proficiency working with a client/server database system such as SQL Server, including T-SQL, SSIS packages, and data reporting tools. developing server and/or client-side data-driven solutions using one or more of the following technologies: ASP.NET, C#, HTML5, CSS, XML, jQuery, Node.js. Required Education/Experience: A Bachelor’s degree in a relevant technology field and a minimum of 2 years of applicable work experience in web design and web programing or an equivalent combination

    $328 (Avg Bid)
    $328 (평균 입찰가)
    27 건의 입찰

    ...platform, Student Information System, and related web products such as JICS and eLearning. working with an academic learning management system (LMS) such as Canvas or Blackboard. developing/integrating with Web Services using REST APIs or other web protocols (SOAP, HTTP). proficiency working with a client/server database system such as SQL Server, including T-SQL, SSIS packages, and data reporting tools. developing server and/or client-side data-driven solutions using one or more of the following technologies: ASP.NET, C#, HTML5, CSS, XML, jQuery, Node.js. Required Education/Experience: A Bachelor’s degree in a relevant technology field and a minimum of 2 years of applicable work experience in web design and web programing or an equivalent combination

    $291 (Avg Bid)
    $291 (평균 입찰가)
    25 건의 입찰

    Data Engineer with SQL, Powerbi, Cloud experience I am looking for a skilled data engineer...looking for a skilled data engineer with 5+ experience in Microsoft SQL Server to assist me with creating reports and dashboards using PowerBI 5hoursday for 5 days in a week in CST morning time Skills and Experience Needed: - Strong proficiency in Microsoft SQL Server - Experience in creating reports and dashboards using PowerBI - Familiarity with data migration and data analysis. Experience in SSIS - Knowledge of cloud platforms (Azure, AWS, etc.) is a plus Project Requirements: - The main goal of this project is to create reports and dashboards using PowerBI. - The expected deliverable format is a PowerBI Dashboard. If you have the necessary skills and experience, please apply for thi...

    $1255 (Avg Bid)
    $1255 (평균 입찰가)
    24 건의 입찰

    ...Table. Create the Stored Procedure Transaction to summarize the data to a table (DailySalesChanges table). The table will be used to create an SSIS project to export the data to excel. The table will include a column for RunDate with the current timestamp. Update the DataWarehouse with Sales and add Sales for Persons. Include the current date and time, the member’s name, address, summarized metric name, value before update, value after update Create the Stored Procedure Transaction to summarize the data to a table (SalesPerformance table). The table will include a column for RunDate with the current timestamp. The table will be used to create an SSIS project to export the data to excel. The process needs to run automatic using Sql Server Agent with Sql Server ...

    $24 (Avg Bid)
    $24 (평균 입찰가)
    14 건의 입찰

    Need someone to build azure pipeline in synapse using rest api. ssis background preferred.

    $212 (Avg Bid)
    $212 (평균 입찰가)
    14 건의 입찰

    For AdventueWorks add summary for people with sales. Determine which people will be of most interest to managers, export those records to excel, summarize the records, add the people to the people table to retain sales data. Total sales by person for the end of the day. Use T-SQL to add sales for the end of the day to the Data-Warehouse Show changes from day to day, record the changes in a changes by day table. AdventureWorks2008R2 and AdventureWorksDW2008R2 Visual Studio 2022 Sql Server 2019 You can message me if you want the links for the AdventureWorks datbases on the Microsoft Website Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login remote and work on my re...

    $42 (Avg Bid)
    $42 (평균 입찰가)
    6 건의 입찰

    Add data cleansing to T-SQL scripts for peoples demographic data. Some examples to check for are format for zip code, email address, and proper capitalization. For records with errors add those to the table for InValid records with a comment of what the error is. You can add a column to that table to add the error type. For records that are valid add those to a table for valid records. I have created the tables and have the create scripts for those. I have also created some data cleansing like checking for duplicates. Make recommendations on what further data cleansing should be added. There might be a data cleansing project for AdventureWorks on the web or github you could use that and make any comments on it you think wold be better. Message me and I will send you the scripts I have so f...

    $37 (Avg Bid)
    $37 (평균 입찰가)
    6 건의 입찰

    Remote help with Data Cleansing, Data Transformation, Data De-normalization. I'm doing that now with T-SQL and want to know if there's a more automated way. The database is a test database on my local machine from AdventureWorks. I will send you the script I'm writing for De-normalization and data cleansing if you message me. You can consider the project complete when you are able to create a SSIS, and SSAS project and it compiles and works and if you can recommend a few ways to automate de-normalization and data cleansing other than writing a T-SQL script. Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login remote and work on my remote machine....

    $22 (Avg Bid)
    $22 (평균 입찰가)
    4 건의 입찰

    Add data cleansing to T-SQL scripts for peoples demographic data. Some examples to check for are format for zip code, email address, and proper capitalization. For records with errors add those to the table for InValid records with a comment of what the error is. You can add a column to that table to add the error type. For records that are valid add those to a table for valid records. I have created the tables and have the create scripts for those. I have also created some data cleansing like checking for duplicates. Make recommendations on what further data cleansing should be added. There might be a data cleansing project for AdventureWorks on the web or github you could use that and make any comments on it you think wold be better. Message me and I will send you the scripts I have so f...

    $40 (Avg Bid)
    $40 (평균 입찰가)
    3 건의 입찰

    Create a data warehouse for the AdventureWorks Person tables. Make recommendations on what the best fact table and dimension tables will be. I'm using AdventureWorks2008R2 and AdventureWorksDW2008R2 from the Microsoft downloads. I will send you the download link if you message me. Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. When you can complete the project? I need the project complete in 48 hours. Confidentiality. a) No Use. Recipient agrees not to use the Confidential Information in any way. b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof. c) Protection of Secrecy. Recipient agrees to take all steps reasonably necess...

    $45 (Avg Bid)
    $45 (평균 입찰가)
    5 건의 입찰

    I am seeking a freelancer to design a betting website, specifically a straightforward lottery system, with a substantial emphasis on security. It's crucial to engage with a professional who possesses deep knowledge and experience in the field. The visual appearance (front end) of the site will be straightforward and uncomplicated. Howev...efficient and secure. My topmost priority is to ensure the site's operability, speed, and above all, security. It's paramount that client funds remain unhackable, and all aspects related to the database, login, and payment methods are safe for users. Necessary requirements: HTML NoSQL Couch & Mongo XSS (Cross-site scripting) PostgreSQL Database Development Web Security API Azure Cloud Security SSIS (SQL Server Integration Ser...

    $1491 (Avg Bid)
    $1491 (평균 입찰가)
    56 건의 입찰

    I am looking to hire experienced candidates with specific technical skills for Microsoft D365 developer. Ideal candidates must have SQL Server Database, writing SSIS Packages, Integration of D365 with third party applications. This will be a good opportunity to earn good income.

    $1491 (Avg Bid)
    $1491 (평균 입찰가)
    17 건의 입찰
    Sql server 종료 left

    I am looking for a skilled SQL Server developer for a project involving database design and development. The ideal candidate should have experience in query optimization and performance tuning, as well as data migration and integration. Tasks: - Database design and development - Query optimization and ...design and development. The ideal candidate should have experience in query optimization and performance tuning, as well as data migration and integration. Tasks: - Database design and development - Query optimization and performance tuning - Data migration and integration Setup: - I need a new SQL Server setup Technologies: - Proficiency in Transact-SQL is required If you have experience in SSIS and SSAS, it would be a plus. Please provide examples of your previous work in S...

    $33 / hr (Avg Bid)
    $33 / hr (평균 입찰가)
    61 건의 입찰

    I am looking for a freelancer to help me create a dashboard using Microstrategy. I'm targeting this dashboard to be viewed solely on a web interface, and only 1-10 users will be able to access it. I need the dashboard to have data visualization capabilities, interactive filters, and real-time data updates. To sum it up, I want to be able to have comprehensive and up-to-date insights on whatever data I choose, all on a web layout.

    $12 (Avg Bid)
    $12 (평균 입찰가)
    4 건의 입찰

    SQL, SSIS, PowerBI Trainer I am looking for a trainer who can provide training on SQL, ssis, powerbi to an audience with an intermediate level of understanding. The training sessions should be 2 hours long. Requirements: - Expertise in SQL, powerbi and a strong understanding of its various aspects - Proven experience in training individuals on SQL - Ability to explain complex SQL concepts in a clear and concise manner - Familiarity with intermediate-level SQL topics such as joins, subqueries, and optimization techniques - Strong communication and presentation skills Ideal Skills and Experience: - Extensive knowledge and experience in SQL - Previous experience in training individuals on SQL, ssis - Proficiency in using training tools and resources to enhance the lear...

    $675 (Avg Bid)
    $675 (평균 입찰가)
    19 건의 입찰

    Project Description: Revisión y correcciones de código SSIS (un ETL) I am looking for a skilled professional who can help with the revision and troubleshooting of SSIS code for an existing business. The ideal candidate will have experience in working with SSIS packages and resolving any issues that may arise during the process. Key Requirements: - Expertise in SSIS (SQL Server Integration Services) - Ability to troubleshoot and resolve issues in existing running packages - Strong knowledge of ETL (Extract, Transform, Load) processes - Familiarity with project management practices Responsibilities: - Review and analyze the existing SSIS code - Identify any errors or inefficiencies in the code - Troubleshoot and resolve issues in running pa...

    $39 / hr (Avg Bid)
    긴급형
    $39 / hr (평균 입찰가)
    8 건의 입찰
    SSIS,SQL Job 종료 left

    SSIS, SQL Job - Data Integration I am looking for a freelancer who can help me with a data integration project using SSIS and SQL Job. Purpose: - The purpose of this project is to integrate data from various sources into a database. Existing Data Source: - Yes, I have an existing database that needs to be integrated with other data sources. Data Type of Source: - The data type of the source is a database. Ideal Skills and Experience: - Strong knowledge and experience with SSIS and SQL Job. - Proficient in working with databases and integrating data from various sources. - Familiarity with data integration best practices and techniques. - Attention to detail and ability to troubleshoot and resolve any issues that may arise during the integration process. If you h...

    $23 (Avg Bid)
    $23 (평균 입찰가)
    23 건의 입찰

    Database-SQL server 2022 4 Database-SSIS 3 Database-SSAS trainer need to make the syllabus based on this topic need minimum 8 year experience daily 4hr of class

    $42 / hr (Avg Bid)
    $42 / hr (평균 입찰가)
    1 건의 입찰

    I have a University practical work, regarding data warehouse, I have to do that; ----------- Propose a topic, preferably linked to a real need that can be resolved through a data warehouse exploited through OLAP tools. The analyzed problem must have at least two measures, a maximum of ten dimensions, of which at least three must be hierarchical ...data models (OLTP). Multidimensional Model (Star Diagram). Data mapping. Design decisions, both at the data model, technology and ETL level. 2) Demo of the solution. Put together a video in which they present the assembled solution showing how the assembled model is exploited with a BI tool. It may not take more than 5 minutes. They can use any OLAP and DBMS tools, for example Power pivot, Microstrategy Analytics Desktop, Dundas, Table...

    $25 (Avg Bid)
    $25 (평균 입찰가)
    6 건의 입찰

    ...deployed at our different clients' projects from Pan India, US & UK and working with us remotely. We have expertise in various niche technologies such as; MicroStrategy, Power BI, Tableau, Data Analytics, Data Engineer, Cloud (AWS & Azure). Apart from this, we cater Hiring & Professional Services. We provide end to end recruitment solutions to leading organizations, whether they are looking for a permanent hiring, a long-term contractor, or a short-term fill in. Our Services: 1. We provide Recruitment Services for full time and contract requirements. We have a dedicated team for this. 2. We have expertise in BI tools (MicroStrategy, Power BI, Tableau). We provide end to end Analytics implementation to our clients. We have a team of engineers who c...

    $41 (Avg Bid)
    $41 (평균 입찰가)
    3 건의 입찰

    DTSX Package for SQL Server Data Transformation and Flat File Destination I am looking for a freelancer who can create a DTSX package for me. The source of the data is SQL Server, and I require data transformation or manipulation within the package. After processing, the destination for the data is a flat file. I need a professional to modify an existing dtsx file for me and amend it in SSIS so that the flat file output each time has a different time / date stamp and then return to me the finished product as a dtsx file which I am then able to call within an SQL Job. Ideal Skills and Experience: - Proficiency in SQL Server - Experience with creating DTSX packages - Knowledge of data transformation and manipulation techniques - Familiarity with flat file destinations.

    $29 (Avg Bid)
    $29 (평균 입찰가)
    8 건의 입찰
    DTSX Package. 종료 left

    DTSX Package for SQL Server Data Transformation and Flat File Destination I am looking for a freelancer who can create a DTSX package for me. The source of the data is SQL Server, and I require data transformation or manipulation within the package. After processing, the destination for the data is a flat file. I need a professional to modify an existing dtsx file for me and amend it in SSIS so that the flat file output each time has a different time / date stamp and then return to me the finished product as a dtsx file which I am then able to call within an SQL Job. Ideal Skills and Experience: - Proficiency in SQL Server - Experience with creating DTSX packages - Knowledge of data transformation and manipulation techniques - Familiarity with flat file destinations.

    $24 (Avg Bid)
    $24 (평균 입찰가)
    10 건의 입찰

    I want to zip files from a path eg "C:UserspcDesktoptesting" - zip them according to date name e.g if files = , , - result : testingJan ; testing =April -The files should be deleted once zipped Filenames should be extracted from the path. When re-executing the job it should ignore the zipfiles and only focus on other file types, in order to not reZip. This shouldn't take much time if you an expert in C#, with experience in , forEach loop

    $26 (Avg Bid)
    $26 (평균 입찰가)
    3 건의 입찰

    I want to zip files / folders in a network drive using SSIS and C# script task. The directory information as well as whether the directory contains file or folder is extracted from a sql table (execute sql task must be used) eg if directory has files then DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles zip to : DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles2022 if directory has folders then DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles20230103 zip to: DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles2023 20230103 All 2023 Jan files or folders in that directory should be zipped in one file After zipping delete the files folders I already have scripts to zip files and zip folders

    $26 (Avg Bid)
    $26 (평균 입찰가)
    13 건의 입찰