Job Requirements
Remote
Secret Polygraph not specified
Mid Level Career (5+ yrs experience)
Salary not specified
Join Premium to unlock estimated salaries 
Job Description
Location: 100% Remote
Years’ Experience: 5+ years Professional Experience
Education: Bachelor’s Degree Required
Clearance: Applicants must be able to obtain and maintain a secret security clearance. United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.
Required Certifications:
• Must currently hold an active CompTIA Security+ certification
Key Skills:
• Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems
• Informatica Development experience required
• Oracle DBMS experience within large-scale database enterprise systems
Responsibilities
• Conversion 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 transformation.
• Deploy, Upgrade, Operate, Manage, and Support of Informatica environments.
• Perform Tuning, Optimization, Troubleshooting, and Daily Monitoring of the database.
• Monitor daily extract generation from an Oracle database and address issues independently.
• Analyze, develop, test, and maintain data ETL extraction procedures utilizing Informatica.
• Perform and support Informatica ETL application installation, configuration, updates and patches.
• Design, develop, and maintain Informatica ETL PowerCenter scripts.
• Analyze, design, develop and maintain Informatica ETL power scripts.
• Build 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 mapping.
• Translate 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 requirements.
• Perform 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.
Qualifications
• 5+ years professional experience required.
• Must currently have an active Secret security clearance.
• Must currently hold an active CompTIA Security+ certification.
• Must possess in depth technical experience specifically with Informatica, SQL, and Python, and experience in PowerCenter development.
• Must have experience with ETL development and the creation of technical documentation.
• Experience performing Informatica ETL Operations and connectors for cloud-based and on-prem ERP systems such as SAP, Oracle, Fusion Cloud, and PeopleSoft.
• Oracle Database experience within large-scale database enterprise systems monitoring the database daily and addressing issues independently.
• Experienced in supporting ETL data migration.
• Experience performing code reviews, debugging, performance tuning, and data mapping.
• Prior software development experience is beneficial.
• An understanding of data warehousing concepts.
• Knowledge of configuration, deployments and troubleshooting.
• Knowledge of Oracle database provisioning, cloning and patching techniques.
• Experience with Cognos BI preferred but not required.
• Data mapping and transformation experience is preferred but not required.
• Experience working in Databricks is preferred but not required.
About Sparibis
Sparibis 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.
Years’ Experience: 5+ years Professional Experience
Education: Bachelor’s Degree Required
Clearance: Applicants must be able to obtain and maintain a secret security clearance. United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.
Required Certifications:
• Must currently hold an active CompTIA Security+ certification
Key Skills:
• Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems
• Informatica Development experience required
• Oracle DBMS experience within large-scale database enterprise systems
Responsibilities
• Conversion 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 transformation.
• Deploy, Upgrade, Operate, Manage, and Support of Informatica environments.
• Perform Tuning, Optimization, Troubleshooting, and Daily Monitoring of the database.
• Monitor daily extract generation from an Oracle database and address issues independently.
• Analyze, develop, test, and maintain data ETL extraction procedures utilizing Informatica.
• Perform and support Informatica ETL application installation, configuration, updates and patches.
• Design, develop, and maintain Informatica ETL PowerCenter scripts.
• Analyze, design, develop and maintain Informatica ETL power scripts.
• Build 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 mapping.
• Translate 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 requirements.
• Perform 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.
Qualifications
• 5+ years professional experience required.
• Must currently have an active Secret security clearance.
• Must currently hold an active CompTIA Security+ certification.
• Must possess in depth technical experience specifically with Informatica, SQL, and Python, and experience in PowerCenter development.
• Must have experience with ETL development and the creation of technical documentation.
• Experience performing Informatica ETL Operations and connectors for cloud-based and on-prem ERP systems such as SAP, Oracle, Fusion Cloud, and PeopleSoft.
• Oracle Database experience within large-scale database enterprise systems monitoring the database daily and addressing issues independently.
• Experienced in supporting ETL data migration.
• Experience performing code reviews, debugging, performance tuning, and data mapping.
• Prior software development experience is beneficial.
• An understanding of data warehousing concepts.
• Knowledge of configuration, deployments and troubleshooting.
• Knowledge of Oracle database provisioning, cloning and patching techniques.
• Experience with Cognos BI preferred but not required.
• Data mapping and transformation experience is preferred but not required.
• Experience working in Databricks is preferred but not required.
About Sparibis
Sparibis 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.
group id: 91099499