Data Engineer/ ETL Developer

FedEx; Honolulu (HI); On-site; USD 69,640 - 94,221; Full time

Job summary

FedEx is seeking a data engineer to create and optimize data solutions, enabling seamless data delivery and analysis across multiple business domains. You will collaborate with various departments to load data tables per business requirements and ensure data is managed across development, QA and production environments.

The role involves designing data warehousing concepts (star/snowflake schemas) and developing scalable ETL processes using Informatica to support BI reporting and data-driven

Qualifications

• Bachelor's degree in computer science, computer information systems, information technology, or equivalent experience.

Responsibilities

• Create and enhance data solutions enabling delivery of data and analysis across domains.
• Collaborate with departments to load data tables per business requirements.
• Manage data in development, QA and production environments to ensure seamless delivery to customers.
• Design data warehousing concepts and star/snowflake schemas for internal departments.
• Develop scalable, secure ETL processes for stakeholder needs.
• Build ETL jobs using Informatica to extract, transform, and load data into the warehouse.
• Create data architectures to support BI efforts and dynamic reporting.

Skills

ETL

Informatica

Data Warehousing

SQL

Education

Bachelor's degree in Computer Science/Information Systems

Tools

Data pipelines

Job description

Job Information

Location: Chicago, Illinois 60604

Duration: 3 Years

Work Schedule: Full Time, 40 Hours/Week

Salary: $81,931.00/Annum + Company Standard Benefits

Job Duties

• Create and enhance datasolutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data across different domains for analysis.
• Works with various departments in collecting requirements and creates tables to load data based on business requirements.
• Manages data in Development, QA and PRODUCTION environments ensuring seamless delivery to the customers.
• Use different Data warehousing concepts to build a Data warehouse for internal departments of the organization.
• Applies Data warehousing concepts such as star and snowflake schema approach while creating tables and maintaining data to ensure data integrity.
• Designs and develops data pipelines, data ingestion and ETL processes that are scalable, repeatable and secure for stakeholder needs.
• Designs ETL Processes using Informatica tool to extract data from heterogeneous sources and transforms data using complex logic as per business needs and ingests it into our warehouse.
• Build Data architecture to support data management strategies to support business intelligence efforts for various stakeholders.
• Ensures data stored in the warehouse can be used to create dynamic Business Intelligence reports for complex analysis helping in making business driven decisions.
• Leads the design of the logical datamodel and implements the physical database structure and constructs and implements operational data stores and data.
• Manages access to confidential data by creating database views and data marts for customers and ensures confidential data is shared using company policies.
• Support deployed dataapplications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution Data Pipeline Management.
• Works with other team members in analyzing the data and advises on how to improve data quality and provide cleaner solutions to business stakeholders.
• Develops real-time and batch ETL dataprocesses aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.
• Builds complex ETL process using Informatica to transform the data as per business needs and automated the process capturing real time data and maintaining history for complex analysis.
• Documents data flow diagrams, security access, data quality and data availability across all business systems.
• Documents all processes of every project using JIRA for reference by any other member on the team and ensures it is always secure.

Minimum Education Requirements

This position requires minimum of bachelor’s degree in computer science, computer information systems, information technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.