Remote - Lead ETL Informatica developer with IDQ exp 10+yrs exp is plus - NYC, NY

Published date Posted on Indeed on Aug 13, 2022 (55 d ago)
Contract W2, 60 Months
Depends on Experience
Travel not required

Job Description

Title : Lead ETL Informatica developer with IDQ exp 10+yrs exp State or Govt client is plus
Location : New york city, NY
Duration:60 months


If your interested please reply me to my email id : or call me at : 973.528.5778

Job description:
Mandatory Qualifications:
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.
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.
Three years or more experience implementing Master Data Management (MDM) solutions to perform deterministic or probabilistic matching and apply survivorship criteria to deduplicate, split, merge, score and integrate data to arrive at a single source of truth (golden record) and to identify master and reference data

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.


Company Information

Founded in 2006, Spruce Technology is a leading provider of IT services for the public, private, and federal sectors, specializing in Strategic Staffing Services, Solutions & Professional Services, and Advisory Services. With clients in 30+ states, Spruce is a certified MBE and MS Gold Partner.
Dice Id : 10215935
Position Id : YS-ETL

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

ResponsibilitiesProvide clinical data management support to clinical development franchise(s) and related Clinical Operations team and/or study project, Safety, Clinical Management team and Biostatistics.Participate in the review of clinical research.

Maharishi Foundation International Maharishi Foundation International... |
2 d ago

About UsMaharishi Foundation International (MFI) is a US-registered non-profit that supports the development of new technologies and outreach opportunities for the worldwide Transcendental Meditation® (TM®) organisations. Over the past 60 years, more.

American Electric Power American Electric Power |
10 d ago

Job Description:This position is Remote. Candidates will be considered based on their qualifications and the candidate's ability to work from an approved work location. Although the location is flexible, AEP does not have a presence in all states and.

ResponsibilitiesProvide clinical data management support to clinical development franchise(s) and related Clinical Operations team and/or study project, Safety, Clinical Management team and Biostatistics.Participate in the review of clinical research.

ABOUT THIS JOB:Data and Analytics Engineering - Platform team is critical to making our organization's data strategy successful. You will play a key role in architecting and engineering modern, adaptive, data-driven, and secure platforms and processes.