Friday, October 22, 2021

Informatica ETL developer @ Phoenix, Arizona

NO OPT & CPT VISA'S

Hello,
My name is Matt Adams and I am a Staffing Specialist at Veda Info Inc. I am reaching out to you on an exciting job opportunity with one of our clients.
 
Please find the JD below and kindly respond with the below details if interested:
 
Work authorization:
Expected pay-rate (or) employer details:
 
Job Title: Informatica ETL developer
Work Location: Phoenix, Arizona
Client: Infosys Technologies Limited
Contract duration: 06 Months + Extendable Possible
 
Does this position require Visa independent candidates only? No
 
Job Details:
Roles and responsibility:
Design phase:
·        Gain access & complete understanding of the APS data source(s), and the Beeline target schema/repository.
·        Develop a Beeline data migration/conversion strategy (under the guidance of the APS project Architect).
·        Organize data workshop with stakeholder (both APS & Beeline) to discuss conversion topics such as functional use of the data elements/attributes, business rules, cleansing necessity/opportunity, mapping/transformation options, etc.
·        Create a data conversion design document, using the SCORE standard DD template, for the conversion process and the end-to-end mappings of each and every piece of data between the APS source(s) and the Beeline target repository.
·        Define the data QA metrics for Completeness, Uniqueness, Integrity, Timeliness, Accuracy, and Validity.
·        Facility design review session(s) with stakeholders to solicit feedbacks and obtain approval for the design document.
 
Development phase:
·        Define the environment needed to support migration/conversion development (e.g., tools, staging database, Beeline dev environment, access, etc.)
·        Develop SQL Scripts and/or ETL workflows for migrating/converting data from APS source to Beeline.
·        Unit test all aspect of the design and verify the unit test results in Beeline.
·        Draft a conversion runbook & execute at least 1 end-to-end migration/conversion to verify all scripts/ETLs flow sequence.
 
Test phase:
·        Execute Mock conversions and verify the runbook sequence, timing, etc. (if called for by the project)
·        Provide data QA report to show successfulness of the conversion.
·        Provide fully converted data to support all test phases.
·        Participate in test team triage and assist in the identification of errors that might be caused by data.
·        Lead/participate in the resolution of all data defects.
 
Cutover phase:
·        Finalize conversion runbook.
·        Participate in cutover planning & development.
·        Lead data conversion activities during cutover.
·        Final reconciliation & data QA report.
·        Post cutover activities such as cleanup, retention, disposal, etc.
 
Skill requirement:
·        ability to write SQL scripts, skilled with Informatica for ETL. And the prefer skill: knowledge of Vendor Management System.
 
Interview Process (Is face to face required?): No
Minimum years of experience: 08+ Years
Certifications Needed: No

 
If this job/position is not suitable to you, please refer a candidate and earn a referral bonus. Vedainfo Referral Program is one of the best in the industry! Contact us for more details.
 
Thanks,
Matt Adams
Technical Recruiter
VEDAINFO INC.
Office: 310-929-1190 EXT: 156
Direct: -+1 310-929-1190

Company Name | Website

No comments:

Post a Comment