Sr. Informatica Data

Engineer - 36881862

  • New York

  • $

    85 Per Hour

  • Contract

Reference: 44823

Business Sector: Software Engineering

Description

Job Title: Sr. Informatica Data Engineer
Work Location: Midtown, NYC, Hybrid
Terms: Contract

We are seeking a highly skilled data integration engineer with deep expertise in Informatica to design and deliver scalable, high-performance data pipelines. This role plays a critical part in transforming complex business requirements into robust data solutions, supporting enterprise data platforms across cloud and on-prem environments. You’ll work at the intersection of data engineering, data quality, and platform optimization to drive best practices and ensure reliable, high-quality data delivery.
Key Responsibilities
  • Design, build, and maintain end-to-end data integration solutions using Informatica tools across both on-prem and cloud platforms
  • Translate business needs into scalable technical designs, including mappings, workflows, and data processing logic
  • Develop and optimize ETL/ELT pipelines to ingest, cleanse, transform, and load data into data warehouses, data marts, and data lakes
  • Create reusable components and standardized frameworks to improve efficiency, consistency, and maintainability
  • Implement data quality controls, validation rules, lineage tracking, and auditing processes to ensure data integrity
  • Monitor, troubleshoot, and resolve data pipeline issues, ensuring timely and accurate data delivery
  • Tune and optimize performance of data integration jobs through partitioning, caching strategies, and pushdown techniques
  • Support testing efforts including unit, integration, and user acceptance testing, as well as production validation
  • Contribute to CI/CD pipeline development for automated deployment of data integration workflows
  • Maintain comprehensive documentation including data flows, mappings, and operational procedures
  • Partner with cross-functional teams to drive continuous improvement and adopt best practices in data engineering
Required Qualifications
  • Extensive hands-on experience with Informatica PowerCenter and experience with cloud-based Informatica tools (such as IICS or similar)
  • Strong proficiency in SQL and experience working with relational databases
  • Proven ability to design and implement complex data integration workflows and transformations
  • Solid understanding of data warehousing concepts, dimensional modeling, and modern data architectures (including data lakes)
  • Experience with data quality, governance, lineage, and metadata management principles
  • Familiarity with version control systems and CI/CD practices for data pipelines
  • Strong analytical, troubleshooting, and problem-solving skills
  • Ability to work independently and manage multiple priorities in a fast-paced environment
  • Strong communication skills with the ability to translate business requirements into technical solutions

Preferred Qualifications
  • Experience working in Agile environments (Scrum or Kanban)
  • Familiarity with collaboration and tracking tools such as Jira or Confluence
  • Relevant Informatica certifications are a plus

Education
  • Bachelor’s degree in a technical field or equivalent practical experience

If interested in applying to this position, please send your resume to Marques.Mason@twentyai.com.