Description

You will develop and manage data movement processes between various systems using ETL methodologies for financial transaction data.

Responsibilities

• Design Informatica mappings and workflows to implement complex business logic based on client requirements.
• Create high-level and detailed design documentation for ETL job implementation.
• Implement data warehouse solutions by building data models and tuning Informatica jobs for performance.
• Develop database objects including tables, views, indexes, and stored procedures in Oracle and SAP HANA.
• Write UNIX shell scripts to automate data loading from flat files into HANA tables and configure completion alerts.
• Extract and analyze data patterns from Oracle, SAP HANA, Hadoop, and flat file sources.
• Execute thorough UAT and regression testing to ensure business logic quality.

Required Skills

• 5+ years of experience in ETL development.
• Informatica PowerCenter workflow and mapping development.
• Oracle database development.
• SAP HANA database management.
• Hadoop ecosystem experience.
• UNIX Shell Scripting.
• Data modeling and performance tuning.
• Bachelor degree in Information Technology, Computer Science, or Management Information Systems.

Key Skills

Education

Bachelor degree in Information Technology, Computer Science, Management Information Systems