Senior Data Warehouse Engineer BFSI Domain
Share
Job Location:
Monthly Salary:
Experience Required:
Posted on:
3 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Description
Data Warehouse Engineer / Lead Banking & Financial Domain
Experience Required: 810 years
Role Descriptions / Responsibilities
Strong technical knowledge in Data Warehouse systems.
Knowledge and experience in the Banking and Financial domain (minimum 8 years).
Experience in ETL processes and developing SSIS packages.
Ability to lead and mentor a team of developers.
Ability to understand requirements and manage complete data warehouse systems.
Mandatory / MUST-HAVE Skills
Strong expertise in ETL and Data Warehouse development.
Hands-on experience with MS SSIS for ETL package development.
Experience with SSRS for reporting and dashboarding.
Strong database skills including IBM Netezza MS SQL Server Sybase.
Experience with AWS Redshift or AWS Glue for cloud-based data warehousing.
Nice-to-Have Skills (Preferred but Not Mandatory)
Experience with AWS Cloud services such as Spark Redshift and EMR.
Knowledge of lending systems and functional processes in banking.
Experience with MDM systems for customer demographics management.
Understanding of retail and commercial deposit systems (Core Banking Canadian banking domain).
Strong solution knowledge in AWS Cloud and hands-on experience with ETL processes like Kafka message processing batch interface data injection and other business-layer processes.
Core Skills / Tools
Data Warehouse
IBM Data Management
IT ISAMS
Database: MS SQL Server
Required Skills:
Experience (Years): 4-6 Essential Skills: Work with project teams throughout the organization to design implement and manage CDN infrastructure using Akamai to ensure high availability performance and scalability for customer facing applications and business processes. Handle multiple priorities and assignments with excellence and precision. Be a part of a 24/7/365 organization (some after hours support is expected as part of normal on-call rotation). Directly support line of business development teams provide guidance to them on implementation and changes for customer facing applications Develop and maintain security protocols and measures to protect CDN infrastructure from cyber threats. Monitor and analyze network performance identifying and resolving issues to optimize content delivery of critical applications. Collaborate with cross-functional teams to integrate Akamai CDN solutions with existing systems and applications. Collaborate with information security teams to implement DDoS protection strategies and other security measures in the CDN. Provide technical support and guidance to clients and internal teams regarding CDN and security best practices. Work closely with vendor and professional service teams on delivery related activities and strategy. Qualifications: Bachelors degree in Computer Science Information Technology or a related field. OR similar work experience. Strong understanding of network protocols (HTTP/HTTPS DNS TCP/IP). Proven experience as a CDN Engineer or similar role with a strong focus on -depth knowledge of Content Delivery Network technologies including caching load balancing and content optimization. Excellent problem-solving skills and attention to detail. Strong communication and teamwork abilities. Experience supporting 24/7/365 customer facing applications at enterprise scale. Awareness and experience with cybersecurity tools and practices such as firewalls intrusion detection/prevention systems and encryption. Proficiency in scripting and automation (e.g. Python Bash) a plus. Relevant certifications (e.g. CISSP CEH) are a plus but not required.
Company Industry
IT Services and IT Consulting
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
