Opportunity Description
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.
Interested in this opportunity? Apply now through Expertini.
Apply for this Position