Arun Raja Anbalagan

Experience

• 

  Hinduja Global Solutions Ltd

  Jan 2011 - Jan 2013

  Customer Relation Officer

  Worked as a Customer Representative Officer, Quality Analyst, Call Queue Manager, and Acting Team Lead.

• 

  Tata Consultancy Services

  Jan 2013 - Nov 2016

  Senior Process Associate

  1) Performed regression testing of ETL workflows to ensure that new changes do not negatively impact existing data processing pipelines.2) Analyzed and tested complex ETL workflows, comparing source data to data warehouse tables to ensure transformation rules were correctly implemented.3) Conducted manual testing of data migrations, ensuring that all data transformations adhered to business rules and maintained integrity.4) Performed end-to-end testing of data pipelines, ensuring seamless data movement across systems and data integrity in the final data warehouse.5) Assisted in creating test strategies and documented test cases for ETL processes. Mostrar menos

• 

  HCL Technologies

  Mar 2017 - May 2024

  Senior Software Engineer

  The Project is to Develop an Infrastructure to support business data with IT generated Data for the Online Analytical Processing System which will help the business to validate the data for MSR. It will have the details about the Policy Data, Customer data . We create business extract with the policy and customer related data from the Analytical Data Store which is to generate reports used by the underwriters to study the new member acquisition trend and retain existing members.Roles and responsibilities:1) Part of the development team that handles the design, planning and execution validation activities.ETL design using Snowflake and Informatica.2) ETL design using Snowflake and Informatica.3) Meet the Customer and participate in Planning for Infrastructure support for the new system.4) Collaborated with onsite teams in an onshore-offshore model to address data requirements, align on timelines, and deliver high-performance data solutions. Mostrar menos

• 

  Hexaware Technologies

  May 2024 - now

  System Analyst

  CDAS-eTMF1) Led a team of 4 data engineers in designing, developing, and managing scalable data pipelines using Snowflake and DBT for enterprise-level data warehouse solutions.2) Hands-on of experience with Snowflake, including SnowPipe, SnowSQL, Streams, Time Travel, and stored procedures.3) Managed code versioning and project collaboration using GitLab, ensuring proper branching strategies, code reviews, and merge requests for ETL pipelines and data transformation scripts.4) Set up CI/CD pipelines in GitLab for automating the deployment of ETL jobs, ensuring the seamless integration of code changes into production environments.5) Strong background in Python for data extraction, transformation and query development. Mostrar menos