MDM Data Engineer
RightTalents LLC
United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Regular working hours
Job source
Tech stack
Java (Programming Language)
Multitier Architecture
Application Programming Interfaces (APIs)
Amazon Web Services
Computing Platforms
Unit Testing
Microsoft Azure
Big Data
Software Documentation
Databases
Data Architecture
Data Dictionary
+37 more
Extract Transform Load (ETL)
Data Transformation
Data Security
Data Stores
Database Development
Perl (Programming Language)
Github
Revision Control Systems
Python (Programming Language)
PostgreSQL
Metadata
Microsoft SQL Server
MySQL
Oracle (Applications)
Standard Sql
DataOps
Service-Oriented Architecture
Simple Object Access Protocol (SOAP)
Software Engineering
SQL Databases
SQL Server Integration Services
Subversion
System Testing
Web Services
Cloud Platform System
Informatica Powercenter
Oracle 10g/11g
Snowflake
Spring-boot
Software Security
Git
Amazon Relational Database Service
Data Management
Tools for Reporting
Restful APIs
Data Pipelines
Programming Languages
Job description
- Support ODS implement MDM Person and Business domain that will integrate multiple sources of data and accompanying web services and APIs
- Develop and support architectural blueprints that leverage the MDM as a foundational service, among other things, support the creation of unified profiles that can be used for such activities as linking business transactions relevant to a business owner
- With guidance from ODS Technical Leads, coordinate the work of senior-level data engineers tasked with building pipelines to the MDM and other data platforms
- Support the development of analytics tools that utilize the data pipeline to provide actionable insights into customer engagement and experience, operational efficiency, and other key business performance metrics
- Review Extraction, Transformation, Load strategies (ETL) for data from a wide variety of data sources using SQL, cloud, and βbig dataβ technologies
- Create, update, and maintain system documentation
- Manage the development of APIs, for data access or landing data as output for further downstream consumption in the appropriate target data store
- Coordinate appropriate security scan accreditations
- Perform special projects and initiatives as assigned
- Develop custom code and services that allow seamless integration between systems
- Contribute to new technology projects as assigned and provide operations and maintenance support for existing applications
- Unit test newly developed code and support system testing efforts
- Troubleshoot errors, defects, and other system issues
- Create and maintain excellent documentation (including data dictionaries, source-to-target maps, and database policies and guidelines) and source code repositories
- Responsible for working with Cityβs Cyber Command unit to follow and complete the application security accreditation process
Requirements
- At least 8 years of experience managing the development and implementation of large technology projects, with at least 3+ years involving an MDM implementation
- At least 8 years of experience in writing SQL
- At least 8 years of experience in copying, transferring, manipulating, and automating data operations that were manual processes
- Experience with tools and components of data architecture such as Informatica Power Centre, IICS, SSIS, or similar ETL tools
- Experience working with Amazon Web Services or Microsoft Azure cloud computing platform and services
- In-depth knowledge of SQL and other database solutions
- Knowledge of modeling database schemas for large datasets
- Experience developing cloud-ready applications
- Experience working with programming languages like Python, Java, and Perl
DESIRABLE SKILLS
- 5+ years hands-on experience in development with the suite of tools from Informatica PowerCenter and B2B Data Transformation
- Experience using Oracle 10g/11g, SQL Server and/or a database appliance
- Knowledge of metadata-driven enterprise reporting platforms
- Experience with application development using Java Spring Boot Framework
- Extensive knowledge of service-oriented architecture using SOAP and RESTful web services
- Experience with 3-tier architecture
- Experience with Oracle, Microsoft SQL Server, MySQL, RDS, PostgreSQL
- Experience working hands-on in cloud-based platforms such as AWS, Microsoft Azure, and Snowflake is a plus.
- Experience with an agile, iterative development process and version control tools such as Git, GitHub, and Subversion
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