ETL Developer Needed – SSIS, SQL Server, and GCP Data Pipeline Support

@AwaisChaudhry

Hello, I understand you want to move from SSIS to a Google Cloud-based pipeline that lands all data in BigQuery with equal or better performance, data quality, and monitoring. My approach is to first map every source, SQL Server databases and nightly flat files, to a clean GCP flow, then rebuild using native services (Dataflow, Cloud Data Fusion, and Cloud Composer) with strong error handling, logging, retries, and a single source of truth for metadata. I’ll design environment-specific configurations and automation (Terraform or Deployment Manager) so dev, test, and prod deployments are effortless. I’ll optimize BigQuery schemas and partitioning, secure access with IAM and service accounts, and ensure data arrives in an auditable, repeatable state. Deliverables include a detailed assessment, a production-ready pipeline design, automated deployment scripts, and handover docs plus a concise walkthrough. What is the most critical data source for your migration in terms of freshness and reliability? Questions I’ll ask you: 1) Do you have existing data quality rules or SLAs I must preserve? 2) Which data sources require the strictest freshness and how do you handle late-arriving data? 3) Do you prefer a single orchestrator (likely Cloud Composer) or a mixed approach with Dataflow for streaming and Fusion for orchestration? 4) What is your target schema strategy for BigQuery (partitioning, clustering, and data types)? Best regards,

@ShafirR

Hello, Your project aligns well with my experience working with SQL Server ETL systems and modernizing data pipelines for cloud analytics platforms. I am a Senior SQL Server DBA and Data Engineer with 10+ years of experience building and supporting ETL pipelines using SSIS, SQL Server, and cloud-based data platforms. I have helped organizations migrate legacy ETL workflows while preserving performance, reliability, and data integrity. For your migration, I can assess your existing SSIS packages, map out the data flows from relational sources and flat files, and design equivalent pipelines on GCP that maintain the same logic with improved scalability and monitoring. My approach includes: • Reviewing SSIS packages and documenting sources, transformations, and dependencies • Designing pipelines using GCP services such as Dataflow, Cloud Composer, or Cloud Data Fusion • Implementing logging, retry handling, and monitoring • Optimizing BigQuery schemas with proper partitioning and performance considerations • Securing pipelines with IAM roles and service accounts • Providing clear documentation and a handover walkthrough for your team I focus on building reliable and maintainable data pipelines that ensure consistent and auditable data delivery. I’m available to review your current setup and help design a clean, production-ready migration. Best regards, Shafir

@devendrathakur12

Hello, Can we discuss about your SSIS to GCP migration project cause I have helped rebuild legacy ETL flows into BigQuery pipelines so data lands faster and monitoring becomes clearer. Dataflow with BigQuery partitioning usually handles mixed DB and flat-file loads reliably. Are the SSIS jobs mostly batch nightly or near-real-time? Do flat files arrive with fixed schema or change often? Should failed loads retry automatically or wait for review? Early schema partition planning saves BigQuery costs later. Best regards, Devendra S.

@techplusintl

Hi there, ★★★ Data Engineering Expert ★★★ 8+ Years Experience ★★★ To assess current SSIS packages and rebuild pipelines in GCP, i'll map out sources and design new pipelines. My approach will be: - Review existing SSIS packages and document data flows. - Use Dataflow and Cloud Composer to build new pipelines with error handling. - Automate deployment with Terraform for easy environment setup. - Optimize BigQuery schemas for performance and data quality. - Prepare hand-over documentation and conduct a walkthrough for your team. What specific data sources are you currently using in your SSIS packages? Looking forward to your response. Regards, Burhan Ahmad

@divumanocha

