Etl Informatica Developer Remote Jobs in Colorado

Summary
Public Service Loan Forgiveness Program and Creditable Service for Annual Leave Accrual are available.
This position is located in the Office of the Chief Information Officer (OCIO), Business Solutions Center (BSC).
IT Specialist (DATAMGT) is responsible for database design, development, configuring, testing, acquisition, deployment, maintenance, monitoring, security and support, data structure logic, data availability and data quality.
Learn more about this agency
Duties
Help

• Develops, deploys, maintains, and administers data pipelines and enterprise data engineering solutions.
• Designs and integrates ETL workflows using tools and languages such as Python, AWS, Azure, and Apache Spark to clean, blend, join, and transform datasets.
• Defines requirements and supports data structure design, development, implementation, and maintenance for FSIS data systems.
• Serves as a point of contact, liaison, facilitator, and SME for requirement gathering, standards enforcement, modernization efforts, and data platform administration.
• Participates in and leads requirements analysis and refinement sessions; resolves requirement conflicts and ensures clarity, completeness, and consistency.
• Leads daily Scrum meetings, plans sprints, tracks and reports agile metrics (e.g., sprint velocity), and demonstrates product capabilities to customers and FSIS leadership.
• Meets with customers to gather requirements for existing and new implementations.
• Collaborates with senior staff, Project Management, Architecture, Enterprise groups, and external FSIS stakeholders to design and implement data warehouse and data lake solutions.
• Provides subject-matter expertise in enterprise and emerging data management technologies, including data orchestration and data engineering/analytics.
• Ensures data and index integrity; performs data validation across multiple datasets.
• Establishes, implements, and oversees Standard Operating Procedures (SOPs) for data platform administration and data management technologies.
• Ensures business requirements are documented and tested.
• Serves as liaison between OCIO system developers and business stakeholders for business application requirements.
• Creates, edits, maintains, and reviews SDLC documentation.

Requirements
Help
Conditions of employment

• You must be a US Citizen or US National.
• Males born after 12/31/1959 must be Selective Service registered or exempt.
• Subject to satisfactory adjudication of background investigation and/or fingerprint check.
• Successful completion of one-year probationary period, unless previously served. Refer to the Next Steps section for more information.
• Direct Deposit: Per Public Law 104-134 all Federal employees are required to have federal payments made by direct deposit to their financial institution.
• Successfully pass the E-Verify employment verification check. To learn more about E-Verify, including your rights and responsibilities, visit https://www.e-verify.gov/.
• False statements or responses on a resume or application can jeopardize employment and may be grounds for disciplinary action, including removal from Federal service.
• If you are selected, you may need to complete a Declaration for Federal Employment (OF-306) prior to being appointed to determine suitability for Federal employment and to authorize a background investigation.

Qualifications
Applicants must meet all qualifications and eligibility requirements by the closing date of the announcement including specialized experience and competency proficiency as defined below.
FOR GS-13 CONSIDERATION: Applicants must have one year of specialized experience at the GS-12 grade level in the Federal service or equivalent responsibility in the private sector/pay systems. This specialized experience must include all the following:

• Experience with the principles and methods to identify, analyze, specify, design, and manage functional data and data lake infrastructure requirements; includes translating data requirements into technical requirements used for logical design or presenting alternative technologies or approaches.
• Experience working on a Cloud data lake and/or Data warehouse.
• Experience with building data pipelines / ETLs using tools and languages such as python and Apache spark.
• Experience leading Scrum and/or Agile meetings and tracking agile metrics.

In addition to the above specialized experience requirements, applicants will undergo a structure resume review to determine whether they meet the Individual Occupational Requirements (IOR) of the 2210 series. Successfully completing the 2210 series USAHire assessment with a passing score will be used as proof of possessing the necessary proficiency in the following competencies: Attention to Detail, Customer Service, Decision Making, Interpersonal Skills, and Teamwork. A panel of subject matter experts will review your resume to determine if you meet the minimum proficiency level (as defined by the 2210 series IOR) for the following competencies:

• Information Management
• Oral Communication
• Problem Solving
• Technical Competence

Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Volunteer work helps build critical competencies and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
Click here for more information on this series: OPM Information Technology Management Series 2210
Additional information
Career Transition Assistance Plan (CTAP), Reemployment Priority List (RPL), or Interagency Career Transition Assistance Plan (ICTAP): Visit the OPM website for information on how to apply as a CTAP, RPL, or ICTAP eligible. To exercise selection priority for this vacancy, CTAP/RPL/ICTAP candidates must meet the basic eligibility requirements and all selective factors. CTAP/ICTAP candidates must be rated and determined to be well qualified (or above) based on an evaluation of the competencies listed in the How You Will Be Evaluated section. When assessed through a score-based category rating method, CTAP/ICTAP applicants must receive a rating of at least 80 out of a possible 100 on the USAHire Assessment.
Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments, based on your adjudication decision. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments.
Expand Hide additional information
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
Benefits
Help
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Review our benefits
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.