Ssis data microstrategy trabalhos
Conocimientos técnicos:<br />? Programación C#+MVC<br />? WEB services ( XML Y REST ) <br />? ORM<br />? Diagrama UML<br />? Metodologías ágiles<br />? Modelos de datos relacionales , Construcción de funciones de BD Y Procedimientos Almacenados , Optimización de modelos existentes <br />? Conocimiento de SSIS <br />Herramientas Críticas:<br />? Herramientas de control de código ( GUT, Bitbucket, TFS, SVN ) <br />? Jquery o similares <br />? JSReport, Entuty Framework o similares
Funciones:<br />* Desempeñar el rol de Analista Programador con competencias de Analista Funcional. <br /><br />Perfil Técnico:<br />Obligatorio:<br />* Microsoft Visual Studio .Net 2008<br />* Desarrollo Web en ASPX<br />* Integration Services (SSIS)<br />* Conocimientos intermedios de SQL Server 2005, 2008<br /><br />Opcional:<br />* Visual SourceSafe 6.0 y TFS (Team Foundation Server)<br />* Conocimientos básicos a medios de COM+ <br />* Microsoft Visual Studio .Net 2010
Requisitos: • Licenciatura em Engenharia Informática ou equivalente; • Experiência mínima 3 anos; • Instalação e configuração; • Administração e monitorização de SQL Server 2008/2008R2/2012/2014/2016; • Alta disponibilidade com SQL Cluster, SQL AlwaysOn, Replicações e Log Shipping; • Migração de base de dados; • Backup...restore; • manutenção de base de dados; • Análise de performance e troubleshooting; • Proatividade e disposição para aprendizagem continua; Valorizamos os conhecimentos em: • Desenvolvimento em TSQL (scripting, automação de processos, stored procedures, f...
Cerca de 10 anos de experiência business intelligence, banco de dados e desenvolvimento, participando de projetos em grandes companhias do ramo farmacêutica (Mantecorp), seguro e previdência (Mongeral AEGON, Dataprev), telecom (BRT, OI, Claro, TIM, Vivo, GVT, Algar), Gas LP (Supergasbras). Habilidades: • Administração de banco de dados SQL Server (2008R2/2012 ) • Microsoft SQL Server BI (SSIS, SSRS, SSAS, PowerBI, TSQL, DAX) • Pentaho Integration (Ketlle) • Informatica Powercenter • Modelagem de dados ( relacional e multidimensional ) • Metodologia Agil
Conhecimento da ferramenta Dynamics CRM e também habilidades em: -SSIS - SQL Server Integration Services -SSRS - SQL Server Reporting Services -SDK – Software Development Kit do Dynamics CRM. Framework -WCF -Plugins -Workflow Assemblies -Ribbon -Jscript -Desenvolvimento e Manutenção no Sistema.
Conhecimento da ferramenta Dynamics CRM e também habilidades em: -SSIS - SQL Server Integration Services -SSRS - SQL Server Reporting Services -SDK – Software Development Kit do Dynamics CRM. Framework -WCF -Plugins -Workflow Assemblies -Ribbon -Jscript -Desenvolvimento e Manutenção no Sistema.
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.
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 s...
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.
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.
...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 ...
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.
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í:
...applications. to translate business requirements into a functional design that provides an appropriate technical solution. to facilitate and schedule multiple projects concurrently. to create and maintain accurate documentation of designs, configurations, and processes. to identify issues and create resolution action plans, for both functional and data-related problems. to communicate technical information to non-technical audiences. to meet deadlines and schedules while setting priorities. to work under limited supervision following established guidelines, procedures, and timelines. to work collaboratively with other campus departments and stakeholders. to handle sensitive and/or confidential
...applications. to translate business requirements into a functional design that provides an appropriate technical solution. to facilitate and schedule multiple projects concurrently. to create and maintain accurate documentation of designs, configurations, and processes. to identify issues and create resolution action plans, for both functional and data-related problems. to communicate technical information to non-technical audiences. to meet deadlines and schedules while setting priorities. to work under limited supervision following established guidelines, procedures, and timelines. to work collaboratively with other campus departments and stakeholders. to handle sensitive and/or confidential
Data Engineer with SQL, Powerbi, Cloud experience I am 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 this project.
...Summarize data for Persons and Sales that Management will want to know. Some examples are High and Low sales for Sales Persons and for Products. Summarize the data, add the data to the Person table to maintain sales data. Show the difference in Sales by day in a DailySalesChanges 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 Creat...
Need someone to build azure pipeline in synapse using rest api. ssis background preferred.
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...
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 wi...
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 re...
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 wi...
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...
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...
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.
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 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 SQL Server.
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.
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...
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...
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 ...
I am looking for a skilled developer to help me with my project. Here are the details: Output Form...for a skilled developer to help me with my project. Here are the details: Output Format: - The desired output format for the generated file is JSON. we already have a similar kind of code. it generates JSON file for each 1 lak records. Data Extraction: - The data needs to be extracted from a database. Data Transformation: - The data needs to be transformed before generating the file. Skills and Experience: - Proficiency in SSIS (SQL Server Integration Services) is required. - Experience with JSON and database extraction is preferred. - Knowledge of data transformation techniques is a plus. If you have the skills and experience required for thi...
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
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 dimensions. Among the work deliverables are: 1) Presentation of the work carried out, which must include: Description of the organization and the context of the business. Description of the need or problem to be solved. Existing 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 vi...
WorkiFicient is an IT Software company focusing on working in Business Intelligence (BI) & Data Analytics. We have a strong team who can help our clients on end-to-end analytics implementations. We have a team of engineers who work on inhouse as well as clients’ offshore analytics projects. Apart from these engineers there are some technical consultants who got 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 th...
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 ...
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 ...
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
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
I am looking for a freelancer who can help me with a project that involves data integration, using SQL and SSIS (SQL Server Integration Services). I will need this freelancer to help me integrate data from database tables into my project. Additionally, they will need to have experience performing complex transformations and cleansing of the data. This project must be completed with the utmost accuracy and attention to detail, as the data is extremely important to me. Experience with SQL Server Integration Services is a must. If you believe you can successfully complete this project, please contact me and we can discuss the details further.
I am looking for a skilled freelancer to assist me with a SQL, SSIS and SSRS project. The main goal of the project is to perform complex data analysis on a Microsoft SQL Server database. The ideal candidate will have experience with data aggregation and analysis, as well as the ability to create SSIS packages and SSRS reports. The scope of the analysis will involve complex queries and filtering to provide insights into a large dataset. Strong skills in SQL, SSIS and SSRS are required to successfully complete this project.
...Familiarity with AWS S3 regions, specifically Asia Pacific (Sydney) I am looking for someone to help me with Microsoft SSIS, .Net integration with S3 bucket. My requirement is integrating Source System which sends flat files to S3 bucket. I got an SSIS job scheduled on a daily basis to read from the S3 bucket and download the files to local folder location and consume the files for further processing. My requirement is, I need someone with SSIS knowledge and AWS knowledge, and .Net c# Delete the files from the landing folder Read the S3 bucket location and download the file(fresh set) to a landing folder. The upstream system sends files as Zip Unzip the files Ideally, this SSIS package should have a script component, which is written in .Net C# and should...
I am looking for an Azure Data Engineer to provide job support for my data solution. Specifically, I need support with Azure Data Factory, Azure Databricks, Azure Stream Analytics, EDW, Python, SQL Server, SSIS, Oracle, Power BI, API, CRM, ERP, and DevOps. The ideal candidate should be able to design, develop, and maintain the Azure data solution. Currently, the data solution is in development and I need support to ensure its success.
SSIS Integration project for SQL Server database to Salesforce - The project involves integrating data from SQL Server database to Salesforce - Duration of the project is 2 months - Ideal skills and experience include: - Proficiency in SSIS and SQL Server Integration Services - Experience with data integration from multiple sources. Atleast 5+ yrs of experience. - Knowledge of SQL Server databases and data transformation techniques
...reliability of our data integration processes. You will collaborate closely with cross-functional teams to design and execute comprehensive testing strategies, identify and resolve defects, and optimize ETL workflows. The ideal candidate will have a strong background in data validation, ETL testing methodologies, and a passion for delivering high-quality data-driven solutions. Responsibilities: 1. Develop and implement comprehensive test strategies and plans for ETL processes, ensuring end-to-end data quality and accuracy. 2. Collaborate with cross-functional teams, including developers, business analysts, and data engineers, to understand data requirements and translate them into test cases. 3. Perform functional, integration, regression, and p...
I am looking for tutor who is Microsoft product expert, like azure, SSIS, data factory etc.
I am looking for an experienced SQL DBA who can assist me with SSIS DB restore and PowerBI. The database size is between 1GB-10GB and I need default settings for the restored database. The main purpose of the PowerBI report is for sales and revenue analysis. The ideal candidate should have the following skills and experience: - Expertise in SQL DBA and SSIS DB restore - Familiarity with PowerBI and its features - SQL and SSRS have been restored Need for urgent help. If needed we can utilize ongoing but for now, I am only looking for short-term assistance to work with our DBA. Thank you
The Exam is Only 15 Question and has a time limit of 20 minutes.
Sql Developer Experience-5+ years Major experience in Sql,TSQL,SSIS and SSRS. Remote
I am looking to hire a Freelancer to develop an SQL SSIS SSRS project. The project will involve using data from SQL Server databases as data sources. Additionally, I need the project to have ETL (Extract, Transform, Load) capabilities and reporting or analytics capabilities.
