Data Analyst (ETL Tools)

Alpha Analytics Services Pvt. Ltd.; Washington (District of Columbia); On-site; USD 80,000 - 120,000; Full time

Job summary

Alpha Analytics Services Pvt. Ltd. in Washington, DC is seeking an ETL developer to design, test, and implement data integration solutions for consulting projects. You will build and optimize ETL jobs, validate data quality, and support deployment across environments.

The role requires 2–4 years of hands-on experience with Pentaho, Talend Open Studio or Informatica, strong SQL skills, and a technical degree. Freshers with solid knowledge may also apply.

Qualifications

• 2-4 years of experience with data integration or ETL tools.
• Strong SQL skills including stored procedures, triggers and functions.
• Technical graduate preferred; freshers with knowledge may apply.

Responsibilities

• Import, cleanse, transform, validate, and analyze data for data modeling and integration.
• Create ETL jobs for dimension and fact tables and work with data warehousing concepts.
• Analyze data from databases and flat files; develop, deploy, optimize ETL processes and resolve defects.
• Develop error handling processes and implement scheduling strategy.

Skills

SQL

Data analysis

Data integration

Education

Technical degree

Tools

Pentaho (Kettle)

Talend Open Studio

Informatica

Job description

Job Summary

The ETL developer is responsible for the development, unit testing and implementation of data integration solutions for Consulting/clients.

Project Description

The ETL developer is responsible for the development, unit testing and implementation of data integration solutions for Consulting/clients.

Responsibilities And Duties

• Responsible for importing, cleansing, transforming, validating and analyzing data with the purpose of understanding or making conclusions from the data for data modeling, data integration and decision making purposes.
• He should perform his daily tasks and should have exposure to the data model and concepts of Data warehouse to create ETL jobs for dimension and fact tables.
• Analyzes data from various sources, including databases and flat files ETL development, deployment, optimization, support, and defect fixes.
• Develop error handling processes Create and implement scheduling strategy.

Key Skills

Talend, Informatica, ETL, ETLTools, Pune, Punejobs, Data analyst, Data Analysis

Required Experience And Qualifications

• 2-4 years of experience with Pentaho (Kettle),Talend Open Studio or Informatica.
• Good knowledge of SQL, including the ability to write stored procedures, triggers, functions, etc.
• A Technical graduate will be preferred.
• Fresher with excellent knowledge and skills of the above technologies can also apply.

Job Type: Full-time