Description The Informatica Developer will be responsible for the development of critical data solutions by working closely with business and IT stakeholders in a collaborative, team environment. The individual will utilize Informatica tools to maintain and build ETL workflows. He/she will be responsible for learning how to support our existing Informatica workflows and will be part of a team that defines and implements a set of ETL best practices. The ideal candidate will have an eye for continual improvement. They will help to identify and create designs and architecture that help to make all systems and business processes scalable.

As a Denver Post Top Workplaces award winner seven years in a row (2012-2018), FirstBank provides many great benefits for being a part of our family. From competitive salaries, employer-contributed retirement and health plans, some reduced fee banking services, paid time off, employer paid basic life insurance, short-term and long term disability policies, to holiday parties and more, you will be appreciated and made to feel at home at FirstBank.

FirstBank provides a high-paced work environment with different projects landing on your desk routinely. From building the back-end of new products, improving current products and designing internal systems, to managing our security systems, maintaining and improving infrastructure and much more, no week is the same. This is a challenging position that comes with great rewards.

#DCE

ESSENTIAL DUTIES AND RESPONSIBILITIES:

•Provide hands-on technical leadership in designing, deploying, and maturing the ETL workflows

•Collaborate with Application Developers and Database Administrators, and Architects in creating data interfaces

•Assist in the development, design and enforcement of the overall data integration and ETL strategy and governance policies

•Responsible for writing transformation logic requirements, developing source to target interfaces, validating workflows incorporating business rules and data interface tuning/troubleshooting

•Create scripts to schedule, manage and load data into the data repositories

•Troubleshoot data interface, data quality, and production workflow issues; coordinate resolution with application developers and database administrators

•Monitor vendor websites for bugs and security alerts; apply patches and patch-sets as needed

•Communicate with management on the status of projects and problem resolution efforts

•Maintain knowledge of current and developing technology

•Perform other duties and projects as assigned

•Understand and comply with all provisions of the Safety in the Workplace policy

Salary Commensurate with Experience

Will consider hiring into a lower career stage

Requirements MINIMUM QUALIFICATIONS OF POSITION:

•Typically requires a bachelor’s degree in related field and a minimum of 2 years of related experience. A combination of post-high school education, job related certification and related experience equivalent to 5 years may be considered in lieu of minimum requirements.

PREFERRED QUALIFICATIONS OF POSITION:

•Bachelor’s Degree in Computer Science, other technical field, or business preferred

KNOWLEDGE AND SKILLS:

•Strong organizational skills

•Strong technical problem-solving, customer service, and collaboration skills

•A strong understanding of data integration concepts and a willingness to continue to learn

•Solid analytic skills for data structures, data flow, data patterns, and data governance

•Good understanding of structured and unstructured data sources including Oracle, SQL Server, DB2, and IMS DB

•Good understanding of SQL, PL/SQL, Transact-SQL concepts and programming

•Analytical and technical aptitude

•Excellent oral and written communication skills

•Excellent project management, organizational, and customer service skills

•Strong ability to work in a team oriented environment

•Development of broad knowledge across the organization including business process, application development methodology, database administration, and testing

•Ability to lead initiatives and manage projects with minimal guidance

•Ability to provide 24x7 on call support

•Note: Initially, hires from outside the company would not have the FirstBank specific knowledge required

WORKING CONDITIONS AND PHYSICAL REQUIREMENTS:

Work is performed in an office environment with moderate noise levels and light to heavy traffic. An individual in this position:

• Frequently remains stationary throughout a typical business day

• Frequently operates a computer and other office machinery, such as a calculator, copy machine, and computer printer

• Occasionally moves about inside the office to access file cabinets, office machinery, and other rooms

• Occasionally positions self to access drawers and shelves of various heights

• Frequently reaches for and handles paperwork and files

• Constantly communicates with customers, coworkers, and management in-person and on the phone

• Must be able to exchange accurate information

Work Hours Monday through Friday

Part Time No

• FirstBank is an EOE/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, genetic information, disability, veteran status, or any other applicable status protected by state or local law.

• Please view Equal Employment Opportunity Posters provided by OFCCP hereat http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm .

• FirstBank will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with FirstBank’s legal duty to furnish information. 41 CFR 60-I.35(c)