Senior Oracle SQL Developer

Responsibilities

• Design, develop, test, implement, and maintain PL/SQL code, UNIX scripts, Views for reporting and other needs.
• Versioning and ETL changes as per the requirements, experience with a variety of transformations like Aggregate, Derived Column, Conditional Split and Data Conversion, Transaction, Checkpoints, SSIS Package Management, Debugging, Error handling and logging, SSIS Package deployment etc.
• Design and develop solutions using SQL and PL/SQL with DBLinks from heterogeneous data sources.
• Create/Modify complex and large queries, writing/modifying stored procedures, functions, implementing error handling logic, performance tuning and query optimization, bug fixing, data auditing and Production Job monitoring.
• Create/Modify tables, keys and indexes. Perform SQL tuning and experience with using SQL Plans to identify bottlenecks in performance.
• Strong concepts of Data Warehousing, strategies for ETL.