• 6+ Years of total experience in ETL.
• Should have extensive knowledge on Datastage Parallel jobs and should have worked in Performance tuning of Sequence and Jobs.
• Should have extensive knowledge on Datastage stages such as Oracle stage, Parallel Transformer, Copy, Funnel, Sort, Remove duplicate, Aggregator, Modify and all other active and passive stages.
• Should have extensive knowledge in creating Shared Container, Parameter set, Message handlers etc.
• Should have extensive knowledge on creating Sql, Views, Materialized Views, Packages, Functions, and Triggers.
• Should have extensive Knowledge on Performance tuning of oracle Sql.
• Should have extensive knowledge on UNIX scripting.
• Knowledge in Unix environment and Data Modelling is preferable.
• Agile experience is preferable.
• Knowledge in Capital Market domain is desirable