Job Title: ETL Specialist – Data Transportation and Transformation
Job Description:
We are seeking a skilled ETL Specialist to join our team and play a pivotal role in the operations and continual development of our Enterprise Data Warehouse (EDW) and Business Intelligence (BI) environments. The ETL Specialist will be responsible for the design, development, and maintenance of ETL technologies that transport and transform data, ensuring seamless integration and optimal performance. The ideal candidate will bring a demonstrated proficiency in Online Analytical Processing (OLAP) tools and a strong aptitude for data manipulation and transformation.
Responsibilities:
– Serve as the ETL specialist for the current operations and ongoing development of the EDW/BI environments.
– Develop ETL technologies for data transportation and transformation, implementing source-to-target mappings and ensuring efficient performance and tuning.
– Provide operational production support for data transportation and transformation processes, addressing issues and ensuring data integrity.
– Implement enhancements for performance tuning, automation, and maintenance of ETL processes to optimize efficiency and reliability.
– Develop data mappings in alignment with logical and physical data models to ensure accurate data flow.
– Utilize Online Analytical Processing (OLAP) tools to map data from business systems and identify source-to-target mappings.
– Design, develop, and maintain ETL workflows, ensuring seamless data integration across systems.
– Collaborate with cross-functional teams to gather requirements and translate them into effective ETL solutions.
– Resolve remedy tickets by efficiently opening, updating, and closing tickets as required.
– Stay updated on industry best practices and emerging trends in ETL technologies and data transformation.
Qualifications:
– Bachelor’s degree in Computer Science, Information Technology, or a related field preferred.
– Demonstrated competency in OLAP tools and a strong understanding of data manipulation and transformation.
– Proven experience in ETL development, data transportation, and transformation processes.
– Proficiency in implementing performance tuning, automation, and maintenance enhancements for ETL processes.
– Strong analytical skills to develop accurate data mappings in alignment with logical and physical data models.
– Experience in designing, developing, and maintaining ETL workflows to ensure smooth data integration.
– Effective problem-solving skills to address operational production support issues.
– Excellent communication skills and the ability to collaborate with cross-functional teams.
– Required certifications: Security+ and National Agency Check Legal and Credit (NACLC) or Secret Clearance
To apply for this job email your details to DECA-Jobs@caelum.com