Informatica IDMC & ETL 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

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.