Hello, Thank you so much for posting this opportunity. It sounds like a great fit, and I’d love to be part of it! I’ve worked on similar projects before, and I’m confident I can bring real value to your project. I’m passionate about what I do and always aim to deliver work that’s not only high-quality but also makes things easier and smoother for my clients. Feel free to take a quick look at my profile to see some of the work I’ve done in the past. If it feels like a good match, I’d be happy to chat further about your project and how I can help bring it to life. I’m available to get started right away and will give this project my full attention from day one. Let’s connect and see how we can make this a success together! Looking forward to hearing from you soon. With Regards!

@ZohaibRoy

⭐⭐⭐⭐⭐ Move SSIS Workloads to Google Cloud with Expert Guidance ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project needs and see you're looking for someone to migrate SSIS workloads to Google Cloud. Look no further; Zohaib is here to help you! My team has successfully completed over 50 similar projects for cloud migrations. I will assess your current SSIS packages and design efficient pipelines to ensure optimal performance and data quality in BigQuery. ➡️ Why Me? I can easily handle your migration project as I have 5 years of experience in cloud services, specializing in data integration and pipeline design. My expertise includes working with Google Cloud tools like Dataflow and Cloud Composer. Furthermore, I have a strong grip on optimizing data workflows and ensuring secure data handling. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing this with you! ➡️ Skills & Experience: ✅ Google Cloud Platform ✅ SSIS Migration ✅ Dataflow ✅ Cloud Data Fusion ✅ Cloud Composer ✅ BigQuery Optimization ✅ Error Handling ✅ Logging Mechanisms ✅ Terraform ✅ Deployment Manager ✅ Data Quality Assurance ✅ IAM Security Waiting for your response! Best Regards, Zohaib

@Feriver

Hello, I have successfully migrated SSIS workloads to Google Cloud, rebuilding pipelines in BigQuery with full performance, monitoring, and data quality parity. My approach begins with a thorough assessment of existing SSIS packages, mapping all source tables and flat-file feeds, then designing native GCP pipelines using Dataflow, Cloud Data Fusion, or Cloud Composer with robust error handling, logging, and retry mechanisms. Scheduling and environment-specific configurations will be automated via Terraform for seamless dev/test/prod deployment. I optimize BigQuery schemas and partitioning strategies, secure data using IAM and service accounts, and ensure all loads arrive in a consistent, auditable state. Deliverables include production-ready pipelines, complete documentation, and a short walkthrough to enable your team to maintain and extend the solution confidently. Thanks, Asif

@vishal1145

Your flat-file loads will fail silently in production if you don't implement dead-letter queues and idempotency checks—SSIS masks these issues with its built-in retry logic, but GCP requires explicit error handling at every stage. I've migrated 4 SSIS environments to GCP and the biggest failure point is always assuming Cloud Composer will "just work" without proper backfill strategies when upstream sources miss their SLA windows. Before I map out the architecture, I need clarity on two things: What's your current data volume per nightly batch (are we talking 10GB or 500GB files), and do your SSIS packages use any custom .NET scripts or third-party connectors that won't translate directly to Python-based Dataflow transforms? The answer changes whether we use Dataflow or Data Fusion as the orchestration layer. Here's the rebuild approach: - SSIS PACKAGE AUDIT: Reverse-engineer every transformation, lookup table, and CDC pattern in your existing packages—then map to equivalent GCP primitives (Dataflow for complex transforms, Cloud Functions for lightweight file triggers). - BIGQUERY SCHEMA DESIGN: Implement date-partitioned tables with clustering on your most-queried columns, plus separate staging datasets so bad records land in quarantine tables instead of breaking the entire load. - CLOUD COMPOSER + TERRAFORM: Build Airflow DAGs that trigger on Cloud Storage file arrival events, with parameterized configs per environment—your dev/test/prod deployments become a single terraform apply command with zero manual steps. - MONITORING STACK: Set up Cloud Logging sinks that push pipeline metrics into BigQuery itself, so you can query job duration, row counts, and error rates using the same SQL your team already knows. I've rebuilt similar pipelines for a healthcare client moving 200GB nightly feeds from SQL Server to BigQuery—we cut their processing window from 4 hours to 45 minutes by parallelizing file ingestion and pre-aggregating dimension tables. Let's schedule a 20-minute call to walk through your SSIS package structure and nail down the GCP service mix before I write a single line of code.

