Federal Reserve Bank ETL- Informatica Software Engineer I - ETL-Information Software Engineer II in Omaha, Nebraska

Job Summary:

The ADS Supervisory Administrative Solutions department of the Federal Reserve Bank of Kansas City - Omaha Branch is seeking a Data Development Software Engineer. The Federal Reserve plays a major role in providing Banking supervision and regulation. This position will be responsible for the design, development, engineering and reengineering of software solutions for a nationally used enterprise system in support of supervision and regulation. Individuals placed within this family will possess specialized technical skills in the domain of software engineering. Progression within the family is both a combination of evolved technical expertise, complexity of assignments and demonstrated leadership.

Key Activities:

  • Leads and/or contributes to the analysis, design, development, integration with peripheral systems, and engineering of enterprise solutions for the organization’s most strategic and complex application delivery projects.

  • Develops strong partnerships and relationships with business customers and key stakeholders.

  • Participates in designing and developing complex reports, analysis, and (Informatica) ETL by writing Design Specifications description of framework, interfaces, services, report, business components and interaction between the components.

  • Provide input on Mapping objects and attributes between source and target databases.

  • Develop and automate data reconciliation between systems Convert Mappings into (Informatica) ETL workflows.

  • Proficient at analyzing business requirements and creating technical designs and specifications for less experienced team members.

  • Provides mentoring and guidance to less experienced staff.

  • Proficient at consulting with customers in the development of technology strategies related to the portfolio in which they are engaged.

  • Maps objectives into roadmap initiatives and works with management to define milestones and deliverables.

  • Expert at leading by example and consistently demonstrates high performance in the areas of customer service, collaboration, team work, mentoring, reliability and solution delivery.

  • Proficient at communicating status and progress on assignments.

  • Raises issues and risks in a timely fashion and effectively contributes to mitigating activities.

  • Proficient at collaborating with complex, matrixed project teams, that are often geographically dispersed and span multiple disciplines (e.g., database administration, server administration, project management, business analysis, etc.), as well as varying skill levels.


  • Bachelor’s degree from an accredited college or university with specialization in an information technology field, or an equivalent combination of related education and work experience.

  • Requires at least 5 years of relevant and progressive information technology experience directly related to architecture, design, and development and management of Data and ETL solutions, ranging in complexity from department-class to enterprise-class.

  • Strong SQL and relational database experience required.

  • Strong Informatica / ETL experience required.

  • ETL performance tuning and parallel processing experience preferred.

  • Demonstrated knowledge and application of ETL Data Warehousing best practices.

  • Experience with Business intelligence report development using Microsoft SQL Server Reporting Services (SSRS), Tableau etc.

  • Data management and Metadata solutions experience.

  • Experience in balancing the complexity of a solution with maintainability. Java development experience preferred.

  • Demonstrated progression in complexity of applications and/or assignments, etc.

  • Strong interpersonal, customer service and communication skills.

  • Interacts with business lines to discuss high-level concepts and/or desired technology solutions based on bias from previous experience; suggests/influences optimal course of action to meet business needs.

  • Explains technical information in terms easily understood by target audiences.

  • Is responsive to customers, exhibits confidence, and is viewed as a credible source.

In some cases, positions require access to confidential supervisory information, access to which is limited to "Protected Individuals" as defined by regulation of the Board of Governors of the Federal Reserve System, 12 CFR 268.205. Protected Individuals include, but are not limited to, U.S. citizens, U.S. nationals, and lawful permanent resident aliens (also known as "green card holders") who are eligible for and seeking United States citizenship within the requisite timeframes.

Follow us on LinkedIn, Twitter, and our YouTube channel - Kansas City Fed.

/The Federal Reserve Bank of Kansas City is an equal opportunity employer. As such, the Bank recruits, hires, trains, and promotes individuals without regard to race, color, religion, sex, national origin, age, disability and/or sexual orientation./


Organization: *Federal Reserve Bank of Kansas City

Title: ETL- Informatica Software Engineer I - ETL-Information Software Engineer II

Location: NE-Omaha

Requisition ID: 255697