Previous Job
Previous
SQL Server developer
Ref No.: 18-00052
Location: Irving, Texas
Start Date: 01/04/2018
Client: Charles Schwab
Job Title: SQL Server ETL / Pentaho Developer
Location: Austin, TX


Description/Comment: Responsible for analyzing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes. Technically strong in ETL, concept, design and development and database utilities (Microsoft SQL Server). This position works as part of team charged with maintaining the information housed within the Configuration Management Database (CMDB). Critical to that mission is the need to acquire data from source systems and use automation to extract, transform, and load it in to the CMDB. This position will design, construct, and test ETL routines to move critical data from disparate systems in to the Configuration Management Database.

Additional Job Details:
- Hands-on experience designing, developing, testing & implementing ETL solutions using Pentaho/Kettle.
- Microsoft SQL Server, SQL Server Integration Studio, and object oriented programming languages
- Strong SQL knowledge and experience a must
- Developing ETL processes to load data into a configuration management database built upon BMC Software technologies in a SQL Server environment
- Design & Develop basic and advanced transformation activities; design automation processes to control data access, transformation and movement; ensure data integrity, anticipate and properly handle errors - Must be able to work independently and communicate effectively across multiple teams
- Leverage an Agile development/test/release cycle - Possess good verbal and written communication skills