Data Analyst

Job Title: Data Analyst 2 - Data Integrations Specialist Job Number: 11764 Location: Portland, OR - Remote work – Must live in either WA, OR, ID, MT Overtime: 5 % On Call: on a rotational basis Travel: up to 10 % for local meetings Length: 5 years MUST be US Citizen to be eligible to apply for Federal Background Check SUMMARY This full-time contract position is located in the Data Integration and Reporting organization within the corporate IT department. This position will draft Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects. This position will also support operations and maintenance, as well as provide 24x7 production support on a rotational basis POSITION RESPONSIBILITIES • Draft Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects. • Draft ETL procedures, batch processes, and scheduling; troubleshoot problems and make suggestions for performance tuning and system integrity. • Develop mappings and workflows in Informatica to automate data integration. • Develop data models and database design techniques, including relational and dimensional modeling. • Effectively map source to target data to meet business/system requirements. • Implement corporate management approved SQL stored procedures and advanced SQL queries. • Assist with the development of functional and technical requirements documents • Draft working documents for interfaces with non-Standard corporate systems. • Debug, analyze and troubleshoot data quality issues. REQUIREMENTS Education & Experience: • Bachelor’s degree in information/computer technology or a closely-related field is preferred. • 5 years of experience is required with an applicable bachelor’s degree. • 9 years of experience is required without a degree or an applicable degree. Required Technical Skills & Experience • 5 years of experience in Data Integration Techniques. • Experience with the following: • Oracle 11g, 12g, 18c or 19c. • Writing DDL and creating database objects. • Partitioning database tables. • Creating Oracle procedures, functions and views. • ETL tool such as Informatica Suite (including Power Center and Power Exchange) Preferred Skills & Experience • Microsoft SQL Server relational database system. • Using XML, REST, XSD and WSDL. • Web Services. • Power Shell development. • Data Warehousing design techniques. • Data analysis, source system analysis and data mapping. • Knowledge of Oracle OLTP and HCC compression. • Informatica Suite (one or more of Power Center version 9 or higher, Data Services, Power Center Cloud) Pre-Employment Requirement All employment offers are contingent upon successful completion of our pre-employment screening that may include drug testing, background/criminal check, and if applicable, must meet eligibility requirements for access to classified information. APR Staffing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. About APR Staffing APR Staffing was born from the merger of two well-respected technical staffing firms in Portland. ieSolutions and Data Resource Group. Both companies have been recent award winners for the Portland Business Journal's Fastest-Growing Private Companies. The two firms, now as APR Staffing, make for one of the fastest-growing and most-respected professional and technical staffing companies in Oregon and Southwest Washington. Collaborating with our customers, we augment their workforce with technical and administrative professionals. We provide only high-caliber, professional-grade resources throughout the Pacific Northwest.