Job Description :
DataStage Developer/Analyst
Brooklyn (Metrotech) NY
12+ months

(we can do c2c but can not provide client letters )

Interview: Phone and F2F

Need local or nearby NY for onsite interview

IBM Information Server 9.1/8.5/8.0.1, IBM Websphere (Ascential) DataStage EE/8.0/7.5x2/7.5/7.1/390 Server and Enterprise Edition (Designer, Manager, Director, Administrator), Quality Stage 7.5/7.0, Meta Stage, Profile Stage, Informatica
RDBMS Oracle 8i/9i/10g, IBM DB2, SQL 2008/2008R2/2012/2014, SQL Server.

Programming Languages UNIX Shell Scripting, SQL, PL/SQL.
Version Control Tool Tortoise SVN 1.4.8

Experience required

Experience in implementing database applications using wide range of RDBMSs like Oracle 8i/9i/10g, DB2, SQL Server

Knowledge of developing DataStage Routines and Custom Stages for special jobs, created Functions, Stored
Procedures, Triggers using SQL, PL/SQL

Extensively involved in performance tuning the complex large data loads and long running jobs to optimize run time,
resource utilization and increase maintainability

Experience with Data Modelling, designing of the logical and physical data warehouse schema, including but not limited
to implementation of full SDLC of Data Warehousing Projects with Dimensional Modelling, Star Schemas, snow Flake
Schemas, and Operational Data Store
Experience with Experience with SQL 2012 on High Availability configuration, support, and troubleshooting

Experience with Performance tuning, Performance monitoring, Replication, Log shipping, Database Mirroring, Database
capacity planning, Users and Role creation and monitoring

Experienced in working in tight schedules meeting deadlines. Excellent work ethics, self-motivated, quick learner and
team oriented