HillsboroRecruiter Since 2001
the smart solution for Hillsboro jobs

Integration Engineer II

Company: Umpqua Bank
Location: Hillsboro
Posted on: November 19, 2021

Job Description:

In this crucial and highly connected role, the Data Integration Engineer support the Enterprise by performing data management, programming, analytic and consultative activities including database, documentation and data trending assessment. Design, develop, and update data integration, profiling, and cleansing routines. Ensuring all relevant metadata is captured and/or updated while providing related modeling, mapping, and process assistance.**Functions**--- Design, develop, test, and update data integration (ETL, replication, and change data capture), data profiling, and data profiling processes. Update and maintain metadata repositories and dictionaries.--- Responsible for creating, validating, and/or updating source-to-target maps. Help perform source analysis and supports departmental process improvement initiatives.--- Assist with logical and physical model design, source-to-target mapping, use cases, and other development processes and artifacts.--- Identify data subject areas, entities, attributes, relationships, information types, and domains. With project team, design and communicate logical and/or physical models and designs.--- Responsible for supporting identification of physical implementation requirements, including normalization techniques and referential integrity or dimensional techniques.--- Assist with defining, maintaining, and enforcing data architecture, definitions, and standards. Participate in data policy, standards, and procedure development processes.--- Perform code reviews, data model reviews, and testing. Establish standards and best practices. Work with IT partners to perform periodic system and database operational tests, audits, and tuning.--- Responsible for promoting understanding of data quality concepts and methods. Identify, document, and recommend solutions for poor quality data.--- Demonstrates compliance with all bank regulations for assigned job function and applies to designated job responsibilities - knowledge may be gained through coursework and on-the-job training. Keeps up to date on regulation changes.--- Follows all Bank policies and procedures, compliance regulations, and completes all required annual or job-specific training.--- Maintain a working knowledge of Bank's written policies and procedures regarding Bank Secrecy Act, Regulation CC, Regulation E, Bank Security and other regulations as applicable to this job description.**Qualification** s--- Bachelor's degree in MIS, computer science, or related field.--- 1-3 years of related experience.--- Basic knowledge of database concepts, methodologies, and architectural approaches.--- Basic knowledge of database systems and administration, including security, development and testing support, modeling and logical design, database design, and quality control.--- Demonstrate strong quantitative, analytical, and problem solving skills, with ability to adapt to new methods, techniques, and procedures.--- Basic knowledge of logical and physical data modeling and data modeling tools. Experienced in complex SQL statements, Microsoft Access, SQL databases, VB programming language, Excel, Data Warehousing, ETL and possibly Crystal Reports. Knowledge of Talend software preferred.--- Proficient in Microsoft Office products (Word, PowerPoint, and Project).--- Basic knowledge of ETL, replication, change data capture and other data integration techniques and technologies (Microsoft SQL Server 2008 Suite of tools (SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Studio, etc.).--- Ability to work effectively in a team or remote environment. Excellent verbal and written communication skills required.**PHYSICAL AND ENVIRONMENTAL DEMANDS**--- Office or remote environment - no specific or unusual physical or environmental demands.--- No travel required.**About Us**We do things a little differently here at Umpqua. Our retail stores serve as community hubs, our associates are given up to 40 hours of volunteer time each year, and we're never satisfied with the status quo. Greatness has no finish line, so we continue every day to keep people at the center of everything we do. We focus on building relationships, understanding our customers' needs and connecting to people in new and innovative ways -- always staying true to our mission of providing personalized banking for all people, whenever and however they prefer to bank.Umpqua Bank is committed to employing a diverse workforce. Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, protected veteran status, or disability. We maintain a drug-free workplace and may perform pre-employment substance abuse testing.\#LI-UP

Keywords: Umpqua Bank, Hillsboro , Integration Engineer II, Engineering , Hillsboro, Oregon

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Oregon jobs by following @recnetOR on Twitter!

Hillsboro RSS job feeds