|
Search Jobvertise Jobs
|
Jobvertise
|
Microsoft SSIS Developer Location: US-TX-Austin Email this job to a friend
Report this Job
Tryfacta is a leading company in the technology services industry that empowers clients to envision new business possibilities. We enable them to build and reshape their workforce, fostering accelerated growth quickly. Additionally, we drive transformation for our clients through our comprehensive digital transformation solutions. Tryfacta is seeking a Microsoft SSIS Dveeloper for our clients in Austin, TX (78751)/Remote. This role is an 3+ Years contract assignment with a State Client. Position Title: Microsoft SSIS Developer Location: Remote Duration: 3+ Years Contract Project Description: Major responsibilities include performing highly advanced (senior level) computer programming work on the Microsoft SQL Server Integration Services (SSIS) platform for development, customization, configuration, and significant documentation work to move critical agency data between Microsoft SQL Server and Oracle databases. Requires thorough understanding and skill in Microsoft SSIS development and configuration management of code, and of MS SQL and Oracle databases. It also requires knowledge of and experience in designing and managing database systems, data warehouses, and ETL data interfaces. The candidate will perform many roles including but not limited to the following: review and development of documentation of the currently deployed architecture; technical analysis of proposed changes to bridges including suggestions of improvements to system performance; and providing technical review and information to other non-technical staff and vendor technical staff. Requires knowledge and background in Microsoft SSIS, MS SQL Server, and Oracle as well as awareness of the full environment technical stack of Informatica, MuleSoft, COBOL, Java, Salesforce, C# with .NET Core, Oracle, Snowflake and Go Anywhere. Requires experience in coding and integration development to include knowledge of best practices throughout the deployment cycle, as well as of working with sandbox environments. Requires proven leadership, prioritization, and analytical skills. May assign, review and/or supervise the work of others; must have the ability to address issues/concerns in a professional manner in a complex technical environment. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Other responsibilities may include coordination of or performing requested research and the analysis required for work proposals, software and systems modifications, and new projects. Overseeing the analysis, designs, plans, diagrams, and verifying procedures for existing and proposed applications. Provides technical advice, assistance, and recommendations in matters related to programming operations and problems, including Production issues. Essential Job Duties: - 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 analysing 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.
- 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 and Extensive experience with Oil & Gas systems
Certifications: N/A Required Skills & Experience: - Experience working in a medium to large information technology environment to include ever-increasing responsibility for development, design, and/or deployment actions.
- Microsoft SQL Server Integration Services (SSIS)
- Microsoft Azure DevOps and Git required, with emphasis on deployment, version control and project tracking.
- 2 years of experience with Oracle databases with some of that experience being Oracle version 12c
- Experience with Microsoft Azure Cloud database services & Microsoft SQL Server and database object migration/validation tools
- Experience with ETL development, monitoring, batch and/or data processing in an automated scheduled environment
- Knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management
- Knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance.
Preferred Skills: - ETL development and data warehouse monitoring
- Development using Oracle or Microsoft SQL Server, SQL, systems analysis, systems design, other relevant information technology experience.
- Development experience using Microsoft SQL Server Integration Services (SSIS)
- Development experience using Microsoft Azure Cloud databases.
- Experience utilizing Microsoft Azure DevOps and Git
- General knowledge of Informatica or similar ETL tool.
- Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and process, including technical architecture
- Experience in data focused projects, like moving from Legacy to newer systems.
Tryfacta is an Equal Opportunity-Affirmative Action Employer. We do not discriminate on the basis of Minority / Female / Disability / Veteran / Gender Identity / Sexual Orientation / Age
Tryfacta Inc
|