Informatica Developer

We areAt 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 57offices in 22 countries within key global markets.Our challengeWe 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 RoleResponsibilities: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.Banking or Financial Services domain experience.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 Excellences (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.