W2ONLY NO C2C - Lead INFORMATICA Consultant {Greensboro, Raleigh}

Matlen Silver; Greensboro (NC); On-site; USD 83,000 - 152,000; Full time

Job summary

Matlen Silver is seeking a Lead Informatica Consultant to join on a 6-12 month contract to hire in Greensboro or Raleigh, NC. The role focuses on designing, developing, and implementing ETL workflows using Informatica PowerCenter and on creating mappings, workflows, sessions, and transformations for robust data integration.

You will collaborate with business analysts, support production deployments, tune ETL performance, and develop Unix shell scripts for automation.

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

Job description

Job Title: Lead InformaticaConsultant

Duration: 6-12 month contract to hire

Location: Greensboro or raleigh, NC

Due to client requirements this role is only open to USC or GC candidates

Job Summary:

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

About Matlen Silver

Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.

Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.

If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: [e-mail] // 908-393-8600

At The Matlen Silver Group, Inc., W2 employees are eligible for the following benefits:

• Health, vision, and dental insurance (single and family coverage)
• 401(k) plan (employee contributions only)