This site uses cookies. To find out more, see our Cookies Policy

ETL Developer in Dallas, TX at Integrated Resources, Inc

Date Posted: 12/7/2018

Job Snapshot

Job Description

ETL Developer
The ETL Developer provides application, data management, and reporting support. He/she ensures the successful transmission of data from both internal and external systems, validation of the received data, and accurate processing of the data into the target systems. He/she establishes controls to ensure the validity of the data, and develops processes to automate these tasks; builds databases, develops reports, and creates the underlying processes to extract, transform, and load the data as needed to deliver the required information. He/she works with data in varying formats, including Teradata and RDBMS. This position demands strong knowledge of Teradata, Ab Initio for data analysis, package design/execution/management, generation of reports, and ad hoc queries.
The ETL Developer not only meets all functional and technical requirements, but someone who truly embodies all of the most important elements of a successful leader; tenacity, resiliency, flexibility, compassion, and professionalism.
  • Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity
  • Strong Knowledge of Teradata, Informatica, Unix Shell scripting, Ab Initio, Sub Version version control Tools.
    Strong data warehouse applications knowledge.
  • Extracts, transforms and loads (ETL) data into staging, data marts, and warehouse from multiple disparate systems for both relational and dimensional data structures.
  • Knowledge of ErWin modeling, Big Data (HDFS), Data Analytical languages R, Python would be a big plus.
  • Coordinates complex client area requirements and processes (e.g., new, enhancements or maintenance), prepares application system specifications, and develops tests and implements efficient, cost effective application solutions.
    • Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of high technical complexity.
    • Works with client management to identify and specify extremely complex business requirements and processes for diverse development platforms, computing environments (e.g., host based, distributed systems, client server), software, hardware, technologies and tools, etc.
    • Researches and evaluates alternative solutions and recommends the most efficient and cost effective solution for the systems design.
    • Formulates logical statements of business problems and devises, tests and implements efficient, cost effective application program solutions (e.g., codes and/or reuses existing code through the use of program development software alternatives and/or integrates purchased solutions).
    • May have supervisory responsibility in instructing, assigning, directing and checking the work of the resources within their section/department.
    • Prepares charts, tables and diagrams to assist in analyzing problems, utilizing various business, scientific, engineering and mathematical techniques. Analyzes existing system and programming logic to provide more efficient machine operations or to identify difficulties, and revises the logic and procedures involved as necessary.

Qualifications
• 7+ years ETL experience
• Strong Knowledge of Abinitio, Teradata, Informatica, Unix Shell scripting, Sub Version version control Tools.
• Strong data warehouse applications knowledge.