@ParasTech7

I have 21 years of experince, Principal Software engineer at Microsoft, I have extensive experince with ETL, data management , large query, data piple line and cleaning using SQL and BigQuery. Well versed with distributed system and Data integration . I can Automate your flow with efficient query, can handle large amount of data efficiently. I have understood your requirements and can deliver.

@DemoNGUYEN

Hi, I have reviewed your SSIS-to-GCP migration requirements. Most SSIS migrations fail because developers treat BigQuery like a standard SQL Server. My approach focuses on Modern ELT (Extract-Load-Transform) to leverage BigQuery’s parallel processing power. My Migration Framework Discovery & Mapping: I will create a Source-to-Target Map (STM) that translates your SSIS "Control Flow" into a Cloud Composer DAG. Native Rebuild: We will replace the "Script Tasks" with Dataflow (Python/Java) or BigQuery SQL. For the flat-file drops, I will implement a "Storage Trigger" pattern that begins processing the moment a file hits the bucket—eliminating the "waiting for the nightly job" bottleneck. Performance First: I will implement Partitioning (on Date/Time) and Clustering (on high-cardinality IDs) to reduce query costs by up to 80% while increasing speed. Automated Governance: Deployments will be handled via Terraform, ensuring that IAM roles and service accounts follow the principle of least privilege. If you are interested, I'm happy to discuss further! Regards, Nguyen

@jagratip3

Hello, I’m a data engineer with strong experience working with SQL, relational databases, and data pipeline development. I’ve worked extensively with ETL processes involving stored procedures, scheduled jobs, and structured data pipelines, and I can help design a clean migration approach from SSIS-based workflows to Google Cloud. For this project, I would start by reviewing the current SSIS packages, identifying all source tables, flat-file feeds, transformations, and dependencies. From there I would document the equivalent architecture on GCP and design reliable pipelines to ingest the data into BigQuery while maintaining data quality, logging, and monitoring. For the pipeline implementation, I would typically use services such as Cloud Data Fusion or Dataflow for ingestion and transformation, combined with Cloud Composer or scheduled workflows for orchestration. The pipelines would include proper retry logic, structured logging, and error handling to ensure production stability. I also have strong experience working with relational data modeling and SQL optimization, which helps when designing BigQuery schemas, partitioning strategies, and query performance improvements. Security would be implemented using service accounts and IAM roles to ensure controlled and auditable data access. I’d be happy to review your current SSIS setup and propose a clear migrati

@Shrutibimpl

Hello, I will audit your existing SSIS packages to map every database and file feed to a modern GCP setup. I will use a popular serverless data tool and a common orchestration service to rebuild the pipelines, ensuring the data lands in BigQuery with robust error handling and retry logic. I will optimize the BigQuery schemas and partitioning to match or exceed your current performance. The entire infrastructure will be automated using a well known IaC tool for seamless deployments across your dev, test, and production environments. I will also configure IAM roles for security and provide complete documentation and a walkthrough for your team. 1) How many SSIS packages and source tables are currently in scope for migration? 2) What is the average daily data volume for the flat file and database feeds? 3) Do you have a preferred GCP orchestration tool like Composer or Data Fusion? Thanks, Bharat

@haseebsidd07

Hey , I just finished reading the job description and I see you are looking for someone experienced in Database Administration, Microsoft SQL Server, Data Integration, SQL, ETL, Relational Databases, Data Warehousing, Terraform, Google Cloud Platform and BigQuery. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback since the last 5-6 years. 3. You will find 5 star feedback on the last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Haseeb,

@HiraMahmood4072

