Hanish Syan

• Creating Staging layer tables in ODI using reverse engineering.
• All the transformations are done on data in ODS tables, creating ODI packages and scenarios, load plans, SAP bods dataflows, jobs
• Creating integration paths using gsutil and move data from on prem to Bigquery and performing the ETL in GCP environment.
• Support data warehouse, Big Data environments by guiding stakeholders on requirements and implementation approaches.
• Manage, coordinate efforts of data modelers, data warehouse/data integration developers, and Extract, Transform and Load (ETL) data management process in database usage and data warehousing.
• Extract data from homogeneous or heterogeneous data sources, transform for querying and analysis purposes, load into final target.
• Ensure metadata, data lineage are captured, compatible with enterprise metadata and data management tools and processes.
• Engage with data managers, stewards and owners to implement , maintain, enhance data governance, quality and related policies, aligning with TD's standards and frameworks.
• Strong experience in Data Quality Source Systems Analysis, Business Rules Validation Source Target Mapping Design Performance Tuning and High-Volume Data Loads.
• Strong experience in Performance tuning and Source to target mapping (ETL)
• Experience in various ETL tools like Talend , Oracle Data Integrator , Data Warehouse
• Experience in working in Hybrid environment in onprem and GCP
• Experience in VI editing and shell scripting.
• Working in Agile Methodology
• Strong experience in data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movements
• Strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns
• Proficiency in Azure Data Factory, Azure Synapse workspaces including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Experience in SQL skills and experience working with Azure SQL Databases and Dataverse and Azure storage concepts and technologies.
• Experience with SSIS, SSRS, PowerBI

• Strong experience in Data Quality Source Systems Analysis, Business Rules Validation Source Target Mapping Design Performance Tuning and High-Volume Data Loads.
• Lead or provide expertise to define and manage detailed system design for data integration processes or data marts/warehouse builds or extensions.
• Creating integration paths using gsutil and move data from on prem to Bigquery and performing the ETL in GCP environment.
• Writing Pl/SQL procedures, functions for new requirement.

• Work with architecture experts to create solutions that meet data management standards. Compile requirements and specifications, work with technology, business systems analysis, development and project teams to resolve content flow issues.
• Assess project impact on storage, network, database infrastructure.
• Create development estimates, review, approve business and system specification requirements, author system design specifications, system deployment plans;
• Scheduling jobs to check the desired result of the projects with the help of HAEPM tool.
• Creating materialized views with complex sql.
• Creating indexes and global temporary tables for performance improvement.
• Creating indexes and global temporary tables for performance improvement.
• Support data warehouse, Big Data environments by guiding stakeholders on requirements and implementation approaches.
• Implement leading-edge data warehouse and Big Data environments including hardware, software, end-user tools, etc.
• Propose, create tools and services to support end-user productivity and system integrations.
• Troubleshoot issues, manage capacity, plan for environment optimization and expansion.
• Lead coordination efforts with technology teams to ensure project success.
• Perform or lead complex analysis in an evolving data environment and gather, analyze, document and maintain all data requirements related to the business applications, interfaces,

• Workings on OWB and PL/SQL to work on change requests
• Understanding the functional design
• Attending daily SCRUM call to understand the implementation plan
• Creating integration paths using gsutil and move data from on prem to Bigquery and performing the ETL in GCP environment
• Working on AGILE methodology
• Job scheduling experience in Control M
• Developing Mappings, process flows
• Writing Pl/SQL procedures, functions for new requirement

GPA: 6.9