About the role
Position Details:
We are looking for a Data warehouse engineer with solid experience in designing, building, and maintaining DWH platforms. Should have working knowledge in implementing data warehouses and data marts for financial institutions using ETL tools and database technologies such as DB2 and Oracle. In this role, you will work closely with the Production support team and development teams across EDS, sharing insights, best practices, and innovative ideas for an efficient data delivery process.
Key Responsibilities:
- Optimize the data warehouse platform, monitoring it, keeping it healthy while keeping the cost down.
- Remediate Infrastructure and application vulnerabilities.
- Work on s/w and H/w EOL activities and data center migrations.
- Test data management and batch runs to support project delivery.
- Disaster recovery planning, testing, and environment management.
- User access management and reporting.
- Maintain design and coding best practices.
- Work with the Enterprise Architecture team to ensure platform components implement the architecture patterns.
- Develop and enforce technology standards to comply with the MUFG policy framework
Requirements:
- 5+ years of overall experience in Information Technology.
- 4+ years’ Experience in working with Datawarehouse platforms.
- 4+years’ experience with the informatica ETL tool
- 4+ years of writing, optimizing complex SQL queries that join across multiple tables and unionize multiple datasets.
- 3+ years of Unix shell scripting experience.
- 2+years of experience with batch processing using Enterprise scheduler tools like Autosys and Tidal.
- Expertise in relational and dimensional databases like UDB DB2, Oracle, and SQL Server.
- Experience in Software development life cycle and effective in troubleshooting Prod issues and providing root cause analysis.
- Must have system design thinking, ability to plan and author technical documents.
- Require problem solving and prioritization skills.
Strong communication skills to collaborate with team members.