Required Skills

ETL Informatica

Work Authorization

  • Us Citizen

  • Security Clearance

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

  • Need New H1B (OPT/CPT Fresh Grads)

Preferred Employment

  • W2-Contract

  • 1099-Contract

  • Contract to Hire

Employment Type

education qualification

  • UG :-

  • PG :-

Other Information

  • No of position :- ( )

  • Post :- 27th Jan 2022

JOB DETAIL

Job Title       :    ETL Informatica Developer

Location       :    Atlanta, GA (Remote)

Duration       :    Full Time

 

Job Description

 

·         Create Informatica mappings with PL/SQL store procedures/functions to incorporate critical business functionality to load data.

·         Used connected, unconnect lookup, static and dynamic cache to implement business logic and improve the performance.

·         Develop procedures and functions using PL/SQL and develop critical reports.

·         Develop PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic.

·         Work with relational databases like DB2.

·         Detail table design and index selection in for TeraData databases using SQL.

·         Develop mappings with XML as target and formatting the target data according to the requirement.

·         Work with logical, physical, conceptual, star, snow flake schema data models.

·         Extract data from flat files, DB2 and to load the data into the SalesForce database.

·         Create and used debugger sessions to debug sessions and create breakpoints for better analysis of mappings.

·         Work with various data sources--relational, flat file (fix width, delimitate) and XML.

·         Involve in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration.

 

Christy Rachel

IT Recruiter

Direct Phone: +1 (609-423-6916)

Email: christy@hanatek.org

LinkedIn: linkedin.com/in/christy-rachel-77a467196

Address: 55 Madison Avenue, Suite 400, Morristown, NJ 07960

URL: www.hanatek.io

Go Green! Think Green before printing!

Company Information