Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Lead ETL Informatica Developer (548 views)

Amelia, OH
March 26, 2021

***** Direct Client Requirement*****                    

Title                          :  Lead ETL Informatica Developer

Location                   : Amelia, OH

Rate                          : DOE /If your experience and skills match call us immediately for submission

Duration                  : 12 Months

Interview Type       : Phone or Skype

Work Status           : Successful applicants must be legally authorized to work in the U.S

Job Type                  : W2

Experience              : 8 years

Prefer W2               : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted


Client is doing a migration from Datastage to Informatica. Required experience with Informatica IICS, EDC and AXON

  • Expert Knowledge of Informatica PowerCenter and other related components
  • Participate in Detailed Technical Design, development, implementation and Support of data applications.
  • Manage and customize all ETL processes as per customer requirement and analyze all processes for same.
  • Analyze all complex data and identify requirements for business enhancement in project.
  • Be able to lead the development effort and coordinate with Offshore team.
  • Use acquired knowledge and develop Logical Data Models, Physical Data Models, and Data Element Dictionaries
  • Translate Business requirements into Data Requirements. Understand the data elements and their domains; understand relationships among those elements and inter-dependencies between models.
  • Working knowledge of RDBMS, dimensional modeling, and data warehousing techniques
  • Must understand relational databases and be able to write and execute SQL statements with extensive experience in MS SQL Server and Oracle.
  • Experience facilitating group sessions with key SMEs, and driving groups toward consensus on data design matters
  • Be able to understand existing code base in DataStage and convert to Informatica mappings
  • Troubleshoot and debug Informatica mappings, sessions and workflows
  • Performance tuning experience and be able to work with large volumes of data
  • Work in Agile projects

Required Skills
Informatica PowerCenter : 6-8 years
SQL Server : 3-4 years

Secondary Skills
Informatica EDC / AXON : 1-2 years
Informatica EDP : 1-2 yearsIICS – Cloud Services

Desired Skills
Informatica MFT : 2 Years
Informatica DQ/BDM/DEI : 2 Years
Microsoft Azure : 1-2 YearsAgile Methodology : 2-3 Years

****Referral Bonus Available: Refer your friends or colleagues, get referral bonus******



Apply here or Please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true
Twitter: https://twitter.com/SohanITInc1

Position Keywords: Informatica IICS, EDC AXON,Informatica PowerCenter,SQL Server,Informatica EDC / AXON,Agile Methodology

Pay Rate: DOE/If your experience and skills match call us immediately for submission

Job Duration: 8 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2937

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox