ETL Data Warehouse Engineer - Informatica & PL/SQL

Orabase Solutions; Florida; On-site; USD 80,000 - 120,000; Full time

Job summary

Orabase Solutions is seeking an experienced professional for ETL data integration in the Town of Florida, NY. The role involves designing, developing, and maintaining the ETL process using Informatica PowerCenter, along with performing data analysis through advanced PL/SQL scripting. Candidates should have a strong background in data warehousing and optimization. The position is project-based across various client sites in the U.S., and candidates must be authorized to work in the U.S. without sponsorship.

Qualifications

• 5+ years experience with ETL processes and data warehousing.
• Strong knowledge of data integration and performance optimization.
• Ability to work on long-term project assignments.

Responsibilities

• Design, develop and maintain the ETL data integration process.
• Analyze and validate data objects using advanced PL/SQL scripting.
• Optimize databases and performance of data warehouses.

Skills

ETL data integration

Informatica PowerCenter

PL/SQL scripting

Data analysis

Tools

Informatica Tool Set

Job description

Job Duties

Responsible for the ETL data integration process which is accomplished using Informatica PowerCenter; Perform data object analysis by defining, analyzing and validating data objects and relationship using advanced PL/SQL scripting and Informatica tool set.; Design, develop and maintain ETL data integration process with Business Intelligence and IT Team. Perform and maintain performance of data warehouse by identifying and resolving data conflicts, optimizing databases, networks and hardware

Job Duties

Responsible for the ETL data integration process which is accomplished using Informatica PowerCenter; Perform data object analysis by defining, analyzing and validating data objects and relationship using advanced PL/SQL scripting and Informatica tool set.; Design, develop and maintain ETL data integration process with Business Intelligence and IT Team. Perform and maintain performance of data warehouse by identifying and resolving data conflicts, optimizing databases, networks and hardware

EO Statement

ORABASE is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that ORABASE will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

Additional Information

+Job Site: 2035 Central Circle Suite 208, McKinney TX 75069

+Travel Details (if applicable): No travel; no telecommuting. Position is project-based at long-term projects at various unanticipated client sites within the U.S., and relocation may be required at the end of each long-term project.

+Mail Resumes To: 2035 Central Circle Suite 208, McKinney TX 75069

+No calls or emails. EOE.

+Must be legally authorized to work in the United States without sponsorship