Tagcor

SQL

Responsibilities:

ETL Development: Design, develop, and maintain ETL processes using Ab Initio for data integration and data warehousing.

Data Transformation: Create transformations to cleanse, enrich, and transform data as per business requirements.

Data Quality: Ensure data quality and accuracy by implementing data validation and cleansing processes.

Performance Optimization: Tune ETL processes to improve performance and efficiency.

Integration: Collaborate with cross-functional teams to integrate ETL solutions with other systems and applications.

Documentation: Maintain clear and up-to-date documentation for ETL processes and data mappings.

Testing: Perform unit testing and participate in integration testing to ensure the reliability of ETL processes.

Troubleshooting: Investigate and resolve ETL-related issues, including data discrepancies and performance bottlenecks.

Monitoring: Implement monitoring solutions to proactively identify and address any issues in ETL jobs.

Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).

Required Skills:

Ab Initio: Proficiency in Ab Initio software, including GDE (Graphical Development Environment) and Co>Operating System.

ETL Expertise: Strong knowledge of ETL concepts and best practices.

Data Warehousing: Familiarity with data warehousing concepts and methodologies.

SQL: Proficiency in SQL for data manipulation and query.

Scripting: Experience with Unix/Linux scripting is a plus.

Problem-Solving: Strong problem-solving and analytical skills.

Familiarity with Big Data technologies (e.g., Hadoop) and GCP

Certification in Ab Initio is a plus.