Find Jobs
Hire Freelancers

Informatica Powercenter ETL Developer needed to work as a consultant on a temporary basis

₹250000-500000 INR

Mbyllur
Postuar over 2 years ago

₹250000-500000 INR

Paguhet në dorëzim
Looking for a Informatica ETL Developer needed to work as a consultant on a temporary basis for 6-8 months from India only and ready to work in 1pm to 10 pm IST shift Experience Requirements: 1. 3-5 years’ of experience in ETL development using Informatica PowerCenter with Oracle database technologies. 2. 3+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes with thorough knowledge of star/snowflake schemas. 3. Two (2) to four (4) years RDBMS development, SQL skills, using Oracle Development Tools like SQL, PL/SQL will be preferred. 4. Experience with developing complex SQL queries and SQL optimization. 5. Informatica Professional Certification is preferred. 6. Development experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture. 7. Experience with Oracle ERP, Siebel would be a plus. 8. Experience using MS SQL Server would be a plus. 9. Experience with Informatica Administration would be a plus. Required Skills 1. Expertise designing, developing, and maintaining Informatica Applications. /Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer, and mapplet designer. 2. Ability to design and develop complex Informatica mappings, sessions, workflows and identify areas of optimizations. 3. Working knowledge of Oracle database features such as materialized views, bitmap indexes, IOTs, external tables, etc. especially as it pertains to ETL. 4. Proficient in data analysis, defect identifications and resolutions. 5. Strong professional verbal and written communication skills. 6. Ability to work with little supervision and within changing priorities. 7. Ability to analyze requirements and troubleshoot problems
ID e Projektit: 31149244

Rreth projektit

1 propozim
Projekt në distancë
Aktive 3 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
1 freelancer is bidding on average ₹455 000 INR for this job
Avatari i Përdoruesit
Hello Sir/Ma'am, I have 7 years of hands-on experience on Informatica powercenter and IICS with multiple MNC companies. During this 7 years, I worked on end-to-end process like --Communicated with business customers to discuss the issues and requirements. --Designed and customized data models for Data warehouse-supporting data from multiple sources on real time. --Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database. --Identified problems in existing production data. Doing extensive troubleshoot the problems to find root cause and give solution to fix the problems permanently. --Implemented various Performance Tuning techniques like Partitioning, Push down optimization, improve transformation performance etc. --Performed unit testing at various levels of the ETL and actively involved in team code reviews. --Creating reusable transformation and mapplet to use them in different mappings. --Writing SQL and UNIX script to create new report or modify report script as per data requested by clients. --Troubleshooting on performance tuning via SQL profiler and performance tuning adviser. --Having good exposer in deployment --I would be available for 1pm to 10 pm IST
₹455 000 INR në 210 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i INDIA
India
0,0
0
Anëtar që nga gush 13, 2021

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.