TAUSEEF HAQ

• Lead design and optimization of financial data pipelines using Informatica IICS, SQL Server, and Azure Fabric, improving reporting performance by 30%.
• Designed Airflow DAGs to orchestrate multi-stage financial workflows, improving pipeline reliability and reducing operational overhead.
• Applied dbt for building modular SQL models and documenting metric logic, improving transparency and reducing onboarding time for Finance teams.
• Integrated ERP, billing, and operational systems into unified datasets, including event-based data ingestion using Kafka for near-real-time reporting needs.
• Built automated validation and reconciliation frameworks using Python and Unix Shell, cutting manual checks by 60%.
• Implemented CI/CD for ETL assets using Jenkins and Git; strengthened governance and data lineage tracking.
• Guided junior engineers in SQL performance tuning, ELT/ETL design patterns, and semantic model development.

Technologies: Informatica IICS, SQL Server, Azure Fabric, Azure Data Factory, Kafka, Airflow, dbt, Python, Power BI, Linux

• Engineered financial data marts and analytical models using Informatica Cloud (IICS), Oracle, and Snowflake.
• Used Airflow to orchestrate ingestion, transformation, and data quality workflows supporting revenue reporting.
• Leveraged dbt for building standardized transformations and metric layers consumed by BI and FP&A teams.
• Integrated multiple data sources into the Finance Data Warehouse, improving analytics and forecasting workflows.
• Optimized SQL and ETL pipelines, reducing data latency by 35% for executive-level dashboards.
• Partnered with global teams to deliver transformation frameworks and validation logic across financial domains.

Technologies: Informatica IICS, Oracle, SQL Server, Snowflake, Pentaho, Airflow, dbt, Python, Unix Shell, Salesforce

• Designed and maintained data pipelines in Talend and Teradata for analytics and finance teams.
• Automated ETL workflows via Shell scripts and Jenkins, reducing delivery times by 40%.
• Developed custom SQL logic and transformations supporting business intelligence dashboards.
• Collaborated with Data Architects to implement scalable data warehouse architectures and finance models.
• Deployed data pipelines on AWS Glue and Redshift for cloud migration initiatives.
• Technologies: Talend, Teradata, SQL, Unix Shell (Bash), Jenkins, Git, AWS (Glue, Redshift), Python

• Developed and maintained ETL pipelines using Wherescape for the Enterprise Data Warehouse (EDW).
• Designed and implemented dimensional models and data marts.
• Optimized complex SQL queries in Teradata for data transformation and reporting.
• Automated ETL workflows with Unix Shell scripts and Control-M scheduling.
• Supported data modeling for BI and analytics initiatives.
• Monitored and resolved ETL job issues in dev and production environments.
• Gathered requirements and prepared technical documentation.
• Technologies: Wherescape, Teradata, SQL, Unix Shell, Control-M, Tableau, Python, Data Modeling, JIRA