Senior Cloud Data Engineer - ETL/Oracle

Anusha Bandlamudi

SENIOR DATA ENGINEER CLOUD DATA ENGINEERING

St. Louis, MO +1-314-***-**** ***********@*****.*** LinkedIn PROFESSIONAL SUMMARY

Senior Data Engineer with 12+ years of experience designing, developing, and supporting enterprise data integration, ETL/ELT, data warehousing, Oracle, and cloud data solutions across financial services, life sciences, and banking. Strong experience with Oracle, PL/SQL, SQL, Informatica PowerCenter, Informatica IICS, Snowflake, Teradata, PostgreSQL, Python, and enterprise data pipelines supporting high-volume analytical and reporting environments. Experienced in building HCM/HR data integrations, Oracle Cloud data pipelines, source-to-target mappings, dimensional data models, canonical/logical/physical data structures, staging and ODS layers, and analytical data marts. Hands-on experience with Oracle Cloud HCM, BI Publisher, OTBI, BICC, Oracle Data Integrator (ODI), REST/API-based integrations, and enterprise reporting data flows. Proven track record supporting approximately 100 production workflows, 10+ source systems, and million-record-per-day workloads, with strong capabilities in SQL/PLSQL development, performance tuning, data quality, reconciliation, production support, and Agile delivery. TECHNICAL SKILLS

Programming & APIs: SQL, PL/SQL, Python, Java, Scala, UNIX/Linux Shell Scripting, REST APIs, API Integration, JSON, XML ETL / ELT & Integration: Informatica PowerCenter, Informatica IICS, Informatica BDM, Informatica Data Quality, Oracle Data Integrator, PowerExchange, BO Data Integrator, Source-to-Target Mapping, ETL/ELT, Data Integration, Data Replication Oracle & HCM Data: Oracle Database, Oracle Cloud HCM, Oracle HCM Data, HR/Employee Data, Payroll Data, Workforce Data, Oracle Fusion HCM, PL/SQL, Oracle Data Integrator (ODI), BICC, OTBI, BI Publisher Data Warehousing & Modeling: Enterprise Data Warehouse, Dimensional Modeling, Star Schema, Snowflake Schema, Fact & Dimension Design, SCD Type I/II, ODS, Staging, Data Marts, Data Vault, Canonical Data Model, Conceptual Data Model, Logical Data Model, Physical Data Model

Cloud & Data Platforms: Oracle Cloud, Snowflake, AWS, Azure, Cloud Data Engineering, Cloud Data Integration, Cloud Data Warehousing, Databricks

Analytics & BI: Power BI, Tableau, OTBI, BI Publisher, Oracle Cloud Reporting, Enterprise Reporting, Analytics Platforms Databases & Data Stores: Oracle, Teradata, Snowflake, PostgreSQL, SQL Server, DB2, RDBMS, Flat Files, Columnar Databases Performance, Quality & Reliability: SQL Tuning, PL/SQL Optimization, ETL Performance Tuning, Data Validation, Data Reconciliation, Record-Count Validation, Duplicate Detection, Exception Handling, Root-Cause Analysis, Production Debugging DevOps & Delivery: Git, GitHub, Jenkins, CI/CD, Control-M, Autosys, TWS, JIRA, SDLC, Agile/Scrum, Production Support Microsoft Power Platform: Power BI, Power Platform, Power Automate PROFESSIONAL EXPERIENCE

Senior Data Engineer - Broadridge Financial Solutions St Louis, MO Aug 2020 – Present

• Architect and support approximately 100 enterprise ETL workflows supporting data integration, batch processing, analytical datasets, and downstream reporting across multiple business functions.

• Integrate data from 10+ source systems and support million-record-per-day processing across relational databases, flat files, and enterprise data environments.

• Develop end-to-end Informatica PowerCenter and IICS pipelines including mappings, sessions, workflows, reusable transformations, source-to-target mappings, and data-quality controls.

• Design enterprise data flows across staging, ODS, warehouse, and analytical layers, applying dimensional modeling and reusable fact/dimension structures.

• Develop complex SQL and PL/SQL logic for transformation, validation, reconciliation, exception handling, and analytical data processing.

• Implement SCD Type I/II logic to preserve historical changes and support downstream reporting and analytics.

