Negotiable
Undetermined
Hybrid
Edinburgh, Scotland, United Kingdom
Summary: The role of Senior IICS & SQL Developer involves designing and maintaining data integration solutions using Informatica Intelligent Cloud Services and PostgreSQL. The position requires a minimum of 6 years of experience in IICS and SQL, along with strong leadership skills to mentor junior developers. The candidate will work in a hybrid environment, collaborating with various stakeholders to ensure data quality and performance. Active participation in Agile ceremonies is also expected.
Key Responsibilities:
- Design, develop, and maintain robust and scalable data integration solutions using Informatica IICS.
- Write complex SQL queries and procedures using PostgreSQL for data extraction, transformation, and reporting.
- Work closely with business analysts, data architects, and stakeholders to gather and understand business requirements.
- Ensure data accuracy, quality, and consistency across systems.
- Troubleshoot and resolve data-related issues and performance bottlenecks in ETL pipelines and databases.
- Participate actively in Agile ceremonies – sprint planning, stand-ups, retrospectives, and reviews.
- Mentor and lead junior developers, fostering collaboration, innovation, and best practices within the team.
- Contribute to continuous improvement initiatives and promote automation wherever possible.
Key Skills:
- Minimum 6+ years of hands-on experience with Informatica IICS (Cloud Data Integration, Application Integration, etc.).
- Strong experience in SQL development using PostgreSQL – writing complex joins, subqueries, stored procedures, and performance tuning.
- Solid understanding of data warehousing concepts, ETL/ELT processes, and data governance.
- Proven experience working in Agile development environments, including CI/CD pipelines and iterative delivery.
- Excellent problem-solving abilities and analytical skills.
- Strong team management or team leadership experience – with the ability to coordinate, motivate, and guide a technical team.
- Excellent verbal and written communication skills.
Salary (Rate): undetermined
City: Edinburgh
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: Senior
Industry: IT
Job Title: Senior IICS & SQL Developer
Location: Edinburgh (Hybrid – 3 Days in Office per Week)
Engagement Type: Contract
Job Overview
We are seeking an experienced and driven Senior Developer with a strong background in Informatica Intelligent Cloud Services (IICS) and SQL development using PostgreSQL. This role requires hands-on expertise in data integration, transformation, and orchestration, with proven ability to work in fast-paced, Agile environments. The ideal candidate will have a minimum of 6 years’ experience in IICS and SQL and demonstrate excellent leadership and team management skills.
Key Responsibilities
- Design, develop, and maintain robust and scalable data integration solutions using Informatica IICS.
- Write complex SQL queries and procedures using PostgreSQL for data extraction, transformation, and reporting.
- Work closely with business analysts, data architects, and stakeholders to gather and understand business requirements.
- Ensure data accuracy, quality, and consistency across systems.
- Troubleshoot and resolve data-related issues and performance bottlenecks in ETL pipelines and databases.
- Participate actively in Agile ceremonies – sprint planning, stand-ups, retrospectives, and reviews.
- Mentor and lead junior developers, fostering collaboration, innovation, and best practices within the team.
- Contribute to continuous improvement initiatives and promote automation wherever possible.
Required Skills & Experience
- Minimum 6+ years of hands-on experience with Informatica IICS (Cloud Data Integration, Application Integration, etc.).
- Strong experience in SQL development using PostgreSQL – writing complex joins, subqueries, stored procedures, and performance tuning.
- Solid understanding of data warehousing concepts, ETL/ELT processes, and data governance.
- Proven experience working in Agile development environments, including CI/CD pipelines and iterative delivery.
- Excellent Problem-solving Abilities And Analytical Skills.
- Strong team management or team leadership experience – with the ability to coordinate, motivate, and guide a technical team.
- Excellent verbal and written communication skills.
Preferred Qualifications
- Experience with cloud platforms (e.g., AWS, Azure, GCP) in relation to data services.
- Informatica certifications (Cloud or On-Premise) are a plus.
- Familiarity with Jira, Confluence, or other Agile project management tools.