Hi, I’m Ankit
BigQuery, Snowflake, Informatica IDMC Integration | Modern Data Stack (Python, DBT, Airflow) | BI (Power BI, Tableau, Looker Studio) | Networking Insight (IPSec VPN Architecture) |
Senior Technical Architect with 18 years of experience designing, developing, and delivering large‑scale Data Warehouse and Information Systems solutions. Currently leading the architecture and implementation of a modern cloud‑based data warehouse on Informatica Cloud (IDMC) and Oracle.
Extensive background in BI, ETL, and data engineering across hospitality, finance, and law enforcement domains. Highly skilled in building robust, scalable data transformation pipelines and optimizing end‑to‑end data flows. Strong expertise in modern data stack technologies including Python, Airbyte, Apache Airflow, dbt, and PostgreSQL.
Deep knowledge of Enterprise Data Warehouse architecture, dimensional and normalized modeling, and schema design (star and snowflake). Proven ability to guide distributed teams, enforce engineering best practices, and ensure compliance with regulatory frameworks such as GDPR, PCI‑DSS, CJIS, and SOX.
A niche resource with a rare blend of deep data engineering expertise and strong networking fundamentals. Skilled in understanding how application, transport, and network layers influence data movement across distributed systems. Expertise in site‑to‑site IPSec VPN tunnels, enabling seamless, secure communication between on‑prem and cloud environments.
- Data Architecture & Modeling: Dimensional modeling, EDW architecture, star/snowflake schemas
- ETL/ELT & Integration: Informatica Cloud (IDMC), Airbyte, Airflow, dbt, Python-based pipelines, JSON, XML, XSD, XSLT, REST/SOAP integrations, YAML (metadata-driven configs)
- Data Exchange & Transformation Standards: JSON, XML, XSD, XSLT, YAML REST/SOAP, metadata driven transformations
- Analytical Skills: Power BI, Tableau, Microsoft Excel Advanced, SQL, Denodo, Looker, Streamlit
- Languages: Python, R, Shell Scripting, PL/SQL
- Databases: DuckDB, MySQL, Oracle, SQL Server, PostgreSQL
