• Senior SQL/Informatica ETL Developer

    Job Locations US-DC
    Job ID
    2225
    Category
    Technical Support
  • Overview

    Growth requires a strong foundation, and at Buchanan & Edwards, our people are our strength. They are the foundation for building the next generation of innovative IT solutions, revolutionizing the industry, and solving the nation’s most critical challenges.

     

    Let Buchanan & Edwards help you unleash your potential and reach your goals. 


    Come grow with us.

     

     

    About the project:The Federal Bureau of Investigation’s (FBI) Resource Planning Office (RPO) has driven business innovation, managed enterprise processes, and provided data informed analyses to the FBI. In service of this mission, RPO has developed six enterprise IT systems, as well as a number of smaller IT-related capabilities, programs, and projects to address specific FBI enterprise management needs and challenges. These systems serve the FBI with integrated enterprise business intelligence reports and analytical capabilities, compensation and benefits analysis and management, process improvements and automation, and operational and intelligence program management

     

    Clearance

    Top Secret

    Responsibilities

    Integrate data between RPO and partner systems and relational data warehouses and lakes for purposes including business intelligence, analysis, and corporate data management, including but not limited to:

    • Design, develop, enhance and maintain the flow of data to and from other FBI systems, for example using available web services or database views
    • Design, develop, enhance and maintain data warehouses, lakes and marts
    • Provide continuous new development to expand and enhance reporting functionality and data sources to meet changing reporting needs
    • Integrate data from new source systems and expand existing data sets from current source system integrations
    • Coordinate dataset changes across FBI systems
    • Host and share standardized corporate data sets for use by system and individual customers
    • Refactor and modernize data subjects from historic (existing) data warehouses and source data repositories into the Enterprise Data Warehouse (EDW), to provide accurate and dynamic reporting capabilities to end-users and data consumers.
    • Support existing production data warehouses and existing enterprise reporting tools until the EDW is available for refactor

    Qualifications

    Required:

    • Bachelor's Degree in a technical field
    • At least 5 years of experience in requirements analysis, systems engineering, operations and maintenance, network/ systems administration, and configuration management.
    • Extensive experience with the latest version of Oracle and SQL format/data modeling.
    • Possess the necessary developer skills to gather, define, document, analyze and implement PL/SQL Informatica, ETL/data.
    • Possess the necessary developer skills to design, code, test, schedule, and implement code.
    • Possess the necessary developer skills to develop, execute, document, and provide guidance on unit test plans, test data, and test results.
    • Extensive experience in understanding the data warehouse concepts and relational databases.
    • Possess the necessary developer skills to model database structures, tables, and fields.
    • Possess the necessary developer skills to debug and troubleshoot production environment application issues.
    • Possess excellent oral and written communication skills with emphasis on complex technical topics and effectively communicating details with all levels of management.
    • Possess the necessary people skills to identify requirements and deliver results.

    Preferred:

    • Ability to manipulate Informatica ETL to perform data analysis
    • Prior work experience with the Federal Bureau of Investigation

     

    Buchanan & Edwards, Inc. (BE) is an Information Technology and Professional Services consulting firm located in Arlington, VA. BE is a diversified high-technology services company, providing government, commercial and nonprofit agencies technology solutions and organizational management services to ensure mission success. Serving the federal sector since 1998, we base our solutions on an in-depth understanding of our clients, their mission and the unique challenges they face. BE is the winner of the 2015 Microsoft U.S. Federal Solution Partner of the Year award, a 2015 and 2016 Washington Post Top Workplace and has been an Inc. 500/5000 awardee for six consecutive years.

     

    Buchanan & Edwards, Inc. is dedicated to fostering, cultivating and preserving a culture of diversity and inclusion. We are committed to crafting a workplace that endorses creativity and innovation, and promotes engagement through open communication, acceptance of new people and ideas, and a supportive team dynamic. Buchanan & Edwards, Inc. is an equal Opportunity Employer –Minorities / Women / Veterans / Individuals with Disabilities / Gender Identity / Sexual Orientation. Buchanan & Edwards is an E-Verify employer.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed