Informatica ETL Developer - IBR (Imagine Believe Realize) : Job Details

The Informatica ETL Developer must be able to meet the key criteria below:Location: 100% remoteYears' Experience: 5+ years professional experienceEducation: Bachelor's Degree requiredSecurity Clearance: IBR is a federal contractor. Applicants must be able to obtain and maintain a Secret security clearance. NOTE: United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.Employment Type: Full-Time, W2Key Skills:Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systemsOracle DBMS experience within large-scale database enterprise systemsCurrent CompTIA Network+, CompTIA Security+, CISSP, or higher-level certification as defined by DoD CIO Information Assurance requirementsPosition OverviewAs an Informatica ETL Developer, you will support the Manpower, Analytics, and Human Resources Systems (MAHRS) program that is in support of the United States Navy. As part of the program, you will assist in overseeing, developing, and maintaining policy for the HR system and data operations. MAHRS develops, delivers, and sustains Human Capital business analytics and tools to improve and support data-driven decision making.ResponsibilitiesConversion of the Extract, Transmit, Load (ETL) process from Data Manager to Informatica Deploy, Upgrade, Operate, Manage, and Support of Informatica environmentsPerform Tuning, Optimization, Troubleshooting, and Daily Monitoring of the databaseMonitor daily extract generation from an Oracle database and address issues independentlyAnalyze, develop, test, and maintain data ETL extraction procedures utilizing InformaticaPerform and support Informatica ETL application installation, configuration, updates and patchesDesign, develop, and maintain Informatica ETL PowerCenter scriptsAnalyze, design, develop and maintain Informatica ETL power scriptsBuild robust ETL pipelines.Optimize data workflows and SQL queries.Pull required data from the Oracle HCM Cloud using the Oracle BI tool and feeding the ETL process the files to be converted into data for existing reports.Involvement in code reviews, debugging, performance tuning, data mappingTranslate business requirements and database administration operational requirements into long-term architecture solutions.Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environmentAnalyzing performance issues, diagnosing/resolving affecting database systemsPerforms data access analysis design, and archive/recovery design and implementation.Maintaining database configurations in compliance with release management, change management, and office of information security requirementsPerform daily activities like production support and continuous database monitoring.Applies knowledge and experience with database technologies, development methodologies, and frontend (e.g. COGNOS) and back-end programming languages (e.g. SQL). Performs database programming and supports systems design.Conducts quality control and auditing databases in a multiple-tier environment to ensure accurate and appropriate use of data.QualificationsBachelor's degree requiredMust be able to obtain a Secret security clearanceCurrent CompTIA Network+, CompTIA Security+, CISSP or higher as defined by the DoD CO Information Assurance (IA) certification requirementsMust possess in depth technical experience specifically with Informatica, SQL, and Python.Experience in PowerCenter developmentInvolvement in code reviews, debugging, performance tuning, data mappingExperience with ETL development and the creation of technical documentation.Prior software development experience desiredExperience performing Informatica ETL Operations and connectors for cloud-based and on-prem ERP systems such as SAP, Oracle, Fusion Cloud, and PeopleSoftOracle Database experience within large-scale database enterprise systems monitoring the database daily and addressing issues independentlyExperienced in supporting ETL data migration. Knowledge of configuration, deployments and troubleshooting.Knowledge of Oracle database provisioning, cloning and patching techniquesExperience with Cognos BI preferred but not requiredData mapping and transformation experience preferred but not requiredExperience working in Databricks preferred but not requiredPhysical Demands and Work EnvironmentWhile this position primarily involves sedentary work in an office environment and/or home-office environment, there are some physical demands associated with the role, including:Extended periods of sitting and working at a computer workstation.Occasional lifting and carrying of equipment or materials weighing up to 20 pounds.Occasional travel to client sites or meetings may be required.Work may need to be performed in a fast-paced environment requiring quick thinking and rapid judgements.Additionally, flexible work arrangements may be available based on business needs.Employee will be exposed to a wide variety of clients in differing functions, personalities, and abilities.About IBRImagine Believe Realize, LLC (IBR) is an emerging small business focused on delivering software and systems engineering solutions to government and commercial clients. Our talent acquisition strategy is tailored to career seeking candidates who embrace continuous learning and desire to grow as a professional in the software/systems engineering industry. We strive to enhance our team members' ability to thrive in the workplace by creating a proper work/life balance and first-class benefits package that includes:Nationwide medical, dental, and vision insurance3 weeks of Paid Time Off and 11 Paid Federal Holidays401k matchingLife Insurance, Short-Term Disability, and Long-Term Disability at no cost to our employeesFlexible spending accounts and Dependent Care spending accountsWellness incentivesReimbursement for professional development and certifications Training assistance opportunitiesUpon hire and in compliance with federal law, all persons hired are required to verify identity and eligibility to work in the United States, and to complete the required employment eligibility verification and background check. IBR is a Federal Contractor.Imagine Believe Realize, LLC is proud to be an Equal Opportunity and Affirmative Action Employer. We do not discriminate based upon race, age, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. Learn more at If alternative methods of assistance are needed with the application process, additional contact information has been provided below:[email protected].###.####