Business Reporting
Afiniti
Islamabad, Pakistan
4d ago

Who are we?

Afiniti is the world’s leading applied artificial intelligence and advanced analytics provider. Afiniti Enterprise Behavioral Pairing™ uses artificial intelligence to identify subtle and valuable patterns of human interaction in order to pair individuals on the basis of behavior, leading to more successful interactions and measurable increases in enterprise profitability.

Afiniti operates throughout the world, and has measurably driven billions of dollars in incremental value for our clients. Purpose

The ETL / Data Engineer will be involved in the design, development, testing and deployment of ETL jobs built using Talend / SSIS / T-SQL and MySQL.

The developer should be able to process data from different source systems (Databases, Flat files, XML etc.) for Enterprise Data Warehouse.

Key Responsibilities

Consult with project teams and end users to identify ETL requirements.

Responsible for translating functional ETL requirements into a technical design document.

Building the ETL jobs and sequences to load data from source systems to Data Warehouse.

Responsible for maintaining change data history (SCD-II) for dimensional data.

Responsible for mapping multiple Microsoft SQL Server and MySQL source databases to centralized SQL Server target system(s) intended to supply business intelligence and general reporting systems.

Monitor, enhance and troubleshoot existing ETL processes.

Ensure audit trail / logging for all ETL processes have.

Automation and Innovation for data manipulation and information management.

Complete root cause analysis and contribute to remediation planning and implementation

Perform data quality analysis, report data quality issues and propose solutions for data quality management

The ideal candidate will have

Minimum 4 years of experience with Talend / SSIS packages and SQL development (T-SQL preferred).

Working knowledge of data warehousing concepts, structures and ETL best practices

Good understanding of business intelligence mechanism and tools.

Strong SQL writing abilities.

Expertise in advance MS Excel

Excellent verbal and written communication skills.

Education & Qualifications

Bachelors of Engineering / Sciences in Computers / Software

Report this job
checkmark

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

Apply
My Email
By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Continue
Application form