Microsoft SSIS Developer

DirectClient: RailRoad Commission of Texas(RRC)SolicitationTitle: Microsoft SSIS DeveloperLocation: Work from Home//WBT 1701 N Congress Ave. Austin, TX 78701Duration: Until 8/31/2023 with possible extensionLast date for submission: October 26, 2022 (1.00 PM-CST) Note: Mostly remote with occasional travel to Austin office DESCRIPTION OF SERVICES Development of automated ETL solutions with Microsoft SSIS and Oracle platforms. Performs analysis and research of application functionality and interprets project requirements to develop technical specifications for application ETL functionality Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems. Practices current development methods/techniques and establishes development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of automated solutions. Communicates and/or collaborates with business area stakeholders to coordinate development efforts in support of business needs. Leads the development and maintenance of documentation and ensures that the content of documentation is well organized, complete, and appropriate to the audience. Ensures project schedules are met, and/or re-negotiated, and approved prior to target dates. Communicates progress and issues affecting work assignments to management and/or Project Manager as soon as possible. Follows established change management code migration processes. Mentors junior level staff in the development, testing, and deployment of new and/or modified solutions. Collaborates with other staff in the development, testing, and deployment of new and/or modified solutions. Familiar with design best practices of data warehouse and application databases. Reviews all application database change requests to determine any (downstream) effect on warehouse ETLs. Consults the Data Dictionary for any dependencies and additional information that the data admin request may require. Assist with the review of database performance and suggest alternative ways to resolve any performance issues Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a minimum four release effort. Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required. Ability to promote the code from development environments to production. Familiarity with Github or equivalent version control systems. Extensive experience with Oil & Gas systems Experience working with state agencies Perform related work as assigned. CANDIDATE SKILLS AND QUALIFICATIONSMinimum Requirements:Years Required/Preferred Experience6+ Required Experience working in a medium to large information technology environment to include ever-increasing responsibility for development, design, and/or deployment actions.3+ Required Knowledge and skill using Microsoft SQL Server Integration Services (SSIS)3+ Required Knowledge and skill using Microsoft Azure DevOps and Git required, with emphasis on deployment, version control and project tracking5+ Required Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint2+ Required Knowledge and at least 2 years of experience with Oracle databases with some of that experience being Oracle version 12c2+ Required Knowledge and skill using Microsoft SQLServer2+ Required Knowledge and skill using Microsoft Azure Cloud database services2+ Required Knowledge of database object migration/validation tools2+ Required Knowledge and understanding of ETL development, monitoring, batch and/or data processing in an automated scheduled environment2+ Required Knowledge of database structures and theories2+ Required Knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management2+ Required Knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance2+ Required General knowledge of technology across all network layers and computer platforms2+ Required Knowledge and experience with the Software Development Life Cycle (SDLC) and project plan understanding2+ Required Excellent written and verbal communication skills, including theability to present and communicate complex technical information (including on-the-job training) clearly and concisely, both orally and in writing, to diverse audiences which includes coworkers, project team members, and IT management.2+ Required Experience in working in fast-paced and ever-changing environments; achieving projects deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to address identified issues. - Required Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel.5+ Preferred ETL development and data warehouse monitoring5+ Preferred Development using Oracle or Microsoft SQL Server, SQL, systems analysis, systems design, other relevant information technology experience5+ Preferred Development experience using Microsoft SQL Server Integration Services (SSIS)5+ Preferred Development experience using Microsoft Azure Cloud databases5+ Preferred Experience utilizing Microsoft Azure DevOps and Git2+ Preferred General knowledge of Informatica or similar ETL tool.2+ Preferred Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and process, including technical architecture2+ Preferred Experience in data focused projects, like moving from Legacy to newer systems Preferred Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field.