Big Data Engineer - 5.8 Alpharetta, Ga (Remote Till Covid)

We are looking for a Big Data Engineer for our long-term multiyear project out of Alpharetta, GA. (Remote till COVID).
Responsibilities: 5-10 years of hands on experience working with Hadoop and Informatica power center.
Experience in Hadoop ecosystem and experience in applying them to practical problems in Hive, Impala and Spark.
Strong knowledge of working with relational databases like Teradata DB2 Oracle Sql server.
Hands on experience in writing shell scripts on UNIX platform.
Experience in data warehousing ETL tools MPP database systems.
Understanding of Data Models Conceptual Logical and Physical Dimensional Relational Data Model Design.
Analyze functional specifications and assist in designing potential technical solutions Identifies data sources and works with source system team and data analyst to define data extraction methodologies.
Good knowledge in writing complex queries in Teradata DB2 Oracle PL SQL.
Maintain batch processing jobs and respond to critical production issues communicate well with stakeholders on his her proposal recommendations.
Knowledge status risks regarding delivering solution on time.
Strong experience with Data Analysis Data Profiling Root Cause Analysis.
Should able to understand Banking system processes and data flow.
Can work independently lead and mentor the team.