Have worked on the Splunk Dashboard, Moogsoft alerts to analyze the ETL job failures to be worked on to get batch processed smoothly.
Used oracle, snowflake database to store all the data, Stored Procedures, Packages, Based on business requirements deliver daily data before planned SLE.
Handled the issues, failures for RTRMNT, Relationship critical batch processing ASAP with notifying required downstream consumers if any source delays, batch processing issues impacting SLE.
Update the database Tables if any record issues such as duplicate or data type issue occurred while loading files after confirming with source.
Update the database connections if any configuration changes done with Cyber Ark, CloudOps team.
Close handled issue tickets in service now with resolution details.
Create confluence pages, KB articles for repeating issue handling.
Generate monthly report on critical modules completion with SLE miss RCA in detail to represent higher management.
Look for the new changes and possible enhancements in Dashboard, tools updates and there by beautify the tool as well User Friendly interface which should be easy in handling.
ADLF to EDC Cloud Migration in AWS 2.0
The main objective is the to support the AWS cloud migration to EDC hydration, CDP salesforce with existing load runs handling without any business impact.
Monitor migrated SOR runs and handle the failures with Dev/L3 support with action on dags as Pause, Clear task, un pause to manage workflows and task execution in airflow.
Run Daily CDP dags manually once salesforce load completed in EDC hydration and validated in RDS DB and salesforce splunk dashboards with events and counts.
Validate data daily once load completed from ETL batches and Airflow dags with avg run times, start times and load volume.
Support technical issue, demonstrate problem solving.
Interact with other downstream systems in data integration issues.
Resolve the critical issues in production support and mingle with team to ensure successful resolution of reported incident.