Senior ETL Informatica PowerCenter Engineer

Synechron; Charlotte (NC); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Competitive compensation

Global offices and mobility programs

Paid time off and holidays

Udemy for Business training

Job summary

Synechron, a global consulting firm, seeks an experienced ETL Informatica Engineer to design, develop, and maintain enterprise data integration solutions using Informatica PowerCenter. The role collaborates with data architects and BI teams to build robust pipelines, optimize SQL, and ensure data quality across warehousing platforms.

Charlotte-based position with competitive base salary and benefits. Candidates should have 5+ years ETL experience and 4+ years PowerCenter, strong SQL, and

Qualifications

• 5+ years of ETL development experience.
• 4+ years hands-on Informatica PowerCenter experience.
• Strong SQL and data warehousing knowledge.

Responsibilities

• Design, develop, test, and deploy ETL workflows using Informatica PowerCenter.
• Develop and maintain mappings, workflows, and transformations.
• Map source-to-target data and model data warehouses.
• Integrate data from relational DBs, cloud apps, files, XML, and APIs.
• Create and optimize SQL queries, procedures, and DB objects.
• Tune ETL performance and ensure data quality and integrity.
• Develop error-handling, logging, and reconciliation processes.
• Collaborate with Data Warehouse, BI, and Analytics teams.
• Support production ETL runs and incident resolution.
• Participate in code reviews and best practices.
• Prepare technical design docs and runbooks.
• Gather and analyze data integration requirements.
• Implement data governance, security, and compliance.

Skills

ETL development

Informatica PowerCenter

SQL development

Oracle

SQL Server

PostgreSQL

Teradata

DB2

Data Warehousing

UNIX/Linux scripting

Performance tuning

Education

Bachelor's degree in CS/IT/Engineering

Tools

Control-M

Autosys

Airflow

IICS

CI/CD tools

Job description

Synechron, a global consulting firm, seeks an experienced ETL Informatica Engineer to design, develop, and maintain enterprise data integration solutions using Informatica PowerCenter. The role collaborates with data architects and BI teams to build robust pipelines, optimize SQL, and ensure data quality across warehousing platforms.

Charlotte-based position with competitive base salary and benefits. Candidates should have 5+ years ETL experience and 4+ years PowerCenter, strong SQL, and