Search for More Jobs
Forward this job to a friend
Apply by email without Registering
Apply by creating/using account
Please enter your registered email address, and we'll email you a link to reset your password right away.
Seeking an experienced SSIS Developer for a growing financial institution. The SSIS Developer will be responsible for data integration from internal and external source systems into the Enterprise Data Warehouse (EDW). As the SSIS Developer, you will work in collaboration with other team members to specify, analyze, design, implement and test SSIS integration packages to meet business needs.
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
Strong knowledge of relational databases, as well as skills in SQL query design and development.
Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
Gathers business requirements and works with data analysts on physical database design and modeling.
Performs code reviews, analyzes execution plans, and re-factors inefficient code.
Follows data standards, resolves data issues, completes unit testing and system documentation for Extract Transfer Load (ETL) processes.
Conducts system tests and root cause analysis, troubleshoots customer issues and corrects database defects, responding quickly to bug fixes and enhancement requests.
Follows change management process to resolve application defects or to implement development enhancements.
Provides assistance with ETL standards and design for future supportability and ease of enhancements.
Assists with the creation of reusable components as they relate to the ETL framework.
Assists with the management of ETL scalability and system management.
Creates technical documentation of design logic and ETL processes based on technology best practices, guidelines and repeatable processes.
Helps prepare and run unit, integration, UAT, regression, stress and performance plan documents and tests while documenting results.
Analyzes day-to-day functions and processes to ensure they are performing within predetermined guidelines, limits, and specifications.
Bachelor's degree from a four-year college or university in the field of computer science, information science, management information systems, or related areas of study
2+ years of SSIS developer experience required.
Experience working on BI/DW projects designing, developing, testing and troubleshooting SSIS packages that implement complex ETL financial services processes.
Experience with the Microsoft BI Stack is required.
Experience with data modeling tools; Microsoft BI tools a must.
Strong analytical ability and aptitude to derive and translate data designs from business concepts.
Has a deep awareness of all aspects of ETL.
Understands and quickly learns business concepts, functions, processes and activities
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Ability to conduct research into systems issues and products as required.
Proven creative problem-solving abilities.
Ability to communicate ideas to technical and non-technical audiences.
Logical, efficient, and proactive.
Highly self-motivated and directed.
Keen attention to detail.
Strong customer service orientation.
Experience working in a team-oriented, collaborative environment.
Experience in data mining or analytics in a banking or financial services environment a plus.
Certifications are highly preferred, but not required: MCSA SQL Server 2012 Certification; and/or MCSE Business Intelligence.
Apply by creating/using account