Datastage Developer

NAClient is embarking an Datawarehouse modernization journey and in the process of creating data lakes in the Snowflake.The ideal candidate will use DataStage tool, build data ingestion pipeline from on premise sources such as Oracle, HANA, DB2 and others into Snowflake Datawarehouse.He/she will follow clients guideline and processes and work closely with their IT and business teams.5+ years of hands on experience using DataStage version 9 or higher (DataStage 11.7.0.1 experience is preferred)Strong ETL experience in handling large volumes of data in the complex heterogeneous data warehouses, and processing high volume jobsPrior experience in building data ingestion pipeline and data replication into cloud environments hosted on Azure platform.Hands on experience in creating the ETL jobs, performance tuning / optimizationKnowledge of Snowflake is added advantageStrong Knowledge in databases such as Oracle, IBM DB2, SAP HANA, and OLAP data warehousesKnowledge in SQL, UNIX shell scripting will be added advantageExperience working in pharma industry is plusHaving knowledge of Snowflake, Tivoli Workflow Scheduler (TWS)/ Maestro and BMC Control-M is added advantageNAPosting Date:Department: -