Hello, I have over 7 years of experience in Relational Databases and SQL. I have carefully read through your project requirements and am confident that I can assist you with migrating your Microsoft SSIS workloads into Google Cloud and rebuilding your existing pipelines in a production-ready manner. To achieve this, I will first assess your current SSIS packages, map out all source tables and file feeds, and document the equivalent flow on GCP. I will then design and build new pipelines using native GCP services with error handling, logging, and retry logic. Additionally, I will automate scheduling and configuration for seamless deployments across different environments. I am well-versed in optimizing BigQuery schemas, securing data with IAM, and ensuring data consistency during migration. I am eager to discuss the project further and explore the best approach to meet your requirements. Please connect with me for a detailed discussion. You can visit my profile at https://www.freelancer.com/u/HiraMahmood4072 Thank you.

@DngPhgNam

⭐⭐⭐⭐⭐ ✅Hi there, hope you are doing well! I have successfully migrated Microsoft SSIS workloads to Google Cloud, designing pipelines that maintain or improve performance and data quality while simplifying transitions from relational databases and flat files to BigQuery. From my experience, the most important part to complete this project successfully is thorough assessment and accurate mapping of current SSIS packages to equivalent GCP data flows. Approach: ⭕ Assess and map all current SSIS sources and workflows ⭕ Design robust pipelines using native GCP tools like Dataflow, Cloud Composer, or Cloud Data Fusion based on workload needs ⭕ Implement full error handling, logging, and retry logic ⭕ Automate deployment across environments using Terraform scripts ⭕ Optimize BigQuery schemas and security using IAM roles ⭕ Deliver comprehensive documentation and conduct a detailed hand-over walkthrough ❓ Could you share details on your existing SSIS package complexity? ❓ What tools or processes are currently used for error handling and monitoring? ❓ Are there specific compliance or security requirements for your data? I am confident my expertise in SSIS to GCP data pipeline migration and automated deployment will ensure a smooth, production-ready rebuild with seamless handover. Best regards, Nam

@bhartimalu

Hello, I can handle your ETL development with SSIS & SQL — designing, building, and optimizing data extraction, transformation, and loading workflows between systems. I’ll ensure reliable data pipelines, error handling, performance tuning, and clean SSIS package deployment. Regards, Bharti

@melikatfz

Hi there, regarding your project, one key area often overlooked is optimizing the backend to handle increased data flow efficiently. Many miss the subtle nuances in database indexing, but I ensure your system runs smoothly and deliver high performance. By focusing on these technical aspects, I can prevent future scalability issues. I've successfully revamped a complex data management system, reducing query response time by 40%, which speaks to my expertise in similar challenges. I include 30 days of post-deployment bug-fixing at no extra cost. What current database structure are you using, and are there any anticipated changes in data volume? Let's discuss how I can assist your project.

@dataspro

Nice to meet you ,The requirements of your project match my areas of work and skills, to introduce myself. My name is Anthony Muñoz and i am the lead engineer for DS Pro IT agency. I have worked for over 10 years as a Full-Stack and software development engineer and have successfully done multiple jobs. It will be a pleasure to work together to make your project. Feel free to discuss about the project with me, greetings.

@Alesha1018

Hello, hope you are doing well, As a seasoned software engineer with a solid background in implementing and optimizing data pipelines, I believe I'm an excellent fit for your SSIS to GCP migration project. I've successfully executed numerous database migrations and understand the intricacies involved in mapping out every source and designing efficient workflows. In addition, my expertise in Microsoft SSIS, SQL Server, and GCP's native services like Dataflow, Cloud Data Fusion, and Cloud Composer make me the perfect candidate for this role. I understand the importance of landing data in BigQuery with consistent performance, quality, and monitoring comparable to or better than your current setup. My comprehensive approach involves not only successfully migrating the data from various sources but also ensuring it lands securely using IAM and service accounts, and devising reliable error handling, logging, and retry logic mechanisms.