Cloud Data Architect - ETL & Warehousing GCP

ANITA CHEDERE

Cloud Data Architect ETL & Data Warehousing Expert GCP Certified

***********@*****.*** • 206-***-**** • linkedin.com/in/anita-chedere • Remote (USA)

PROFESSIONAL SUMMARY

Results-driven Cloud Data Architect with 19+ years of experience designing and delivering enterprise-scale data warehousing, ETL, and analytics solutions across Healthcare, Insurance, Oil & Gas, Finance, and Telecom industries. Proven track record of leading on-premises-to-cloud migrations (Informatica PowerCenter IICS, Snowflake, GCP), architecting end-to-end data pipelines, and driving 25%+ performance improvements in ETL execution. GCP Certified Professional Cloud Architect with hands-on expertise in Snowflake, Databricks, Informatica IICS, and AWS/Azure ecosystems. Trusted advisor to C-suite and cross-functional teams translating complex data challenges into scalable, governed, and cost-effective solutions.

CORE COMPETENCIES

Cloud Data Architecture (GCP, AWS, Azure) • Snowflake & Databricks • Informatica PowerCenter & IICS • ETL/ELT Framework Design • Data Warehouse Modeling (Star/Snowflake Schema) • Data Governance & Quality • Change Data Capture (CDC) • Cloud Migration Leadership • Data Pipeline Automation • HL7 / FHIR Healthcare Standards • CI/CD & DevOps (Jenkins, Azure ADO) • Python, SQL, PL/SQL • Agile / Scrum

CERTIFICATIONS

• GCP Professional Cloud Architect • Informatica PowerCenter Data Integration 9.x Developer • Informatica PowerCenter Data Integration 9.x Administrator

PROFESSIONAL EXPERIENCE

Systems Architect / Cloud Data Architect Health & Human Services Commission, State of Texas TX (Remote) Jan 2025 – Present

•Lead data architecture design and implementation across multiple Healthcare projects, integrating data from Oracle, SQL Server, Excel, Access, and PDF sources into cloud-based analytics platforms.

•Architected and executed migration of on-premises Informatica PowerCenter deployments to cloud-based IICS (CDI-PC), ensuring zero-downtime transitions and operational best practices.

•Developed complex ETL mappings and workflows using Informatica PowerCenter 10.4 and IICS to automate data ingestion pipelines feeding Tableau dashboards and analytics systems.

•Designed Oracle SQL scripts optimized for high-volume data processing; led data modeling using Erwin and Visio for performance management and warehousing projects.

•Collaborated with cross-functional, matrixed teams to drive cloud adoption, implementing Azure Logic Apps and Azure Storage for scalable data orchestration.

Technologies: Informatica PowerCenter 10.4, Informatica IICS, Oracle, Snowflake, Tableau, Azure Logic Apps, Azure Storage, Jira, Erwin

ETL / Cloud Data Architect Elevance Health (formerly Anthem) IN (Remote) Oct 2022 – Dec 2024

•Architected enterprise data pipelines for Member, Provider, Clinical, Claims, and Rate Capitation domains, ensuring HL7/FHIR interoperability across healthcare systems serving millions of members.

•Designed hybrid cloud solutions combining on-premises sensitive data with cloud-scalable workloads on Snowflake and AWS Redshift, reducing infrastructure costs and improving elasticity.

•Built reusable ETL frameworks — Ingestion Framework, Integration Framework, Error Handling Framework — accelerating delivery of new data integrations by 40%.

•Implemented Change Data Capture (CDC) via Informatica Power Exchange across IICS and PowerCenter to enable real-time data streaming and reduce batch window dependencies.

•Enforced data governance policies covering data quality standards, security, privacy compliance, and lineage, improving downstream analytics accuracy and regulatory readiness.

•Mentored and guided junior developers on IICS best practices, coding standards, and performance optimization techniques including dynamic caching and partitioning.

•Managed data warehouse schemas (Star and Snowflake) in alignment with business requirements; validated data integrity using Informatica Data Quality (IDQ).

Technologies: Informatica PowerCenter 10.4, Informatica IICS, Snowflake, AWS Redshift, Teradata 16.0, Netezza, IBM DB2, Oracle, Control-M

ETL Architect Cigna Healthcare TX (Remote) Sep 2019 – Oct 2022

•Architected and delivered cloud-based data integration platform using Informatica IICS, consolidating Member, Provider, Claims, Medicare/Medicaid, EDI (837/834/277/278), and Benefits data into a centralized data lake.

