DBA Web Technologies
Sr Metadata Developer & Administrator (SQL, ETL, scripting, tuning, data mapping
DBA Web Technologies, Location, West Virginia, United States,
Sr Metadata Developer & Administrator (SQL, ETL, scripting, tuning, data mapping, replication)
in McLean, VALocation:
McLean, VADuration:
Full-Time Permanent position (no contracts, no corp to corp, no remote)Salary:
Excellent Compensation with benefits + interview travel + relocation possibleSKILLS:
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 replicationDESCRIPTION:We are aggressively searching for a Sr Metadata Developer & Administrator for our prestigious client for their location in McLean, VA. The Senior Metadata Developer/Administrator 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, and deploy code to multiple environments. Work collaboratively with other open-minded, technology-savvy, and dedicated team members.Role and Responsibilities:Create resource in Metadata managerCreating Linking rules in Metadata ManagerWork with business SMEs and identified project stakeholders to develop requirements (functional/non-functional/operational/data quality) for Metadata Management systemDevelop Requirements traceability matrix (RTM)Perform Data Mapping and linking in Informatics Metadata ManagerPerform data profiling, data analysis, setup mock data for development/unit testingPerform 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 metadataSupport all phases of the project development lifecycle using SDLC and other project methodologiesLoad ETL mappings, Database objects and other data movement objects to Metadata ManagerCorrect 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 TestingPerform troubleshooting on IDQ componentsIdentify application bottlenecks and opportunities to optimize performanceProvide resolution to an extensive range of complicated MDM/IDQ related problems, proactively and as issues surfaceRequired Skills and Qualifications:College Degree or equivalent experience; advanced studies/degree preferredAbout 7 to 10 years overall current and hands-on development experience with Metadata Manager Product ExpertiseExperience in SQL, ETL skills, UNIX, shell, autosysMetadata Manager Product ExpertiseMinimum 2-4 years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuningMinimum 1-2 years of current and hands-on UNIX shell scripting experienceMinimum 1-2 years of current and hands-on Autosys experienceMinimum 1-2 years of current and hands-on experience with code management tools such as GitHub or ClearCasePreferred Skills:Metadata Management/Repository Experience, ideally with product a plus but not requiredData Quality (IDQ) and PowerCenterETL development skills (either IBM DataStage or similar) a plus but not requiredCommercial Off the Shelf Products/Packaged Software implementation experience a plus but not requiredETL Development experience with PowerCenterExperience in AGILE based project developmentStrong decision making and problem solving skills and experience with project deliveryTechnical project coordinator experience. Ability to work independently on multiple projects; and lead junior and mid-level developers in technology deliverySuperior communications skills, comfortable with working with middle and senior managementExperience with DB2, Oracle, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred
#J-18808-Ljbffr
in McLean, VALocation:
McLean, VADuration:
Full-Time Permanent position (no contracts, no corp to corp, no remote)Salary:
Excellent Compensation with benefits + interview travel + relocation possibleSKILLS:
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 replicationDESCRIPTION:We are aggressively searching for a Sr Metadata Developer & Administrator for our prestigious client for their location in McLean, VA. The Senior Metadata Developer/Administrator 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, and deploy code to multiple environments. Work collaboratively with other open-minded, technology-savvy, and dedicated team members.Role and Responsibilities:Create resource in Metadata managerCreating Linking rules in Metadata ManagerWork with business SMEs and identified project stakeholders to develop requirements (functional/non-functional/operational/data quality) for Metadata Management systemDevelop Requirements traceability matrix (RTM)Perform Data Mapping and linking in Informatics Metadata ManagerPerform data profiling, data analysis, setup mock data for development/unit testingPerform 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 metadataSupport all phases of the project development lifecycle using SDLC and other project methodologiesLoad ETL mappings, Database objects and other data movement objects to Metadata ManagerCorrect 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 TestingPerform troubleshooting on IDQ componentsIdentify application bottlenecks and opportunities to optimize performanceProvide resolution to an extensive range of complicated MDM/IDQ related problems, proactively and as issues surfaceRequired Skills and Qualifications:College Degree or equivalent experience; advanced studies/degree preferredAbout 7 to 10 years overall current and hands-on development experience with Metadata Manager Product ExpertiseExperience in SQL, ETL skills, UNIX, shell, autosysMetadata Manager Product ExpertiseMinimum 2-4 years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuningMinimum 1-2 years of current and hands-on UNIX shell scripting experienceMinimum 1-2 years of current and hands-on Autosys experienceMinimum 1-2 years of current and hands-on experience with code management tools such as GitHub or ClearCasePreferred Skills:Metadata Management/Repository Experience, ideally with product a plus but not requiredData Quality (IDQ) and PowerCenterETL development skills (either IBM DataStage or similar) a plus but not requiredCommercial Off the Shelf Products/Packaged Software implementation experience a plus but not requiredETL Development experience with PowerCenterExperience in AGILE based project developmentStrong decision making and problem solving skills and experience with project deliveryTechnical project coordinator experience. Ability to work independently on multiple projects; and lead junior and mid-level developers in technology deliverySuperior communications skills, comfortable with working with middle and senior managementExperience with DB2, Oracle, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred
#J-18808-Ljbffr