Data Engineer - ETL & IICS Snowflake

Annapoorani Karthikeyan Data Engineer

Experience

Substitute Teacher and Office Support Charlotte Mecklenburg Schools, Charlotte, North Carolina NOV '11 - PRESENT

Data Analyst Instantt Travel, Bengaluru, India

MAR '19 - MAR '20

+1-980-***-**** *********@*****.*** Charlotte, NC 28277 Results-oriented Data Engineer with extensive experience in designing and implementing ETL processes, utilizing Informatica Intelligent Cloud Services (IICS), Snowflake, and SQL to transform raw data into actionable insights. Proven expertise in developing scalable data pipelines, ensuring high data quality and integrity through rigorous testing and validation. Adept at collaborating with cross-functional teams to meet business requirements, I possess a strong technical foundation in cloud platforms and database management, delivering robust data solutions in fast-paced environments.

Coordinated and managed school-wide projects, including curriculum development initiatives and extracurricular programs, ensuring alignment with educational goals and timelines. Facilitated cross-departmental collaboration among teachers and staff to enhance project outcomes and improve resource allocation, contributing to a cohesive educational environment. Maintains a positive learning environment, manages student behavior, and ensures that classroom rules are followed.

Follows lesson plans provided by the regular teacher, delivers instruction, and engages students in learning activities.

Assists students with their learning needs, answers questions, and provides additional support as needed. Greets visitors, answers phone calls, and directs inquiries to the appropriate person, as well as files paperwork.

Gathered and prioritized requirements from Operations, Finance, and Account Managers; translated needs into user stories and acceptance criteria for travel reporting and policy compliance. Defined and standardized KPI framework (e.g., spend per trip, advance purchase window, policy compliance rate, unused ticket liability) across 24+ clients to align decision-making. Authored BRDs/FRDs and created as-is/to-be process maps for booking, approval, and expense workflows; identified bottlenecks and recommended improvements. Led UAT for dashboard and data pipeline enhancements; built test plans/cases, managed defect triage, and secured stakeholder sign-off.

Performed root-cause analysis on data discrepancies across booking, GDS, and expense systems; implemented preventive data quality controls.

Maintained a prioritized product backlog, coordinated sprints, and documented release notes and change logs in an Agile/Scrum environment. Conducted impact analyses for policy/vendor changes; prepared stakeholder communications, training materials, and quick reference guides to drive adoption. Established data governance artifacts (data dictionary, report definitions, field lineage) and formalized validation rules and escalation paths. Built business cases and ROI models for initiatives (e.g., preferred supplier adoption, itinerary optimization) to support vendor negotiations and cost savings. Monitored SLAs for data availability and report delivery; authored SOPs and handoffs to ensure consistent Data Engineer Honeywell Technology Solutions, Bengaluru, India OCT '17 - FEB '18

Employee Service Specialis Sutherland Global Services, Chennai, Tamil Nadu OCT '15 - MAR '17

Education

Bharathiar University

JUL '15

Masters in Computer Science

service and support.

Facilitated stakeholder workshops and demos to collect feedback, iterate on solutions, and ensure alignment with business goals.

Ensured compliance with privacy/security requirements for traveler PII, implementing role-based access controls in analytics and dashboards.

Oversee and manage ETL support operations across critical data platforms, ensuring high availability and performance of data pipelines.

Lead troubleshooting and resolution of issues in Informatica IICS workflows and Snowflake data integrations, achieving a reduction in downtime.

Optimize Oracle SQL queries and stored procedures, successfully improving performance and addressing bottlenecks in data processing.

Support UNIX-based job scheduling, including scripting for automation and conducting log analysis to ensure efficient operations.

Coordinate with development, infrastructure, and business teams to swiftly resolve incidents and implement long-term fixes.

Maintain and enhance support documentation, including runbooks and SOPs, promoting standardization and operational consistency.

Participate in Root Cause Analysis (RCA) and continuous improvement initiatives, resulting in actionable strategies to mitigate reoccurring issues.

Provide mentorship and guidance to junior support engineers, fostering skill development and enhancing team efficiency.

Collaborate with stakeholders to ensure adherence to Service Level Agreements (SLAs) and compliance standards, effectively managing expectations.

Successfully reduced ETL processing times through optimized SQL query implementations and improved data integration workflows.

Developed and implemented data pipelines to ingest, store and process large datasets using Apache Spark and Hive.

Created ETL jobs to migrate data from various sources such as Oracle, MySQL, MS SQL Server into HDFS. Provided hands-on Excel assistance to clients, enabling advanced data analysis, automation, and reporting solutions tailored to business needs.

Supported administrative operations, ensuring accurate documentation, efficient workflow management, and timely updates of key business records.

Delivered technical troubleshooting and support, resolving application and process issues for end-users across multiple platforms.

Collaborated with cross-functional teams to streamline business processes and improve client satisfaction through proactive service delivery.

Sri Krishna Arts and Science College

JUL '13

BS in Computer Science

Skills

Testing Frameworks API Testing Database Testing Test Design Agile methodologies Sprint planning Testing Frameworks

Requirements gathering, stakeholder engagement, and SDLC processes SQL Power BI Snowflake

Contact this candidate