Informatica ETL Developer (Unix) - PowerCenter & Automation

Truist; Charlotte (NC); On-site; USD 95,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

401k plan

Paid vacation & sick days

Job summary

Truist Financial Corporation is seeking an Informatica Developer to design, develop, and maintain ETL processes using Informatica PowerCenter or IICS on the 1st shift in the United States. The role emphasizes Unix/Linux scripting, data integration from multiple sources, and collaboration with data functional teams to ensure data quality and timely delivery.

Responsibilities include developing mappings and workflows, optimizing performance, supporting deployments, and ensuring compliance with

Qualifications

• Experience designing and developing ETL workflows with Informatica PowerCenter or IICS.
• Strong SQL skills across Oracle, SQL Server, DB2.
• Unix/Linux scripting for automation and batch processing.
• Experience in data warehousing concepts and data modeling.
• Familiar with multiple data sources (XML, flat files, RDBMS).

Responsibilities

• Design, develop, and implement ETL workflows using Informatica PowerCenter.
• Create and maintain mappings, workflows, sessions, and transformations.
• Develop data integration solutions from multiple sources for loading data.
• Perform data analysis, validation, and troubleshooting of ETL processes.
• Optimize ETL performance and implement tuning strategies.
• Develop Unix shell scripts for job automation, scheduling, and monitoring.
• Work with SQL queries, stored procedures, and database objects for data processing.
• Support production deployments, issue resolution, and maintenance activities.
• Collaborate with business analysts and stakeholders to understand requirements.
• Ensure data quality, integrity, and compliance with standards.
• Participate in SDLC phases: requirements, design, development, testing, and deployment.

Skills

Informatica PowerCenter / IICS

SQL

Unix/Linux scripting

Data warehousing concepts

Data modeling

Workflow scheduling

Performance tuning

Multiple data sources

Agile familiarity

Version control

Tools

Control-M

Autosys

Job description

Truist Financial Corporation is seeking an Informatica Developer to design, develop, and maintain ETL processes using Informatica PowerCenter or IICS on the 1st shift in the United States. The role emphasizes Unix/Linux scripting, data integration from multiple sources, and collaboration with data functional teams to ensure data quality and timely delivery.

Responsibilities include developing mappings and workflows, optimizing performance, supporting deployments, and ensuring compliance with