Company:
First Tek, Inc.
Location: Portland
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
POSITION RESPONSIBILITIES
Note: All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.
Develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects.
Edit C# code/routines to transform file formats and/or interact with web services.
Assist with the development of ETL procedures, batch processes, and scheduling; troubleshoot problems and make suggestions for performance tuning and system integrity.
Develop data models and database design techniques, including relational and dimensional modeling.
Effectively map source to target data to meet business/system requirements.
Facilitate SQL stored procedures and advanced SQL queries.
Draft functional and technical requirement documents for diverse audiences (technical and non-technical), including migration, implementation and test plans.
Develop mappings and workflows in Informatica to automate data integration.
Draft working documents for interfaces with non-Standard BPA systems.
Debug, analyze and troubleshoot data quality issues
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Associate's or Bachelor's Degree in Information/Computer Technology, Business Systems or a related technical field is preferred.
With an Applicable Associate's Degree in applicable fields, 7 years of experience is required.
With an Applicable Bachelor's Degree in applicable fields, 5 years of experience is required.
Without a degree, 9 years of experience is required.
Experience must include direct work experience in Information Technology performing Data Analysis.
Required Technical Skills & Experience (required on matrix)
Demonstrated experience with the following:
Informatica PowerCenter version 10 or higher
Microsoft SQL Server 2016/2019/2022
Windows Server 2016 or higher
Oracle 11q or higher
Preferred Skills & Experience (optional on matrix)
The following skills are preferred:
Experience working in a multi domain network environment.
Experience with Azure DevOps (ADO) formerly Team Foundation Server (TFS)
Task automation and monitoring
Informatica Suite including:
Power Center version 10 or higher
Power Exchange version 10 or higher
Microsoft Visual Studio 2016 or higher (C# .NET)
Experience with software development coordination with clients and management
Experience with Oracle relational database system
Experience using XML, XSD, WSDL, Rest API and JSON
Experience in Database Analysis
Experience with Power Shell development
Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.
Note: All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.
Develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects.
Edit C# code/routines to transform file formats and/or interact with web services.
Assist with the development of ETL procedures, batch processes, and scheduling; troubleshoot problems and make suggestions for performance tuning and system integrity.
Develop data models and database design techniques, including relational and dimensional modeling.
Effectively map source to target data to meet business/system requirements.
Facilitate SQL stored procedures and advanced SQL queries.
Draft functional and technical requirement documents for diverse audiences (technical and non-technical), including migration, implementation and test plans.
Develop mappings and workflows in Informatica to automate data integration.
Draft working documents for interfaces with non-Standard BPA systems.
Debug, analyze and troubleshoot data quality issues
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Associate's or Bachelor's Degree in Information/Computer Technology, Business Systems or a related technical field is preferred.
With an Applicable Associate's Degree in applicable fields, 7 years of experience is required.
With an Applicable Bachelor's Degree in applicable fields, 5 years of experience is required.
Without a degree, 9 years of experience is required.
Experience must include direct work experience in Information Technology performing Data Analysis.
Required Technical Skills & Experience (required on matrix)
Demonstrated experience with the following:
Informatica PowerCenter version 10 or higher
Microsoft SQL Server 2016/2019/2022
Windows Server 2016 or higher
Oracle 11q or higher
Preferred Skills & Experience (optional on matrix)
The following skills are preferred:
Experience working in a multi domain network environment.
Experience with Azure DevOps (ADO) formerly Team Foundation Server (TFS)
Task automation and monitoring
Informatica Suite including:
Power Center version 10 or higher
Power Exchange version 10 or higher
Microsoft Visual Studio 2016 or higher (C# .NET)
Experience with software development coordination with clients and management
Experience with Oracle relational database system
Experience using XML, XSD, WSDL, Rest API and JSON
Experience in Database Analysis
Experience with Power Shell development
Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.
Share this job
Useful Links