Sr Metadata Developer & Administrator (SQL, ETL, scripting, tuning, data mapping, replication) in McLean, VA Job at DBA Web Technologies, Indiana

blVjZDZIbHFjZXlFcjE2S3hoM1A5V2s2VXc9PQ==
  • DBA Web Technologies
  • Indiana

Job Description

Sr Metadata Developer & Administrator (SQL, ETL, scripting, tuning, data mapping, replication) in McLean, VA

data mapping, data replication, ETL, Metadata Administrator, Metadata Developer, Metadata Management, Metadata Repository, Oracle, Performance Tuning, SQL

Location: Virginia

Job Function: Metadata Specialist

Date Of Job Posting: 06-08-2018

Sr Metadata Developer & Administrator (SQL, ETL, scripting, tuning, data mapping, replication) in McLean, VA   

Position: Sr Metadata Developer & Administrator (SQL, ETL, scripting, tuning, data mapping, replication)

Location: McLean, VA

Duration: Full-Time Permanent position (no contracts, no corp to corp, no remote)   

Salary:   Excellent Compensation with benefits + interview travel + relocation possible  

SKILLS: Metadata Developer, Metadata Administrator, SQL, ETL, UNIX, shell, autosys,  performance tuning, GitHub, ClearCase, data mapping, ETL mapping, IDQ Component, Metadata Management, Metadata Repository, agile, DB2, Oracle, Stored Procedures, SQL tuning, data replication

DESCRIPTION:

We are aggressively searching for a Sr Metadata Developer & Administrator for our prestigious client for their location in McLean, VA.

Senior (Metadata Developer/Adminstrator) will work in the Data Services department of the Information Technology division. We are seeking a motivated individual to design and develop enhancements to software applications on a Metadata Manager Product Expertise and Perform Data Modeling (develop MetaModel in Metadata Manager). As a member of the IT development team, the individual would develop source code, unit test, participate in code reviews, deploy code to multiple environments. Work collaboratively with other open minded, technology savvy and dedicated team members. 

Role and Responsibilities:

-Create resource in Metadata manager

-Creating Linking rules in Metadata Manager

-Work with business SMEs and identified project stakeholders to develop requirements (functional/non-functional/operational/data quality) for Metadata Management system

-Develop Requirements traceability matrix (RTM)

-Perform Data Mapping and linking in Informatics Metadata Manager

-Perform data profiling, data analysis, setup mock data for development/unit testing

-Perform Data Modeling (develop MetaModel in Metadata Manager)

-Work with other team members, testers, business area SMEs to help implement the Metadata Manager product, including configuring connectors to both databases and ETLs for harvesting of metadata

-Support all phases of the project development lifecycle using SDLC and other project methodologies

-Load ETL mappings, Database objects and other data movement objects to Metadata Manager

-Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, -User Acceptance Testing, End-to-End Testing, and Performance Testing

-Perform troubleshooting on IDQ components

-Identify application bottlenecks and opportunities to optimize performance

-Provide resolution to an extensive range of complicated MDM/IDQ related problems, proactively and as issues surface

Required Skills and Qualifications:  

-College Degree or equivalent experience; advanced studies/degree preferred

-About 7 t0 10 years overall current and hands-on development experience with Metadata Manager Product Expertise

-Experience in SQL, ETL skills, UNIX, shell, autosys

-Metadata Manager Product Expertise

-Minimum 2- 4 years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning

-Minimum 1 -2 years of current and hands-on UNIX shell scripting experience

-Minimum 1 -2 years of current and hands-on Autosys experience

-Minimum 1 -2 years of current and hands-on experience with code management tools such as GitHub or ClearCase

Preferred Skills:

-Metadata Management/Repository Experience, ideally with product a plus but not required

-Data Quality (IDQ) and PowerCenter

-ETL development skills (either IBM DataStage or ) a plus but not requied

-Commercial Off the Shelf Products/Packaged Software implementation experience a plus but not required

-ETL Development experience with PowerCenter

-Experience in AGILE based project development

-Strong decision making and problem solving skills and experience with project delivery

-Technical project coordinator experience. Ability to work independently on multiple projects; and lead junior and mid-level developers in technology delivery

-Superior communications skills, comfortable with working with middle and senior management

-Experience with DB2, Oracle, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred

=================================================

Apply for this job

Job Tags

Permanent employment, Full time, Remote job, Relocation,

Similar Jobs

Avant Tech

Sr. Cyber Security Analyst Job at Avant Tech

 ...JOB DESCRIPTION Reporting to the Security Operations Manager, the Senior Cyber Security Analyst is responsible for deployment and management...  ...Risk Architect to review the infrastructure & microservices network and data architecture and identify vital security detection and... 

The W Real Estate Group

Join Our Growing Team with a High-Value Investment in Your Success! Job at The W Real Estate Group

 ...Here, you'll find a vibrant and supportive environment designed to help you learn, grow, and excel. We are offering high-value investments in new agents, demonstrating our commitment to your success. This significant investment provides you with a clear path to... 

Hickok Cole

Rise Architecture/Interior Design Internship + Stipend Job at Hickok Cole

 ...to every opportunity across our diverse architecture, interior design, and creative branding...  ...financial assistance to reduce barriers for entry into architecture and interior design...  ...experience required to be competitive for entry-level positions upon graduation and be exposed... 

University of Kentucky

Assistant or Associate Professor in Earth & Environmental Sciences | University of Kentucky Job at University of Kentucky

 ...Department Name: 8E060:Earth and Environmental Sciences Job Summary: The Department of Earth & Environmental Science ( EES ) in the College of Arts and Sciences at the University of Kentucky in Lexington, KY seeks to fill a tenure-eligible faculty position at... 

Eurofins USA PSS Insourcing Solutions

Entry-Level Biochemist Job at Eurofins USA PSS Insourcing Solutions

 ...because your growth is our growth A chance to step in to the pharmaceutical/biopharmaceutical industry and move up the ladder of success...  ...activities Perform cGLP cell banking activities for research use Coordinate with a broader scientific team to align on...