Work with business users and stakeholders to gather and analyze and troubleshoot incidents related to batch, ETL processes, and programs.
Perform systems analysis, systems design, applications development, unit testing, integration testing, user acceptance testing, preparation for deployment, technical documentation, and application support for existing ETL processes or programs that require enhancements.
Develop, analyze, and modify existing ETL, programs or batch processes such as triggers, functions, stored procedures, views.
Deep experience in data warehousing concepts and data analysis
Experience writing stored procedures and performance tuning
Expert PL/SQL development and SQL
Create, review, and modify technical documentation such as E/R Diagrams, dataflow models, UML etc...
Develop and/or modify existing batch applications that import data from various source files with client/server interactions
Support, enhance, and develop existing web applications, and develop new enhancements
Design source to target mappings and other documentation