Personal details

Ganesh J. - Remote data engineer

Ganesh J.

Based in: 🇲🇽 Mexico
Timezone: Guadalajara (UTC-6)

Summary

Experienced ETL Developer with over 8 years of expertise in data warehousing, utilizing ETL tools such as IBM Datastage and Talend. Proficient in a wide range of technologies including Unix Shell Scripting, Python, PySpark, Control M, Crontab, Talend TAC, SQL, Snowflake, and Azure Databricks.

Key Qualifications:

  • Strong analytical and problem-solving skills.
  • Deep understanding of data warehousing concepts, including Star Schema, Snow Flake, Dimension, Fact tables, OLTP, and OLAP data systems.
  • Familiarity with AWS Cloud and Azure concepts (in progress).
  • Exceptional background in ETL component analysis, design, development, and testing.
  • Proficient in source query optimization, ETL code performance tuning, and the development of reusable and automated ETL code.
  • Extensive experience in data extraction, transformation, and loading (ETL) from heterogeneous source systems, including integration with Azure Cloud.
  • Demonstrated expertise in IBM Datastage and Talend Open Studio, designing error-handling processes and automation.
  • Skilled in data migration projects, including the migration of SSIS packages and Oracle Stored Procedures.
  • Expertise in ETL DevOps, including Git Hub, Talend CI/CD implementation, Nexus, and Kubernetes.
  • Proficient in scheduling jobs using Crontab, Control M, and Talend TAC.
  • Familiarity with Python and knowledge of PySpark and Big Data concepts.
  • Effective communication with source and downstream teams, including client interactions.
  • Experienced in SDLC and Agile methodologies.
  • Strong communication skills, quick learner, and ability to meet deadlines.

This revised summary is more concise and highlights your key qualifications and achievements, making it easier for potential employers to quickly grasp your expertise and experience.

Work Experience

Technical Lead
HCL Technologies | Jun 2021 - Present
Python
Unix
Azure
Talend
Microsoft SQL Server
DataStage
Snowflake

BC (Business Continuation) IT supports a portfolio of applications and tools that are implemented to provide processes and procedures to mitigate risk from evolving threats, increase resilience, and improve operational effectiveness.

Responsibilities:

  • Understand the requirements of clients, converting the business needs into technical solutions.
  • Work towards fulfilling requirements by successfully delivering critical applications and E2E Testing
  • Review the code, help the team technically, and share Business Knowledge and other lead activities.

Technologies: Datastage(8.x,11.x), Talend (6.x,7.x), Snaplogic, Snowflake, MS SQL, Unix Shell Scripting, Python, Talend Tac, Control M, Salesforce and Azure MS SQL

ETL Developer
NationstarMortgage (Mr Cooper) | Dec 2017 - Jun 2021
Azure
Talend
Microsoft SQL Server
DataStage

Nationstar Mortgage provides servicing and origination for homeowners throughout the United States, and Xome, provides technology and data-enhanced solutions to the real estate market and companies engaged in the origination and/or servicing of mortgage loans. As we need to continually improve our business, we hear from our Clients.

Responsibilities:

  • Converting business needs into technical solutions.
  • Working towards fulfilling requirements by successfully delivering critical applications

Technology: Datastage(8.x,11.x), Talend (6.x,7.x), MS SQL,Unix Shell Scripting, Talend Tac, Control M and Azure MS SQL