Informatica Developer (Unix)

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

Regular or Temporary:

Regular

Language Fluency:

English (Required)

Work Shift:

1st shift (United States of America)

Please review the following job description:

An Informatica Developer is responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) processes using Informatica tools. The role involves working closely with data functional teams to ensure efficient data integration, transformation, and delivery. Strong Unix/Linux scripting skills are required to support automation, scheduling, and batch processing activities.

Essential Duties And Responsibilities

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

Key Responsibilities

• Design, develop, and implement ETL workflows using Informatica PowerCenter
• Create and maintain mappings, workflows, sessions, and transformations
• Develop data integration solutions to extract, transform, and load data from multiple sources
• Perform data analysis, validation, and troubleshooting of ETL processes
• Optimize ETL performance and implement tuning strategies
• Develop and maintain 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

Required Technical Skills

• Informatica PowerCenter / Informatica Cloud (IICS)
• Strong knowledge of ETL development and data warehousing concepts
• Proficiency in SQL (Oracle, SQL Server, DB2, etc.)
• Hands-on experience with Unix/Linux and Shell scripting
• Experience in data modeling and database design
• Knowledge of workflow scheduling tools (e.g., Control-M, Autosys)
• Understanding of performance tuning and optimization techniques
• Experience working with multiple data sources (XML, flat files, RDBMS)

Preferred/Additional Skills

• Familiarity with Agile methodologies
• Experience with version control and release management

Soft Skills

• Strong analytical and problem-solving skills
• Good communication and collaboration abilities
• Attention to detail and accuracy
• Ability to work independently and within teams

General Description of Available Benefits for Eligible Employees of Truist Financial Corporation:

All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position. Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays. For more details on Truist’s generous benefit plans, please visit our Benefits site. Depending on the position and division, this job may also be eligible for Truist’s defined benefit pension plan, restricted stock units, and/or a deferred compensation plan. As you advance through the hiring process, you will also learn more about the specific benefits available for any non-temporary position for which you apply, based on full-time or part-time status, position, and division of work.

Truist is an Equal Opportunity Employer that does not discriminate on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status, or other classification protected by law. Truist is a Drug Free Workplace.

EEO is the Law E-Verify IER Right to Work