View Bench List Portal

Similar candidates

• Sunil Kumar Pochampally

• Understanding requirements and application functionality to provide solutions.

• Created design document to suit business requirements.

• Created database objects in database for development.

• Interacted with business for requirement clarifications

• Develops new screens using Oracle Forms 11g for application as per requirements.

• Created stored procedures and packages in Oracle databases using SQL and PL/SQL, which were called by user-oriented application modules.

• Created database objects such as tables, views, procedures, functions, triggers and packages.

• Develops Oracle reports required by the application using Oracle Reports 11g.

• Integrates, tests, debugs and implements application systems.

Environment: Oracle Forms & Reports 11g, Oracle SQL, PLSQL 11g, UNIX, SQL Developer, Putty, Windows 7

• Understanding requirements and application functionality to provide solutions

• Created views in Hive to fetch data from source tables to intermediate environment

• Prepared Hive and impala queries for data quality in Source (L1) and target (L5)

• Created indexes and partitions on various tables in order to enhance performance

• Created database objects like tables, views, indexes and sequences

• Tested, debugged and implemented application systems

• Optimized hive queries for better performance to retrieve results

• Prepared Hive and Impala queries for data validation after loading

• Validated data of Incremental load and full load during testing

• Prepared Hive and Impala queries for sanity validation and for testing for fixes in source and target

• Part of Daily status meetings with offshore team for work status and work allocation

• Prepared queries for checking incremental load

Environment: Hive, Impala, UNIX, Oracle 11g, Putty, Windows 7