Overview:
ACS Professional Staffing is looking for an employee to work on-site with our client. This Data Analyst 2 position will develop Extract, Transform, and Load (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects. This position requires demonstrated experience using ETL tools, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). In addition to new development, responsibilities will also include supporting operations and maintenance, as well as providing 24/7 production support on a rotational basis. This full-time position is located in Portland, OR.
Responsibilities:
- 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 systems.
- Debug, analyze and troubleshoot data quality issues
Requirements:
- 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.
- 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
- 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
- Valid U.S. Driver’s License is required.
Work sponsorship is not available at this time. Third-party candidates will not be considered for this position.
Because we are a federal government contractor, we have special restrictions placed on us for hiring foreign nationals into certain key positions within the company. This particular position requires U.S. citizenship.
ACS Professional Staffing will provide equal employment opportunities to all applicants without regard to the applicant’s race, color, religion, sex, gender, genetic information, national origin, age, veteran status, disability status, or any other status protected by federal or state law. The company will provide reasonable accommodations to allow an applicant to participate in the hiring process if so requested.
If you have any questions about the job posting, please contact recruiting@acsprostaffing.com
If you have any questions about our Reasonable Accommodation Policy, please feel free to email hr@acsprostaffing.com