Data Engineer - Informatica Cloud

Job Summary

The Data Engineer II will be an integral member of the Reliance IT Data Integration team and will be expected to clean, prepare, and optimize data for consumption. The Data Engineer-II will work with the team to create high end data and analytics driven ETL solutions leveraging Informatica Data Management Cloud (IDMC), Amazon Web Services (AWS), Big Data tools and technologies. The Data Engineer II will collect and curate data from disparate sources to perform data interrogation, develop analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics. The Data Engineer II will communicate with stakeholders and conduct research to develop a comprehensive understanding of relevant business needs and requirements. In this role, the individual will identify and collect structured and unstructured data from various sources, evaluate the data to ensure that they meet analytic needs, and prepare the data for analysis. The role will require business and technical requirements gathering and documentation (BRD, PRD) experience, as well as data workflow design and presentations

Physical Requirements

Stand or Sit(Stationary position), Walk(Move, Traverse), Use hand / fingers to handle or feel (Operate, Activate, Use, Prepare, Inspect, Place, Detect, Position), Talk / hear(Communicate, Detect, Converse with, Discern, Convey, Express oneself, Exchange information), See (Detect, Determine, Perceive, Identify, Recognize, Judge, Observe, Inspect, Estimate, Assess), Reaching, Repetitive Motion

Function in the Job

Sedentary Work- Exerting up to 10 pounds of force occasionally, and / or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Job Function

Technical Design- Able to identify, analyze, specify, design, and translate functional design to technical design. Create and document technical designs for medium to high complexity solutions that may include integration with external systems.

• Create and document technical designs for medium to high complexity solutions that may include integrations with external systems.
• Facilitates peer technical design review.
• Design systems that span multiple technologies / platforms
• Define and documents work processes / standards.
• Create and apply design standards across all applications.
• Design solutions to meet performance requirements and scalability expectations.
• Conduct data analysis and modeling to design medium to complex systems utilizing multiple technologies (may have a specific area of expertise), including integrations with external systems.
• Collect and curate data from disparate sources to perform data wrangling to clean, prepare, and standardize data for consumption.
• Design and create framework, program controls and services that can be utilized by other developers in creation of applications.
• Apply mathematical principles or statistical approaches to solve complex problems in scientific or applied fields.

Data Modeling - Able to write, test, debug, and maintain data workflows for end-user adoption, productivity improvement and efficiency.

Requirements Elicitation - Ability to identify a desired future state that addresses a business problem.

Requirements Management and Analysis - Ability to define, document, and manage business requirements to the smallest set that will provide the biggest impact in advancing business objectives.

Provide Accurate Project Effort Estimates - Ability to quantify and meet individual and project phase level efforts.

Adherence to Standards - Ability to create solutions that adhere to and incorporate RTS standards.

Required Skills

Compensation Range

The anticipated compensation for this position is USD $106,000.00 / Yr. - USD $146,000.00 / Yr. depending on experience, qualifications, and location.