Data Integration SpecialistThe role involves designing, building, and supporting enterprise data integration solutions using Informatica Data Management Cloud (IDMC) and Intelligent Cloud Services (IICS). The focus is on ETL/ELT pipelines, data quality, and governance across cloud and on-prem environments, supporting data warehousing and analytics initiatives.Location: Weehawken, NJ (Onsite – 5 days/week)Salary Range: Competitive based on experience and qualificationsRequired Skills & Qualifications:Strong hands-on experience with IDMC, IICS (PowerCenter a plus)Advanced SQL / PL-SQL; experience with Oracle, SQL ServerExperience with AWS, Azure, or GCPETL/ELT, data warehousing, data modeling conceptsExperience with CSV, JSON, Parquet, error handling, and transformationsStrong analytical, troubleshooting, and communication skillsPrior work experience at client or in client's IndustryApplicants must be able to work directly for Artech on W2Preferred Skills & Qualifications:Informatica MDM (Master Data Management)Experience with modern ETL frameworks and migration projectsExperience with data ingestion and replication solutionsDay-to-Day Responsibilities:Design and develop data integration workflows, mappings, and pipelines using IDMC/IICSBuild and manage data flows between cloud and on-prem systems (e.g., SAP, Salesforce, Snowflake)Implement data profiling, cleansing, and validation using Informatica Data Quality (IDQ)Apply data governance standards and policies within IDMCOptimize performance of data pipelines and mappingsTroubleshoot and resolve data integration issuesProduce clear technical documentation for workflows and processesCompany Benefits & Culture:Comprehensive health, dental, and vision insurance401(k) with company matchingOpportunities for professional growth and development