Ssiscông việc
I have an SSIS package that pulls data from an Oracle database through an connection and loads it downstream for ETL processing. The transfer works, but network-level performance is far below what I need. Here is what I’m looking for: • Diagnose the current ADO.NET-to-Oracle connection, identify any network, buffer, or packet-size bottlenecks, and benchmark the baseline throughput. • Tune the SSIS data flow (buffers, rows per batch, commit size, async settings, etc.) and, if necessary, adjust the Oracle driver or provider configuration. • Provide an updated package or detailed change list so I can reproduce the performance gains in other environments. • Produce a concise report summarizing findings, before-and-after metrics, and next-step re...
...relationships, and indexes that align with our current Microsoft Dynamics workflows while remaining compatible with long-standing Access front-ends and SQL Server reporting. • Data migration – extract and cleanse data sitting in several internal legacy databases, then import it cleanly into the new schemas. You’ll have direct access to the existing SQL Server instances plus a handful of Access files; SSIS or your preferred migration tool is fine as long as the result is reliable and auditable. • SQL query optimisation – review the most heavily used stored procedures and ad-hoc queries. I want tangible speed gains, so expect to use execution plans, indexing strategies, and T-SQL refactoring. All work happens on Microsoft Dynamics, Access, and SQL Ser...
I need an SSIS project to run a complex SQL query across multiple SQL servers, all within the same network. The goal is to aggregate results from these servers. Key Requirements: - Develop an SSIS package to execute the SQL query. - Ensure efficient aggregation of results. - Provide error handling and logging mechanisms. Ideal Skills: - Proficiency in SQL Server and SSIS. - Experience with complex SQL queries. - Strong understanding of data aggregation techniques.
...craft interactive Power BI dashboards that spotlight Sales performance—pipeline health, revenue trends, win-loss ratios, and regional drill-downs. I expect polished visual standards, sensible DAX, and refresh cycles that won’t keep users waiting. Deliverables I need to sign off on: • SQL scripts for all new or modified database objects and the dimensional model • Automated ETL process (T-SQL, SSIS, or your preferred approach) with clear scheduling and logging • A Power BI dataset plus at least one fully-built Sales dashboard published to the Power BI Service • A brief performance and maintenance guide so the team can keep things running smoothly Acceptance criteria include sub-5-second dashboard load times on common filters and refresh jo...
...Enforce data quality, governance, and HIPAA compliance for PHI data • Automate deployments and monitoring using Terraform and AWS CloudWatch metrics and alarms • Work with Git/GitHub for version control and CI/CD workflows • Document data workflows, schemas, and operational runbooks for knowledge sharing • Support and guide production-grade pipelines built on Dagster, DBT, Airflow, AWS Glue, and SSIS Required Skills & Tech Stack: • Python (Strong) • SQL (Advanced) • Dagster, DBT, Airflow, AWS Glue • AWS: Athena, Glue, SQS, SNS, IAM, CloudWatch • Databases: PostgreSQL, AWS RDS, Oracle, Microsoft SQL Server • Data Modeling & Query Optimization • Pandas, PySpark, PyCharm • Terraform, Docker, DataGrip, VS Code •...
...Enforce data quality, governance, and HIPAA compliance for PHI data • Automate deployments and monitoring using Terraform and AWS CloudWatch metrics and alarms • Work with Git/GitHub for version control and CI/CD workflows • Document data workflows, schemas, and operational runbooks for knowledge sharing • Support and guide production-grade pipelines built on Dagster, DBT, Airflow, AWS Glue, and SSIS Required Skills & Tech Stack: • Python (Strong) • SQL (Advanced) • Dagster, DBT, Airflow, AWS Glue • AWS: Athena, Glue, SQS, SNS, IAM, CloudWatch • Databases: PostgreSQL, AWS RDS, Oracle, Microsoft SQL Server • Data Modeling & Query Optimization • Pandas, PySpark, PyCharm • Terraform, Docker, DataGrip, VS Code •...
We are looking for a Software Engineer (.NET) with strong experience in designing, developing, testing, and maintainin...role involves building efficient database solutions, creating and consuming Web APIs, and developing front-end components using JavaScript, jQuery, AJAX, HTML, and Bootstrap. The ideal candidate will maintain high code quality through unit testing/TDD and peer reviews, and possess solid skills in LINQ, Git, and Entity Framework. Bonus experience with Azure DevOps/CI-CD, React, Kendo UI, AutoMapper, SSIS, and common C# design patterns such as Singleton, Factory Method, and Abstract Factory is highly valued. Responsibilities also include collaborating with cross-functional teams, troubleshooting performance issues, and producing clear, well-structured technical docu...
I need to wire an Oracle 19c database into an ETL workflow that pull...job covers: • designing or refining the extraction logic from both SQL Server and Oracle • transforming the datasets so they match the target Oracle schema (PK/FK integrity, datatypes, time-zone handling, etc.) • loading the cleansed data into Oracle with repeatable, schedulable jobs I’m open to whichever toolchain you feel is fastest and most reliable—Oracle Data Integrator, SQL Server SSIS, Python with cx_Oracle and pyodbc, or a comparable approach—as long as the final workflow can be automated, logged, and easily handed over. Done means: the full ETL runs end-to-end without manual tweaks, error handling is in place, and I have clear deployment notes plus the source ...
I'm looking for an experienced SSIS developer to create new packages for me. The primary data source will be SQL Server, and the main operation involved will be data transformation. Key Requirements: - Develop SSIS packages from scratch - SQL Server as primary data source - Focus on data transformation operations Ideal Skills and Experience: - Proficiency in SSIS and SQL Server - Strong background in data transformation - Experience in developing SSIS packages Please share your relevant experience and approach.
I'm looking for an experienced SSIS developer to create new packages for me. The primary data source will be SQL Server, and the main operation involved will be data transformation. Key Requirements: - Develop SSIS packages from scratch - SQL Server as primary data source - Focus on data transformation operations Ideal Skills and Experience: - Proficiency in SSIS and SQL Server - Strong background in data transformation - Experience in developing SSIS packages Please share your relevant experience and approach.
I need a lightweight utility that can connect to two Microsoft SQL Server instances and move both transactional and historical data—roughly 1 GB up to 100 GB in total—from a source database to a target one. The goal is a smooth, one-click (or one-command) migration that preserves...criteria • All data—both historical (archive tables) and current transactional data—arrives intact. • Two successive runs migrate only the delta. • No blocking locks or noticeable performance hit on the live source during migration. If you’ve built similar SQL Server sync or ETL tools, please send a quick note outlining your approach and any technologies you’d leverage (e.g., SqlBulkCopy, SSIS, EF Core, or custom T-SQL). I’m ready to get star...
We are looking for a Software Engineer (.NET) with strong experience in designing, developing, testing, and maintainin...role involves building efficient database solutions, creating and consuming Web APIs, and developing front-end components using JavaScript, jQuery, AJAX, HTML, and Bootstrap. The ideal candidate will maintain high code quality through unit testing/TDD and peer reviews, and possess solid skills in LINQ, Git, and Entity Framework. Bonus experience with Azure DevOps/CI-CD, React, Kendo UI, AutoMapper, SSIS, and common C# design patterns such as Singleton, Factory Method, and Abstract Factory is highly valued. Responsibilities also include collaborating with cross-functional teams, troubleshooting performance issues, and producing clear, well-structured technical docu...
I want a clean, repeatable SSIS package that extracts data from the AdventureWorks OLTP database and populates a small star-schema warehouse. The package must: • Create and load DimCustomer and DimDate with surrogate keys and all attributes ready for analysis. • Build an accumulating snapshot fact table, AccumulatingFactOrderPerformance, capturing each order’s key milestones (order, due, ship) together with the relevant quantities. • Run both an initial full load and an incremental load that can be scheduled. • Come with SQL scripts for building the warehouse objects plus concise documentation showing package flow, configurations, and how to extend the model. Please keep the control flow modular, use best practices for look-ups and SCD handling, and...
...development in Databricks, notebooks & schema design, development, best practice and notebooks Azure Dev Ops / CI-CD Pipelines 2) Hands On in Python PySpark, Spark SQL, Delta Live + Kafka; Azure SQL DB, Azure Data Factory, Azure DataBricks, Azure Synapse, Azure Data Lake, Delta, Pyspark, Python, Logic Apps, Azure DevOps, CI/CD implementation, Power BI / QlikSense, Blob Storage, ADLS, Azure Key Vault, ETL, SSIS 3) Experience in Query Development, Performance Tuning and loading data to Databricks SQL DW 4) Experience in data ingestion into ADLS, Azure Blob Storage, Azure Logic Apps 5) Practical knowledge of data warehouse implementation – denormalization, conformance, fact, dimensions 6) Good knowledge of data visualizations best practices using either or both QlikSense a...
...development in Databricks, notebooks & schema design, development, best practice and notebooks Azure Dev Ops / CI-CD Pipelines 2) Hands On in Python PySpark, Spark SQL, Delta Live + Kafka; Azure SQL DB, Azure Data Factory, Azure DataBricks, Azure Synapse, Azure Data Lake, Delta, Pyspark, Python, Logic Apps, Azure DevOps, CI/CD implementation, Power BI / QlikSense, Blob Storage, ADLS, Azure Key Vault, ETL, SSIS 3) Experience in Query Development, Performance Tuning and loading data to Databricks SQL DW 4) Experience in data ingestion into ADLS, Azure Blob Storage, Azure Logic Apps 5) Practical knowledge of data warehouse implementation – denormalization, conformance, fact, dimensions Desired Experience: 1) 8 to 10 years of experience in Azure Data & Analytics core sk...
...supporting structures required for complete accounting traceability. Every source table must be accurately mapped, transformed, and loaded into the ACES relational model without loss of context or integrity. Data accuracy, field-level validation, format consistency, preserved timestamps, and full end-to-end auditability are mandatory. Since both environments run on SQL Server, expertise in T-SQL, SSIS (or equivalent ETL frameworks), and version-controlled script delivery is essential. Deliverables: • A comprehensive data-mapping document linking every Exact field to its ACES target. • Reusable and parameterized ETL packages/scripts for repeatable runs. • Validation routines and reports demonstrating parity of record counts, balances, and hash totals with the sourc...
...customer master and sales detail tables, so please create those structures and wire up the foreign keys accordingly. Once the data model is sound, connect it to Power BI. I want the connection set up (DirectQuery or import—whichever performs best for this volume) and a quick sample report that proves the joins are working. Deliverables • SQL Server schema (tables, keys, indexes) • ETL script or SSIS/Power Query steps that load the CSV • Added customer master and sales detail tables with working relationships • Verified Power BI file (*.pbix) connected to the database and showing a test report • Brief hand-off notes so I can refresh or extend the model on my own I’m on SQL Server developer edition and the latest Power BI Deskto...
...DP-600 workload or Databricks. The assignment centers on two core responsibilities: shaping reliable data models and building the pipelines that keep them fresh. You’ll be working mainly with SQL databases and SAP HANA as upstream sources. Inside Fabric you’ll orchestrate data movement through Pipelines and refine it in Notebooks using Python and PySpark. If you’ve touched Azure Data Factory or SSIS that’s a plus, but the real priority is confidence inside the Fabric Lakehouse, OneLake, and associated governance features. Deliverables • A well-documented Fabric|Databricks Lakehouse model aligned to the client’s business entities • Production-ready Fabric|DatabricksPipelines and accompanying Python/PySpark notebooks that load, transform,...
I receive live data on my vendor’s SMS server running SQL Server 2022 Standard. I need that 10 GB – 100 GB of data copied to my new server continuously, in real time, with no transformation—just a clean mirror. What I need you to handle: • Study both servers, security, and connectivity to decide on the best method (Transactional Replication, CDC, Always On, SSIS, or any real-time approach compatible with Standard 2022). • Build a working proof of concept, then roll it into production with minimal downtime. • Configure jobs, alerts, and monitoring so I’m notified of lag or failures and everything auto-recovers. • Supply concise documentation plus a quick rollback plan, and walk me through the setup so I can maintain it. For better...
I'm seeking an experienced SSIS professional to assist with debugging and error handling. Currently, I'm facing data flow errors, specifically with the source component. Key Requirements: - Expertise in SSIS, particularly with data flow tasks. - Strong debugging skills to identify and resolve errors. - Familiarity with various source components in SSIS. Ideal Skills and Experience: - Proven track record in SSIS package development and troubleshooting. - Ability to optimize and ensure smooth data flow. - Problem-solving mindset and attention to detail. Your assistance will help ensure the integrity and efficiency of my data processes.
...tables. 4. Separate destination tables inside OneLake SQL for each data group, with primary keys and indexes ready for reporting. 5. Error handling, logging, and a simple dashboard or log file that shows last-run status. 6. Deployment scripts plus concise documentation so my team can maintain or extend the flow later. If you have hands-on experience with Fabric pipelines, Azure Data Factory, SSIS, or comparable ETL tooling and can deliver a tested end-to-end solution, let’s talk timelines and milestones....
...Speaker C1, who can take full ownership of several SQL Server Integration Services (SSIS) packages. The core goal is to design, build, and refine these packages so that our data flows run smoothly from source systems into our reporting environment without manual intervention. You will work directly with me to: • create or enhance .dtsx packages that meet our current business logic, • troubleshoot performance bottlenecks in existing jobs, and • deliver clean, well-commented T-SQL and SSIS configurations ready for deployment. Please include a short note on past SSIS work you have completed and any approaches you use to keep packages maintainable and performant. Final deliverables are the updated SSIS packages, deployment instructions...
... Supporting cloud migration initiatives, particularly on Azure Cloud Services. Qualifications 8+ years of Software Engineering experience. Bachelor’s degree in Engineering/Computer Science (or equivalent). Strong background in Java development (essential). Hands-on experience in Azure Cloud Services (especially cloud migration). Technical Skills Proficiency with data manipulation tools: SSIS, Informatica. Strong command of development languages: Python, Java, C/C++, HTML, XML, SQL, JSON. Familiarity with Windows/UNIX environments. Experience with Git (GitHub/GitLab). Knowledge of test-driven development and industry best practices. Hands-on experience with Azure/AWS cloud platforms. Ability to adapt to Agile/Waterfall development methodologies. Eagerness to l...
The SSIS package I maintain for our office keeps failing during execution because of a configuration-level error tied to the Package Configurations themselves. It is not a typical connection-string, variable, or environment-variable issue; the problem appears deeper inside the configuration metadata and surfaces only after deployment. What I need: • A quick remote review of the package in SQL Server Data Tools / Visual Studio. • Identification of the exact misconfiguration and a clean, reproducible fix. • A brief walk-through (screenshare or short write-up) so I understand what went wrong and how you resolved it. Acceptance criteria • Package executes successfully in my test and production environments. • No new warnings or validation errors on b...
...milestones. * Stay updated with emerging technologies and apply best practices. **Qualifications** * **8+ years** of Software Engineering experience. * Bachelor’s degree in **Engineering / Computer Science** or equivalent. * Strong hands-on experience in **Java development**. * **ECL knowledge – Mandatory.** * Hands-on expertise in **Azure** (cloud services, migration projects). * Proficiency with **SSIS, Informatica** for data manipulation. * Strong knowledge of **Python, Java, C/C++, SQL, HTML, XML, JSON**. * Experience in **Windows & UNIX environments**. * Knowledge of **Git (GitHub/GitLab)**, version control, and CI/CD. * Familiarity with **Test-Driven Development (TDD)** and best coding practices. * Strong analytical and problem-solving skills. **Preferred...
Experienced DevOps and Software Engineer(20+ Years) with a background in software development, automation, and cloud infrastructure (AWS, Azure). Skilled in CI/CD (Jenkins, GitHub Actions, GitLab), containerization (Docker, Kubernetes), an...Vulnerabilities: Tennable Artifact Repositories: Nexus, JFrog Artifactory Scripting & Utilities: Python, Bash, Perl, PHP System Monitoring: Nagios, Zabbix, Pingdom Production Support & SaaS: AWS, Heroku, ECS, EKS, Okta, Sentry, Pingdom, 1Password, Fastly, CloudFlare Other Technologies: SQL, PL/SQL, Oracle, C, Shell Scripting (SH, KSH, CSH, Bash), HTML/CSS, JavaScript (jQuery, AJAX), XML, Java, LDAP, VBA, ETL (SSIS), D3 Database Looking for a project in the below technologies Docker, Kubernetes, Helm Charts, AWS, Ansible, Terraform, Pyth...
I need a skilled BI developer with data science knowledge to establish a data warehouse and build an ETL pipeline using Microsoft SSIS. The data will be sourced from APIs, Excel-based files, and management tools like Jira. Requirements: - Expertise in SQL Server - Proficiency in Microsoft SSIS - Experience with API integration and handling Excel files - Knowledge in data warehousing concepts and design - Ability to create visualizations for decision-making tools - Expert in DAX - Power BI Ideal Skills: - Strong background in Business Intelligence - Experience with data science methodologies - Familiarity with Jira and project management data Your work will help streamline data for visualization and improve decision-making processes.
I need an experienced SSIS developer to focus on ETL processes. The primary goal is to extract data from various sources and load it into SQL Server. The project involves working with SQL Server as the main data source, but flexibility to integrate with SQL SERVER RDS and Excel files is also important. Key Requirements: - Develop and maintain efficient ETL packages. - Optimize existing ETL processes. - Extract data from various sources and load into SQL Server. Ideal Skills and Experience: - Strong proficiency in SSIS and ETL processes. - Experience with SQL Server, and familiarity with Oracle and Excel files. - Ability to create, maintain, and optimize ETL packages effectively.
...Cloud Migration Projects: Led end-to-end data migrations from on-prem SQL Server and SSIS packages to Azure Synapse, including metadata-driven incremental loads and DDL script automation using PowerShell. Performance Optimization: Improved data extraction performance with Polybase, BCP, and Copy Activity, external tables, and durable functions. Refactored Python/PySpark code for AWS compatibility and better performance. Data Warehousing & Modelling: Designed star schema and normalized data models, implemented SCD Type 2, and developed Fact/Dim tables with curated layers across industries like education, healthcare, and manufacturing. ETL & Orchestration Expertise: Developed complex ETL workflows using SSIS, ADF pipelines, PowerShell scripts, and custom API in...
I'm seeking a skilled freelancer to assist me with building dashboards in Power BI, focusing on supply chain data. As a Data Analyst with experience in Supply Chain Analytics, I need support to enhance my data visualization capabilities. Key Requirements: - Develop and optimize dashboards in ...data effectively - Collaborate to ensure the dashboards meet analytical needs Ideal Skills and Experience: - Proficiency in Power BI for dashboard creation - Strong background in data visualization and analytics - Experience with supply chain data is highly desirable - Ability to write SQL queries and perform data cleaning using Excel and Python - Familiarity with ETL workflows, particularly using SSIS, is a plus Please share your relevant experience and availability to discuss this p...
Kindly apply only if you have relevant...leading BI tools. ● Strong command of SQL for data querying, transformation, and performance tuning. ● Solid understanding of data modeling concepts (e.g., star schema, snowflake schema). Technical Skills: ● Advanced SQL skills including stored procedures and performance optimization. ● Hands-on experience with BI tools such as Tableau, Power BI, and Snowflake. ● Familiarity with ETL tools like SSIS, Informatica, or Azure Data Factory. ● Understanding of data warehousing principles, methodologies, and architecture. Soft Skills: ● Excellent analytical and problem-solving capabilities with keen attention to detail. ● Strong communication and interpersonal skills—able to bridge the gap between technical teams and business stakeholders.
I need an experienced Azure professional to migrate an SSIS package, currently triggered by ActiveBatch Scheduler, to Azure. Requirements: - Use Azure Data Factory and Azure Batch - Exact replication of current setup Key consideration: - Data extraction and loading processes Ideal Skills: - Azure Data Factory - Azure Batch - SSIS package migration - Experience with ActiveBatch Scheduler
...and enhance key components of existing solution. Key Areas I Need Help With: Data model design Converting dimension tables from SCD Type 1 to SCD Type 2 Designing and modifying ETL processes (using SSIS) Careful Implementing change as I am working on live data and historical data preservation Updating data models and ensuring consistency across layers (Landing → DW → DM) Writing efficient SQL queries and troubleshooting ETL data issues Sorting Mapping Tech Stack: SQL Server (SSMS) SSIS (SQL Server Integration Services) Azure DevOps (for version control) Visual Studio (for SSIS development) I am looking for: Someone who can guide me during development (like a mentor connecting twice or thrice in a week for few hours. Flexible as per ...
I'm looking for an experienced developer to enhance an existing .NET Core application. Requirements: - Fix functionality issues in the application. - Improve the user interface for better user experience. Ideal Skills: - Proficiency in .NET Core and C#. - Experience with SSIS and MySQL. - Strong problem-solving capabilities. - UI/UX design skills to improve user interfaces. Please provide examples of similar work done. Ssis skill is must. Need to map the table with destination
I'm looking for an experienced developer to enhance an existing .NET Core application. Requirements: - Fix functionality issues in the application. - Improve the user interface for better user experience. Ideal Skills: - Proficiency in .NET Core and C#. - Experience with SSIS and MySQL. - Strong problem-solving capabilities. - UI/UX design skills to improve user interfaces. Please provide examples of similar work done.
I'm looking for an experienced developer to enhance an existing .NET Core application. Requirements: - Fix functionality issues in the application. - Improve the user interface for better user experience. Ideal Skills: - Proficiency in .NET Core and C#. - Experience with SSIS and MySQL. - Strong problem-solving capabilities. - UI/UX design skills to improve user interfaces. Please provide examples of similar work done.
I'm looking for an experienced developer to enhance an existing .NET Core application. Requirements: - Fix functionality issues in the application. - Improve the user interface for better user experience. Ideal Skills: - Proficiency in .NET Core and C#. - Experience with SSIS and MySQL. - Strong problem-solving capabilities. - UI/UX design skills to improve user interfaces. Please provide examples of similar work done.
I need an experienced SQL, SSIS, and ADF developer to work in a screen-sharing environment. The project involves: - Data integration and ETL processes - Working with existing SQL Server databases Ideal skills and experience: - Proficiency in SQL Server - Strong knowledge of SSIS and ADF - Experience in data integration and ETL Please provide examples of similar work.
...and Providing third-level support to business users. Essential Experience building .Net/.Net Core web-based applications in C# .Net/Entity/React frameworks ASP.Net Core, Web Forms, MVC APIs/Web Services Knowledge of Azure (LogicApps/Azure Function Apps, Web Apps) Nice to Have Exposure to web development using HTML5, CSS and JavaScript (jQuery, React JS) SQL Server, T-SQL and/or SQL scripting SSIS/SSRS/SSAS, Power BI Exposure to developing the Microsoft Dynamics 365 CE / CRM platform Python/Flask/Apache Kafka/Git/GitHub/Postman/Swagger Azure DevOps Experience of Agile/Scrum practices Knowledge of client/server application development Knowledge of agile development methodologies Knowledge of unit testing theory Solid understanding of relational database design and querying co...
I need help migrating 1-10 SSIS packages from SQL Server 2016 to SQL Server 2022 using Visual Studio deployment. Requirements: - Migrate SSIS packages with custom scripts/components - Custom scripts/components tested for SQL Server 2022 compatibility Ideal Skills and Experience: - Expertise in SQL Server Integration Services (SSIS) - Experience with SQL Server 2022 and Visual Studio - Knowledge of migrating SSIS packages and handling custom scripts
Description: We are looking for an experienced Java ETL Developer for a 2-hour remote screen sharing session today. Task Overview: You will assist in rewriting an existing ETL package from SSIS to Java. No new logic needs to be created – the goal is to translate the existing logic from SSIS into Java code. Requirements: 5+ years of experience in Java and ETL development. Strong understanding of data workflows and ETL best practices. Familiarity with SSIS packages and Java-based ETL frameworks/tools. Ability to clearly explain your approach and work collaboratively in real time. Tech Stack: Java, SSIS, ETL tools Session Details: Duration: 2 hours Budget: ₹1000 (for 2 hours) Mode: Remote (via screen sharing) Date: Today – immediate availa...
Part-Time Data Engineer – MSBI / SSIS / ADF / Data Lakes Location: Remote Job Type: Part-Time Experience: 8+ Years Job Summary: We are seeking a skilled Part-Time Data Engineer with strong expertise in MSBI (SSIS), Azure Data Factory (ADF), and Data Lake migration. The role involves monitoring, creating, troubleshooting, and managing ETL pipelines across on-premise and cloud environments. Responsibilities: • Monitor, create, troubleshoot, and optimize SSIS packages and scheduled jobs. • Monitor, create, troubleshoot, and manage ADF pipelines and activities. • Migrate existing SSIS workflows and data loads to Azure Data Lake and ADF pipelines. • Perform error handling, performance tuning, and log management for ETL processes....
I'm seeking a professional skilled in Power BI, SSIS, and SQL Server to assist with data visualization, integration, and management. The primary goal is to create a Power BI dashboard for tracking business performance, leveraging various data sources including Excel, SQL Server, and cloud-based storage. Key Responsibilities: - Design and implement a comprehensive Power BI dashboard for business performance tracking. - Integrate data from multiple sources using SSIS. - Manage and optimize our SQL Server database for optimal performance and accessibility. Ideal Skills & Experience: - Proficient in Power BI, with a strong portfolio of business performance tracking dashboards. - Extensive experience with SSIS for data integration. - Advanced skills in SQL Server...
I need help setting up an SSIS task that will pick up file from SFTP site and move to Sharepoint, everyday at a scheduled time
...seeking a SSIS data engineer with expertise in SQL Server Integration Services (SSIS) to enhance ETL processes, Query Optimization and Performance Tuning. This project primarily focuses on educating an individual to handle various data sources in real-time in a crash course format (1 Day or Continue 4-5 Hours Depends, Open for Discussion). The ideal candidate will have a strong industry background with some teaching experience in data migration, transformation, and ETL system optimization. Key Responsibilities: - Analyze and improve the current ETL processes. - Implement real-time ETL processes. - Work with diverse data sources including SQL Server, E-Commerce platforms, and social media platforms. Platform: SSIS Server Studio Ideal Skills and Experience: - Exten...
I'm seeking a professional with solid experience in SSIS and T-SQL who can assist me in fixing bugs that are affecting our data quality. Ultimately, the primary goal is to enhance the quality of our data through this process. Ideal skills and experience for the job include: - Proficient understanding of SSIS and T-SQL - Proven track record in improving data quality - Strong problem-solving skills to identify and fix bugs - Experience in data extraction and transformation
I'm in need of an SSIS expert for my project. The primary goal is data transformation. I need someone who can connect to SQL Server as the data source and transform the data before it reaches its destination, which is also SQL Server. Skills and Experience needed: - Proficient in SQL Server - Extensive experience with SSIS - Strong data transformation skills - Able to work with complex data sets Please only apply if you meet these criteria. Your ability to transform data efficiently will be key to the success of this project.
Desarrollar en conjunto con un equipo interno de la organización, un Data Lake robusto y escalable que consolide datos clave de SAP S/4 HANA Public Edition y Salesforce, aprovechando la potencia de SAP Cloud Platform Integration (CPI) para una integración eficiente y Microsoft SQL Server Integration Services (SSIS) para la transformación y carga de datos. Este Data Lake permitirá análisis profundos y personalizados en Power BI, brindando información valiosa para la toma de decisiones estratégicas. Analíticos a extraer de SAP S/4 Hana Public Edition * Backorder (Procesamiento de pedidos pendientes por clasificación, cliente, oficina de venta, grupo de ventas, sociedad) * Analíticos de ventas y costos (producto, cl...
I got hired recently for the following job description: "Looking for a driven and detail oriented Treasury Operations Specialist with a strong technical skillset to partner with the Treasury Technology team to design and build out a strategic Cash Wires platform. Principal Responsibiliti...6. Expertise in data modeling, including defining Entity Relationship Diagrams is a plus." I'm looking for a mentor/guide, someone who has worked within Treasury Technology at a broker-dealer or asset management firm. Someone who knows about Kyriba. I need 5 - 7 hours weekly (1hr/day), just to guide me, help me with my deliverables. Someone who can explain how broker-dealer firms work, what SSIs (Standard Settlement Instruction) mean, different types of accounting relations...
I'm looking for a skilled developer who can create a custom SQL Server Integration Services (SSIS) task in C#. This task will need to facilitate data exporting to a SQL compatible database. Key Requirements: - Create a specific SSIS task that can export data to a SQL compatible database - Use a specific .NET driver that I will provide - Implement the task in C# Ideal skills for this project: - Extensive experience with SSIS and SQL Server - Proficient in C# and .NET framework - Familiar with creating custom SSIS tasks - Experience in data exporting Please note, I will provide the specific .NET driver to be used for this project. Previous experience with similar tasks is highly advantageous. Bidder with the most relevant experience will be preferred.