•Achieved 25% improvement in ETL job execution times through advanced performance tuning — partition optimization, dynamic caching, and query refactoring in Teradata and SQL Server.

•Developed real-time data streaming processes alongside scheduled batch pipelines handling high-volume healthcare data ingestion and transformation for enterprise analytics and regulatory reporting.

•Integrated QNXT with external payer systems, enhancing claims processing, benefits management, and provider management data flows.

•Automated project infrastructure using Jenkins CI/CD pipelines and Windows schedulers; managed source control via GitHub and Udeploy.

•Participated in Agile ceremonies including PI planning, sprint planning, story grooming, and daily standups using JIRA.

Technologies: Informatica PowerCenter 10.6, Informatica IICS, Teradata 16.0, MS SQL Server 2016, Oracle, Jenkins, GitHub, Udeploy, SharePoint

Senior ETL Data Integration Analyst Farmers Insurance WA Mar 2019 – Sep 2019

•Designed and developed ETL integrations for auto insurance data domain using Informatica PowerCenter and IICS with MS SQL Server targets.

Technologies: Informatica PowerCenter 10.2, Informatica IICS, MS SQL Server

Senior ETL Data Integration Analyst Ministry of Health ON, Canada Sep 2017 – Jun 2018

•Built and maintained ETL pipelines for provincial health data integrations; supported Cognos reporting across Oracle and SQL Server sources.

Technologies: Informatica PowerCenter 9.6, Oracle, MS SQL Server, Cognos, UNIX

Senior ETL Data Integration Analyst Federated Co-Operatives Ltd. SK, Canada Oct 2016 – Sep 2017

•Implemented Informatica PowerCenter BDM and MDM solutions for retail data integration; supported IBM Netezza data warehouse and Cognos analytics platform.

Technologies: Informatica PowerCenter BDM/9.6, Informatica MDM & ILM, IBM DB2, IBM Netezza, Cognos, UNIX

Senior Integration Consultant Groundswell Group (EnCana, Cenovus, EnMax, Talisman, Shaw, FHSA, Calfrac) Canada Apr 2010 – Apr 2016

•Served as senior integration consultant to major Oil & Gas, Telecom, Utilities, and Healthcare clients. Delivered POC engagements for cloud data migration, Big Data, and data integration modernization. Contributed to SOW development and project scoping.

Technologies: Informatica PowerCenter 9.x, Informatica MDM, Business Objects Enterprise, Oracle 12g, Teradata, UNIX

EARLIER EXPERIENCE (2005 – 2009)

Senior ETL Developer — Norwich Union Insurance (UK), Grant Thornton LLP (IL), CBS Interactive (FL), BMW (NJ), GSK (NJ), Hyperion Solutions (CT), Fidelity Investments (MA), AmeriCredit Corp (TX). Delivered Informatica PowerCenter ETL solutions across financial services, insurance, pharma, and automotive sectors. Core technologies: Informatica PowerCenter 6.x–8.x, Oracle, Teradata, MS SQL Server, SSIS, SAP Power Exchange.

TECHNICAL SKILLS

Cloud Platforms: GCP (Certified), AWS (RDS, Redshift, Glue, CloudWatch), Azure (ADO, Logic Apps, Storage, Synapse)

Data Warehousing: Snowflake, Teradata, Netezza, IBM DB2, Oracle, MS SQL Server, Redshift

ETL / Integration: Informatica PowerCenter (6.x–10.x), Informatica IICS, SSIS, Informatica MDM, Informatica IDQ, Power Exchange (CDC)

Big Data & Analytics: Databricks, Apache Spark, Tableau, Business Objects, Cognos

Languages: SQL, PL/SQL, Python, Shell, PowerShell

DevOps / CI-CD: Jenkins, Azure ADO, GitHub, Terraform, AWS CDK, Udeploy

Data Modeling Tools: Erwin, MS Visio

Monitoring / ITSM: Dynatrace, AWS CloudWatch, ServiceNow, Jira, Remedy

Healthcare Standards: HL7, FHIR, EDI (837, 834, 277, 278), ICD Codes, QNXT

Methodologies: Agile (Scrum, Kanban), Waterfall, SAFe / PI Planning

EDUCATION

Master of Science, Computer Science — Osmania University 2000

Bachelor of Science, Computer Science — Osmania University 1998

Contact this candidate