Database Extract Transfer Load Jobs in Randolph, MA

Company Description

Innovative Firm

Job Description

The Data Architect will be expected to leverage their deep technical knowledge of data modeling and data integration best practices along with cross industry data expertise to empower the business to make data-driven decisions.

Work involves moderate to highly complex efforts in an agile environment to make the company's long-term data strategy a success. This includes the development and delivery of our long-term strategic goals with a strong data architecture vision in collaboration with business users, department managers, technology leaders, and other key stakeholders.

Direction is received from the Manager, Data Services.

Essential duties to be performed with or without reasonable accommodation

• Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
• Analyze source system data using profiling tools.
• Expert knowledge in dimensional data modeling, ETL processes, data integration applications and business intelligence tools. SAP Business Objects and Tableau a plus.
• Interacts with OLTP systems and translated relational models into dimensional models.
• Maintains Data Model repository.
• Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
• Participates in collaborations to transform business requirements into ETL and data validation designs. This includes knowledge sharing and mentoring fellow team members.
• Executes and provides feedback for data modeling policies, procedure, processes and standards.
• Evaluates source system data and data models
• Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
• Design data models in Data Modeling tools (ErWin preferred)

• Knowledge of RDBMS platforms (e.g. SQL Server or Hadoop) with experience in generating DDL
• Experience with software quality assurance testing, release procedures, coding design and documentation protocol.
• Address data related problems in regards to systems architecture, integration, compatibility, and multiple-platform integration.
• Understanding of the systems development life cycle
• Experience working in on an Agile team (preferably Scrum) of Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria.
• Experience with an Agile Tool such as Team Foundation Server (TFS) to track stories and code quality.

Requirements

• Bachelor's degree in Computer Science or a related field
• A strong background in establishing a Data Quality framework and architecture in accordance with existing company policies, procedures, and guidelines.
• Solid experience using Informatica PowerCenter in a Data Warehouse environment.  Experience in Informatica Data Transformation a plus.
• Expert understanding of join logic, performance and query optimization in Informatica.
• Expertise in using partitioning, transformations, and incremental caching in Informatica.
• Experienced in being the lead designer of data mappings, transformation, and movement routines.  This includes detailed designs, technical specifications, and transformation rules.
• Experience in Perl or PowerShell for scripting
• Highly proficient in writing and tuning complex SQL (T-SQL in SQL Server)
• Strong experience with SQL Server 2014/2016
• Proven success working in a collaborative and agile environment (Scrum methodology a plus).
• Demonstrates analytical thinking and strong problem solving skills.
• Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design.
• Experience or exposure to Informatica Metadata Manager, SAP Business Objects & Crystal, Tableau, Hadoop, and CA ErWin.
• Proven background designing and architecting ETL solutions as part of a cross-functional team.
• Experience in making hardware recommendations, sizing, and configuration for development systems.
• Experience in Hybrid Cloud based implementations and architecture.  Azure experience a plus.
• Platforms:  MS Windows on VMWare
• Database Management Systems:  Microsoft SQL Server 2012/2014/2016
• Data integration: Informatica PowerCenter ETL, Informatica Data Transformation Tool, and HortonWorks (Hadoop background a plus)
• BI Reporting and Visualization: SAP Business Objects & Tableau
• Job Scheduling:  SMA Solutions OpCon
• SQL, Strong SQL/T-SQL, MS PowerShell scripting
• File Movement:  GO Anywhere Managed File Transfer
• Experience working with SharePoint
• Azure/AWS Cloud experience a plus
• Agile Development - Scrum Methodology
• MS-Office/Visio/PowerPoint

Additional Information

All your information will be kept confidential according to EEO guidelines.