Job Title: Programmer 4/PR4 (Sr. ETL developer)
NFP Rate: $56.66
Will close to submissions: Monday July 27 @ 10 am EST
Interviews: skype or Microsoft TEAMS
Role: Programmer 4 (Sr. ETL Developer) is requested from August 1, 2020 to January 30, 2021 (1000 hours)
ALPS Project: Staff Augmentation
MBE/Open Market: MBE
Requirement Description:
The Ohio Department of Aging (ODA) is looking for an experienced Sr. ETL Developer to join the team. She or he will be involved in designing, testing and implementing ETL scripts within the Oracle and SQL database environment to maximize the efficiency of data migration process while maintaining excellent data quality standards, and will participate in other data management initiatives.
A well-qualified candidate will have experience with various coding languages and systems and will have extensive knowledge of data warehouse architecture. Individual must have the ability to effectively communicate with internal and external stakeholders, and will actively support the Ohio Department of Aging’s data strategy and goals
This position will function as a skilled Sr. ETL Developer that include:
• Utilize the software development lifecycle to implement technology solutions that create and enhance applications.
• Extensive knowledge of database and coding languages including Oracle databases, SQL database, PL/SQL packages, Microsoft .NET, Web API and REST, JSON, jQuery, and SQL.
• Strong hands-on experience of data modelling techniques including dimensional modelling
• Define and capture metadata and rules associated with ETL processes.
• Attend information gathering sessions and provides data analysis and data mapping.
• Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports.
• Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process.
• Facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.
• Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
• Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.
• Apply best practices in the design of ETL processes to support information loads, validations and reporting.
Mandatory Requirements/Time:
• 4-year college degree or equivalent technical study
• 10+ years of Application Development in Microsoft .NET,
• 7+ years of Oracle Database
• 7+ years of SQL Database
• 7+ years of SQL script
• 7+ years of ETL process
• 7+ years of API designs in RESTful, XML, XSLT, JSON, jQuery.
• 5+ Years of UI/UX experience
• 5+ years of PL/SQL Experience
• Excellent analytical skills, attention to detail, and problem-solving skills.
• Ability to demonstrate working knowledge of ETL Tool including SSIS, Tableau Pre, Talend, Segment.
• Proven ability to handle multiple tasks and projects simultaneously.
• Familiar with the Agile Methodology.
• Working experience in Database & application performance tuning.
• Must possess excellent written and oral communication skills.
• Strong experience in creating good solutions w/o mature, detailed, codified business requirements.
• Working experience in delivering expected results in unstructured environments.
• Works productively and effectively independently without significant management oversight.
