Hirak G.

Hirak G.

Experienced DB person with Very recent Snowflake Experience

Kolkata , India

Experience: 21 Years

Hirak

Kolkata , India

Experienced DB person with Very recent Snowflake Experience

33364 USD / Year

  • Start Date / Notice Period end date: 2022-04-18

21 Years

Now you can Instantly Chat with Hirak!

About Me

Almost twenty one years of diversified experience in the Software Development in both medium range and start-up environments, with  multiple range of technologies, under different industry settings and standards. Extensive work experience across ...

I have done certifications in 

1. AWS Certified Cloud Practitioner

2. Snow Pro CORE certification

Other technologies which i have worked in are as follows

 

Cloud Computing: AMAZON AWS (S3, EMR, Athena, Lambda, SNS,SQS)

Big Data Technologies:Hadoop HDFS, HIVE, PIG, OOZIE, FLUME

RDBMS and Data Warehousing Appliances: SQL Server, NETEZZA, Redshift, PostgreSQL, Snowflake

ETL/ELT Tools: ODI (Oracle Data Integrator), Informatica

GIS Software and APIS: MapInfo, Map basic, MapX, Sylvan Maps OCX and Google maps API

Programming Languages :Visual Basic 6.0, Visual Basic. NET,  C#, C++, JAVA

Source control tools:Microsoft VSS, Perforce, Bit bucket

Documentation version management tools:Microsoft SharePoint portal. Confluence

 

Show More

Portfolio Projects

On-Prem-Oracle to AWS- Snowflake migration

Company

On-Prem-Oracle to AWS- Snowflake migration

Description

  1. This is a project re-architecture where we have a On-Prem architecture comprising of Oracle, TIBCO and informatica to an Appropriate and revised architecture in AWS cloud and Snowflake
  2. The data we are dealing with is with data of various financial Funds across the globe.
  3. We have to go through the old logic identify the Canonicals (Metrics) and reorder/make changes to their logic and flow in certain cases
  4. Make new design for the metrics in Snowflake while the data landing and logic floe and control is in AWS
  5. Do QA in parallel with development while each metric is developed and made ready for testing
  6. Do UAT with the sales and marketing team for each of the metrics
  7. Perform Releases and prepare teams for cross production support

Show More Show Less

Skills

Snowflake AWS

Snowflake Migration from SQL Server

Company

Snowflake Migration from SQL Server

Description

  1. Understand the existing architecture Which has been Implemented in Snowflake. Find out the  new use cases which needs to be implemented over there.
  2. Based on that decide the tables, Procedures and Data flow , Views which needs to be implemented
  3. Once the decision regarding the new implementation is done document that in details in confluence
  4. Explain the details of the documentation to the team members
  5. Take part in complex coding and try to solve problems along with my colleagues
  6. Take part in the Implementation and participate in UAT and the final Release to production

Show More Show Less

Skills

AWS Snowflake

Migration from NETEZZA to REDSHIFT

Company

Migration from NETEZZA to REDSHIFT

Role

Backend Developer

Description

  1. Understand the existing databases across NETEZZA and how the data is stored over there. Based on this design the appropriate database schemas/tables and structures in Amazon Redshift
  1. Determine plans to Migrate the existing ETL process based on Netezza and Talend to comply with Redshift. Make changes whatever necessary to facilitate this
  2. Create Proof of concept in case some new technical implementation must be done
  3. Explain the work to the technical implementation team.
  4. Take part in coding if the implementation team undergoes technical challenges
  5. Perform code reviews and Release management

Show More Show Less

Skills

Netezza AWS

Big data based Solution in Amazon Cloud (AWS)

Company

Big data based Solution in Amazon Cloud (AWS)

Role

Backend Developer

Description

  1. Understand and document the Requirements from the product Team and document them in terms of Architecture blocks and Data flow diagrams and finalize the implementation design
  2. Determine the technologies and data flow end points to be used in each design blocks in the architecture.
  3. Create Proof of concept in case some new technical implementation has to be done
  4. Explain the work to the technical implementation team.
  5. Take part in coding if the implementation team undergoes technical challenges

Perform code reviews and Release management

Show More Show Less

Domain Big data based Data Warehousing solutions for data collected from Internet traffic

Company

Domain Big data based Data Warehousing solutions for data collected from Internet traffic

Description

  1. Understand and document the Requirements from the product Team and document them in terms of Architecture blocks and Data flow diagrams and finalize the implementation design
  2. Determine the technologies and data flow end points to be used in each design blocks in the architecture.
  3. Create  Proof of concept in case some new technical implementation has to be done
  4. Explain the work to the technical implementation team.
  5. Take part in coding if the implementation team undergoes technical challenges
  6. Perform code reviews and Release management

Show More Show Less

Telecom data warehousing and reporting , GIS Solutions for benchmarking various wireless carriers

Company

Telecom data warehousing and reporting , GIS Solutions for benchmarking various wireless carriers

Role

Backend Developer

Description

  1. Reporting Daily status to the management team at offshore as well at Clients end. Participating in each step from the project initiation, Design, Implementation and Delivery. Delegated work to the other team members and monitored their day to day software development process.
  2. Take part in the coordinating the User Acceptance tests, code Deployment, Post Deployment support
  3. Perform code review of the code written by other team members
  4. Perform Bug fixes for the issues reported by testing team
  5. Perform Unit testing of the code written and provide releases for the testing team
  6. Take Part on Software Development (Coding)

Show More Show Less

Geographical Information Systems (GIS) In Power and public utilities sector

Company

Geographical Information Systems (GIS) In Power and public utilities sector

Role

Frontend Developer

Description

  1. Take Part on Software Development (Coding)
  2. Perform Unit testing of the code written and provide releases for the testing team
  3. Perform Bug fixes for the issues reported by testing team

Show More Show Less

Mechanical Engineering solutions and Geographical Information Systems (GIS)

Company

Mechanical Engineering solutions and Geographical Information Systems (GIS)

Description

  1. Take Part on Software Development (Coding)
  2. Perform Unit testing of the code written and provide releases for the testing team
  3. Perform Bug fixes for the issues reported by testing team

Show More Show Less