Senior ETL Developer

Location: Boston, MA
Date Posted: 05-16-2018
Job Overview

The ETL Developer is responsible for end-to-end processes related to the Extraction, Transformation, and Load of business information from transaction systems into data warehouses and reporting systems.  This includes the design, development, and deployment of batch and near-real-time data load processing, with primary focus on maintaining the back-end components to support our client’s data warehousing systems.  

Tasks and Responsibilities
  •     Design and develop ETL processes to integrate data among business systems and data warehouses
  •     Participate in data modeling design sessions
  •     Analyze problems and propose solutions
  •     Use Informatica and scripting
  •     Perform in-depth unit testing prior to promoting to QA
  •     Support and take direction from Data Architects, Principal and Lead ETL Developers
  •     Look for opportunities to enhance existing code and processes as well as overall data quality improvements
  •     Participate in system and user testing
  •     Perform production implementation, including all required documentation
Qualifications
  •     BA or BS in information systems, information technology, or computer science
  •      Experience in ETL design and development; experience in Informatica preferred
  •     Experience in database development using Oracle and/SQL Server
  •     Strong SQL scripting skills, including procedural languages such as PL/SQL and T-SQL
  •     Experience with ETL tools such as Informatica and/or SSIS,
  •     Experience in working with large–scale data warehousing and complex transformations
  •     Experience in working with dimensional models
  •     Experience using a software development lifecycle (SDLC) methodology
  •     Knowledge of Stored Procedures/Unix scripting knowledge
  •     Knowledge of implementing adequate controls for balancing
  •     Analytical, problem solving, and testing skills
  •     Effective oral and written communication skills
  •     Must have solid understanding of relational database design
  •     Entrepreneurial mindset and passion for emerging technologies
  •     Ability to collaborate with stakeholders from local, national, and international constituencies
  •     Excellent communication and creative-thinking skills, with an ability to use data to inform all decisions
Nice to Have
  •     Knowledge of Salesfoce.com data model
  •     Experience with Informatica Cloud
or
this job portal is powered by CATS