Required Skills

ETL development using Informatica Power Center v10+ Python SQL Server Oracle Teradata

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 29th Aug 2024

JOB DETAIL

Profile & Analyze Source Data (Mainframe Extracts, flat files, SQL Server, Web services etc.) usage using Informatica ETL.
Analyzing and evaluating data sources, data volume and business rules
Automation, job scheduling, dependencies, monitoring
Extraction, transformation and load of data using ETL tools
Configure/Script Business rules and transformation rules in Informatica
Design, development of ETL Informatica jobs as per the Business requirements
Understanding the data model, designing the model for EDW, mapping the data and running the ETL jobs
Ensure appropriate level of Unit Test and System Test of all deliverables
Understanding of deployment process of both Informatica PowerCenter and IICS jobs
Knowledge in version control tools like Bitbucket, Git etc and knowledge of branching and check-in of code
Defect fixes for System Test, Operational Acceptance Test and Production
 

Company Information