Vacancy caducado!
MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.
SummaryDatabase Developer will be responsible for Data Integration and Report Development and will work independently and collaboratively with the team on the development, testing, integration, maintenance, and support of the Firm on day-to-day operations.Email resume and a summary of your relevant experience to MadisonHaberl @ MichaelPage.US.com.Client DetailsA leading financial service company. Email resume and a summary of your relevant experience to MadisonHaberl @ MichaelPage.US.com.Description- 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.