ETL ANALYST DEVELOPER

JOB SUMMARY

Our client is looking for ETL Analyst Developers to join their team. This role is responsible for all phases of the development process, including analysis, design, construction, testing, implementation, and providing application support while working with ETL technologies and Big Data solutions.

JOB DESCRIPTION

• Consults with users, clients and other technology groups on issues and recommends advanced programming solutions.
• Accountable for all phases of development process, analysis, design, construction, testing and implementation.
• Provides user and operational support on applications to business users.
• Solves / works complex problems / projects through in-depth evaluation of business processes, system processes and industry standards; performs root cause analyses.
• Engages in post implementation analysis of business usage to ensure successful system design and functionality.
• Provides sound understanding of Big Data apps development concepts and principles and knowledge of concepts and principles in other technology areas.
• Provides evaluative judgment based on analysis of factual information in complicated and unique situations.
• Directly impacts the business by ensuring the quality of work provided by self and others. Impacts own team and closely related work teams. Exhibits sound and comprehensive communication and diplomacy skills to exchange complex information.
• Building/interpreting design documents.
• Building/interpreting mapping documents.
• Building/completing test documents.
• Participate in technical design & code reviews.
• Understand & adhere to ETL best practice.
• Develop & troubleshoot Informatica code.
• Convert SQL scripts from Teradata syntax to GaussDB (PostgreSQL) syntax.

JOB REQUIREMENTS

• Writes advanced SQL including some query tuning.
• Experience in the identification of data quality.
• Some database design experience is helpful.
• Experience designing and building complete ETL (moving and transforming data) in either of these technologies:
• SSIS, ODS
• ODI, Informatica
• Hadoop, Kafka
• Data warehousing
• Teradata
• Oracle
• PostgreSQL
• Utilize ad-hoc techniques to perform on-the-fly analysis of data.
• Proficient in how to deploy to and debug a production environment.
• Experience with real time and batch data ingestion frameworks.
• Prefer Data management or data modeling experience within Big Data (Hive/Impala/Hbase).
• Hands on Experience with open source software platforms Linux.
• Agile development processes experience a plus.
• Strong leadership, interpersonal, influence, negotiation, and written and verbal communication skills required.

GET IN TOUCH

Please apply online or send your CV to Talent@mcs-global.com For more details, feel free to reach out directly at : WhatsApp link: wa.me/6282137682541