Having experience in the field of IT industry at IBM DataStage (ETL tool), as a senior developer.ETL developer and production support- IBM Datastage (Designer, Director), information Analyzer, Data migration, Data integration, Data Warehousing (EDW), And Data Mart (DM).Experience with Data warehouse development, Extraction, transformation, web services, Data analysis, Data validation, post-production support (On Call 24*7), identify track defects, and provide resolution/fixes.Extensive experience in using ETL for extraction, transformation, and loading of data from heterogeneous source systems like Oracle, Flat files applying business transformation rules, and loading the data into the target system.Extensive experience in building SQL for data load process, and data validation testing.Dealt with UNIX operations as a part of ETL designs & coding.Good functional knowledge of the enterprise procurement process.Strong understanding of Data warehousing concepts.The File stages I have worked so far are- Sequential, and Dataset.The Debug/Development stagesI have worked so far are- Sample, Row Generator, ColumnGenerator, Peek, Head, and Tail.The database I have worked so far is- Oracle Connector.The processing stages I have worked so far are- Join, Lookup, Merge, Funnel, Transformer, Filter, Switch, Sort, Aggregator, etc.Business processes have very good capabilities in understanding the functionalities, leading to gaining excellent Automobile and Insurance domain knowledge. life cycle with requirement study, analysis, design, testing,Team player who can also work independently.Responsible for monitoring and running jobs, and hourly batch jobs using DataStage director. performedDesigning and scheduling the datastage jobs in production.Ready work in 24/7 Rotational shifts and on call support in holidays.