Executive - Dev-Data-Pipeline

JOB DESCRIPTION
About KPMG in India

KPMG entities in India are professional services firm(s). These Indian member firms are affiliated with KPMG International Limited. KPMG was established in India in August 1993. Our professionals leverage the global network of firms, and are conversant with local laws, regulations, markets and competition. KPMG has offices across India in Ahmedabad, Bengaluru, Chandigarh, Chennai, Gurugram, Jaipur, Hyderabad, Jaipur, Kochi, Kolkata, Mumbai, Noida, Pune, Vadodara and Vijayawada.

KPMG entities in India offer services to national and international clients in India across sectors. We strive to provide rapid, performance-based, industry-focused and technology-enabled services, which reflect a shared knowledge of global and local industries and our experience of the Indian business environment.

Context

KPMG entities in India are professional service firms(s). These Indian member firms are affiliated with KPMG international limited. We strive to provide rapid, performance-based, industry-focused and technology-enabled service, which reflect a shared knowledge of global and local industries and out experience of the Indian business environment.

We are creating a strategic solution architecture horizontal team to own, translate and drive this vision into various verticals, business or technology capability block owners and strategic projects.

Job Description

Role Objective:

Senior ETL Developer will design, develop, and optimize Talend data pipelines, ensuring the seamless integration of data from multiple sources to provide actionable insights for informed decision-making across the organization. Sound understanding of databases to store structured and unstructured data with optimized modelling techniques. Should have good exposure on data catalog and data quality modules of any leading product (preferably Talend).

Location- Mumbai

Years of Experience - 3-5 yrs

Roles & Responsibilities:

Business Understanding: Collaborate with business analysts and stakeholders to understand business needs and translate them into ETL solution.

Arch/Design Documentation: Develop comprehensive architecture and design documentation for data landscape.

Dev Testing & Solution: Implement and oversee development testing to ensure the reliability and performance of solution. Provide solutions to identified issues and continuously improve application performance.

Understanding Coding Standards, Compliance & Infosecurity: Adhere to coding standards and ensure compliance with information security protocols and best practices.

Non-functional Requirement: Address non-functional requirements such as performance, scalability, security, and maintainability in the design and development of Talend based ETL solution.

Technical Skills:

Core Tool exposure – Talend Data Integrator, Talend Data Catalog, Talend Data Quality, Relational Database (PostgreSQL, SQL Server, etc.)

Core Concepts – ETL, Data load strategy, Data Modelling, Data Governance and management, Query optimization and performance enhancement

Cloud exposure – Exposure of working on one of the cloud service providers (AWS, Azure, GCP, OCI, etc.)

SQL Skills- Extensive knowledge and hands-on experience with SQL, Query tuning, optimization, and best practice understanding

Soft Skills-

Very good communication and presentation skills

Must be able to articulate the thoughts and convince key stakeholders

Should be able to guide and upskill team members

Good to Have:

Programming Language: Knowledge and hands-on experience with languages like Python and R.

Relevant certifications related to the role