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

JOB-RELATED SKILLS/COMPETENCIES;

• 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.

If you're interested in hearing more about this opportunity, apply now!