Oracle PL/SQL Developer

Trigyn's direct government client has an immediate need for an Oracle PL/SQL Developer in Albany, NY.

Description:
? As part of the product development team, you will work in an agile environment and collaborate and develop solutions to solve data integration challenges.
? As part of the Data Migration team, you will perform data migration activities to migrate data from legacy systems such as the mainframe, extracted data files, and databases to a modern data platform.
? As part of the Data Migration team, you will perform activities such as analyzing, designing, developing, testing, and deploying Extract, Transform, and Load (ETL) solutions.
? As part of the Data Migration team, you will perform data preparation activities such as data extraction, data analysis, data profiling, and data cleansing.
? As part of the Data Conversion team, you will perform data conversion activities such as data mapping and data consolidation of duplicate and redundant data.
? As part of the Data Management team, you will monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
? As part of the Data Management team, you will create ETL design, source to target mapping documents, and implementation documentation.
? Communicate and coordinate with members of the product team to work across multiple projects.
? Other duties as assigned.

Mandatory Qualification:
? Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software.
? Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

? 60 months of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.
? 60 months of experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.
? 60 months of experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
? 60 months of experience with Data Quality processes, approaches, measurement techniques and business cases for data analysis, data profiling, data cleansing, data standardization, match and merge functionality using Informatica Data Quality
? 60 months of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.
? 60 months of experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.
? 60 months of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL process
? 60 months of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.

For Immediate Response call , or send your resume to
For Immediate Response call , or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.