Warsaw based opportunity with remote work model (2 days in the office/month).
As an Senior IPC Developer, you will be working for our client, a leading player in the online banking sector, on the development and optimization of data warehouse solutions. This includes designing and implementing ETL processes, enhancing data architecture, and supporting the business intelligence environment to ensure effective data reporting and analysis. The project involves using cutting-edge technologies like Informatica Power Center and Oracle-based systems to support complex financial systems. You’ll be part of a dynamic IT team that ensures data integrity, performance, and scalability of large-scale data systems.
- Design and implement ETL processes using Informatica Power Center
- Develop and maintain data warehouses and reporting data marts
- Participate in the implementation and integration of Informatica tools
- Design, implement and develop BI-class analytical environments
- Create and maintain Oracle databases and applications
- Define and document technical specifications and administrative documentation
- Test and validate software solutions created by others
- Prepare software installation packages
- Support the software release and handover to production teams
- Strong knowledge of Informatica Power Center for ETL process development
- Knowledge of accounting and financial reporting in the banking sector.
- Hands on experience with tools to automate development work using AI solutions (e.g., Codex, Claude)
- Solid understanding of RDBMS Oracle 9i/10g and database design
- Excellent command of SQL and good knowledge of PL/SQL
- Understanding of information systems engineering and development methodologies
- At least 6 months of experience designing and implementing ETL solutions
- At least 1 year of experience with Oracle-based systems in information environments
- Knowledge of Snowflake and Python
- Practical experience designing data warehouses for large-scale institutions
- Ability to read and write technical documentation in English
- Strong analytical thinking and problem-solving skills
- Team-oriented mindset with attention to quality and detail
- Theoretical knowledge and practical experience with Big Data, Python, and Spark
- Familiarity with Business Intelligence (BI) concepts
- Ability to work using Agile methodologies (Scrum, Kanban)
- Knowledge of tools such as SQL Developer, SVN, GitHub, JIRA, and Confluence