ETL Informatica Developer

Role: ETL Informatica Developer

Location: Charlotte, NC / Addison, TX ( 3days onsite 2 days remote)

The ideal consultant is a senior ETL Developer with 10+ years of experience in data warehousing and Big Data projects, preferably in financial or enterprise domains. 
Must have strong Informatica PowerCenter, Hadoop ecosystem, Oracle SQL, and Linux scripting skills with proven L3 production support experience.

Required Qualifications:

• 10+ years of overall ETL and data warehousing development experience.
• Solid experience with either Big Data (HDFS, Spark, Impala, Hive, etc.) and/or Informatica Power Center
• 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.

Description:

• 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.

General Skills:

• Leadership skills and the ability to take ownership of a project or work effort to see it through.
• Self-starter that tackles whatever is needed to complete assigned tasks.
• Clear communicator, both in written and oral forms.
• Attention to detail to ensure adherence to mandates, regulations, technical guidance, etc.
• An inquisitive mind with the desire to learn new skills, technologies and business processes.
• 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.
• Ability to work with front-line support team and other technology teams.
• 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.

Desired Qualifications:

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