UniCredit Bank RomaniaJunior DWH Developer
Aug. 2020 - Jul. 2022I was working as a Data Warehouse Developer on Accounting&Regulatory team, and my requirements were: • Experience working with financial data.
• Experience in working with large volumes of data.
• Write DML/DDL SQL statements.
• Ensure the consistency of the information in the database.
• Understand, investigate and solve problems that occur in database maintenance process.
• Developing .sh scripts.
• Developing and adjusting ETL jobs with Datastage.
• Monitoring and manage ETL flow scheduling runs through Mainframe with Host on Demand (HOD).
• Collaborate with various groups (clients, technical infrastructure staff) to identify and resolve application issues.
• Participate in requirements gathering and analysis, technical design, testing, documentation and project planning.
• Consult with clients to gather information about needs, objectives, functions, performance expectations and input and output requirements.
• 2nd layer support for technical users, production incidents and requirements.
• Maintaining the quality and production environments aligned and up to date for proper flow runs.
• Ensuring implementation and supporting phases of deployments for different modules, releases and patches.
• Handling Incident Management which includes allocation, deadline tracking, creating change requests for copy data, raise tickets for access, ensuring the rights on applications using Service Now and Archimede.
• On-call support: Maintaining the system runs in production environment and solving urgent incidents promptly which includes support outside the business hours. Technologies: IBM InfoSphere DataStage, Mainframe-JCL, Host on Demand, Teradata SQL Assistant, WinSCP, Counter Monitor, Metamon, Archimede, Service Now, Remedy