Data Warehouse ETL Developer- DMV GC/Citizens Only

CyGnA

Data Warehouse ETL Developer- DMV GC/Citizens Only

National
Full Time
Paid
  • Responsibilities

    DMV Seeks (2) two Data warehouse developers with at least 5-7 years of proven professional experience in the design, development, testing and administration of Informatia PowerCenter workflows and mappings.

    DMV requires consultant services of two individuals who are highly skilled and experienced in data warehouse structures and dashboard generation. Work to be performed in a designated DMV office location. The IT Specialist will primarily provide technical expertise in data warehousing and dashboard generation using various data sources. • Develop and support an extract, transform, load (ETL) process for data warehouse structures that support reporting and data analytic systems. • Collaborate with a diverse team of business analysts and report developers to develop and build enterprise data warehouse (EDW) artifacts such as SQL code, logical and physical data models, and business intelligence reports. • Contribute to software design and architecture while following development specifications and standards. • Perform administration, analyst and developer responsibilities as needed within the full stack supporting the data warehouse. • Perform complex analysis and design across multiple database platforms and technologies covering DB2, oracle, SQL and other databases. • Instruct and guide those with less experience. • To conduct research into new data warehouse applications and determine viability for adoption. • Identify and describe business intelligence (BI) problems and requirements from across the organization. • Collaborate with data providers to ensure the right data is in the warehouse and is updated as changes occur in the data providers' source system applications. • Profile and understand large volumes of source data, including structured and unstructured data. Sources will include MySQL, Microsoft SQL Server, flat files, web application API's and the Cloud. • Regularly conduct ETL and database performance tuning. Look for ways to improve overall performance. • Identify opportunities to leverage existing metrics and develop new metrics to help move the organization forward by identifying waste in our processes. • Provide insight into creating and maintain a system that helps ad-hoc metrics providers move to a more robust and shareable reporting interface. • Assist in the development of metrics and processes to ensure quality standards are met on new and existing data. • Develop complex Dashboards for the agency using various data structures and sources. • Develop and support an extract, transform, load (ETL) process for data warehouse structures that support reporting and data analytic systems. • Collaborate with a diverse team of business analysts and report developers to develop and build enterprise data warehouse (EDW) artifacts such as SQL code, logical and physical data models, and business intelligence reports. • Contribute to software design and architecture while following development specifications and standards. • Perform administration, analyst and developer responsibilities as needed within the full stack supporting the data warehouse. • Perform complex analysis and design across multiple database platforms and technologies covering DB2, oracle, SQL and other databases. • Instruct and guide those with less experience. • To conduct research into new data warehouse applications and determine viability for adoption. • Identify and describe business intelligence (BI) problems and requirements from across the organization. • Collaborate with data providers to ensure the right data is in the warehouse and is updated as changes occur in the data providers' source system applications. • Profile and understand large volumes of source data, including structured and unstructured data. Sources will include MySQL, Microsoft SQL Server, flat files, web application API's and the Cloud. • Regularly conduct ETL and database performance tuning. Look for ways to improve overall performance. • Identify opportunities to leverage existing metrics and develop new metrics to help move the organization forward by identifying waste in our processes. • Provide insight into creating and maintain a system that helps ad-hoc metrics providers move to a more robust and shareable reporting interface. • Assist in the development of metrics and processes to ensure quality standards are met on new and existing data.

    • Develop complex Dashboards for the agency using various data structures and sources.

    CONTRACT JOB DESCRIPTION Responsibilities: 1. Demonstrates expertise in conveying technical and functional concepts for a specific technical specialty. 2. Identifies improvements to project standards to achieve high quality services/ products. This is a professional position which may require subject matter expertise consistent with demanding and rare technological skills. 3. May require coordination of programming activities being conducted by the application development team 4. Confers with other business and technical personnel to resolve problems of intent, inaccuracy, or feasibility of computer processing and project design. 5. Works with necessary personnel to determine if modifications are necessary with interested personnel to determine necessity for modifications or enhancements. 6. Leverages excellent written and verbal communication skills to develop new business process and programming solutions as directed by business and technical stakeholders. 7. May coordinate activities of application developers. 8. Able to identify best practices and standards for the use of the product. 9. Proven track record of hands-on technical design and code work within large complex systems. 10. Proven hands-on technical work with a variety of technologies. 11. Demonstrated technical expertise integrating a variety of diverse technical environments and cross-platform technologies. 12. Delivers support and design for industry specific applications that require integration with statewide systems or applications. 13. Interacts with executive level business users or technical experts. 14. Advanced experience in the required technical subject matter. 15. May function as a niche technical SME (Subject Matter Expert). 16. Has proven experience across large and complex implementations and systems. Minimum Education/Certification Requirements: Bachelor's degree in Information Technology or related field or equivalent experience Skills