Informatica Software Engineer

CFO Technology is looking for a Senior Developer / Tech Lead for the Opera DAL Accounting Subledgers Application Development team in Wroclaw, with strong technical skills in Oracle PL-SQL, Informatica ETL, Unix and familiarity of Agile development practices.

Opera / DAL is a sub ledger and P&L generating system for many types of Structured / Non- Structured , Single /Multi Legged products and its feeds data to Ledger, Regulatory and P&L reporting systems. The system receives over 300+ feeds from many upstream systems and processes over 40 Million records every day and across 3 regions. It also supports adjustment functionality using which product controls post Journals to fix upstream DQ issues.

Team: The Wroclaw Accouting Subledgers team is relatively new and currently comprises 4 developers (2 Java, 2 Oracle/ETL), and 1 platform services/DBA support - supported by a small team of Business Analysts.

This role supplements a growth plan for the Wroclaw ASL team where we plan to approximately double the size of the team.

Overall there is a global footprint to the ASL team, with its 100+ members spread across London, New York, Raleigh, Singapore, Pune & Bangalore.

• Perform leading roles which includes:

o Review requirements, prepare/contribute to design decisions, Solution, coding and code review design & testing strategy

o Participate in development & manage book of work delivery of project along with vendor team

o Interface with Business Analysts, QAs and PMs

o Co-ordinate and manage the integration and UAT phase

o Ensure resolution of any issues / defects

o Reporting and status updates on projects

o Level-3 Support / performance tuning

• Participate in development tasks including

o Writing transformation and mappings in Informatica PowerCenter 10.1.1

o Development of Unix shell scripts to control the operation of data loading processes

o Building Oracle PL/SQL Views, Stored Procedures and ad-hoc queries

o Design of the overall data sourcing framework and process working closely with the upstream / downstream application teams.

o Be an active scrum participant & in full control of their own backlog

• Ensure quality of our delivery by using process standardization and best DevOps practices
• To become SME for Strategic Sub-ledger Operational Data store components

• University degree level (preferably in IT)
• 3 years of experience in analysis, design and development of applications in financial services industry
• Prior experience in an investment bank (Finance domain) preferred
• Technical:

o Extensive hands-on technical expertise on Informatica PowerCenter

o Strong knowledge of SQL Overrides

o Knowledge of Batch processing, Scheduling in Control-M

o Experience in high-volume ETL/ Batch processing & database performance tuning

o Conversant with Unix like OS & shell scripting

o Troubleshooting experience a must.

o Experience and in-depth understanding of software development lifecycle from requirements to testing and release and production / L3 support

o Exposure to SDLC tools, such as: JIRA, Confluence, SVN, TeamCity, Crucible

• Others:

o At times, candidate may need to work flexible hours to engage with other global IT teams in Singapore, London, & US

o Strong inclination to business, functional understanding

o Strong analytical and problem solving skills

o Excellent written and verbal communication skills

o Ability to work independently and collaboratively in a distributed team

o Confident and resourceful

o Willingness to learn

Expressions (IIF, DECODE, disconnected lookups etc)

Simple Transformations (eg. caches/lookups, joins etc)

o Functional knowledge of Product control domain - PNL / adjustments

o Working experience in onshore/offshore or outsourced models

o Exposure to DevOps & Agile methodologies

o Exposure to HDFS & Informatica BDM

Partitions

Complex transformations (eg. rank, aggregator, sorter)

Oracle features (version 12c onwards)

Essential knowledge of

PL/SQL procedures & functions

Partitions

Indexes

Views

Handling exceptions and logging errors

Nice-to-have knowledge of

PL/SQL pipelined functions

Dynamic SQL (dbms_sql / execute immediate functionality)

Performance tuning

Analytic functions (RANK, ROW_NUMBER etc).

• Competitive salary
• Luxoft Training Center
• Access to e-learning Library
• Individual development plans
• Long-term cooperation with possibility to gain experience in different projects and technologies
• A significant number of professional communities (Agile Community, Tech Community, Business Analysis Community, etc.)

• Group Life Insurance
• Private healthcare insurance – LuxMed. Unlimited access to specialist consultations with Dental Care included
• Medical costs reimbursement for employees (up to certain amount per quarter)
• Travel Insurance
• Benefit Program - Cafeteria and Multisport Card

• Various communities (sport, recreation activities, trips, board games, cultural and educational activities)
• Discounts program for employees – BeLux (banking offer, car leasing offer and cafeteria program discount)
• Convenient locations in a modern offices with game rooms
• Multinational projects for clients all over the world