ETL 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 14,000+, and has 55 offices in 20 countries within key global markets.Our challengeWe are seeking an experienced ETL Informatica Developer to join our Data Management team. The ideal candidate will be responsible for designing, developing, and maintaining ETL processes utilizing Informatica PowerCenter and PowerExchange. The role requires a strong understanding of data integration, data warehousing, and database design.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 Pittsburgh, PA and Dallas, TX is $95k - $105k/year & benefits (see below).The RoleResponsibilities:Design, develop, and implement ETL processes using Informatica PowerCenter and PowerExchange.Collaborate with business analysts and data architects to translate business requirements into technical specifications.Perform data analysis, data mapping, and data validation to ensure accurate data transformation and loading.Develop complex Informatica mappings and workflows to extract data from various sources, transform it according to business rules, and load it into target data warehouses or data marts.Ensure the integrity, security, and privacy of data throughout the ETL process.Monitor ETL jobs, troubleshoot issues, and perform performance tuning to optimize data processing.Create and maintain documentation for ETL processes, data models, and data flow diagrams.Stay current with new features and capabilities in Informatica and related data management technologies.Work closely with the testing team to support the testing process and resolve any issues that arise.Participate in code reviews and ensure adherence to best practices and standards.Provide technical guidance and mentorship to junior team membersRequirements: You are: 8+ years of experience in ETL development with Informatica PowerCenter and PowerExchange.Must have experience in Informatica Power Exchange and SQL, Shell scripting, UNIX/Linux commands.Strong understanding of relational database concepts, SQL, and data warehousing principles.Experience with data modeling and data mapping.Proven ability to write complex SQL queries and tune them for performance.Knowledge of data quality and data governance principles.Excellent problem-solving skills and attention to detail.Strong communication and collaboration skills.It would be great if you also had:Familiarity with other ETL tools and technologies is a plus.We can offer you:A highly competitive compensation and benefits packageA multinational organization with 55 offices in 20 countries and the possibility to work abroadLaptop and a mobile phone10 days of paid annual leave (plus sick leave and national holidays)Maternity & Paternity leave plansA comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)Retirement savings plansA higher education certification policyCommuter 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 coursesCoaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groupsCutting edge projects at the world's leading tier-one banks, financial institutions and insurance firmsA flat and approachable organizationA truly diverse, fun-loving and global work cultureSYNECHRON'S DIVERSITY & INCLUSION STATEMENTDiversity & 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.Candidate Application Notice