• Prepared estimates, timelines of the deliverable and project execution plan.• Managed sprint backlog items tasks and Scrum boards (physical or virtual)• Prepared S2T mapping documents and designed DataStage jobs • Created job sequences, generic extract and load jobs and shell scripts.• Wrote complex SQL scripts (Teradata) to avoid DataStage Look-ups to improve the performance.• Developed complex stored procedures using I/O parameters, cursors, views and triggers.• Created bteq scripts and Control-M tables to schedule the bteq script triggering.

• Worked on developing ETL jobs and loading the data into data marts/data warehouse.• Wrote mapping documents for all the ETL Jobs and coordinated scrum ceremonies.• Wrote several UNIX shell scripts according to the business requirements.• Used stage variables for source validations and capture rejects and Job Parameters for automation.• Strong knowledge in creating procedures, functions, sequences, triggers.• Developed Control-M tables to schedule the jobs

• Worked on the logical and physical design of the Data warehouse• Analyzed source data for dimensional modeling• Loaded Type I and Type II slowly changing dimension tables from several operational source files• Generating and interpreting mapping documentation and translating into detailed design specifications• Created Shell scripts for scheduling the DataStage jobs using wrappers.• Created Control-M tables to schedule the jobs• Involved in daily Scrum calls and sprint demos.