Job Description
MAJOR DUTIES AND RESPONSIBILITIES:
- Responsible for creating software code that will extract data from source systems, transform it as necessary and load it into data warehouses and/or into data marts required during the development, quality assurance and transition to production phases
- Help data analysts run data profiling scripts and documenting the results
- Create detail design specifications based on architecture and design specifications
- Document satisfaction of requirements in design specifications to help with requirements traceability
- Participate in design specification quality assurance reviews involving a data integration architect and data integration designer
- Create unit test data to ensure that the code performs under all expected conditions
- Develop data integration software using SSIS (SQL Server Integration Services)
- Data Warehouse architectural and development solution, including facilitation of the bank’s data delivery of information
- Day-to-day, you will responsible for the technical design/configuration of existing ETL processes
- Conduct unit tests in a personal schema to ensure that the code meets the specification
- Document test results and store test data and results in a project documentation repository
- Participate in code reviews with data architects, lead developers, and other developers
- Be accountable to the data integration architect for the quality of data warehouse developer deliverables
- 3 years of experience working in a data warehouse environment using SSIS and Microsoft SQL Server
- Exposure to Oracle Databases and Informatica PowerCenter
- 5+ years of experience in advanced SQL and be able to write complex logic using SQL as part of ETL, and use SQL effectively to perform complex data analysis and discovery
- Must be detail-oriented and have a critical eye for data quality
- Demonstrated ability to troubleshoot, optimize and performance-tune existing SQL code
- Demonstrated ability to perform data analysis/discovery and communicate results in business-friendly terms
- This job requires access to confidential and sensitive information, requiring ongoing discretion and secure Information Management.