Hemachandra Menakuru Email & Phone Number

Wellington, Nz

Wellington, Wellington Region, New Zealand

Wellington, Wellington Region, New Zealand

• Developed end-to-end data pipelines using Snowflake, Python scripts, and Airflow DAGs for orchestrating data operations.• Managed data extraction, transformation, and loading processes into Snowflake, ensuring data accuracy and consistency.• Successfully developed role-based data masking policies and tags in Snowflake, in accordance with BNZ's PIA compliance regulations.• Generated Snowflake CLONE copies to facilitate parallel test executions and time-based analysis.• Developed Airflow DAGs (Directed Acyclic Graphs) to orchestrate end-to-end data pipelines for data extraction, transformation, and loading processes.• Led comprehensive end-to-end deployment solutions for Snowflake, Informatica, and Apache Airflow DAGs using Astronomer, spanning various environments to establish a resilient data platform. • Collaborating with diverse teams to establish new branching strategies for CI/CD deployments.• Developed deployment pipelines for Snowflake and Airflow assets using GitHub Actions and Jenkins.• Implemented a GitHub peer-review process for various sub-teams.• Proficiently managing high-volume deployment operations across multiple environments while adhering to BNZ standards• Successfully established effective GitHub policies, streamlined pull request processes, and enforced branch protection rules, ensuring better code quality and collaboration.• Managed multiple GitHub repositories to address diverse requirements.

Wellington & Wairarapa, New Zealand

• Collaborated with stakeholders to establish a novel Data platform on AWS cloud and Snowflake environment.• Developed Python data pipelines, integrating data from AWS S3 to Snowflake RAW Database.• Utilized Python scripts to invoke APIs for data retrieval and integration from source applications to S3 bucket.• Managed JSON formatted data within Snowflake platform.• Designed and constructed Data Vault 2.0 models within Snowflake environment.• Implemented DBT (Transformation) jobs for applying business logic and migrating data through Snowflake layers.• Created AWS Serverless Lambda functions and scheduled them using CloudWatch.• Automated release tests and deployments through CI/CD workflows using Terraform and GitHub.• Conducted data analysis to comprehend data nature and optimized modeling strategies.• Executed data extraction scenarios by identifying incremental load keys through source system data analysis.• Developed SAS DI ETL Jobs for extracting, transforming, and loading data from diverse sources into Data Warehouse Databases.• Created flow jobs in SAS Management Console and scheduled them through IBM Flow Manager.• Actively participated in AGILE ceremonies (Sprint review, planning, and retrospective sessions), contributing to process enhancement.• Supported SSAS Cube enhancements and resolved data issues.• Managed SVN releases and maintained source code versions within Subversion.• Pioneered the adoption of new cloud technologies (Snowflake) to migrate the Data Warehouse to the cloud.• Developed Unix shell scripts for improved operational failure alerts and communication to relevant teams.

Wellington & Wairarapa, New Zealand

Wellington & Wairarapa, New Zealand

Wellington & Wairarapa, New Zealand

Datastage ETL Designer and Developer

Chennai, Tamil Nadu, India

Datastage Developer