JOBSEARCHER

Sybase Developer

Overview: As a Sybase Developer, you will design and optimize database solutions in ASE or MS SQL environments, and drive ETL integration using Informatica PowerCenter. You’ll build and tune database objects, write efficient T-SQL, and support data modeling for OLTP and DW contexts. You will collaborate with cross-functional teams to deliver reliable data services and performance improvements in a finance-focused domain. This role offers hands-on impact shaping data layer and BI-ready insights at a mid-senior level.
Responsibilities: Develop and optimize database objects in Sybase ASE and/or MS SQLDevelop ETL solutions using Informatica PowerCenter (and similar tools) Create and maintain tables, views, stored procedures, triggers, and related objectsImplement and tune Sybase/SQL Server T-SQL: procedures, cursors, triggers, transactions, batch processingPerformance-tune procedures and triggers; analyze query plans and optimize queriesUtilize client utilities (isql, bcp) for data operationsWrite Unix shell scripts and work with scheduling tools (Control-M, Autosys) Apply relational and dimensional data modeling concepts to designsCollaborate with cross-functional teams and stakeholders to complete tasksLeverage BI tools knowledge as a plus to support reporting needs
Key requirements:
  • Experience as a Sybase Database Developer on ASE and/or MS SQLETL 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 queriesExperience with isql, bcp, and other client utilitiesUnix shell scripting experience and familiarity with scheduling tools (Control-M, Autosys)
Understanding of relational and dimensional data modelingNice to have: OLTP and DW design concepts; BI tools experienceFinance industry experience and strong communication skillsTeam-oriented with the ability to deliver with limited guidanceExcellent oral and written communicationTeam playerAbility to articulate technical concepts to non-technical stakeholdersSybase ASEMS SQL ServerT-SQL