Data Engineer

Experience: 6+ Years
Role: Data Engineer

Required Skills

Must Have

. Informatica PowerCenter

. SQL (Oracle/Teradata/SQL Server)

. Python

. Apache Spark

. Hive & HDFS

. ETL/Data Warehousing concepts

. Unix Shell Scripting

. Production Support

. Agile/Scrum

Good to Have

. Apache Sqoop

. Apache NiFi

. Control-M or AutoSys

. Git/Bitbucket

. Jenkins

. Banking or Financial Services domain experience.

Key Responsibilities

. Design, develop, and maintain ETL workflows using Informatica PowerCenter.

. Develop data pipelines using Python, Spark, Hive, and HDFS.

. Perform data extraction, transformation, and loading (ETL/ELT) from multiple source systems.

. Write and optimize SQL queries for Oracle, Teradata, or SQL Server databases.

. Prepare technical design documents, mapping specifications, and data flow documentation.

. Perform performance tuning, troubleshooting, and production support.

. Coordinate with Business Analysts, QA, and business stakeholders throughout the project lifecycle.

. Participate in Agile/Scrum ceremonies and contribute to sprint planning and delivery.

. Support production deployments and incident resolution.