Data Integration Specialist

Senior SSIS / Data Integration Developer Remote (Must reside in TX, AZ, KY, TN, GA, SC, NC, FL) | Long-Term Contract CornerStone TTS is seeking a Senior SSIS / Data Integration Developer for a large-scale enterprise modernization initiative. This role is ideal for a senior data integration professional with deep experience in Microsoft SSIS, SQL Server, Oracle, ETL development, production support, and enterprise database environments . What You'll Do Design, develop, enhance, and support complex SSIS ETL solutions . Integrate data between Microsoft SQL Server and Oracle databases. Support automated batch processing, scheduled ETL jobs, production troubleshooting, and performance optimization. Analyze database and application changes for downstream ETL impact. Support database migration, validation, deployment, and release activities. Use Azure DevOps and Git for version control, deployment, and project tracking. Create and maintain technical, process, and interface documentation. Collaborate with technical teams and business stakeholders. Review technical work, troubleshoot complex issues, and provide guidance to other developers. Required Qualifications Candidates must meet all required qualifications : 6+ years working in medium-to-large enterprise IT environments. 6+ years hands-on Microsoft SSIS experience. 4+ years using Azure DevOps and Git . 5+ years with Microsoft Office tools, including Word, Excel, PowerPoint, Visio, and SharePoint . 4+ years Oracle , including at least 2 years with Oracle 12c . 4+ years Microsoft SQL Server . 2+ years Microsoft Azure cloud database services . 2+ years database object migration and validation tools . 2+ years ETL development, monitoring, batch processing, or automated scheduled processing . 2+ years database structures and relational database concepts . 2+ years enterprise information management, RDBMS, and metadata management . 2+ years data governance and PII-related data-management knowledge . 2+ years general enterprise technology knowledge across platforms and network layers . 2+ years SDLC and project-plan experience . 2+ years communicating complex technical information to technical and non-technical audiences . 2+ years working in fast-paced environments while meeting deadlines and resolving complex issues . Strong interpersonal, negotiation, conflict-resolution, and stakeholder-management skills. 2+ years hands-on experience with the LoneSTAR application, SSIS bridge, and associated databases. Preferred Data warehouse and ETL monitoring experience. Legacy-to-modern platform migration experience. Informatica or similar ETL tools. Master data, metadata, reference data, data warehousing, and BI concepts. Experience with enterprise environments involving technologies such as Snowflake, MuleSoft, Salesforce, Java, C#/.NET, COBOL, or GoAnywhere. Oil & Gas or public-sector technology experience. Why CornerStone TTS? CornerStone TTS connects experienced technology professionals with complex enterprise initiatives where their expertise can make an immediate impact. Our technical recruiting team understands the technology behind the roles we represent and focuses on aligning candidates with opportunities that match their real-world experience.