Informatica Developer

Design, develop, and implement ETL workflows using Informatica PowerCenter and related tools.

Greensboro, North Carolina, United States
Posted Nov 5, 2026

Apply with RefersoAI Apply on careers page

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

Requirements

Bachelor's degree

Nice to have: Agile methodologies, version control, release management

Skills

Informatica PowerCenterInformatica Cloud (IICS)ETL developmentdata warehousing conceptsSQL (Oracle, SQL Server, DB2)Unix/LinuxShell scriptingdata modelingdatabase designworkflow scheduling tools (Control-M, Autosys)performance tuningoptimization techniquesmultiple data sources (XML, flat files, RDBMS)Informatica PowerCenterInformatica CloudControl-MAutosysUnix/LinuxShell scripting SQL

Full description

Description: Business Initiative/Purpose: (Goal, Business Impact, Accomplishments from the work) Specialized ETL work for Finance teams.. Bachelor Degree: (Required, Preferred or Not Required) Preferred. Role Responsibilities: (what they will be doing) 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. Must Have Skills/Prior Experiences: (Vendor should not submit any candidate that does not have these skills/prior experience.) 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). Plus/Nice to Have Skills/Prior Experiences:(Hiring Manager DOES NOT require these skills/ prior experience. However candidates with any of these will be looked at first.) 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. EEO: “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”