Karthik Bairineni
Sedgwick CMS
Sammamish,WA
13
years of professional experience
Results-driven Senior ETL Developer with over 9 years of expertise in programming, SQL, and enterprise data integration. Proven ability to design and optimize robust ETL pipelines, develop intricate SQL queries, and deliver reliable analytics solutions that enhance reporting accuracy and drive actionable business insights. Experienced in leveraging Salesforce to refresh CRM data in alignment with evolving business requirements. Committed to utilizing technical skills and analytical acumen to support data-driven decision-making processes.
Work History
ETL Lead Developer
11 Years 8 Months- Designed and implemented robust ETL pipelines, enhancing data availability and reliability for analytics by seamlessly integrating multiple on-prem and cloud data sources.
- Created and optimized data mappings to facilitate source data extraction into SQL database, enabling effective comparison with Salesforce object data for timely refresh.
- Executed maintenance and construction of IDMC mappings and task flows, facilitating effective cloud-to-on-prem and cloud-to-cloud integrations.
- Leveraged PowerExchange 10.5.3 to extract and replicate data from source systems into IDMC pipelines, ensuring secure and reliable data ingestion.
- Developed and optimized Teradata SQL for data transformations, aggregations, and reporting layer consumption.
- Automated batch workflows using CA7 Scheduler, coordinating mainframe, Teradata, and cloud workloads to ensure 100% SLA compliance.
- Implemented complex data transformations, profiling, and validation logic within IDMC, achieving >99% data accuracy across reporting platforms.
- Integrated and managed Salesforce Cloud data, including standard and custom objects, and synchronized Salesforce data with Teradata and on-prem systems.
- Supported ETL modernization and migration initiatives by re-engineering legacy pipelines and executing IDMC and PowerExchange upgrades without production downtime.
- Deployed ETL workflows and configuration changes using URBAN DEPLOY (uDeploy), ensuring controlled, repeatable deployments across DEV, QA, and PROD.
- Monitored ETL and Teradata load jobs, performed root-cause analysis, and resolved failures, reducing recurring issues by 30%.
- Worked on Archiving UNIX Source files using simple shell scripts
- Led ETL design and implementation for data integration projects across multiple platforms.
- Developed and optimized ETL workflows to improve data processing efficiency and accuracy.
- Mentored junior developers in best practices for ETL development and troubleshooting techniques.
- Collaborated with cross-functional teams to gather requirements and define data transformation rules.
- Troubleshot complex data issues, implementing solutions to minimize downtime and improve system reliability.
- Reviewed peers'' code submissions to ensure adherence to established coding standards, contributing to overall project success rates consistently over time.
ETL Developer
1 Year 3 Months- Analyzed and configured Salesforce Education Cloud objects (Contacts, Accounts, Program Enrollments, Opportunities) to align with institutional and legacy data models.
- Developed and optimized IDMC/IICS mappings, synchronizations, and replications, reducing data integration time by 30% and improving reporting timelines.
- Replicated Salesforce Cloud data to on-prem systems and Teradata, implementing synchronization processes to maintain consistent datasets across platforms.
- Utilized PowerExchange 10.5.3 for incremental and full data extraction from source systems into IDMC pipelines.
- Automated batch workflows by integrating CA7 Scheduler with IDMC/IICS, improving operational efficiency and meeting execution timelines.
- Executed Salesforce sandbox testing, data loads, and QA validations using Data Loader and integration tools, ensuring error-free production releases.
- Automated business workflows using Salesforce Flows, Process Builder, and Approval Processes, enhancing user experience and operational efficiency.
- Maintained high data quality through profiling, deduplication, and validation within IDMC, supporting reliable Teradata reporting.
- Developed Salesforce reports and dashboards to track student engagement and program outcomes for stakeholders.
- Supported major IDMC upgrades, API changes, and data migration initiatives, ensuring system stability and continuity.
Education
Master of Science - Computer And Information Sciences
Skills
Databases: Microsoft SQL Server 2019
MySQL
T-SQL
Oracle
Teradata
BI & Reporting Tools: SSRS
BOLD Reports
Power BI Paginated Reports
ETL & Data Processing: SSIS
IICS/IDMC
Informatica Data Loader
Import Wizard
Informatica 10.5.3
PowerExchange 10.5.3
Programming Languages: C#
.NET
Python (Basic)
Transact-SQL
UNIX Scripting
Deployment Tools: ArtiFactory
uDeploy
Healthcare Compliance: HIPAA
CMS Guidelines
Audit Reporting
Project Management & Documentation: Agile
JIRA
Visio
Excel
SharePoint
Confluence
Scheduling Tools: Mainframe CA7
CRM Tools: Salesforce
Timeline
ETL Lead Developer
Sedgwick CMS
12.2014 - CurrentRead More
ETL Developer
Apollo Group Inc
09.2013 - 12.2014Read More
University of South Alabama
Master of Science from Computer And Information Sciences
Read More