Developer ETL

Job Title: Informatica IDMC Developer

Duration: 12+ Months Contract

Location: Weehawken, NJ (Onsite)

Role:
Informatica IDMC Developer designs, builds, and maintains data integration solutions using Informatica Data Management Cloud (IDMC) and Intelligent Cloud Services (IICS), focusing on ETL/ELT pipelines, data quality, and governance across cloud/on-prem systems, requiring strong SQL, cloud platform knowledge (AWS/Azure/GCP), and skills in data modeling, transformations, and troubleshooting data issues for data warehousing and analytics.

• Design & Develop:
  Create data integration workflows, mappings, and pipelines using IICS/IDMC for data ingestion, transformation, and loading.
• Cloud Integration:
  Connect and manage data flow between cloud and on-premises applications, potentially with SAP, Salesforce, Snowflake.
• Data Quality:
  Implement data profiling, cleansing, and validation rules using Informatica Data Quality (IDQ).
• Governance:
  Apply data governance policies and standards within IDMC.
• Performance Tuning:
  Optimize data workflows and mappings for efficiency.
• Troubleshooting:
  Debug and resolve data pipeline issues.
• Documentation:
  Create technical documentation for processes and workflows.

• Informatica:
  Strong experience with IDMC, IICS, and potentially Informatica Power Center.
• Databases:
  Proficiency in SQL, PL/SQL, and working with databases (Oracle, SQL Server).
• Cloud:
  Familiarity with cloud platforms (AWS, Azure, GCP).
• Data Concepts:
  Understanding of data warehousing, data modeling, and ETL principles.
• Technical
  
  Skills:
  
  Experience with file formats (CSV, JSON, Parquet) and error handling.
• Soft Skills:
  
  Analytical, problem-solving, and communication skills; ability to work in teams.

• Experience with Informatica MDM (Master Data Management).
• Knowledge of modern ETL frameworks and migration projects.
• Experience with data ingestion and replication.

Minimum years of experience: 10 years

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.