Responsible for the development of the ETL process flows and collaborating with the staff developing/supporting ETL components for ODS environments and Dashboard reporting systems. Requires systems analysis, strong ETL skills, SQL optimization skills, PL/SQL development skills, BI development skills and database/ETL performance and tuning.
Analyze, design, develop and implement ETL process flows and BI applications
Maintain and modify applications based on approved change requests.
Contribute to the creation of project plans through the identification of activities and tasks required to achieve successful systems implementation.
Assist the operational teams with root cause analysis and solutions to production issues.
Work closely with clients and technical teams to define and document SAIDs, use cases, and business and/or technical requirements.
Solicit and/or perform code reviews.
Communicate weekly status to Project Team and Manager.
Perform miscellaneous job-related duties as assigned.
Comply with all established procedures and policies of Comcast.
_________________________________________________________________
Responsible for developing code to integrate, transform and populate data in the internal database from multiple sources. The Data Analyst must understand relational databases, data modeling requirements to build data stores and data marts. The Data Analyst will have experience in creation of ETL mappings and transformations using ODI, Pentaho or PL/SQL implementations; moving data from multiple sources and types (flat files, DB tables, applications, etc.) to target areas. The Data Analyst is expected to have expertise developing SQL and PL/SQL code; using procedures, functions, triggers and packages in Oracle.
Requires both technical and business skills that include technical and business requirements gathering, project accountability, architecture design, documentation and development as part of the complete project lifecycle. In addition to new projects, there are existing implementations where called upon to handle data maintenance items like data quality management, error handling, mapping, table changes and more
Based on business requirements, develop detailed technical requirements and specifications. Identify missing details in the business requirements and engage the appropriate resource(s) for clarification.
Develop mapping and data processing procedures to extract data from various data sources and populate the internal database.
Develop data extracts and procedures to support internal and client (external) business analytics.
Develop unit test cases and ensure successful test completion. Unit tests should be thorough and cover all functions dealing with business logic and data layouts.
Develop efficiencies throughout the SDLC on an iterative basis; this includes reuse of existing internal/third party components.
Identify cross-department competency needs and assists with development of standard operating procedures within and across client teams.
Contribute to the project estimation process.
Multi-task through project execution and prioritize accordingly thereby ensuring project deadlines are met and deliverables are completed in a timely fashion.
Assist with the transition from project completion to on-going production and production support
Communicate requirements and status with other teams and competencies is required on an ongoing basis. Assist the operational teams with root cause analysis and solutions to production issues.
Work closely with clients and technical teams to define and document SAIDs, use cases, and business and/or technical requirements.
Solicit and/or perform code reviews.
Communicate weekly status to Project Team and Manager.
Perform miscellaneous job-related duties as assigned.
Comply with all established procedures and policies of Comcast.
