SSIS Developer Job Description
SSIS developer
provides development experience using Microsoft SSIS and SQL Server.
SSIS Developer Duties & Responsibilities
To write an effective SSIS developer job description, begin by listing detailed duties, responsibilities and expectations. We have included SSIS developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
Design, implement and maintain database objects (tables, views, indexes, ) and database security
Experience working with SSIS packages
Proficient with ETL tools such as Microsoft SSIS
Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
Test and prepare ETL processes for deployment to production and non-production environments
Support system and acceptance testing including the development or refinement of test plans
SSIS Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SSIS Developer
List any licenses or certifications required by the position: MCSA, BI, MCSD
Education for SSIS Developer
Typically a job would require a certain level of education.
Employers hiring for the SSIS developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Computer Science, Education, Engineering, Technical, Business, Information Technology, Software Development, Technology, Financial Services, Information Systems
Skills for SSIS Developer
Desired skills for SSIS developer include:
T-SQL
Data modeling
Object oriented programming and development practices using .Net / Java platform
SQL
SSIS
Functions and Triggers
SSAS
SSIS development
Stored Procedures
Views
Desired experience for SSIS developer includes:
We provide solutions for a wide variety of business problems, many of which require multi-platform solutions
Good knowledge of SQL Server database
At least 3-5 years of data integration (sourcing, staging, mapping, loading, ) experience, SSIS preferred
B.B.A
Demonstrated experience with an enterprise-class integration tool such as SSIS, Informatica, Ab Initio, Data Stage
Demonstrated experience working in a team development environment using an IDE
SSIS Developer Examples
1
SSIS Developer Job Description
Job Description Example
Our company is looking for a SSIS developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for SSIS developer
- Develop ETL/DW best practices and participate as a reviewer and contributor in requirement, design and code reviews
- Leads on shore and offshore developers on various initiatives
- Participates in resource planning and task estimation
- Create/maintain design related artifacts data models , Mapping documents, architecture diagrams, data flow diagrams
- As the ETL/BI Developer you will be coding, testing, debugging, implementing, and documenting moderately complex programs
- Creating documentation to show work / data flows (DFD, ERD, ) and end - user resources
- Working as a part of a team to manage and deliver quality and robust system enhancements to critical systems, as required by the business
- Designing and developing C# and VBScript enhancements to an existing application that automates the system via WebMethods and Control-M
- Working within the technology team to assist with best-practice technical tasks
- Assisting with the technical configuration of QRM
Qualifications for SSIS developer
- Certifications related to data mining
- Master’s Degree in Computer Science or Information Technology, or equivalent experience
- Thorough knowledge of SSIS components with a broad range of experience transforming data from CSV files, XML files, and common relational database sources and destinations
- Hands-on development experience with Transact-SQL, including stored procedure development
- Strong knowledge of relational database logical and physical design including star schemas and data cubes
- Experience in working with distributed development teams
2
SSIS Developer Job Description
Job Description Example
Our company is growing rapidly and is looking for a SSIS developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for SSIS developer
- Create Teradata tables, load data to Teradata tables and create customized views from the table
- Understands complex business needs and designs an accurate, robust and easily maintainable software solution
- Obtains and evaluates information on factors such as reporting formats required and security needs to determine hardware configuration
- Provides estimates of effort for programming and implementation specific tasks to aid in preparing project timelines
- Reviews input into developing a test strategy for large projects
- Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse
- Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions
- Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance
- Integrates ETL development with existing projects to maximize object reuse
- Develops, tests and troubleshoots ETL processes
Qualifications for SSIS developer
- Participate in system and integration test
- BA/BS degree or technical institute training AND 1 or more years of experience on one platform
- Experience programming in SQL and Microsoft .net is required
- Bachelor's degree in Computer Sciences or Computer Engineering or associated discipline or the equivalent experience
- Microsoft Certified Solutions Developer (MCSD) certification is a plus
- Strong cube/analytical data model design expertise (preferred)
3
SSIS Developer Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of SSIS developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SSIS developer
- Review and make recommendations for tuning SQL queries
- Define and captures metadata and rules associated with ETL processes
- Works with business requirements analyst to identify and understand source data systems
- Analyzes possible system alternatives in relationship to business need, costs, effectiveness, and information availability requirements
- Develops or assists in the creation of project time estimates
- Develops and implements application documentation and training materials
- Provides post implementation support of user questions and fine tuning of processes
- Maintains knowledge on current computer hardware and software technology
- Managing the database artifacts and providing subject matter expertize on best practices for creation, deployment and ongoing management of databases in a reporting/BI environment
- Monitoring daily/other database jobs and data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting
Qualifications for SSIS developer
- Specific knowledge of Software Deployment Requirements for BI/DW Projects (preferred)
- Experience with shipped extracts (scheduled deliveries, ftp)
- Use the SSIS platform to extract, transform, and load data
- 7 to 10 years of experience designing, developing and implementing applications using Microsoft Solutions (.Net
- Ability to learn and apply technologies quickly
- Advance degree a plus
4
SSIS Developer Job Description
Job Description Example
Our growing company is looking for a SSIS developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SSIS developer
- Develop ETL using SSIS
- Develop complex SQL queries for small to large sets of data and lead query optimization efforts
- Design and architect artifacts using Data Modeling concepts
- Designing databases and some data sourcing/ETL requirements for efficient use in reporting and BI
- Performing routine database administration activities including setup login credentials for users & administer general security measures on database, to resolve and troubleshoot database access/other database issues, handle the backing up process of the database & its inspection
- Provide support and participate in design and implementation of ETL processes and procedures
- May work with internal business process owners, business SME's
- Work in an environment with little supervision and participate in team strategizing, and vision execution/ implementation of the reporting & BI strategies supporting from a database stand point, collaborates with other team members/BAs in supporting shared/common reporting needs and projects
- Act as single point of contact for application and provide required technical leadership to the team
- Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytic reports
Qualifications for SSIS developer
- Demonstrated achievement in Professional and/or academics pursuits- high GPA, academic honors, etc
- Locals only please
- Responsible for data profiling SQL and database tuning / optimization
- 5+ years of experience with SSIS ETL development
- Strong technical skills using SQL Server and TSQL
- Experience using SSIS for ETL
5
SSIS Developer Job Description
Job Description Example
Our growing company is hiring for a SSIS developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SSIS developer
- May be internal or client-focused, working in conjunction with Professional Services and outsourcing functions
- Produce comprehensive tests for all developed code
- Work to load a variety of data into databases, while working with business users and software developers to make that information available for queries, reports, and custom software applications
- Extract & import datasets from various data sources for use in custom software applications and future self-service analytic platforms
- Monitor, troubleshoot and support a wide range of extraction processes & datasets used across the company
- Assist with database performance optimization and interoperability issues
- Work with business users in creating extracts, queries and reports in response to requests for specific data
- Develop test plans to make sure the data warehouse solution meets all user requirements
- Perform analysis of business requirements to design and recommend solutions to meet the customer needs
- Design and develop applications and web services using ASP.NET Web Forms, MVC, C#, XML, HTML, JavaScript, jQuery, AngularJS, CSS, Bootstrap, Entity Framework
Qualifications for SSIS developer
- Experience with the Data Vault Methodology, preferably Data Vault 2.0
- Must have experience with Star Schema modeling
- A working knowledge of SQL Server Master Data Services is a must
- Ability to work with the business to understand their needs and requirements
- Experience with Control-M (or similar scheduling systems)
- Experience with running the Microsoft stack in public or private cloud environments