Sushma Nagireddy

Data Engineer with 4+ years of experience optimizing and analyzing ETL data pipelines. Experienced in handling production issues related to AWS applications, Talend ETL, and ServiceNow. Proficient in SQL, AWS S3, AWS SQS, ECS, DMS, Glue and shell scripting.

Strong debugging and troubleshooting skills with a proactive attitude to support and resolve customer issues on a 24/7 basis. Hands on experience in designing, coding, and deploying PySpark ETL pipelines. Passionate about building reusable frameworks in SQL to drive operational efficiency and enable data driven decision making.

Data Engineer - Cognizant - Bengaluru, Karnataka

(2022-05)

Data Engineer with 4+ years of experience of Optimizing and Analyzing ETL data pipelines. Experienced in handling production issues related to AWS applications, Talend ETL, and ServiceNow. Proficient in SQL, AWS S3, AWS SQS, ECS, DMS, Glue and shell scripting.

Strong debugging and troubleshooting skills, with a proactive attitude to support and resolve customer issues on a 24/7 basis. Hands on experience in designing, coding, and deploying PySpark ETL pipelines integrating AWS S3 –>Glue–>Redshift, enabling efficient ingestion and transformation of datasets. Performed multiple levels of testing in production and non-production environments to ensure application stability and data accuracy.

Collaborated with clients to deliver end to end solutions, from requirement gathering and design to development, deployment and performance tuning. Passionate about building reusable frameworks in SQL to drive operational efficiency, reduce manual effort and enable data driven decision making.

Programmer Analyst Trainee - Cognizant Technology Solutions - Bengaluru, Karnataka

(2022-05 - 2023-05)

Florida Power & Light Company project - AMI-ETL and Customer care Dashboard portfolio. Florida Power & Light Company is the largest energy company in the United States as measured by retail electricity produced and sold, serving more than 5 million customer accounts or an estimated 10 million+ people across the state of Florida.

• Analyzed and optimized existing SQL queries in Talend ETL to improve performance and maintain legacy project logic
• Designed and developed dimension and fact tables for base layer creation using data modeling techniques for historical data maintenance
• Performed data analysis end to end flow testing in DEV, QA and prod environments
• Managed and resolved incident tickets within defined SLA using ServiceNow/Jira
• Monitored 1000+ scheduled jobs running 24x7 across AWS services, Control-M, and Unix Crontab
• Built KPI layer by performing metric calculations and loading data into Postgres and redshift tables
• Collaborated with frontend dashboard teams for bug fixes, data corrections, and enhancements
• Created and maintained tables in Amazon Redshift, ensuring data accuracy and performance
• Prepared impact analysis documents to assess changes and their impact on existing functionalities
• Gathered business requirements and coordinated with key stakeholders for review and approvals

Programmer Analyst - Cognizant Technology Solutions - Bengaluru, Karnataka

(2023-05 - 2024-09)

AMI-ETL (2023 to 2024): AMI is the Advanced metering Infrastructure. AMI ETL is collecting data from oracle, Mainframe and DataLake and loading data to Postgres DB. AMI-ETL (2024-2025): 80% of the jobs were running on prem servers which load data in oracle using UNIX shell scripts, Informatica power center tools, SQL server.

Provided end-to-end support for each application with main responsibility to load data within expected SLA. Jobs are built on AWS Glue, lambda and Talend loading data in redshift DB.

• Analyzed and optimized existing SQL queries in Talend ETL to improve performance and maintain legacy project logic
• Designed and developed dimension and fact tables for base layer creation using data modeling techniques for historical data maintenance
• Performed data analysis end to end flow testing in DEV, QA and prod environments
• Managed and resolved incident tickets within defined SLA using ServiceNow/Jira
• Monitored 1000+ scheduled jobs running 24x7 across AWS services, Control-M, and Unix Crontab
• Built KPI layer by performing metric calculations and loading data into Postgres and redshift tables
• Collaborated with frontend dashboard teams for bug fixes, data corrections, and enhancements
• Handled testing activities, including validating datasets
• Created and maintained tables in Amazon Redshift, ensuring data accuracy and performance
• Prepared impact analysis documents to assess changes and their impact on existing functionalities
• Gathered business requirements and coordinated with key stakeholders for review and approvals

Associate/ Team Lead - Cognizant Technology Solutions - Bengaluru, Karnataka

(2024-10)

AMS-Customer Service (2025-Present): Provided Application Management Services (AMS) support for Solar, Wind, DG, and Battery energy applications on a daily operational basis. Supported business-critical renewable energy applications used for monitoring, reporting, and operational insights.

• Handled customer-reported incidents and service requests through ServiceNow and Jira, ensuring timely resolution within defined SLA
• Worked closely with customers to validate application data via UI dashboards and addressed discrepancies or data concerns raised by business users
• Investigated data mismatches, performance issues, and functional defects reported by customers and provided appropriate fixes or workarounds
• Coordinated with backend, data, and infrastructure teams to resolve complex incidents impacting Solar and Wind application accuracy
• Performed root cause analysis (RCA) for recurring issues and implemented preventive measures to improve application stability
• Maintained clear communication with customers regarding incident status, resolution timelines, and post-fix validation
• Ensured high availability and reliability of renewable energy applications supporting daily business operations
• Completed the task within 3 days for more around 15 Battery sites tags updated in production and performed data analysis end to end to before on time as per business requirement

Bachelor of Engineering - Electronics and Communication Engineering - Sri Chadrasekendra Saraswathi Viswa Mahavidyalaya (2022)

XII - Sri Chaitanya Junior College (2018)

X - Keshava Reddy High School (2016)