Our client in Las Vegas, NV is looking for a strong Datastage consultant.

 

• Minimum 8 Years' experience with IBM Information Server 11.x, DataStage/ QualityStage


• Minimum 8 Years' RDBMS Oracle 10g+, SQL Server 2008R2 or later and Teradata.


• Minimum 3 Years' UNIX Shell Scripting, SQL, PL/SQL.


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


• 3-5 years of experience with DW Architecture, ETL process design, and ETL mapping documentation are required.


• Experience with 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


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


• Experience with data management in the Azure cloud platform is desirable


• Experience with Azure data factory is desirable