ETL Data Analyst

Who we are

Artmac Soft is a technology consulting and serviceoriented IT company dedicated to providing innovative technology solutions and services to Customers.

Job Description:

Job Title : ETL Data Analyst

Job Type : C2C/1099

Experience : 810 Years

Location : Sun Jose California

We are looking for an ETL Data Analyst who will be responsible for designing developing and maintaining ETL processes to support data integration and business intelligence initiatives. The ideal candidate will have a strong background in data analysis database management and ETL (Extract Transform Load) tools.

Responsibilities:

• Experience in Data Analysis ETL deployment and Data warehouse Support using Informatica Power Center Teradata Oracle and Unix.
• Experience with data modeling and database design.
• Experience in Finance Data Analysis (Booking Revenue) is a must for Control M (Scheduling) to be advantageous.
• Strong SQL development and Teradata database knowledge.
• Excellent analytical and logical thinking skills are necessary to provide hopeful ideas as well as a good grasp of GIT (version control).
• Knowledge of data warehousing concepts and best practices.
• Familiarity with big data technologies (e.g. Hadoop Spark) is a plus.
• Design develop and maintain ETL processes to extract transform and load data from various source systems into the data warehouse.
• Perform data profiling cleansing and validation to ensure highquality data is available for analysis.
• Monitor and troubleshoot ETL processes to identify and resolve issues promptly.
• Optimize ETL processes for performance and scalability.
• Create and maintain documentation related to ETL processes data mappings and dataflow diagrams.
• Develop and implement data quality checks and validations to ensure data accuracy.
• Exceptional communication skills to drive the customer and stakeholders representing the team.
• Monitor data workflows to ensure timely and accurate data integration.
• Troubleshoot and resolve data integration issues.

Qualification:

• Bachelors degree or equivalent combination of education and experience