Lead ETL/Informatica Developer Job at MVP Consulting Plus, Albany, NY

WHVVYUIwOFhFQmNDMDJScG9MRGxucFdlL2c9PQ==
  • MVP Consulting Plus
  • Albany, NY

Job Description

As a direct vendor to the NYS Integrated Eligibility System project in Albany, NY, we are seeking a Lead ETL Developer: Duties/Responsibilities: Daily activities will include, but are not limited to: Perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation. 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 administer ETL solutions for medium to large scale. Mandatory Qualifications: Level III - 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. Desirable Qualifications: 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. Three or more years of experience in MDM preferably with Informatica MDM. 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. #J-18808-Ljbffr MVP Consulting Plus

Job Tags

Similar Jobs

Sanford Health

Medical Assistant - Neurology Clinic Job at Sanford Health

Careers With Purpose With over 224 clinic locations and 46 medical centers, Sanford Health is one of the largest and fastest-growing not-...  ...re seeking a caring, responsible, and empathetic Medical Assistant (MA/CMA) who will be involved in assisting with patient care... 

LifeStance Health

Psychologist- Top Market Pay - La Mesa, CA Job at LifeStance Health

We are actively looking to hire talented Psychologists in the La Mesa area, who are passionate about patient care and committed to clinical excellence. We offer Psychologists: Sign on bonus Competitive Compensation: $140,000 - $152,000. Flexible work schedules...

Addison Group

Credentialing Specialist Job at Addison Group

 ...Job Description Job Title: Credentialing Coordinator Location (city, state): Oak Brook, IL Industry: Healthcare Administration / Credentialing Pay: $25$28/hour (depending on experience) About Our Client: Our client is the nations... 

Schneider

CDL-A - Dedicated truck driver - Independent Container Line Job at Schneider

 ...$1,240 weekly Home time: Weekly Experience: All CDL holders Overview ~ Haul ship containers...  ...driving. Weekly performance pay. Paid orientation. Paid time off after 6...  ...0 miles of Wilmington, NC. Need CDL training? Explore our company-paid CDL training... 

David Pool and Spa

Swimming Pool Service Technician Job at David Pool and Spa

 ...Job Description Job Description A Pool Service Technician is responsible for maintaining swimming pools and related equipment. They perform routine maintenance, repair damages, and ensure pools are up to safety and health standards. Due to the nature of the job most...