ETL Developer

$135,200 - $145,600/Yr

Innova Solutions USA - Plano, TX

Full-time - Mid Level

Plano, TX

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The ETL Developer role at Innova Solutions involves developing complex ETL workflows using Informatica Powercenter, creating data mappings from various data sources, and performing unit testing. The position requires strong technical and analytical skills, with a focus on performance tuning and SQL query optimization. The developer will work independently and coordinate with a distributed team, providing regular updates to management.

Responsibilities

• Develop complex ETL workflows using Informatica Powercenter.
• Create data mappings to ingest data from various sources including flat files, RDMS, Hive, and REST APIs.
• Develop Unix scripting for data processing tasks.
• Perform unit testing and develop test cases for ETL processes.
• Interact and coordinate with a distributed team effectively.
• Provide regular task status updates to management.

Requirements

• Strong technical skills in Informatica Powercenter.
• Proficiency in performance tuning of targets, sources, mappings, and SQL queries.
• Good conceptual understanding of PL/SQL, Functions, and writing complex SQLs.
• Strong skills in UNIX commands and scripting.
• Experience with MuleSoft integration tools.
• Expertise in PL/SQL programming and database design.

Nice-to-haves

• Experience with source control repositories like SVN/BitBucket.
• Familiarity with continuous build integration tools such as IBM UBuild/Jenkins and IBM UDeploy/Ansible.
• Knowledge of Python programming.
• Experience with Tableau or reporting tools.
• Previous experience in a data warehouse project.

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 and other types of paid leaves
• Employee Assistance Program (EAP)