You will design and develop data integration processes and manage high-volume data workflows.
Responsibilities
- Design tables, perform data analysis, and write complex SQL and PL/SQL queries.
- Develop ETL processes using Informatica and conduct thorough unit testing.
- Optimize performance through query tuning, table partitioning, and transaction monitoring.
- Manage job scheduling using Autosys and maintain processes within Unix/Linux environments.
- Partner with business technology and support teams to deliver data solutions.
Required Skills
- 10+ years of professional ETL development experience.
- Extensive experience with SQL and PL/SQL.
- Hands-on Informatica ETL development.
- Proficiency with Sybase or SQL Server.
- Experience with Java.
- Strong knowledge of triggers, stored procedures, and third-party tools.
- Experience handling high-volume data and performance tuning.
- Exposure to Unix/Linux environments.
- Experience with Autosys job scheduling.
- Knowledge of capital markets and treasury business.
Preferred Skills
- Strong analytical, problem-solving, and decision-making skills.