Commonwealth Care Alliance Teradata Developer in Boston, Massachusetts
Teradata Developer. Responsible for programming and integrating various data and software systems to improve quality and efficiency across the organization ? and the development and maintenance of data processes which includes ETL processes that pull data from sources including claims data, enrollment data and clinical patient applications data. The duties and responsibilities are the following: Provide solutions for data driven applications involving large and complex data; design, develop and support application solutions with a focus on Teradata architecture and its utilities such as Fast Load, Multi Load, Fast Export, TPump and BTEQ; write technical procedures and documentation for the application interfaces developed; work in an object-oriented, multi-developer environment with version control, change management and continuous improvement protocols; work closely with business users and PMO to review requirements; develop, recommend and discuss technical designs that meet those requirements; provide emergency support as necessary, including after-hours; analyze, document, and perform system configuration and setup as well as integration and system testing for both externally developed and in-house developed applications; trouble shoot issues with existing systems and resolve; identify opportunities that can improve efficiency of business processes; provide assistance and advice to business users in the effective use of applications and information technology; work in a team environment with 5-6 other database and/or software developers; act as a mentor to other developers. REQUIREMENTS: Bachelor?s degree (or foreign equivalent) in Information Technology, Computer Science or related and 5 years post-Bachelor?s progressive experience as Teradata Developer or related Teradata Development position. Technical computing skill set or knowledge must include Databases: Teradata V15, Teradata V2R6 and V2R5, and SQL Server; Operating Systems: Unix and Windows; Languages: SQL, PL/SQL, .Net; Scripting Languages: Unix shell scripting and Python; ETL Tool: IBM Infosphere Datastage or related. Software Tools: VSS, Relational Clear Case or related; Teradata Application Utilities: BTEQ, Multi Load, Fast Load, Fast Export, TPump; Modeling Tools: Erwin, Visio or related; Teradata Data warehouse architecture; data modeling and data analysis. Extensive SQL performance tuning experience processing and integrating voluminous data across heterogeneous environments. Experience with database replication using Oracle GoldenGate. Will only consider applications from ?US Workers? (US Citizen, Lawful Permanent Resident, etc.).