Data Engineer (ETL Developer)

Company: Experis
Location: Austin
Posted on: February 21, 2021

Job Description:

Data Engineer (ETL Developer) Job Description:

• Position is for a developer to assist a data warehouse / business intelligence team with designing and developing ETL processes to enable interactive data dictionary and visualization. Experience:
  • Must have 5+ years of experience in Informatica and Data Warehousing
  • Well versed with ETL concepts and expertise on Informatica tool 8x and above
  • Very strong experience in PL/SQL, SQL Store procedures, Data analysis
  • Excellent Communication and Analytical Skills
  • Self-starter who can perform consultant role
  • Should be a good team player
  • Good knowledge of SDLC and well versed with ETL methodologies and best practices
  • Should be well versed with performance tuning guidelines
  • Informatica or Qlik Sense experience a plus Requirements:
    • Solid understanding of BI data warehousing concepts
    • Deep knowledge of the Informatica tool (Version 8 or above)
    • Strong knowledge of software implementation best practices
    • Strong experience designing and working with multi architectures
    • Ability to design and work with either Oracle or SQL Server database
    • Experience with other ETL tool or similar technologies
    • Ability to adapt quickly to an existing, complex environment
    • Should be a self-motivated, independent, detail oriented, responsible team-player
    • Passionate about building high-quality systems
    • Strong verbal and written communication skills
    • Strong analytical skills able to identify alternatives, presenting options, and making recommendations to meet the projects goals
    • Good Problem solving abilities Skills: Provide a migration plan and schedule for ETL migration activities; include sizing, frequency and complexity of business rules for data validation and transformation. Perform ETL requirements gathering and business analysis for each identified legacy file that will migrate to the new ETL platform Perform routine data processing operations in production environment to ensure high quality, accurate, and timely data for integration into DMDC enterprise applications and services. Provide operational sustainment of all ETL development initiatives; as well as the sustainment of the ETL platform and framework. Perform periodic operational tasks, no more than quarterly, required to maintain the proper level of performance and integrity of all systems. These tasks include the following: design and/or redesign of system framework; verification and validation; initial coding; revision; unit testing; debugging; and documentation for all system software. Document all ETL processes. At a minimum, the following documentation items shall be maintained for each data asset of each ETL process: a. Submission/Edit standard transformations and validation business rules b. Layouts c. Business Glossary entries d. Standard naming conventions e. Data lineage; mappings from authoritative data sources to downstream enterprise integrated processes f. Current Functional and Technical Points of Contact for data submissions g. Respond to and create data calls to support requests. - provided by Dice

Keywords: Experis, Austin , Data Engineer (ETL Developer), IT / Software / Systems , Austin, Texas