DataStage, Control-M, Unix, Shell Scripting Professional

• Strong experience in IBM DataStage design and development with hands-on expertise in ETL processes.

• Work with DataStage components including Designer, Director, and Operations Console for ETL job management.

• Design and develop DataStage Server and Parallel jobs including job sequencing, parameter sets, and containers.

• Apply strong knowledge of data warehousing concepts including Star Schema and Snowflake Schema.

• Develop transformation logic using stages such as Transformer, Lookup, Merge, ODBC, and Oracle connectors.

• Experience in data cleansing, data transformation, and data integration activities.

• Work with scheduling and workload automation tools such as Control-M for job orchestration.

• Hands-on experience in Unix shell scripting for automation and process execution.

• Knowledge of Teradata utilities such as FastLoad, MultiLoad, and TPump for data loading processes.

• Collaborate with cross-functional teams to ensure efficient ETL pipeline execution.