Senior ETL/Data Integration Engineer with 12+ Years Experience

KRISHNA YELLA

Senior ETL / Data Integration Engineer

PROFESSIONAL SUMMARY

Senior ETL and Data Integration Engineer with 12+ years of experience designing, developing, and optimizing large-scale data pipelines across Healthcare, Insurance, Financial Services, Telecom, and Retail domains. Proven expertise in Informatica PowerCenter, IICS, Talend, and enterprise data warehousing with strong SQL, UNIX, and cloud exposure (AWS, Azure). Experienced in end-to-end ETL architecture, performance tuning, API integrations, and CI/CD-driven deployments. Strong collaborator in Agile environments with a track record of delivering scalable, production-ready data solutions for full-time enterprise roles.

CORE SKILLS

ETL / Data Integration: Informatica PowerCenter, Informatica IICS, Talend, Informatica IDQ, Power Exchange

Programming: SQL, PL/SQL, T-SQL, UNIX Shell, Python (automation), PySpark (validation)

Databases: Oracle, Teradata, PostgreSQL, MySQL, Redshift, DB2, SQL Server, Hive

Cloud & DevOps: AWS, Azure, GitHub, CI/CD, Control-M, Autosys

APIs & Integration: REST, SOAP, Salesforce, Anaplan, ECIF

Reporting & Tools: Tableau, Cognos, Jira, ServiceNow, Toad

PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions — Remote

Senior ETL / Data Integration Engineer Client: Nationwide

Jan 2025 – Present

Designed and automated Talend-based ETL pipelines integrating Anaplan planning data into Salesforce, improving data availability and business reporting.

Enhanced and optimized Informatica PowerCenter mappings, improving load performance and downstream data consistency.

Developed Python and PySpark utilities to automate data validation, reducing manual checks and operational effort.

Implemented structured error handling, logging, and alerts for Talend jobs to improve production reliability.

Orchestrated workflows using Universal Automation Center (UAC) with dependency management and notifications.

Collaborated cross-functionally with Salesforce, Anaplan, and ECIF teams in an Agile delivery model.

Produced detailed technical documentation, data flow diagrams, and audit-ready artifacts.

Environment: Talend 8.x, Informatica PowerCenter 10.x, Python, PySpark, Salesforce, Oracle, AWS

Senior ETL / Data Integration Engineer Client: Wellmark Inc

Aug 2024 – Jan 2025

Built and maintained FHIR-compliant ETL pipelines using Informatica IICS for healthcare interoperability.

Developed IICS mappings and Web Service transformations to process JSON data into AWS and DynamoDB.

Optimized existing ETL workflows using parallelization and advanced transformations, improving throughput.

Led offshore coordination for development, reviews, and deployments using GitHub and CI/CD pipelines.

Partnered with QA and product teams to resolve defects and support production releases.

Ensured compliance with healthcare data standards and security requirements.

Environment: Informatica IICS, AWS, Azure, DynamoDB, GitHub, ServiceNow

Senior ETL / Data Integration Engineer Client: Talcott

Jan 2023 – Jul 2024

Designed ETL solutions for Variable Annuity end-to-end data conversion using a point-in-time migration strategy.

Migrated policy, producer, and payout data from multiple source systems into Oracle-based conversion engines.

Built reusable IICS taskflows, parameterized jobs, and automated reconciliation frameworks.

Actively participated in Agile sprints and CI/CD deployments.

Led offshore code reviews, performance tuning, and production support activities.

Environment: Informatica IICS, Oracle 12c, UNIX, AWS, GitHub

Blue Cross Blue Shield – Kansas City, MO

Senior ETL / Data Integration Engineer

Jun 2020 – Jan 2023

Automated large-scale provider data processing workflows, replacing manual processes and improving data accuracy.

Designed and developed 30+ Informatica PowerCenter mappings to integrate data into Facets, CACTUS, and MA-ACA systems.

Applied Informatica Data Quality (IDQ) for address validation, profiling, and mailability scoring.

Created mapplets, sessions, workflows, and command tasks to support ETL orchestration.

Scheduled and monitored ETL jobs using Control-M with dependency management.

Collaborated with business and QA teams for unit testing and validation.

Transamerica – Plano, TX

Senior ETL Developer

Mar 2018 – May 2020

Supported enterprise Finance Modernization (FINMOD) initiatives aligned with IFRS standards.

Ingested data from 160+ legacy systems into Hadoop staging environments.

Developed ETL solutions using Informatica PowerCenter, BDE (Blaze), and Power Exchange.

Performed performance tuning and optimization of long-running ETL jobs.

Automated workflows using Control-M and validated data using Hive and SQL tools.

Earlier Experience (2016 – 2018)

Senior / Informatica Developer – AT&T, Frontier Communications, Hyundai

Led large-scale telecom and enterprise data migration and conversion projects.

Implemented CDC, SCD Type 1 & 2, Salesforce integrations, and data quality frameworks.

Developed reusable Informatica mappings, workflows, and automation scripts.

Supported production deployments and post-go-live issue resolution.

EDUCATION

M.S. Electrical Engineering — SUNY New Paltz, NY

B.S. Electrical & Electronics Engineering — Acharya Nagarjuna University, India

Contact this candidate