• Perform SQL tuning, ETL performance optimization, session partitioning, cache optimization, workflow analysis, and database performance troubleshooting.

• Build UNIX-based data validation processes covering record counts, duplicates, mandatory fields, file validation, source-to-target reconciliation, and exception reporting.

• Manage production support and resolve 5+ data/ETL incidents weekly, performing root-cause analysis, impact assessment, debugging, and SLA-driven remediation.

• Manage GitHub branching, pull requests, code reviews, deployment scripts, and CI/CD processes across Development, Test, Stage, and Production environments.

• Partner with DBAs, Product Owners, reporting teams, application teams, analysts, and business stakeholders to translate requirements into scalable data solutions.

• Participate in Agile planning, technical design, testing, release coordination, production support, and knowledge transfer across distributed teams

DATA ENGINEER - Thermo Fisher Scientific USA Aug 2016 – Jan 2020

• Developed enterprise Informatica PowerCenter ETL pipelines integrating relational databases and flat-file sources into Oracle-based enterprise data warehouse and reporting environments.

• Developed complex Oracle SQL and PL/SQL transformations, stored procedures, validation logic, exception handling, and source-to-target reconciliation processes.

• Designed and populated staging, ODS, and data-mart layers supporting enterprise supply-chain and revenue reporting.

• Created technical mapping specifications, transformation rules, source-to-target mappings, and target database structures based on business requirements.

• Implemented incremental processing and historical data logic to support recurring enterprise reporting and analytical workloads.

• Investigated recurring data-load failures across Informatica workflows, Oracle stored procedures, and database processes, performing root-cause analysis and permanent remediation.

• Optimized ETL workloads through SQL tuning, transformation optimization, workflow analysis, lookup-cache tuning, and mapping improvements.

• Promoted ETL and database changes across Development, QA, and Production environments while supporting Control-M/Maestro scheduling.

• Partnered with reporting teams, DBAs, QA, business stakeholders, and distributed development teams to deliver reliable enterprise data solutions

Informatica Developer - IGATE USA Oct 2013 – Jan 2016

• Developed Informatica mappings, sessions, command tasks, workflows, and technical specifications supporting enterprise data-processing solutions.

• Improved batch-processing performance through mapping optimization, incremental aggregation, lookup-cache tuning, SQL/workflow analysis, and ETL tuning.

• Resolved high-priority production incidents within SLA by troubleshooting Informatica mappings, database issues, SQL logic, and scheduler configurations.

• Developed UNIX shell automation for file handling, job triggering, validation, and pre/post-session processing across scheduled data workflows.

• Worked with vendors, QA, DBAs, analysts, and distributed delivery teams on requirements, technical documentation, testing, and production coordination.

• Supported business-analysis activities by documenting requirements and solution designs and coordinating delivery across onshore/offshore teams

KEY PROJECTS

CLOUD DATA PIPELINE & WAREHOUSE MODERNIZATION — Python Snowflake Cloud Data Engineering SQL

• Designed and implemented cloud-oriented ingestion and transformation workflows using Python and SQL, moving structured source data through staging, transformation, and analytical layers.

• Applied data validation, reconciliation, incremental processing, and reusable transformation patterns to improve reliability and maintainability of recurring data pipelines. ENTERPRISE DATA QUALITY & RECONCILIATION FRAMEWORK — Python SQL Snowflake Data Quality

• Developed reusable validation logic for record counts, duplicates, mandatory fields, source-to-target reconciliation, and exception handling across integrated datasets.

• Standardized data-quality checks and exception reporting to improve confidence in downstream reporting and reduce manual validation effort.

ORACLE CLOUD HCM DATA INTEGRATION & ANALYTICS - Oracle Cloud HCM BICC OTBI BI Publisher ODI PL/SQL Informatica

• Designed Oracle Cloud HCM data pipelines integrating employee, assignment, department, job, and organizational data into staging, ODS, warehouse, and analytical layers.

• Developed source-to-target mappings and SQL/PLSQL transformations, applying dimensional modeling and SCD Type I/II to support historical HCM reporting and analytics.

• Used BICC, OTBI, and BI Publisher data flows to support HCM reporting, data validation, reconciliation, and downstream analytical requirements

EDUCATION

Bachelor of Engineering (B.E.), Electronics C Communication Engineering 2010 Anna University

Contact this candidate