Informatica Developer

Synechron; Charlotte (NC); On-site; USD 95,000 - 100,000; Full time

Benefits offered by this job

Competitive compensation

Global opportunities

Leave benefits

Maternity & paternity leave

Insurance plans

Retirement savings

Education policy

Udemy for Business

Training opportunities

Job summary

Synechron is seeking an experienced Informatica IDMC Developer to design, implement, and optimize cloud-based data integration and ETL workflows using Informatica PowerCenter and related technologies. The role focuses on data warehousing, data governance, and collaboration with cross-functional teams in a fast-paced environment.

You will work on proposals with Oracle/SQL Server/ Teradata/DB2 databases and engage in performance tuning, code reviews, and deployment support.

Qualifications

• 6+ years of Informatica development experience.
• Strong hands-on experience with Informatica PowerCenter.
• Expertise in ETL design and Data Warehousing concepts.
• Strong SQL and database development experience.
• Experience with Oracle, SQL Server, Teradata, or DB2.
• Knowledge of data modeling concepts (Star Schema, Snowflake Schema).
• Experience in performance tuning and optimization of ETL processes.
• Strong troubleshooting and analytical skills.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.
• Analyze source systems and map data to target applications/data warehouses.
• Create and maintain mappings, mapplets, sessions, workflows, and reusable ETL components.
• Develop complex SQL queries, stored procedures, and database objects.
• Perform data extraction, transformation, and loading (ETL) activities.
• Troubleshoot ETL failures and resolve data quality issues.
• Optimize ETL jobs for performance, scalability, and reliability.
• Collaborate with business analysts, data architects, and application teams to gather requirements.
• Support production deployments and provide post-production support.
• Ensure adherence to data governance, security, and compliance standards.
• Participate in code reviews and document technical designs.

Skills

Informatica PowerCenter

ETL design

Data Warehousing

SQL

DBMS variety

Data modeling

Performance tuning

Troubleshooting

Communication skills

Tools

Informatica Intelligent Cloud Services (IICS/IDMC)

AWS/Azure/GCP

Control-M

Autosys

Job description

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 16,700, and has 57 offices in 22 countries within key global markets.

We are looking for an experienced Informatica IDMC Developer with strong expertise in cloud-based data integration, ETL development, and API integrations.

Additional Information*

The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Charlotte, NC is $95k - $100k/year & benefits (see below).

The Role

Responsibilities:

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.
• Analyze source systems and map data to target applications/data warehouses.
• Create and maintain mappings, mapplets, sessions, workflows, and reusable ETL components.
• Develop complex SQL queries, stored procedures, and database objects.
• Perform data extraction, transformation, and loading (ETL) activities.
• Troubleshoot ETL failures and resolve data quality issues.
• Optimize ETL jobs for performance, scalability, and reliability.
• Collaborate with business analysts, data architects, and application teams to gather requirements.
• Support production deployments and provide post-production support.
• Ensure adherence to data governance, security, and compliance standards.
• Participate in code reviews and document technical designs.

Requirements:

• 6+ years of Informatica development experience.
• Strong hands‑on experience with Informatica PowerCenter.
• Expertise in ETL design and Data Warehousing concepts.
• Strong SQL and database development experience.
• Experience with Oracle, SQL Server, Teradata, or DB2.
• Knowledge of data modeling concepts (Star Schema, Snowflake Schema).
• Experience in performance tuning and optimization of ETL processes.
• Strong troubleshooting and analytical skills.
• Excellent communication and stakeholder management skills.

Preferred, but not required:

• Experience with Informatica Intelligent Cloud Services (IICS/IDMC).
• Knowledge of cloud platforms such as AWS, Azure, or GCP.
• Experience with data governance and data quality tools.
• Exposure to scheduling tools such as Control-M or Autosys.

We offer:

• A highly competitive compensation and benefits package.
• A multinational organization with 57 offices in 22 countries and the possibility to work abroad.
• 10 days of paid annual leave (plus sick leave and national holidays).
• Maternity & paternity leave plans.
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
• Retirement savings plans.
• A higher education certification policy.
• Commuter benefits (varies by region).
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellence (CoE) groups.
• Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
• A flat and approachable organization.
• A truly diverse, fun-loving, and global work culture.