Data Engineer

Pinion; Wakefield; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading technology services company is seeking an ETL Developer to design and manage data integration solutions. You will work with cutting-edge tools like Informatica and Azure while playing a key role in supporting financial institutions. The position requires hands-on experience with ETL processes and a strong knowledge of cloud-based integrations, set within a collaborative and innovative environment.

Qualifications

• 1+ year experience specifically using Informatica IICS.
• Hands-on experience with ETL tools and cloud-based integration.
• Exposure to the Financial Services industry.

Responsibilities

• Design and develop ETL processes using Informatica and Azure.
• Performance tuning and optimization of data integration processes.
• Support data analysis and business process automation.

Skills

ETL tools

Data modeling

Cloud-based integrations

Business process automation

Excellent communication skills

Job description

About Us

We are an innovative technology services company, since 2001 we have been providing mission critical systems and their support for some of the leading financial institutions around the world. Thesolutions provided by us are part of millions of people’s everyday life in making payments or online transactions. Our global team are from diverse backgrounds and experiences in a collaborative and open culture to deliver outstanding services for our customers. Our team enjoys this thought provoking and rewarding environment. Our customers tell us that our team are some of the best they have worked with – not only because of their professional ability, but also their behaviour and attitude. As part of the Pinion team, you will develop those core skills while delivering critical technology solutions for a variety of customers.

About the Role

• Design and development with Informatica IICS or PowerCenter in either/both Data Warehousing and Enterprise Integration projects
• Development of ETL [Extract Transform & Load] by utilizing relevant technologies (e.g. Informatica, MS Azure Data Factory, Azure Data Lake, etc.).
• Develop Data Ingestion and Integration from data sources to Azure Data Warehouse, based on Data Pipeline Framework(s) established by our Data Analytics and Information Technology teams as well as technical requirement specifications developed across all departments.
• Develop all necessary ad-hoc Data Ingestion/Integration processes into operational procedures for our Production Environment by adhering to agile, reliable, secure, high-performing, efficient, and effective methodology.
• Build and deploy Data Gathering/Integration solutions for periodic ingestion of field-generated or subject expert-generated content into a centralized reporting environment.
• Work with various business teams and departments to increase efficiency and accuracy of business processes through business process automation.
• Performance Tuning and Optimization of all Data Ingestion and Data Integration processes, including Data Platforms and databases.
• Support Data Analyst, Information Technology, and Business Stakeholder(s) in analyzing & resolving any data issues, as required.
• Develop business process automation solutions running mostly on hosted platforms (such as Azure or AWS).
• Demonstrate understanding of tools for building business process automation solutions to securely connect to multiple hosted platforms (e.g. PowerApps, Flow, SharePoint, Nintex, and K2).
• Additional duties may be assigned, as needed.

About You

• Hands-on experience with ETL tools (e.g. Informatica, BODS, Data Stage, Azure data Factory, Pipeline work, etc.).
• Demonstrated knowledge in data modeling (e.g. keys, logical, subject areas, referential integrity, etc.).
• 1+ year experience specifically using Informatica IICS cloud-based tools
• Experience with Cloud-based integrations
• Exposure to the Financial Services industry
• Demonstrated ability to exercise independent judgment when dealing with competing priorities & initiatives; this involves keeping all stakeholders informed of issues, progress, status, and resolution.
• Demonstrated ability to thrive in a fast-paced environment with minimal direction, extreme pressure, and tight deadlines.
• Proven success in simultaneously handling strategic and transactional responsibilities, especially in a small-team environment.
• Excellent communication skills (written and verbal) in English.