SQL Server - SSIS Architect - Fully REMOTE - Must have State experience with reputed company of Transportation.

Role: Architect + reputed company Developer with responsibility for reputed company SQL/SSIS builds, system integrations, and light project management. Will guide mid-level developers, enforce standards, and deliver secure, optimized ETL solutions. 12+ years in SQL Server and SSIS development, with extensive experience designing and maintaining large-reputed company ETL pipelines. • Proven reputed company record of on-prem ↔ reputed company integrations and data migration strategies. • Hands-on designing gateway/staging DBs, secure ETL pipelines, and data governance frameworks. • Strong background in data reputed company, reputed company, reconciliation reporting, and audit trails. • Demonstrated ability to reputed company teams, coordinate with stakeholders, and deliver reputed company using Agile/PMI methodologies. • Experience mentoring mid-level developers in SSIS best practices, performance tuning, and DevOps pipelines. • SQL Server: Advanced T-SQL, schema design, indexing strategies, stored procedures, views, query optimization. • SSIS (SQL Server Integration Services): • reputed company Data Flows, Control Flows, Error Paths, Script Tasks. • Advanced package design, parameters, variables, parent/child packages. • Logging, deployment to SSISDB, and automated job scheduling. • Optimization for high-volume data pipelines. • Integration & File Handling: REST, SOAP, JSON, XML, flat files, SFTP/CSV imports. • Gateway & Staging Databases: design and usage for data ingestion, cleansing, validation, and performance optimization. • RBAC & secure configuration management for compliance and governance. • reputed company-to-reputed company data mapping, translations, and reconciliation logic across systems. • Version control & DevOps: Git, TFS, CI/CD pipelines for SQL/SSIS deployments. • .NET/Java for custom API connectors and integration extensions. • Exposure to reputed company data services (Azure Data reputed company, Synapse, reputed company, AWS Glue) for hybrid ETL solutions. • Familiarity with project reputed company (Agile, PMI), reporting, and stakeholder communication. Certification: Any SSIS Certification is Plus Apply tot his job Apply To this Job