ETL Data Integration Specialist in Kansas City, MO at GDH

Date Posted: 2/15/2018

Job Snapshot

  • Employee Type:
    Full-Time
  • Job Type:
    Other
  • Experience:
    At least 8 year(s)
  • Date Posted:
    2/15/2018
  • Job ID:
    29043

Job Description

.bd_title { font-weight: bold; } The ETL Data Integration Specialist will be responsible for working closely with the Data Architects, Data Analyst’s and Power BI Development teams to produce ETL solutions in support of data warehousing and data management that follow industry best practices and company standards. The ETL Specialist will have strong programming and analytical skills with the ability to review, analyze and understand business requirements and internal database source and target state architecture. The role will cover full systems development life cycle (SDLC) phases including requirements analysis, system design, development, coding, testing, debugging, implementation, and post-implementation support _____________________________________________________________________________________ Knowledge & Skills:
Collaborate with business/data analysts, data architects, developers, database administrators to create conceptual, logical, and physical data models for Business Intelligence reporting databases. Review Business Requirements to identify ETL requirements and design Informatica/SSIS based customized solutions that support the creation of databases, table spaces, tables, indexes, triggers, procedures, and other database objects. Support the design, development, and implementation of data architecture for historical reporting and analysis. Defines the content and structure of the database (schema) and advises users on efficient techniques for extracting data. Optimize and automate data transfers between internal source databases using Informatca and Azure Cloud platform. Advanced knowledge of Integration development requiring complex transformation rules using SSIS/SSAS packages. Advises development team on design factors that impact storage capacity, processing speed, and input/output requirements. Develop and apply advanced research techniques in the investigation and resolution of highly complex compatibility and interface design considerations. Creative problem-solving skills with the ability to manage multiple projects in a fast paced environment. Factors emerging technologies and product supportability into design and implementation. Implement changes and provide post-implementation user support and system support. Demonstrate solid organizational and time management skills with ability to perform detailed tasks with high degree of accuracy and work and perform under pressure. Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure. ____________________________________________________________________________________ Requirements
: Bachelor's Degree in Engineering, Computer Science, Information Systems or related field with programming coursework or equivalent database development experience. 8+ years of experience in IT Industry involving Analysis, Design, ETL Integration and Development, Issue resolution, Maintenance, Production Implementation and Testing. 5+ years hands on experience in an SSIS/SSAS ETL developer/admin role with exposure to interfacing with DB2 SalesForce, SAP, SQL Server and Flat Files. Must have knowledge of standard operating procedures to deploy SSIS packages into Production. 3+ years of experience in the following; Informatica Power Center 9.x, Informatica Data Quality 9.x, Informatica Developer Client, Informatica Analyst tool 9.x, Informatica Power Exchange. (Knowledge of Informatica Cloud Services and Informatica Admin experience a plus). High level of proficiency with designing and developing SSIS packaged solutions using complex transformations rules involving SCD1, SCD2, Aggregator, Data Conversion, Conditional Split, DQS cleansing, cache transformation Lookup, Derived columns, Script component transformation etc. Experience working within the railroad industry and familiar with KPI’s supporting business and/or operations. (Preferable) Experience with Erwin data modeler, TFS, SSAS, SSRS, MSSQL and Visual Studio, ideal, but not required. Strong Data Modeling experience in ODS, Dimensional Data Modeling Methodologies likes Star Schema, and Snowflake Schema. Experience with data warehouse tasks supporting requirements management, architecture design, analysis, mapping, integrity checking, impact analysis and regression testing. Excellent analytical and problem-solving skills, with a demonstrated ability to identify and resolve ETL related root cause errors. Strong oral and written communication skills a must