Spearheads development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
Manages automation of file processing as well as all ETL processes within a job workflow.
Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
Manage software upgrades, capacity planning and system optimization.
Perform the unit testing, system integration testing and assist with user acceptance testing
Adapt ETL code to accommodate changes in source data and new business requirements.
Document the ETL detailed design and test results.
Prioritize development and enhancement requests.
Ensures data quality throughout entire ETL process.
Understanding of Middleware Data Integration
Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation.
Designs Power BI Reports and Dashboard is an advantage.
Power BI Data Analysis and Modeling is an advantage.
Designs Datadog Dashboard is an advantage.
Configure Datadog Alerts using Datadog Logs and Events is an advantage.
Datadog Real User Monitoring Configuration is an advantage.
Qualifications:
Bachelor's degree in computer science or equivalent experience required
8yrs to 10 years experience in managing data lineage and performing impact analysis
8yrs to 10 years 10 years experience with ETL tool development using Oracle PLSQL.
Knowledge in ADF (Azure Data Factory) is preferred
8yrs to 10 years 10 years experience with Oracle (10g, 11g and 12c)
Expert ability in SQL and PL/SQL
Excellent ETL design and documentation skills
Understanding of advanced database concepts: e.g., instance, table, table space, data files, database structure, indexes to fine tune programs and solve program failures.
Understanding of basic Unix Operation system concepts, programs, directory structure and basic commands (e.g., vi, sh)
Familiarity with the technical aspects of Unix, the Oracle RDBMS, and tools
Knowledge in Python language is an advantage
Deep appreciation of Agile or rapid application development (RAD) method
Ability to handle multiple tasks and adapt to a constantly changing environment
