ETL Developer - Informatica

About The Role

This position requires the successful candidate to work on a W2 directly with FDM. We cannot accept C2C, 1099 or employment sponsorship (e.g. H1-B) for this position.

FDM is a global business and technology consultancy delivering client and industry driven solutions through our 5 core specialist Practices; Software Engineering, Data & Analytics, IT Operations, Change & Transformation, and Risk, Regulation & Compliance.

FDM is seeking a ETL Developer located in Charlotte, Greensboro, Raleigh, or Atlanta to support a project in the Financial Services sector. Involvement in this project is anticipated to last initially 12 months but may be extended.

This role will be in-person with requirements to be in office 4 to 5 days per week.

About You

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

• Minimum 4-5 years' Experience in 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

About Us

About FDM

FDM powers the people behind tech and innovation. We spot trends, find top talent, and help businesses stay ahead.

With 35+ years of experience, we coach, mentor, and launch fresh thinkers from diverse backgrounds into world-class careers. Partnering with top global companies, we deliver the right talent at the right time-while guiding our people toward exponential growth.

🌍 Global impact - 18 centers across North America, APAC, the UK, and Europe

🚀 25,000+ careers launched - and counting

🤝 300+ trusted client partners

Additional Considerations

FDM Group, Inc. is registered to operate and hire employees in select states within the US. We will consider employment applications exclusively from candidates who are either residing in one of the following states or willing to relocate to them: Arizona, California, Colorado, Connecticut, Delaware, Florida, Georgia, Illinois, Indiana, Massachusetts, Maryland, Minnesota, North Carolina, New Jersey, New York, Pennsylvania, Tennessee, Texas, Utah, and Virginia.