ETL / Data Integration Specialist

Location : Pittsburgh, PA (Day 1 On-Site- 5 Days On-Site in a Week- No Hybrid Module)

Primary Success Factors :

• Translates data requirements into applications that employ appropriate data models and ETL solutions. Analyzes, defines, develops, and maintains complex database structures and ETL architectures and applications. Creates data flows and ETL models defining the data transformation needs of projects. Ensures effective and efficient utilization of ETL processes when accessing, integrating, and delivering data between systems.
• Develops and implements data validation, auditing, reconciliation, testing methodologies, and integration processes. Co-ordinates with business / data analysts on data cleansing and data profiling activities to improve quality of data.
• Works closely with DBA Team and Operations to establish ETL job workflow with reliable error / exception handling and rollback framework, including scheduling, error management, restartability, email notifications, and information publishing.
• Develops and maintains accurate system documentation including information about attributes, lineage, and business rules. Assists in the gathering of metadata and maintenance of repositories and data dictionaries.
• Helps set standards and complies with Bank and data governance policies, procedures, and regulations to ensure safe and sound business operations. Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding the security of financial data.
• Works with IT groups to implement a disaster recovery and business continuance solutions for ETL processes, including the installation, configuration, and testing of software.
• Participates in the development and maintenance of strategic, architectural, and tactical plans for the Bank's data integration technologies. Conversant with and cognizant of the future direction of systems, how that direction impacts the Bank, and how future and current systems can be exploited for the benefit of the Bank.
• Maintains understanding of data modeling and data integration technology trends and best practices and uses this knowledge to bring solutions to business units and IT; makes recommendations on buy vs. build decisions. Mentors Team members and is a technical resource on data integration and ETL technologies.
• Maintains understanding of information flows and the data integration technology to support the documentation of the all of the banks structured data flows.
• Provide production support for the banks integrated batch processing.
• Provides periodic reports on activities, accomplishments, issues and their solutions, as well as assisting in forecasts of future utilization, tools, and resource requirements.
• Ensures compliance with applicable policies, procedures and regulations to ensure safe and sound business operations.
• Prefer to be knowledgeable in Data Warehousing and Change Data Capture lifecycles and methodologies. Performs modeling of data sources and flows and works with Data Services staff to identify, design, and implement data warehouse objects – star schemas, multidimensional tables, and BI Universes – using best practices. Designs and develops prototypes, data classifications, and database tables and views to aggregate data as required for reporting optimization.

Required Experience :