ETL developer

Innova Solutions USA • Kennesaw, GA

210d

About The Position

A client of Innova Solutions is immediately hiring for an ETL Developer. As an ETL developer to support production and project work in the GTS Data space, the individual will be responsible for understanding the requirements, design and functionality of the jobs and propose strategic solutions and innovative tactical work-around solutions as needed. The candidate should be able to lead projects and guide others, work somewhat flexible hours when needed, such as working approximately one weekend per month. May get comp-off time during weekdays when exceeding normal work hours. This position requires a good analytical mind, problem solving ability, clear communication skills, a drive to learn new technologies and an ability to work with multiple others across variable teams.

Requirements

• 10+ years of overall ETL and data warehousing development experience.
• Solid experience with either Informatica Power Center and/or Big Data (HDFS, Spark, Impala, Hive, etc.)
• Oracle database experience with ability to write and understand SQL.
• Working knowledge of Linux basics, including the ability to write and understand basic shell scripts.
• Troubleshooting and data analysis skills and the drive to determine the root cause of an issue.
• Experience with data movement and transformation technologies.

Nice To Haves

• Skala development.
• Python, shell scripting or other programming language development.
• AutoSys job scheduling experience.

Responsibilities

• L3 Production Support (approximately 25% of the time)
• Ability to analyze issue to determine root cause and propose solutions.
• Focus on issues to provide work-around solutions, when needed.
• Clear communication of the issue, its root cause and proposed solutions.
• Lead Developer (approximately 75% of the time)
• Must be a proactive self-starter that looks to take up new work.
• Ability to do requirements analysis, followed by designing and implementing a solution.
• ETL skills to implement solutions using Informatica, Hadoop, PL/SQL, Linux scripting, etc.
• Identify gaps and propose improvements to processes and tools.
• Work within the team and other teams to get the work done.

Benefits

• Medical & pharmacy coverage
• Dental/vision insurance
• 401(k)
• Health saving account (HSA)
• Flexible spending account (FSA)
• Life Insurance
• Pet Insurance
• Short term and Long term Disability
• Accident & Critical illness coverage
• Pre-paid legal & ID theft protection
• Sick time
• Other types of paid leaves (as required by law)
• Employee Assistance Program (EAP)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Industry: Professional, Scientific, and Technical Services