Data Engineer (+3 Years Experience)

Valleysoft, a reputable IT services company, is seeking a skilled Data Engineer to join our dynamic team. The successful candidate will be responsible for designing, developing, and maintaining scalable data solutions to support business analytics and decision-making processes.Key Responsibilities:Design, build, and optimize data pipelines and ETL processes for collecting, transforming, and storing data across multiple sourcesDevelop and maintain data warehouses, data marts, and data lakes to enable efficient data access and analysisCollaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver relevant solutionsEnsure data quality, consistency, and security throughout the data lifecycleMonitor and troubleshoot data pipeline performance and implement improvementsKeep up-to-date with emerging data engineering technologies and best practicesRequirementsBuild and maintain data warehouse and data marts, including ODS and internal departmental martsGather, process, maintain, and analyze large datasets, ensuring data accuracy and qualityDesign, automate, and support ETL pipelines and data flows across multiple applicationsCreate logical and physical data flow models and mapping designs for ETL processesStrong SQL skills (performance tuning, index management) and solid understanding of database structuresStrong understanding of data modeling conceptsFamiliarity with SQL and NoSQL storage, and Big Data technologies (Hive, Impala, YARN, Kafka, etc.)Informatica-specific requirements:Hands-on experience with Informatica PowerCenter development (mappings, sessions, workflows)Strong knowledge of Informatica transformations (e.g., Lookup, Joiner, Aggregator, Expression, Router, Sorter) and performance tuningExperience with Informatica DeveloperExperience with Informatica B2B is a plusAbility to design, automate, monitor, and troubleshoot ETL jobs, including schedulingBanking sector requirements (preferred):Previous experience in the banking sector, preferably business banking, including working with banking datasetsStrong understanding of data quality and reconciliation expectations in banking environmentsExperience working under regulated environments and change control practices is a strong plusBenefitsPrivate Health InsuranceTraining & Development