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

ETL Developer in Salt Lake City, UT at ConsultNet

Date Posted: 3/7/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    3/7/2019
  • Job ID:
    19-00524

Job Description

Job Responsibilities:
• Participate in the development and support of an enterprise wide data transformation and movement architecture and platform.
• Design, develop and test ETL applications consistent with application architecture guidelines.
• Design error-processing routines.
• Create/manage batch processes.
• Access disparate data sources (databases, hardware devices, VSAM and flat files) and apply internal and external business rules, policies and data quality measures.
• Insure the data is safely and securely transferred to target destinations.
• Gather mapping and reporting requirements and coordinate all data movement activities.
• Analyze business requirements as they relate to the ETL process, research, evaluate and recommend alternative solutions.
• Transform business requirements into technical requirement documents.
• Analyze, develop, install, test, upgrade, maintain and support complex data/process models, and processes in an ETL environment.
• Provide project estimates, plans, and schedules.
• Work productively in a team environment.
• Communicate effectively with business and IT staff across functional departments.
• Work with management and staff to establish best practice standards for ETL functions.
• Lead development of new methodologies for supporting data transformations and processing in a corporate-wide ETL solution.
• Provide after business hours support for production ETL systems.
• Maintain an in-depth knowledge of current and emerging technologies and standards and provide technical direction to management and users.
• Provide technical direction to other team members including contractors and employees. Qualifications
Bachelor's degree in Computer Science or equivalent degree.
• 8+ years of total IT experience.
• 5+ years of experience with the IBM InfoSphere Information Server ETL tool in a data warehouse environment is a must. Experience with both Server and Enterprise editions preferred.
• Experience with UNIX scripting, SQL, DMExpress, FilePort also strongly preferred.
• Experience with QualityStage, Information Analyzer, and Change Data Delivery (CDD) will get top priority in considerations.
• Experience with IBM's MDM software is a definite plus.
• Knowledge of Extraction, Transformation, and Loading (ETL) disciplines.
• Knowledge of database loading methods.
• Knowledge of data warehousing methodologies.
• Knowledge of Greenplum database platforms.
• Knowledge of mainframe file structures, namely copybooks is a plus.
• Knowledge of AIX UNIX systems and tools.
• Knowledge of all phases of the system development life cycle.
• Strong problem resolution skills.
• Strong testing and debugging skills.
• Strong communication and interpersonal skills.
• Demonstrated ability to take ownership & responsibility for development and maintenance projects.
• Sound understanding of banking/financial industry processes is a plus.
Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at www.consultnet.com