Rahul Shetty

ETL/Data Engineering Tech Lead

Freddie Mac•  March 2014 - October 2024•  McLean, VA

Led a team and was responsible for a portfolio of technology implementation projects spanning across multiple applications and utilizing various BI tech stacks to address migration to cloud infrastructure. Collaborated with cross-functional teams, data scientists, and stakeholders to manage overlapping timelines, prioritize tasks, and allocate resources efficiently for concurrent projects. Responsible for maintaining the resilience and reliability of the company's infrastructure, through execution of continuous testing strategy. Led IICS/IDMC (Informatica cloud) and Snowflake implementation at the company level, achieving a 30% improvement in processing time, 20% faster time to market, and $80K in annual cost savings. Participated in setting up Snowflake’s data share with RnD team, utilized timetravel for data recovery, streamlined data ingestion pipeline using AWS Datasync and Stepfunctions. Configured CI/CD pipelines for On-Premise systems, automating the deployment of components in Informatica PowerCenter, Vertica, and Autosys, with integration to GIT for version control. Automated complex data analytics workflows using Hadoop and PySpark for distributed data processing, eliminating delays and reducing errors. Perform root cause analysis approach for errors and set up a process to address via modernization, influencing future tool enhancements and contributing to product improvements. Developed ServiceNow dashboards and reports, enabling the department to stay updated on changes and incidents, resulting in a 10% efficiency improvement.

Application Integration Specialist

NTT Data Inc.•  April 2012 - March 2014•  Baltimore, MD

Developed and tested complex ETL systems, integrating data from various sources into optimized ODS/Datamarts, ensuring timely delivery and alignment with business goals. Provided architectural and technical solutions to read data from external non-standard data sources like FACETS, NASCO NPS, and NASCO MembersEdge to load into Datamart. Designed and implemented processes to generate and email error reports based on requirements.

Sr. ETL Developer/Analyst

eTeam Inc.•  October 2009 - April 2012

Designed and implemented the EOB (explanation of benefits) module enabling better benefits recommendations based on the member’s eligibility. Streamlined the data repository by consolidating similar sources into a single folder, ensuring data integrity, and scheduling workflows using Maestro and AUTOSYS tools. Developed standard templates for subject areas with customizable field masking as per vendor specifications, and created UNIX scripts for FTP operations and parameter file updates.