Description

Design, develop, and optimize data workflows to move data from SQL databases to target environments including AWS S3.

Responsibilities

• Design, develop, and unit test data mappings and workflows using Informatica PowerCenter, Repository Manager, and Workflow Manager.
• Extract, transform, and load data from various source systems to target environments such as databases and AWS S3 files.
• Tune, optimize, and troubleshoot ETL batch jobs for performance and throughput across production, QA, and UAT environments.
• Implement stored procedures, functions, and triggers to support data processing requirements.

Required Skills

• Hands-on experience with Informatica PowerCenter, Repository Manager, and Workflow Manager.
• Proficiency in MySQL, T-SQL, or PSQL.
• Experience with RDBMS concepts and relational databases.
• Ability to work with SQL databases and AWS S3 file targets.
• Knowledge of stored procedures, functions, and triggers.
• Any graduate degree.

Preferred Skills

• Knowledge of Investment Banking and Capital Markets.
• Experience with Salesforce.com and Tier1CRM.

Key Skills

Education

Any graduate