ETL Developer

24 Mar 2024

Vacancy expired!

Our client, an energy services holding company, is seeking an ETL Developer

Location:Tri-State

Position Type: IT Contract

Job Summary:

The Data Conversion Developer is responsible to design, develop, maintain, monitor, and execute ETL processes using Informatica Cloud services (IICS) and SQL Servers. The Data Conversion Developer is responsible for the identification of new and existing data objects, perform data analysis, design, extract, transformation and loading of data between legacy systems and other existing/new ERP systems. The Data Conversion Developer will conduct activities including interviews, reviewing, developing documentation to identify all source and target data mapping in scope for the NEXT program.

The Data Conversion Developer will analyze existing data for completeness, accuracy, consistency, and integrity to identify all requirements for data creation and quality improvement. The Data Conversion Developer will work closely with the requirements and design teams to identify future state data model and all data requirements including validation rules/domains, referential integrity, mandatory data, systems of record, and data maintenance and synchronization requirements.

The Data Conversion Developer will perform mapping of data between source and target systems and record all attribute level business requirements. They will then identify all data creation, quality improvement and transformation requirements.

The Data Conversion Developer will work closely with the Data Conversion Lead to create a Conversion Approach and Plan for all data creation and transformation activities. They will design and build Extract, Transformation and Loading (ETL) solutions using a combination of SQL and other platforms including Informatica, Azure and others to extract data from source systems, create, improve, and transform data according to busines and technical requirements and load data into target systems.

The Data Conversion Developer will ensure that ETL solutions meet business, technical and performance requirements to meet business and project schedule requirements to meet cutover timing requirements for high volume data loads.

The Data Conversion Developer will work with the Data Conversion Lead and Testing teams to develop test cases, test scripts and solutions to test and validate the results of the ETL processes and solutions to ensure that all business, technical and performance requirements are met.

The Data Conversion Developer will work with Testing and other teams to resolve issues identified during all testing activities - functional, technical and performance.

The Data Conversion Developer will work with the Data Conversion Lead to define a data conversion infrastructure architecture, approach and design for example Conversion Development, Test, Gold and other environments as well as define a data governance process to promote data between those environments.

Job Responsibilities:

  • Create inventory of source and target systems
  • Create attribute level mappings with requirements between source and target systems
  • Analyze current data quality to identify data creation and quality improvement requirements
  • Assist Data Conversion Lead to create Conversion Approach and Plan
  • Design, develop, maintain, monitor, and build Extract, Transformation and Loading (ETL) solutions using SQL and Informatica Cloud services (IICS)
  • Investigate production ETL issues / problems
  • Ensure that ETL solutions meet business, technical and performance requirements to meet business and project schedule requirements
  • Work with the Data Conversion Lead and Testing teams to develop test cases, test scripts and solutions to test and validate the results of the ETL processes and solutions to ensure that all business, technical and performance requirements are met.
  • Work with the Testing and other teams to resolve issues identified during all testing activities
  • Work with the Data Conversion Lead to define a data conversion infrastructure architecture, approach, and design
  • Work with the Data Conversion Lead to define a data governance process to promote data between environments

Qualifications:

  • Bachelor's degree in Computer Science or related discipline or the equivalent work experience and technical training
  • Technical proficiency in the following SQL Server, T-SQL, Informatica IICS
  • Experience working with IICS Administration, Monitoring, Mapping configuration and deployments
  • Experience working with IICS Connections, API Integrations, Schedules, and Automation
  • Experience working with creating, validating, and moving files using IICS
  • Experienced in effectively interacting and communicating with IS partners
  • Can consolidate requirements and translate them into IS deliverables
  • Act as a subject matter expert and resource for others on assigned ETL processes
  • Knowledge of functions, features and facilities of applicable programming languages
  • Minimum of 5 years' experience in either of the following: IT experience in business systems analysis in a large-scale environment across multiple hardware and software platforms, or business unit.

  • ID: #49530937
  • State: New Jersey Wall 07719 Wall USA
  • City: Wall
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2023-03-24
  • Deadline: 2023-05-22
  • Category: Et cetera