Senior Data Engineer (Informatica)
We are seeking a Senior Data Engineer with strong Informatica expertise to join our team. In this role, you will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for an enterprise data warehouse, collaborating with cross-functional teams to deliver robust data solutions.
Responsibilities
- Develop new ETL processes and enhancements, and modify existing code using Informatica PowerCenter
- Work independently to develop, configure, and unit test programs from specs (source to target mappings)
- Collaborate closely with data architects, reporting team, and application team on ETL development efforts
- Design and document ETL solutions for projects, estimate work effort, and provide status updates on tasks
- Provide technical support for the administration and production support of Informatica
- Deliver first- and second-level troubleshooting, along with baseline and operational support
- Adhere to best practices and methodologies established for the ETL development team
- Present all work in design and code review sessions to senior team members
- Prepare documentation that describes and supports the code developed
- Identify improvements to the data warehouse environment and work with the team to implement these solutions
- Escalate issues to the appropriate party when required
Requirements
- 5+ years of hands-on experience in ETL development for a data warehouse
- 5+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes
- Proficiency in complex SQL
- Expertise in integration technologies and processes
- Familiarity with Query Surge and Windows environment
- Knowledge of testing tools and techniques
- Understanding of Kimball design methodology
- Excellent analytical, organizational, presentation, and facilitation skills
- Ability to handle multiple tasks under tight deadlines
- Excellent command of written and spoken English (B2+ level)
Benefits
With us you can:
- Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
- Receive the necessary equipment to perform your work tasks
- Change projects and technology stacks within EPAM
- Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
- Relocation opportunities may be available for eligible candidates, depending on the role and openings at other EPAM locations
- Participate in volunteer, charity programs and communities (both technical and interest-based)
We focus on your professional growth:
- You can plan your individual career path together with your manager
- Receive regular feedback from colleagues
- Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
- Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
- Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
- Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
- Study at EPAM Solution Architecture School with the instructors who are practicing architects
- Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
- Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)
What we offer:
- Vacation and sick leave (including a sick leave without a medical certificate)
- A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
- Medical insurance for family members at corporate rates
- Company support during significant life events (childbirth or adoption, marriage, etc.)
- Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
- E-kids program - a free programming language training program for EPAMers' children