ETL Developer

TechDigital Group; Atlanta (GA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading digital technology firm in Atlanta is looking for an ETL Developer experienced in Informatica DEI/BDM. The role includes designing ETL processes, providing testing support, and performance tuning. Candidates should have strong skills in Unix, SQL, and knowledge of CI/CD practices. Familiarity with Talend and Snowflake is a plus.

Qualifications

• Strong knowledge of ETL processes and Informatica DEI/BDM.
• Ability to perform independent testing and support production issues.
• Experience with performance tuning in ETL environments.

Responsibilities

• Assist in design deliverables and ETL development.
• Support defect triage and resolution across testing phases.
• Create deployment plans and coordinate with production support.

Skills

Informatica DEI (BDM)

Hive

Unix

SQL

GitLab

CICD

Communication skills

Onshore-offshore model experience

Job description

Required skills: Informatica DEI (BDM)

Nice to have skills: Talend + Snowflake or Ab Initio

Resource should have the following technical skill set.

• Understand the design, work with designer and architect, and based on that plan the ETL development using Informatica DEI/BDM toolset.
• Assist in completing the design deliverables.
• Perform ETL development using Informatica DEI/BDM and create the code base, complete the unit testing and capture unit test results.
• At times should be able to perform independent testing.
• Provide the testing support for defect triage and resolution across the SIT, UAT phases.
• Create the production deployment plan, scheduling sheets and get change approval from required stake holders.
• Support production deployment and co -ordinate with production support and infrastructure teams.
• Provide warranty support and investigate production ETL issues and fix them.
• Implement performance tuning using Informatica DEI/BDM toolset.
• Should have strong knowledge on Hive
• Should have strong Unix and SQL knowledge
• Should have gitlab , CICD knowledge
• Should have good communication skill
• Should be able to work in onshore offshore model
• It will be an additional advantage if candidate has exposure to Talend + Snowflake or Ab Initio