V
Lead Software Engineer
Job Description
Job Requirements
IBM Power systems knowledge
DB2
RPG- RPGLE
SQL
Connect Direct
IBM Iseries CL language
DB2 for i
Querying physical and logical files.
Data lineage analysis.
Mapping file fields back to DB2 source tables.
RPG Development
Read and understand RPGLE and RPG programs.
Trace how outbound files are built.
Key Activities Include
Create a complete inventory of all Connect:Direct and SFTP file feeds.
Identify which files are sent and received by each interface.
Analyse file layouts, record structures and field definitions.
Map every file field back to the originating data source.
Identify the RPG, CL or batch processes that create and process the files.
Document job schedules, dependencies and operational processes.
Analyse Connect:Direct process definitions, transfer routes and execution history.
Determine which Avaloq functions consume each feed and the associated business purpose.
Produce end-to-end data lineage.
Complete impact assessments and migration artefacts for the programme.
Feed inventory and interface catalogue.
Source-to-target field mapping.
Work Experience
7-10Years
IBM Power systems knowledge
DB2
RPG- RPGLE
SQL
Connect Direct
IBM Iseries CL language
DB2 for i
Querying physical and logical files.
Data lineage analysis.
Mapping file fields back to DB2 source tables.
RPG Development
Read and understand RPGLE and RPG programs.
Trace how outbound files are built.
Key Activities Include
Create a complete inventory of all Connect:Direct and SFTP file feeds.
Identify which files are sent and received by each interface.
Analyse file layouts, record structures and field definitions.
Map every file field back to the originating data source.
Identify the RPG, CL or batch processes that create and process the files.
Document job schedules, dependencies and operational processes.
Analyse Connect:Direct process definitions, transfer routes and execution history.
Determine which Avaloq functions consume each feed and the associated business purpose.
Produce end-to-end data lineage.
Complete impact assessments and migration artefacts for the programme.
Feed inventory and interface catalogue.
Source-to-target field mapping.
Work Experience
7-10Years
More Info
Key Skills
Data lineage analysis
Querying physical and logical files
IBM Power systems
DB2 for i
IBM Iseries CL language
About Company
Skills:
Power Automate, Css3, jQuery, Javascript, Data Migration, Html5, Azure Cloud Services, Sql Server Integration Services, Web Apis, Etl, Dataverse, Power Pages Portal Engineering, Dynamics 365 Power Pages, liquid templates, D365 Customization
Skills:
.NET, Mqtt, Apis, Kafka, Sql, Microservices, Typescript, Javascript, Docker, Flutter, Kubernetes, AWS, Podman
Skills:
.NET, Distributed Systems, Microsoft Azure, Rest Apis, Sql, Automated Testing, Relational Databases, API design principles