ETL Developer Informatica BDM

Cloud Hybrid Technologies LLC; Atlanta (GA); On-site; USD 120,000 - 150,000; Full time

Job summary

Cloud Hybrid Technologies LLC is seeking a skilled ETL Developer to design and implement robust ETL pipelines using Informatica DEI/BDM. You will collaborate with designers and architects, translate designs into code, and perform unit testing. The role includes production deployment planning, defect triage, and support across SIT/UAT and production environments.

Strong knowledge of Hive, Unix, SQL, and CI/CD processes is essential. Prior exposure to Talend and Snowflake is a plus.

Qualifications

• 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

Responsibilities

• Design and implement ETL solutions based on architectural guidance.
• Collaborate with designers and architects to translate designs into working ETL components.
• Lead unit and integration testing for ETL components and track results.
• Coordinate SIT/UAT testing support and defect triage with cross-functional teams.
• Create and maintain deployment and change management artifacts for production releases.
• Assist in production support and troubleshooting of ETL issues.
• Provide guidance on performance tuning and optimization for ETL jobs.
• Share knowledge of Hive, Unix, SQL, and CI/CD tools with the team.

Skills

Informatica DEI/BDM

ETL development

Hive

Unix

SQL

Communication

Onshore/offshore collaboration

Talend

Snowflake

Tools

GitLab

CI/CD

Job description

• 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

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract