Sybase Developer

Responsibilities: Develop and optimize database objects in Sybase ASE and/or MS SQL Develop ETL solutions using Informatica PowerCenter (and similar tools) Create and maintain tables, views, stored procedures, triggers, and related objects Implement and tune Sybase/SQL Server T-SQL: procedures, cursors, triggers, transactions, batch processing Performance-tune procedures and triggers; analyze query plans and optimize queries Utilize client utilities (isql, bcp) for data operations Write Unix shell scripts and work with scheduling tools (Control-M, Autosys) Apply relational and dimensional data modeling concepts to designs Collaborate with cross-functional teams and stakeholders to complete tasks Leverage BI tools knowledge as a plus to support reporting needs

Key requirements: Experience as a Sybase Database Developer on ASE and/or MS SQL ETL development experience with Informatica PowerCenter or similar tools (DataStage, Ab Initio) Experience creating database objects (tables, views, stored procedures, triggers) Proficient in Sybase/SQL Server T-SQL programming and related areas (procedures, cursors, triggers, transactions, batch) Knowledge of performance tuning and query plan analysis; ability to fine-tune queries Experience with isql, bcp, and other client utilities Unix shell scripting experience and familiarity with scheduling tools (Control-M, Autosys) Understanding of relational and dimensional data modeling Nice to have: OLTP and DW design concepts; BI tools experience Finance industry experience and strong communication skills Team-oriented with the ability to deliver with limited guidance Excellent oral and written communication Team player Ability to articulate technical concepts to non-technical stakeholders Sybase ASE MS SQL Server T-SQL