Senior System Analyst EDW

Job Summary:
We are seeking a highly experienced Senior System Analyst to support enterprise data warehousing initiatives within the banking domain. The role involves system analysis, solution design, and L3 support for complex data platforms leveraging Informatica, Teradata, Hadoop, and Oracle technologies. The ideal candidate will possess strong SDLC knowledge, hands-on experience in data modeling and ETL processes, and the ability to act as a bridge between business and technical teams.


Key Responsibilities:

Perform system analysis, design, and solutioning for EDW and data integration projects
Provide L3 production support, including incident management, root cause analysis, and performance tuning
Collaborate with business stakeholders and technical teams to gather and translate requirements into technical specifications
Design and review data models, data marts, and data mapping processes
Oversee ETL processes using Informatica or SAS, ensuring data quality and consistency
Support implementation and enhancement of data platforms (Teradata, Hadoop, Oracle)
Ensure adherence to SDLC, IT service management (ITSM/ITSC), and governance standards
Contribute to continuous improvement initiatives, including automation and optimization of data workflows
Mentor junior analysts and developers where required
Required Skills:

6-9 years of experience in data warehousing, system analysis, and production support
Strong experience in Informatica (certification preferred/mandatory) or SAS for ETL development
Hands-on experience with at least one of the following: Teradata, Hadoop (Hive), or Oracle (mandatory)
Certification in at least two relevant technologies (e.g., ETL, database, analytics, or big data platforms)
Strong knowledge of data modeling, data mapping, and data marts
Experience working in banking or financial services domain
Proficiency in SQL and database concepts across Teradata, Oracle, or Hadoop ecosystems
Understanding of SDLC, IT service continuity/support (ITSC), and release processes
Familiarity with CI/CD or DevOps tools such as Jira, Jenkins, or Bitbucket
Experience working in Unix/Linux/Windows/AIX environments

Nice-to-Have Skills:

Exposure to big data and analytics tools such as HDFS, Hive, Scala, Python, Power BI, Qlik Sense, SAS, or Splunk
Knowledge of AI/ML concepts or data science platforms
Experience with containerization and orchestration (Docker, Kubernetes, Red Hat OpenShift)
Familiarity with tools such as Control-M, QuerySurge, Business Objects, PUTTY, or Aldon
Strong functional understanding of banking domains such as Finance (GL, reconciliation), Risk (credit risk, Basel, BCBS 239), Retail/Wholesale banking, Trade Finance, Treasury, or Wealth Management
Experience in data profiling, data quality, and metadata management
Exposure to Agile methodologies, DevOps practices, and CI/CD pipelines
Business analysis skills and ability to translate functional requirements into technical solutions