Informatica BDM/ IDMC Technical Lead

Avance Consulting; Norwich; On-site; GBP 40,000 - 80,000; Full time

Job summary

An established industry player is seeking a talented data professional with hands-on experience in ETL tools and cloud computing architecture. This role involves developing and supporting data applications to process large volumes of data while ensuring data quality and integration. You will work closely with business and technical teams to design solutions that enhance analytics and business intelligence capabilities. If you're passionate about data and eager to make an impact in a dynamic environment, this opportunity is perfect for you.

Qualifications

• Hands-on experience with ETL Tools such as Informatica and strong implementation background.
• Proficient in SQL with performance tuning skills.

Responsibilities

• Develop and support data applications and infrastructure for large data volumes.
• Collaborate with teams to gather requirements and optimize data quality rules.

Skills

ETL Tools

Informatica Intelligent Cloud Services

SQL

Data analysis

Application integration

Data Warehouse

Business Intelligence

Infrastructure architecture

Data quality checks

Performance tuning

Job description

Hands-on experience with ETL Tools such as Informatica Intelligent Cloud Services (IDMC) and Informatica PowerCenter, with strong implementation background.

Develop and support data applications and infrastructure utilizing various technologies to process large data volumes.

Key responsibilities:

• Strong knowledge of cloud computing architecture, including infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS) models.
• Experience with IDMC components such as application integration, data integration, and data quality.
• Solid understanding of RDBMS, Data Warehouse, and Business Intelligence concepts.
• Proficient in SQL with performance tuning skills.
• Comprehensive knowledge of the Informatica platform and its components.
• Data analysis and profiling skills using Informatica and Excel.
• Experience in infrastructure architecture: designing, hardware sizing, effort estimation, and security.
• Design solutions to enable Analytics and Business Intelligence capabilities.
• Implement data quality checks and standardization in the code.
• Document mappings, mapplets, and rules thoroughly; prepare handover documentation for clients.
• Collaborate with business and technical teams to gather requirements and optimize data quality rules.

Key skills/knowledge/experience:

• Informatica Intelligent Cloud Services, DataLake, Data Warehouse
• Data analysis activities and related experience
• Application integration using SOAP/REST APIs
• Data modeling, AWS concepts, and familiarity with Spark (a plus)