Sparibis
Location: 100% RemoteYears' Experience: 5+ years professional experienceEducation: Bachelor's Degree requiredWork Authorization: United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.Clearance: Applicants must be able to obtain and maintain a Secret security clearance. Key Skills: Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systemsOracle DBMS experience within large-scale database enterprise systemsCurrent or ability to obtain either CompTIA Network+, CompTIA Security+, or higher-level certification as defined by DoD CIO Information Assurance requirementsResponsibilitiesConversion of the Extract, Transmit, Load (ETL) process from Data Manager to Informatica Responsible for designing, developing, and maintaining ETL processes to facilitate data integration and transformationDeploy, 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.Ensure that data is accurately and securely extracted, transformed, and loaded into database system for analysis and reporting.Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environment.Analyzing performance issues, diagnosing/resolving affecting database systems.Performs 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. Understanding of data warehousing conceptsKnowledge 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 requiredAbout SparibisSparibis LLC is a professional solution firm that Clients rely on to access the best talent to drive their business success. Sparibis is an equal opportunity employer that values diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply.