This page is optimized for mobile devices, if you would prefer the desktop version just click here

ETL Developer

Company: Qual IT Resources

Location: US - Ohio - Cincinnati

Category:

Posted: July 3, 2024

ETL Developer

As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help automate data extraction from source systems and transform unstructured and disparate source data into target data stores or data marts.

General Responsibilities:

Uses different data warehousing concepts to build a data warehouse for internal departments of the organization

Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing, and analyzing large sets of data

the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts
and support stored procedures, understand and code in open SQL language in SQL and HANA cloud foundry (BAS) environments
smart data Integration (SDI) objects between multiple source systems which helps in transformation, extraction and loading into target database
logical and physical data flow models for ETL

Monitor, create and troubleshoot SAP job failures, through SAP HANA and SAC cockpit for high performance system availability (i.e. Alerts, services, disk space usage, memory usage, CPU usage, stored procedures for QA/DEV/PRD)

complex data analysis/validation to ensure the accuracy and integrity of data
and research data anomalies and recommend/implement corrective actions
performance optimization and tuning on new and/or existing data warehouse and/or ETL operations
in ongoing architecture quality review activities to ensure both current and future capability meets architecture standards
and maintain of documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting
accurate and detailed requirement specifications documents, workflow analysis, user guides, and functional specification documents
storage needs for reporting databases and data warehouse

Experience and Education Requirements:

Bachelors degree in computer science or related field preferred

3+ years related experience as a ETL Developer/Data Analyst or similar position

3+ years related experience with data modeling with Cloud concepts (Snowflake, HANA calculation views)

Experience working with SAP HANA cloud foundry is a plus

Experience with SAP Analytics Cloud a plus

Strong understanding of SQL Server Integration Services (SSIS) (or similar tools) for ETL

Proficient in MS SQL Server (or similar relational databases like Oracle and PostgreSQL)

Experience in database design and management.

Non-Technical Requirements:

Excellent analytical and problem-solving skills

Strong planning and organizational skills

Ability to clearly articulate pros and cons of various technologies and platforms

Outstanding interpersonal, verbal, and written communication skills

Ability to perform detailed analysis of business problems and technical environments and use this in designing the solution

Exhibit patience with other associates

Ability to estimate the financial impact of individual solution architecture alternatives

Ability to provide accurate estimates for tasks and project activity

Possess personal drive and initiative regarding career growth

Ability to work independently, prioritize own tasks, and tasks of others

Able to multi-task in fast paced environment and manage time effectively

Passion for customer service, efficiency, effectiveness, precision, and quality

Good team player, and willingness to assist others, and share expertise

Able to work flexible hours; expected to work nights and weekends as needed

Ability to travel between offices, as required

Read the full job description and apply online on the recuiter's web-site

Get Jobilize Job Search Mobile App Now

Receive real-time job alerts and never miss the right job again

Related Job Postings

Local CDL-A Driver - Home Daily / 2 Days off a week $70K / Yr

Company: US Xpress

Location: United States - OH - OH - Bradford

Posted: June 28, 2024

Local Home Daily CDL-A Truck Drivers / 2 Days off per week! • Average $70k annual salary! • BENEFITS: • Great Pay - $70k annual salary, , Home Daily, Load and Unload Pay, Paid vacation after 1 year, Paid Orientation, Newer Trucks! , 1,250 watt inverter in every U.S. • Xpress read more...

View Job Details