Lead ETL, Informatica Developer at Remote, Remote, USA |
Email: [email protected] |
From: Chetan Kumar Jha, Absolute IT [email protected] Reply to: [email protected] Job Title: Lead ETL/Informatica Developer Location: Hybrid in Albany, NY (Relocation ok) . Duration: 28 Month Visa: USC, GC, GC EAD & H4 EAD Mandatory Qualification (PASS/FAIL) 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 seven (7) years of experience working on complex data migration projects with 2 or more years in a leadership role as a Developer performing data extraction, data transformation, and data loading (ETL) from legacy systems to a modern data platform. More than (7) years of hands-on experience in implementing and maintaining data integration and master data management processes using Informatica suite of products such as Informatica PowerCenter, Informatica Data Quality, and Informatica Master Data Management (MDM). Additional Qualifications: Seven years or more of hands-on experience using Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, JSON, and XML files. Five or more years 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. Three or more years of hands-on professional experience performing MDM activities such as data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, automation, and orchestration using Informatica MDM. Five years or more experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality for data migration projects. Seven or more years of experience developing complex SQL, T-SQL, PL/SQL objects with Oracle 19c or SQL Server 2019, or higher such as stored procedures, triggers, packages, materialized views, and performance tuning. Three or more years of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL processes. Keywords: information technology green card procedural language New York Lead ETL, Informatica Developer [email protected] |
[email protected] View all |
Fri Oct 11 03:41:00 UTC 2024 |