Raghuram Bada
Chicago
Summary
ETL & Data Replication Support Analyst with expertise in AWS data pipelines and Talend job optimization at GE Aerospace. Proven track record in automating validation processes to enhance data integrity. Proficient in incident management using ServiceNow, ensuring swift resolution and operational excellence.
Overview
4
4
years of professional experience
Work History
ETL & Data Replication Support Analyst
GE Aerospace
Cincinnati
01.2021 - Current
- Supported and maintained critical data pipelines and real-time change data capture (CDC) replication workflows—using tools like Oracle GoldenGate or SQL Server Replication—to ensure precise, low-latency data transfer into both staging and production Snowflake schemas. Administered orchestrated ETL/ELT jobs (e.g., Airflow, dbt), monitored CDC lag metrics, managed schema evolution, resolved DML/DDL conflict anomalies, and fine-tuned query performance—ultimately guaranteeing seamless, timely synchronization across Oracle, SQL Server, and Snowflake environments.
- Operated and maintained 150+ ETL workflows using Control-M, Talend, and Informatica across Oracle, SQL Server, and Snowflake environments.
- Engineered real-time change data capture (CDC) replication via HVR: monitored replication status, reviewed lag metrics, parsed HVR log files, and executed targeted recovery at channel/table level to resolve sync issues.
- Automated validation pipelines using complex SQL (e.g., window functions, checksums, EXCEPT logic) and Unix shell scripting (Bash), enabling automated row-count comparisons and data integrity verification across source and target platforms.
- Composed backend Unix scripts to detect, repair, and resume interrupted replication jobs by manipulating file pointers and block-level data objects.
- Participated in HVR implementation: configured agents, defined capture and integration maps, performed initial baseline loads, and verified data via custom QA scripts.
- Authored and scheduled 100+ Talend jobs optimized with parallelization, partition filtering, and incremental load strategies, reducing execution time and maintaining near-zero downtime.
- Built AWS data ingestion pipelines with S3 (stages), Lambda functions (triggered by S3 events), and DynamoDB tables, enabling event-driven architecture and decoupled processing layers.
- Utilized ServiceNow and JIRA APIs to programmatically create, update, and categorize over 200 incident tickets, with customized alert triggers to meet SLA thresholds.
- Developed Confluence-hosted KB articles covering Talend job design, Control-M scheduling syntax, HVR best practices, and AWS deployment guidelines—improving team onboarding and troubleshooting speed by ~40%.
- Facilitated cross-functional syncs with DevOps, DBAs, and offshore engineering teams, drafting deployment manifests, reviewing cron-schedules, performing pre-/post-deployment data validation, and managing promotion of code and HVR configurations.
- Mentored junior analysts in SQL tuning, pipeline monitoring, incident remediation strategies, and technical documentation practices.
- Automated Unix-based Data Orchestration: Crafted and executed advanced shell scripts (e.g. rsync, tar, inotifywait) to manage data object lifecycles, handle block-file rotations, checkpoint logs, and resume failed processing tasks via cron workflows—ensuring uninterrupted backend operations and enhanced system resilience.
- Optimized Tableau Reporting & Data Validation: Developed SQL-driven validation frameworks and Tableau Prep flows to enforce schema consistency, null checks, and fuzzy-match standardization. Engineered pre-aggregated extracts at the warehouse level, eliminating unused fields and improving refresh speeds by up to 40%
- Engineered CI/CD for HVR & Talend Environments: Architected and maintained version-controlled release pipelines using Git and Maven (via Nexus), promoting CDC jobs and HVR routes through dev/test/pre-prod environments. Implemented zero-downtime production deployments using clustered Talend JobServers and load-balanced HVR agents.
- Managed Incident Escalation & Troubleshooting via ITSM Tools: Logged and triaged ETL/CDC incidents in ServiceNow and JIRA, enriched tickets with logs, deploy metadata, and diagnostic metrics. Streamlined escalation to Level 2/3 teams using integrated ITSM workflows, significantly reducing mean time to resolution.
Education
Bachelor of Science - Business, Accounting
Eastern Illinois University
Charleston, Illinois05.2019
Skills
- Cloud & AWS: Lambda, DynamoDB, S3, Glue, EMR, Athena, CloudWatch, Redshift, EventBridge
- ETL & Job Scheduling: Talend, HVR, Informatica, Control-M, Autosys
- Incident & Change Management: ServiceNow, JIRA, ITSM processes
- Data Visualization: Tableau report validation and optimization
- Backend Operations: Unix shell scripting, job control commands
- Tools: DBeaver, PgAdmin, Gitbash, WinSCP, Putty, Fivetran
Websites
Timeline
ETL & Data Replication Support Analyst
GE Aerospace
01.2021 - Current
Bachelor of Science - Business, Accounting
Eastern Illinois University
Similar Profiles
Louis PettingillLouis Pettingill
All Around Cell Member at GE Aerospace (Formerly GE Aircraft)All Around Cell Member at GE Aerospace (Formerly GE Aircraft)
Louis PettingillLouis Pettingill
All Around Cell Member at GE Aerospace (Formerly GE Aircraft)All Around Cell Member at GE Aerospace (Formerly GE Aircraft)
Samuel SimpsonSamuel Simpson
Final Inspector at GE AerospaceFinal Inspector at GE Aerospace
JOSEPH YEBOAHJOSEPH YEBOAH
Lead material procurement and execution specialist at GE AerospaceLead material procurement and execution specialist at GE Aerospace
CHIEDZA NADIA TAPFUMANEYICHIEDZA NADIA TAPFUMANEYI
Clinical Applications Manager at CSI Healthcare ITClinical Applications Manager at CSI Healthcare IT