Senior Software Engineer

Job Title : Senior Software Engineer (5-8 yrs of experience)Location : OnsiteExpected Start Date : ImmediateDuration : 6-12 MonthsPrimary Skill:Pentaho ETL Platform, Oracle, SQL, PL/SQLMandatory- Strong Pentaho Enterprise Edition hands-on experience in develop & manage.Mandatory - Oracle database experience.Mandatory - Handling Flat files, database as source/targetTechnical skills requiredExperience in Pentaho ETL DevelopmentHands-on experience with Pentaho Data Integration (PDI) tools, including transformations and jobs.Proficiency in designing and optimizing ETL workflows using Pentaho Spoon, Kitchen, and Pan.Ability to implement complex data integration requirements such as data cleansing, validation, and transformations.Experience in integrating Pentaho with various data sources, including database, flat files, XML, JSON, and APIs.Design, Develop, and Implement Data Integration RequirementsExpertise in gathering and analyzing data integration requirements to create scalable solutions.Ability to design modular and reusable ETL components for large-scale data pipelines.Advanced SQL and PL/SQL KnowledgeStrong skills in writing, optimizing, and debugging complex SQL queries and stored procedures.Experience in bulk data processing using advanced SQL and PL/SQL techniques.Proficiency in data modeling, schema design, and query optimization.Job DescriptionDesign, develop and manage ETL workflows using Pentaho Data Integration platform - Enterprise edition.Implement complex data integration requirements such as data cleansing, validation, and transformationsSupport wokrflow failures, debug and analyse root cause and provide solution.Analyse source & target data discrepancies and publishCollaborate with other IT and business departments as per project needs to deliver common goalsMonitoring data infrastructure for performance and reliability to address issues promptly.Documenting data pipelines, processes, and best practices for knowledge sharing.