Vacancy expired!
- Design and develop database and applications with all phases of SDLC.
- Use SSIS, SSRS, and SQL to develop ETL packages and reports.
- Maintain the exiting SSIS Packages, Data Flow logic designs and SSRS Reports.
- Design and develop new features/functionalities of ETL Data Integration usingSSIS, SQL, C#, Python, etc.
- Perform hands-on data-related tasks such as data analysis, data integration, dataissue remediation, data reconciliation, data warehousing, and reportingautomation.
- Develop functions, views and stored procedures, complex SQL queries forreports that meet regulatory, risk, management and business requirements.
- Conduct legacy report logic analysis and develop the report on the newreporting platform.
- Perform end-to-end reports management including design, development, testing,configuration, deployment, and maintenance of the reports.
- Proactively manage and monitor SQL Server infrastructure and assist teams to tune performance and remediate any issues utilizing the Database infrastructure.
- Design, implement and maintain data integrations between enterprise systems.Maintain and enforce data consistency across those systems.
- Design, implement and maintain solutions to assist in the analysis and delivery of data stored in enterprise systems through the use of SQL Server businessintelligence tools, including SSIS, SSRS, etc.
- Establish, maintain and follow group procedures and policies related to the SQLServer environment, including installations, configurations, backups, disasterrecovery, and other such operations.
- Write technical documents and testing reports.
- Execute ad hoc tasks assigned by Supervisors.
- Extensive experience writing advanced SQL queries and stored procedures and troubleshooting their performance.
- Familiarity with Windows server operating systems, and an understanding of server hardware as it relates to MS SQL Server, as well as an understanding of basic networking and system concepts.
- Ensure all database programs meet company and performance requirements.
- Ensure the Bank's database systems run effectively and securely on a daily basis.
- Develop test plans, test scripts, validation procedures, and perform systemintegration testing.
- Develop reports development and maintenance policies, and draft the newproduct or report requirements for H.O.
- Self-motivated and be able to work independently and collaboratively withothers teams.
- Proven Microsoft T-SQL skills.
- Demonstrated knowledge of large, relational databases and data structures.
- Strong understanding of ETL concepts.
- Familiarity with Business Intelligence tools including SSIS and SSRS,integration with SQL.
- Demonstrated experience with maintaining database security, access controland management.
- Proficient in standard business and database software including: MS Office, MSAccess, Crystal Report, and SSMS.
- Strong quantitative skills, attention to detail, and a high aptitude for problemsolving.
Vacancy expired!