At a Glance
- Tasks: Design and build data pipelines using Informatica for analytics and reporting.
- Company: Amber Labs is a forward-thinking tech consultancy focused on collaboration and rapid learning.
- Benefits: Enjoy flexible work, private medical insurance, 25 days leave, and a global rewards platform.
- Why this job: Join a dynamic start-up that values personal growth and encourages experimentation.
- Qualifications: 5+ years in ETL development with Informatica; AWS experience preferred.
- Other info: This is a 12-month fixed-term contract; BPSS clearance required.
The predicted salary is between 36000 - 60000 £ per year.
At Amber Labs, we are a cutting-edge UK and European technology consultancy that prioritises empowering autonomy, promoting experimentation, and facilitating rapid learning to provide exceptional value to our clients. Our company culture is centred around collaboration, where all colleagues, regardless of their role, work together to minimise risk and shorten delivery times. Our team consists of highly-skilled cross-functional consultants, analysts, and support staff.
We are seeking an experienced Data Integration Engineer with strong hands-on expertise in Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS), and ideally some experience working with AWS cloud-based data services. You will be responsible for designing, building, and maintaining data pipelines to support enterprise data warehousing, analytics, and reporting solutions.
Key Responsibilities- Design and develop ETL/ELT workflows using Informatica to support data integration and transformation needs.
- Work with large-scale structured and unstructured data from various sources including on-premise and cloud platforms.
- Develop and optimize data pipelines and data integration processes between on-premises systems and AWS cloud services such as S3, Redshift, RDS, Glue, and Lambda.
- Collaborate with Data Architects, Data Analysts, and BI developers to understand data requirements and deliver solutions.
- Ensure data quality, consistency, and governance across platforms.
- Implement error handling, logging, and performance tuning for ETL jobs.
- Support production deployments, monitoring, and incident resolution.
- 5+ years of experience in ETL development using Informatica (PowerCenter and/or IICS).
- Strong understanding of data warehousing concepts, data modelling (dimensional/star schema), and data integration patterns.
- Hands-on experience with SQL and relational databases (e.g., Oracle, SQL Server, PostgreSQL).
- Familiarity with AWS data services such as S3, Redshift, Glue, EMR, Lambda, or RDS.
- Knowledge of scripting languages (e.g., Python, Shell) for automation and orchestration.
- Experience working in Agile environments and using tools such as JIRA, Git, or CI/CD pipelines.
- Excellent problem-solving, debugging, and performance tuning skills.
- AWS Certification (e.g., AWS Certified Data Analytics – Specialty, AWS Certified Solutions Architect – Associate).
- Experience migrating on-premise ETL processes to the cloud.
- Knowledge of Informatica Cloud integrations with AWS.
- Exposure to DevOps and Infrastructure as Code (e.g., Terraform, CloudFormation).
Competitive salary and performance-based bonus structure. Join a rapidly expanding start-up where personal growth is a part of our DNA. Benefit from a flexible work environment focused on deliverable outcomes. Receive private medical insurance through Aviva. Enjoy the benefits of a company pension plan through Nest. 25 days of annual leave plus UK bank holidays. Access Perkbox, a global employee rewards platform offering discounts, perks, and wellness resources. Participate in a generous employee referral program. A highly collaborative and collegial environment with opportunities for career advancement. Be encouraged to take bold steps and embrace a mindset of experimentation. Choose your preferred device, PC or Mac.
Diversity & Inclusion: Here at Amber Labs, we are dedicated to fostering an inclusive and equitable workplace for all. Our commitment to diversity, equality, and inclusion includes valuing the unique experiences, perspectives, and backgrounds of all employees and creating an environment where everyone feels welcomed, respected, and valued. Prohibiting all forms of harassment, bullying, discrimination, and victimisation and promoting a culture of dignity and respect for all. Educating all new hires on our Diversity and Inclusion policies and ensuring they are aware of their rights and responsibilities to create a safe and inclusive workplace. By taking these steps, we are dedicated to building a workplace that reflects and celebrates the diversity of our employees and communities.
This role at Amber Labs is a 12 Month salary based FTC position, and all employees are required to hold BPSS. Please be advised that, at this time, we are unable to consider candidates who require sponsorship or hold a visa of any type.
Our Talent Acquisition Team will be in touch to advise you on the next steps. We have a two-stage interview process for most of our consultants. In certain cases, we may include a third and final stage, which is a conversation with the company Partners. This will only be considered if deemed necessary.
Informatica Data Engineer employer: Amber Labs
Contact Detail:
Amber Labs Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Informatica Data Engineer
✨Tip Number 1
Familiarise yourself with the latest features and updates in Informatica PowerCenter and IICS. Being able to discuss recent advancements or changes during your interview can demonstrate your commitment to staying current in the field.
✨Tip Number 2
Network with professionals who are currently working at Amber Labs or similar companies. Engaging with them on platforms like LinkedIn can provide you with insider knowledge about the company culture and expectations, which can be invaluable during your interview.
✨Tip Number 3
Prepare to discuss specific projects where you've successfully implemented ETL processes using Informatica. Highlighting your hands-on experience with AWS services will also set you apart, as this is a key requirement for the role.
✨Tip Number 4
Showcase your problem-solving skills by preparing examples of how you've tackled challenges in previous roles. Amber Labs values collaboration and innovation, so demonstrating your ability to work effectively in a team while overcoming obstacles will resonate well with the interviewers.
We think you need these skills to ace Informatica Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Informatica PowerCenter and AWS cloud services. Use specific examples of projects where you've designed and built data pipelines, showcasing your skills in ETL development.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role at Amber Labs. Mention how your background aligns with their focus on collaboration and rapid learning, and provide examples of how you've worked effectively in team settings.
Showcase Relevant Skills: Clearly list your technical skills relevant to the job description, such as SQL proficiency, experience with data warehousing concepts, and familiarity with scripting languages. This will help demonstrate that you meet the required qualifications.
Prepare for the Interview: While this step is not part of the written application, it's important to prepare for potential interview questions. Research common data engineering scenarios and be ready to discuss how you've handled challenges in previous roles.
How to prepare for a job interview at Amber Labs
✨Showcase Your ETL Expertise
Make sure to highlight your hands-on experience with Informatica PowerCenter or IICS during the interview. Be prepared to discuss specific projects where you designed and developed ETL workflows, as this will demonstrate your technical skills and problem-solving abilities.
✨Understand Data Integration Patterns
Familiarise yourself with various data integration patterns and be ready to explain how you've applied them in past roles. This knowledge will show that you can effectively handle both structured and unstructured data from different sources, which is crucial for the role.
✨Demonstrate Cloud Knowledge
Since the position involves working with AWS services, brush up on your knowledge of S3, Redshift, and Glue. Be prepared to discuss any relevant experience you have with cloud-based data services and how you've integrated them into your data pipelines.
✨Emphasise Collaboration Skills
Amber Labs values collaboration, so be ready to share examples of how you've worked with cross-functional teams in the past. Highlight your ability to communicate effectively with Data Architects, Analysts, and BI developers to deliver successful data solutions.