Rohith M

Etl Developer @Southwest Airlines

Dallas-Fort Worth, TX, US

Performed analysis of complex business issues and provided recommendations for possible solutions. Writing SQL queries, reports, and used systems to do analysis based on data metrics and facts to provide recommendations.• Daily transnational data and reports will be available by next day to load into Datawarehouse.• File check process (shell script) will be waiting for this file and kick start the actual load process once files arrives.• As an initial load process, we will Multiload this file into Teradata staging table and archive the file in to archive folder after Multiload completes successfully.• This actual load process contains mostly Teradata stored procedures and are scheduled to run every day through scheduling tool(Control-M).• After completion of load process, we will run Validation process to validate the data loaded in target tables against source.• Develop Fast load scripts to load data from host file in to Landing Zone table.• Involved in writing the ETL specifications and unit test plans for the mappings.• Apply the business transformation using BTEQ scripts.• Creating Database Tables, Views, Functions, Procedures, Packages as well as Database Sequences, Triggers and database link.• Written SQL queries for retrieving the required data from the database.• Tested and Debugged PL/SQL packages.• Create BTEQ scripts to load the data from staging table in to target table.• Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and involved in writing database procedures, functions and packages.• Provided required support in Multiple (SIT, UAT & PROD) stages of the project.

SRM IST Chennai

Bachelor's degree, Computer Science