What are the responsibilities and job description for the DataStage Consultant position at Saxon Global?
Title : DataStage Consultant
Company : Commercial Banking Corporation
Pay Rate : $65.00-$70.00 / Hour
Start Date : 01 / 10 / 2025
Location : Jersey City, NJ
Visa : All visa
MUST LIVE IN NEW JERSEY
MUST HAVE LINKEDIN PROFILE THAT MATCHES RESUME
Remarks :
Need senior person. Must be onsite 2x week - Wednesdays and Thursdays specifically.
Onsite Flexibility : 60% Remote / Wednesday and Thursday onsite in Jersey City NJ
Interview : First is video; second maybe onsite on Jersey City, NJ
Description : Job description
Support of IBM DataStage ETL processes, SQL server and Oracle based applications.
Troubleshoot and resolve complex technical issues, ensuring the reliability and availability of applications.
Root cause analysis of both technical and functional issues.
Develop and modify existing ETL processes, Write SQL and PL / SQL queries.
Involve in Design and develop functional specifications and technical documents.
Develop, test, and deploy applications using Azure cloud services, with a strong emphasis on Databricks.
Working closely with various stakeholders such as business customers, vendors, and internal teams to provide support.
Qualifications and Skills
Must have strong experience in developing and supporting IBM DataStage components - DataStage Designer, DataStage Director, DataStage Administrator and IBM information server.
Have good experience with Oracle PL / SQL (packages, procedures, functions)
Thorough understanding of DW principles (Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snowflake Schema, OLTP, OLAP and Data Warehousing concepts).
Nice to have experience in Azure Data Platform services (Azure Data Lake (ADLS), Data factory (ADF), Azure SQL DW, Databricks), SQL Server, Oracle, Data Warehouse etc.
Ability to recreate existing legacy application logic and functionality into Azure Data Factory / Data Lake, SQL Database and SQL Datawarehouse environment.
Excellent Communication and Analytical skills.
5 years of experience in the above tech stack.
Bachelors / master's degree in computer science
Salary : $65 - $70
