This position is located in the Department of Veterans Affairs, Veterans Benefits Administration (VBA), Office of Performance Analysis and Integrity (PA&I), on the Data Warehouse Team.Qualifications: To qualify for this position, applicants must meet all requirements by the closing date of this announcement:12/24/2023.
TIME-IN-GRADE REQUIREMENT: Applicants who are current Federal employees and have held a GS grade any time in the past 52 weeks must also meet time-in-grade requirements.
To verify your eligibility, you must submit a copy of your most recent Notification of Personnel Action, Standard Form 50 (SF-50). The grade may have been in any occupation, but must have been held in the Federal service. You must provide a copy of your most recent SF-50 that indicates proof of status, and shows Time in Grade (for example, you were a career or career-conditional employee) and identifies your position title, series, grade, step, salary, tenure, and type of service (Competitive or Excepted). If the most recent SF-50 has an effective date within the past year, it may not clearly demonstrate you possess one-year time-in-grade, as required by the announcement. In this instance, you must also submit your most recent promotion or within-grade increase in addition to your recent SF-50. If you previously held a higher grade, you must also submit any SF-50 showing that grade. DO NOT submit Award SF-50's and/or General Adjustment SF-50's as they cannot be used to prove time-in-grade.
- For a GS-14 position you must have served 52 weeks at the GS-13 level.
GS-14 Grade Level:
- Specialized Experience: As a Senior Extract Transform Load (ETL) Developer, candidate must demonstrate proficiency using Informatica PowerCenter to develop mappings, Workflow Manger to create tasks and workflows, and Workflow Monitor to monitor the workflows. The candidate must understand dimensional modeling and star schemas to include, collecting and documenting requirements from business users, designing dimension and fact tables, developing ETL processes, and supporting front end reports. The candidate must have experience in Oracle Database and Informatica ETL performance tuning approaches in Data Warehouse Environments. Additionally, the candidate must have experience building BI solutions in OBIEE, PowerBI, C Sharp or Apex.
- Education Substitution: There is no educational substitution at the GS-14 grade level.
Full vs. Part-Time Employment: Full-time employment is considered to be at least 35 hours per week. Part-time experience will be credited on a pro-rated basis; when including part-time employment in your resume you must specify the average hours worked per week.
Physical Requirements: The work is sedentary, although some slight physical effort may be required.
For more information on these qualification standards, please visit the United States Office of Personnel Management's website at http://://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/.Education: There is no educational substitute at the GS-14 grade level.Employment Type: FULL_TIME