Summary
Denver Water is a local water utility that relies on contractors to deliver low-demand or specialized IT services to ensure reliable water supplies. Read how the company engaged with ExistBI for the delivery of Informatica consulting and support services over a 12-month period which was happily extended by an additional 12 months.
About Denver Water
Denver Water is a local water utility that delivers high-quality water and promotes its efficient use to 1.5 million people in the city of Denver and many surrounding suburbs. Established in 1918, the utility is a public agency funded by water rates and new tap fees, not taxes. It is Colorado’s oldest and largest water utility.
To manage their IT operations, Denver Water internally staffs for high demand and general while low demand and specialized skills are staffed with contract personnel.
Challenge
Denver Water uses Informatica PowerCenter for Extract, Transform, and Load (ETL) services for their data management applications and needed an experienced contractor who could deliver administration, architecture, and development support. Specifically, they needed an Informatica and ETL expert to:
- Provide backup support for Informatica operations
- Assist to restore the Informatica application in the event of an unplanned outage
- Assist in debugging, perform root cause analysis, and resolve Informatica or ETL issues
- Participate in support calls to plan and implement software patches and upgrades
- Respond to a backup support request with an acknowledgment within 20 minutes of receipt and work to triage within 60 minutes of receipt
- Provide support documentation after each task.
Solution
ExistBI worked closely with Denver Water to deliver the following services:
Informatica Administration
- Maintain and own Workfront helpdesk ticket management and incident resolution process. This includes notifying business users of issue resolution when delayed delivery or incorrect data has impacted their processes.
- Manage and own Informatica PowerCenter application issues including applying permanent resolutions, implementing preventive measures, and submitting issue documentation.
- Deliver production system support including daily spot check of system health and managing the application release process.
- Support the release of new PowerCenter workflows and mappings into production servers, including building new or updating existing Enterprise Scheduler jobs.
- Provide documentation for primary support engagements.
- Assist with Informatica upgrade services.
Informatica Architecture and Development
- Review and optimize existing Informatica environments and recommend enhancements that improve operations and architecture.
- Deliver ETL development tasks including ETL specifications, documentation, and testing.
- Develop implementation plans for the upgrade of Informatica PowerCenter software.
Expertise Offered
Denver Water required ExistBI to possess expertise in the following areas:
Informatica PowerCenter is a data integration and ETL tool used to extract data from various sources, transform it according to business rules, and load it into a target data warehouse or data repository for analysis and reporting. It is widely used to efficiently manage and process data.
Oracle SQL Developer is an integrated development environment (IDE) to help developers and database administrators (DBAs) efficiently facilitate database development and administration tasks.
Microsoft SQL Server Management Studio (SSMS) is an integrated environment for working with SQL Server and offers a wide range of features that assist database administrators (DBAs) and developers in database management, querying, and development.
Operating systems and functions including Windows OS (including .bat files and DOS commands), Linux OS, FTP basics, administration of login authentication via Kerberos, and expert debugging skills.
ETL development including a strong understanding of data structures, data modeling, and databases. ExistBI is also proficient in working with various data formats and sources, understanding data quality issues, and ensuring data accuracy during the extraction and transformation process. In addition to Informatica, ExistBI is well-versed in working with ETL tools like Microsoft SSIS, Talend, IBM InfoSphere DataStage, and SAP Data Services.
Do you need the expertise of a proven and experienced ETL consultant who can help you reliably move your data? Let ExistBI be your ETL partner.
