Job Title: Informatica Developer with Power Exchange
Job Location: Dallas, TX
Overview:
We 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.
The Role
Responbilities:
- 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 members
Requirement:
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.
- Familiarity with other ETL tools and technologies is a plus.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
We can offer you:
- A highly competitive compensation and benefits package
- A multinational organization with 52 offices in 20 countries and the possibility to work abroad
- Laptop and a mobile phone
- 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
SYNECHRON’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 empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs.
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.