Informatica Developer (Unix)

The position is described below. If you want to apply click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application youll be invited to create a profile which will let you see your application status and any communications. If you already have a profile with us you can log in to check status.

Need Help

If you have a disability and need assistance with the application you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries wont receive a response).

Regular or Temporary:

Language Fluency: English (Required)

Work Shift:

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 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 Truists generous benefit plans please visit our Benefits site. Depending on the position and division this job may also be eligible for Truists 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