ETL Developer Informatica BDM

Valiant Technologies LLC; Atlanta (GA); On-site; USD 90,000 - 130,000; Full time

Job summary

VALIANT TECHNOLOGIES LLC in Atlanta, GA seeks an ETL specialist to design and implement data pipelines using Informatica DEI/BDM. You will collaborate with designers and architects to plan development, build the codebase, and conduct unit testing, while supporting SIT/UAT defect triage.

Candidate should have strong Hive, Unix, and SQL skills, plus GitLab CI/CD experience and a willingness to operate in an onshore/offshore model. Bonus for Talend/Snowflake or Ab Initio exposure.

Qualifications

• Experience with ETL design using Informatica DEI/BDM.
• Plan ETL development based on design deliverables.
• Create code, perform unit testing, and capture results.
• Support SIT/UAT defect triage and resolution.
• Create deployment plans and obtain change approvals.
• Support production deployment with infra teams.
• Warranty support for production ETL issues.
• Performance tuning with Informatica DEI/BDM.
• Strong knowledge of Hive, Unix, and SQL.
• GitLab CI/CD knowledge and collaboration in onshore/offshore model.
• Exposure to Talend, Snowflake or Ab Initio is a plus.

Responsibilities

• Understand the design, collaborate with designer and architect, and plan ETL development.
• Develop ETL artifacts using Informatica DEI/BDM and build the code base.
• Execute unit tests and document results; perform independent testing as needed.
• Provide testing support for SIT/UAT defect triage and resolution.
• Create production deployment plan and scheduling sheets; obtain stakeholder approval.
• Coordinate production deployment with production support and infrastructure teams.
• Respond to production ETL issues with warranty support and fixes.
• Apply performance tuning techniques within Informatica DEI/BDM.
• Leverage Hive, Unix, and SQL to optimize data processing.
• Collaborate in an onshore/offshore delivery model.

Skills

ETL development

Strong communication

Onshore/offshore

Tools

Informatica DEI/BDM

GitLab CI/CD

Talend

Snowflake

Ab Initio

Unix

SQL

Hive

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

VALIANT TECHNOLOGIES LLC 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. VALIANT TECHNOLOGIES LLC 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 VALIANT TECHNOLOGIES LLC 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