CPS Recruitment Hiring for Developer / 57878 Job at Albany, NY Full Time

Our client located in Albany, NY, is a supplier of Technical Talent for NYS Government contract jobs. We are partnering with them to find a Developer to perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation.

Pay Rate: $57/hour

This long-term contract is expected to last at least 36 months

Responsibilities and Duties:

Daily activities will include, but are not limited to:

• Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting
  application performance
• Manage and administers ETL solutions for medium to large scale OLTP and OLAP projects
• Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes
• Communicate and coordinate with members of the development team to work across multiple projects
• Explore, actively support and work on new technology initiatives that may be of interest to the organization
• Actively participate in troubleshooting any technical issues that the program may have

Qualifications and Skills:

Mandatory:

• More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer
• ?More than (7) years of experience in analysis,
  design, development, testing and implementation of data integration solutions using PL/SQL & relational databases
• Five or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality

Preferred:

• ?Seven years or more of hands-on 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
• ??Seven or more years 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
• ??Five or more years of experience with Data
  Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge functionality
  using tools such as Informatica Data Quality
• ?Seven years or more 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
• ?Seven or more years of experience writing
  complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes
• ?Seven years or more of experience in performance
  tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes
• ?Experience with implementing ETL solutions for
  medium to large scale OLTP and OLAP projects?
• ?Experience in writing technical specifications
  including ETL source to target mapping documents, ETL design documents, implementation documents
• ?Experience with Health & Human services
  applications