Informatica Developer

We are

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 17,000+, and has 58 offices in 22 countries within key global markets.

The following information aims to provide potential candidates with a better understanding of the requirements for this role.

Our challenge

We are seeking an experienced Informatica Developer to design, develop, test, and maintain enterprise data integration solutions. The successful candidate will work with business analysts, data architects, database administrators, and other technology teams to build reliable ETL/ELT workflows, support data warehouse initiatives, and ensure the quality, availability, and performance of data across the organization.

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 $90k - $96k/year & benefits (see below).

The Role

Responsibilities:

• Design, develop, test, and implement ETL/ELT workflows using Informatica PowerCenter and/or Informatica Cloud Data Integration (IICS) .
• Develop mappings, mapplets, workflows, sessions, taskflows, and reusable transformations.
• Integrate data from various sources, including relational databases, flat files, APIs, cloud platforms, and enterprise applications.
• Analyze business and technical requirements and translate them into scalable data integration solutions.
• Perform data profiling, cleansing, validation, transformation, and error handling.
• Develop and maintain data warehouse loading processes, including full loads, incremental loads, and slowly changing dimensions.
• Optimize mappings and workflows for performance, scalability, and reliability.
• Troubleshoot production issues, perform root-cause analysis, and implement corrective actions.
• Monitor ETL jobs and ensure completion within established service-level agreements.
• Implement data quality, data governance, security, and audit requirements.

Requirements:

• 5+ years of hands-on experience developing ETL solutions with Informatica.
• Strong knowledge of Informatica PowerCenter and/or IICS.
• Proficiency in SQL and experience working with relational databases such as:Oracle
• SQL Server
• PostgreSQL
• MySQL
• Experience with data warehousing concepts, dimensional modeling, and ETL best practices.
• Understanding of transformations such as Lookup, Joiner, Aggregator, Router, Rank, Update Strategy, and Expression.
• Experience with workflow scheduling, monitoring, logging, and error handling.
• Strong analytical, problem-solving, and debugging skills.
• Good understanding of software development life cycle and release processes.
• Excellent written and verbal communication skills.

We offer:

• A highly competitive compensation and benefits package.
• A multinational organization with 58 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.

S YNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.