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...Are you passionate about clinical research and ready to make an impact on patients' lives? We're looking for a Clinical Research Associate (CRA) to join a fast-growing biotech company (confidential) that's advancing innovative therapies in neuroscience. What You'll...
The Department of Art is looking to hire a motivated student to be a Gallery Assistant. A successful candidate will be supporting exhibition programming in the Kimura Gallery in the Fine Arts Building and the Arc Gallery in the Consortium Library. This is a great opportunity...
...at Position Summary... What you'll do... Are you a recent pharmacy graduate looking to kickstart your career in a energetic and supportive environment? Join our pharmacy team as a Grad Intern and gain hands-on experience making a impact on our customers'...
...the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
...We are looking for a detail-oriented Email Correspondence Clerk to join our remote... ...steady and flexible role that allows you to work from home. Your primary responsibility will be... ...teams to ensure prompt and accurate order processing and delivery. Escalating customer...