Browse Informatica job posts for project examples or post your job on Upwork for free!

Informatica Job Cost Overview

Typical total cost of Upwork Informatica projects based on completed and fixed-price jobs.

Upwork Informatica Jobs Completed Quarterly

On average, 2 Informatica projects are completed every quarter on Upwork.


Time to Complete Upwork Informatica Jobs

Time needed to complete a Informatica project on Upwork.

Average Informatica Freelancer Feedback Score

Informatica Upwork freelancers typically receive a client rating of 4.93.

Last updated: October 1, 2015

Popular Informatica Searches

Clear all filters

Girish Kargadde

Girish Kargadde

Informatica, ODI, OBIEE, OBIA

India - Tests: 1

Overall 8 years experience in DW/BI solutions and software development, Design, Development and testing experience using both ETL (Informatica, ODI and Pervasive ETL) and Reporting (OBIEE) tools. 4 years of experience in OBIA.

$11.11 /hr
0 hours

Girish D

Girish D

Searching for Management/informatica/DWH/BI/Bigdata/Java/KPO work

India - Portfolio: 2

6+ years of experience in Data warehousing Technology Requirement Analysis, Data Analysis, Application Design, Application Development which includes, Requirement gathering, Customization and Maintenance of various Business Applications in Data Warehouse/BI (ETL,Reporting) as well as SDLC of any technology. I have worked on real time projects as well as training material also provided proper material with real time scenarios. You can check my earlier job history. Service Description Professional Expertise: • Experience in Transformations, Mappings, Targets, Workflows, Worklets, Sessions. • Good in elimination of bottlenecks in the mapping for performance tuning. • Good understanding of ETL Framework and Processes; In particular – Incident Management, Problem Management, Change Management, Business Continuity Management, Service Management. • Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files. • Effective in interaction with Business users, understand their requirement, simplify complex IT jargon in business suitable language and vice versa. Technical/System Skills: • Programming Languages: SQL/ PLSQL, C • DBMS: Oracle SQL, Teradata, Microsoft SQL Server 2005/2008. • Operating System: UNIX, Windows. • Scripting Languages: UNIX Shell • ETL-Tools: Informatica Power Center 8.x/9.x • Reporting-Tools: Cognos,Tableau,QlikView Experience: 1. Healthcare –Reporting Management Description: To generate Flexible generic process for evaluation of valuable data as to maintain history products. It has various data Sources for modules like Products, Facility, Professional, Vendors, etc. It has various source systems like Flat files, Oracle, SQL Server. Data from these sources acquired into the Stage database. Data cleansing and aggregation is done for the data and populated into ODS layer and then to Data warehouse for maintaining history and Data marts for reporting requirements. Roles & Responsibilities: • Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications. • Developed standard and re-usable mappings and mapplets using various transformations. • Extracted Data from flat files and various relational databases to Oracle Data warehouse Database. • Created the unit test cases for mappings developed and verified the data. • Conducted the peer review and debugging for mappings developed and tested. • Creating test plans and developing Test Scripts:Unit Testing,UAT support, document results, fixes assigned SIT & UAT defects and provides status for tracking. • Defect Tracking, Data Verification. Environment: Informatica Power center 8.x/9.x, Oracle, Toad, Windows, Unix, SQL Server 2005, Flat-file 2. EDW- Daily processing Description: EDW Data warehouse deals with different kinds of financial loans which are categorized as Facility, Professional, FEP. Data is coming from various sources like Oracle, Flat File etc which will be loaded in to EDW based on different frequencies as per the requirement. The entire ETL process consists of source systems, staging area, ODS layer, Data warehouse and Data mart. Responsibilities: • Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications. • Involved in business analysis, technical design sessions with business and technical staff to develop requirements document and data modeling with design of Data Warehouse, data marts. • Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, etc. • Data quality checking and interacting with the business analysts • Communication with the client for weekly status report and responsible for writing procedures in SQL server. • Created the unit test cases for mappings developed and verified the data. • Conducted the peer review and debugging for mappings developed and tested. • Creating test plans and developing Test Scripts:Unit Testing,UAT support, document results, fixes assigned SIT & UAT defects and provides status for tracking. Environment: Informatica PowerCenter 8.6, Oracle 10g, Oracle, Unix, 3. Procter-IDW Description: Integrated Data warehouse (IDW): to build an Integrated Data Warehouse (IDW) that will enable fact-based decision-making. The data warehouse being built will serve as a firm foundation for Business Intelligence and Data Analytics subsequently. The subject area covered in this phase is CUSTOMER, TRADES, ACCOUNT, ASSETS, DEPOSITS and SECURITY. The process loads the customers and account details, Household wise/Category wise Exclusive, Qualified and Practice revenue amounts, which will be used by the Decision Support System for the analysis.

$15.00 /hr
88 hours

Waqas B.

Waqas B. Agency Contractor

Expert ETL Developer with experience in Informatica and Pentaho

Pakistan - Tests: 5 - Portfolio: 6

I am a Certified Informatica and Teradata specialist and have worked on several enterprise level Data warehouse projects for clients in US and Middle East including Reonomy (US), Qatar Telecom (Ooredoo) (Qatar), Emirates (Dubai), National Bank of Abu dhabi (Abu Dhabi), Mobily (Saudi Arabia). I have good analytical & design skills, focused approach, team player, hard working and professional attitude to work. PROFILE - 7 years of experience in ETL, BI and Data warehousing. - Hands-on experience in Data Integration Tools including Informatica PowerCenter 8.6/9.1, TIBCO Business works 5.6, Pentaho Data Integration and Server Integration Service (SSIS). - Experience in Data warehousing with substantial knowledge of Telecommunication, Health care, Real Estate and Retail domains. - Working knowledge of complete Data warehouse development life cycle (Data Modeling, Data warehouse designing, ETL development, BI reporting) - Exposure to large data volumes in major database systems including Teradata, Oracle, Microsoft SQL and MySQL. - Deep knowledge of SQL, and Reporting experience in Crystal Reports, Jaspersoft Studio, Pentaho BI and Microstrategy. SKILLS SUMMARY Data Integration Tools: Informatica Power Center 8.6/9.1, TIBCO Business works 5.6, Pentaho Data Integration, SQL Server Integration Service (SSIS), konstanz Information Miner, Adeptia ETL Suite, MicroStrategy BI, Pentaho BI, Jaspersoft Studio Databases: Teradata, Oracle, Microsoft SQL Server, MySQL, MS Access and GUI tools including SQL Developer, Toad, SQLyog. Data Modeling and Profiling: MS Visio, ERwin, Gliffy, Talend Open Profiler, Informatica Integrated Data Profiler. Programming: Asp.Net, C#/VB.Net, VB6, C/C++, Java.

Associated with: KavTech Solutions

100% Job Success
$27.78 /hr
2,062 hours

Mohit J.

Mohit J.

Senior Oracle Developer/Architect

India - Tests: 2 - Portfolio: 5

I am an ETL/ Oracle Database Architect with over 8 years of experience in the following speciality areas: 1. Design and Architecture 2. Data Modeling and Database Design 3. Custom ETL Solutions using Procedural SQL (MS T-SQL, Oracle PL/SQL and MySQL) 4. Data Migration and Cleansing 5. Database Process Automation 6. SQL and Procedural SQL Performance Tuning 7. Advanced Database Application Development 8. Freelance Database Training My past experience includes working extensively with the various clients in the Banking and Capital markets domain in India and United States. Some of the major clients include Fidelity Investments Boston, Citigroup, Royal Bank of Scotland etc. I have been involved in all the stages of SDLC including Requirements Gathering and Analysis, Design, Build, Testing, Implementation and Post-Implementation Support. My core competency lies in strong analytical, problem solving and requirement elicitation skills. I am well versed with the projects involving high volumes of data, data analytics and assure you of value addition, timely delivery and quality deliverables. Please feel free to call/email me for more details/discussion on my past projects and experience.

Groups: Oracle Certified Associates, Oracle Certified Experts...

$33.33 /hr
131 hours

Ravish HS

Ravish HS Agency Contractor

Management,Business intellegence,DW,Analyst,oracle,Database,ETL

India - Tests: 7 - Portfolio: 4

Objective : In pursuit of true knowledge and looking for a challenging career, which provides ample opportunities to exploit my potential to the mutual benefits of myself and the company I work for   Work History: Over Sixteen years of experience in Information Technology. I have worked for over 6 years in USA on H1B. I have been involved in Project management, Data Analysis, design, development, implementation and enhancement of software Projects over these years. Also, I have expertise in Data Warehousing and Business Intelligence Solutions using technologies mentioned below. I have work experience in segments like Manufacturing, Finance, Healthcare, Auto Insurance, Telemarketing, and Sports(ESPN). Databases-     Oracle, SQL server, Sybase, DB2, MS/Access, Focus, Essbase Language -      C, COBOL, SQR, PL/SQL, T-SQL, HTML, Java ETL Tool - Informatica, DataStage BI Tools - Brio/Hyperion Interactive Reporting , SQR/production                          Reports, BusinessObject, Brio Query, Brio  Portal Cognos,  Microstrategy, ER-Win, Visual Source Safe, PVCS GUI       - PowerBuilder, Visual Basic, Gupta SQL / CENTURA OS           - UNIX & Windows RESPONSIBILITY:  -Leadership with development group with hands on problem identification  and resolution. -Concept through requirements, planning, development and integration. -Full life cycle application development with Object oriented Software  Engineering. -Specialized in Report design & Development, data analysis, PM, ETL, BI,   and Data warehousing.

Associated with: Howine

$11.11 /hr
0 hours

Sujeet Kumar Singh

Sujeet Kumar Singh Agency Contractor

MySQL/SQL Server DBA, DWH & BI, SSIS/SSAS/SSRS, Informatica, AWS

India - Tests: 3 - Portfolio: 4

I have 10 plus years of experience in MySQL DBA/DWH BI and Web development. I have designed and develop very complex to high data ware house solution for the organization. I am very dependable and pride myself on punctuality and meeting deadlines. I am seeking opportunities to build/create BI solution and software development from the ground up for you or your business. I have worked on many freelancers’ projects where my responsibilities included developing and maintaining the application built using MySQL, UNIX, Perl/PHP and Data ware house technologies. My experience creating solutions includes building and deploying scalable solutions on top of clients’ project. I am an expert in Perl, PHP, UNIX, MySQL, PostgreSQL, SQL Server 2008 and Data-ware house using Informatica and MSBI. I have consistently delivered projects on time and under budget. I can provide services in the below mentioned areas: MySQL, PostgreSQL, Oracle, PL/SQL, SQL-Server 2005, 2008 Microsoft Data Warehouse and Business Intelligence Developer SSIS/SSAS/SSRS, Informatica, Kalido DIW, Kalido BIM Data Modeling and Designing Amazon Web Services (EC2, S3, EBS) Perl, Object Oriented Perl, PHP UNIX/Shell script Performance Audits SQL reviews Index reviews Capacity Reviews Consultation for application interaction with MySQL Consultation for caching layers alongside MySQL Consultation for MySQL replication architecture Database Backups and Restores Database Monitoring Replication troubleshooting Load Balancing Stored Procedures Data Quality issues

Associated with: SV Techsolution

79% Job Success
$15.00 /hr
139 hours

Noor Alam

Noor Alam

DW(ETL,BI)12yrs:Oracle,Teradata, ODIEE,SSIS,SSRS,Informatica,Obi

Bangladesh - Tests: 1 - Portfolio: 5

I am expert on ODIEE11G/12C (Exp: 10 years), MSBI (SSIS, SSAS, SSRS, MS SQL Server 2008 R2/2012/2014), Exadata, Teradata, Oracle8i/9i/10g/11g, T-SQL,Infromatica8.5/8.6/9.1, Obiee11g, Erwin, MS Visio 2010, Excel, MySQL and I have more than 10 years of experience in SQL, PL/SQL, T-SQL, Datawarehousing, ETL, BI, Analysis, Data Architect, Dimensional Modeling (Star-schema, Snowflake, 3NF), Project Management, Database Design, Database Engineering, Documentation on Business Intelligence Strategic Road map Business Requirements and Technical Feasibility Assessment etc. Technical: I provide BI (DW) Solutions by the followings: .Oracle Flexcube UBS .Data Modeling, .ETL Design, .LDM & PDM, .OLAP, .Source System Analysis .Oracle9i/10g/11g, .Teradata13 .Teradata SQL, Teradata Tools & Utilities (BTEQ, FastLoad, MultiLoad, TPT) .PL/SQL .Informatica8.5/8.6/9.1 .OBIEE .SAP BO .SAP Crystal Report .MS SQL Server 2012 .Linux .Shell script .MS VISIO 2010 .MS Project 2010 Core Banking Domain: 1. Oracle Flexcube UBS release 2. TCS Core Banking Solution 3. BankUltimus Core Banking Solution (Leads Corp.) ETL Development/ETL Design and Data Migration through Informatica/SSIS for Data Warehouse (Bank), Worked division: I) ATM Data II) Card Data III) Corporate Banking IV) Retail Banking Inter-Banking Informatica/SSIS, Sql Server & Oracle BI DW Basel-II projects (Bank) with Data Migration: 1. Bangladesh Bank (Central Bank of Bangladesh) 2. SIBL SKILLS: * Data Vault Design (Components: Hub, Link, Satellite) * Planning & Define Data-mart schema architecture e.g. - Start Schema, - Snowflake, - 3NF Banglalink(Orascom) EDW Teradata Telcom Project Technology:Teradata,Informatica9.1,SAP BO XI,ERwin. * Teradata SQL * Teradata ETL tools & Utilities such as * BTEQ,MultiLoad,FastLoad,FastExport,TPT * Teradata Physical Implementation * Teradata Administration * Data Modeling to build LDM and PDM * Developed standard SQL, PL/SQL code * Query optimization technique * Developed Data summarization & aggregation concepts and scripts * Developed shell scripts (Korn shell) for ELT and BI purpose * Develop ELT process using Informatica9.1 * Developed ELT process for various Operational Data Source (TABS, IVR, LMS, CMS, POS, SALESCOM and forth) of Banglalinks’ Telecom (Orascom) and BI reporting with BI Chain Development. * Design and created ELT standards and procedures * Assisted in architecture design of new data warehouse and ETL/ELT process * Documents all ELT code for the business * Designed and installed test scripts for ELT code * Created Informatica9.1 ELT code from functional and technical specs * Converting Oracle Procedures, Functions into Teradata stored Procedure (SP) and Syntax. * Created FTP scripts for moving source and target files * Tuned SQL statements for end users creating custom reports * Data Migration From Oracle to Teradata. Mappings the following Subject Areas: a) CALL USAGE B) ROAMING C) RECHARGE D) CUSTOMER PRODUCTION E) TABS F) INTERACTION (CALL CENTER) G) IMEI H) LMS (Loyalty Management System) & CMS (Campaign Management System) * Creating WorkFlow and WorkLet and also Managing sessions through WorkFlow. * BI Report (Daily, Weekly & Monthly) CHAIN Development for Banglalink BI Department. . Business Report creating through Teradata, SAP BO. * Developed SHELL SCRIPTS to transfer CSV & SEND EMAIL and for Mappings. * Banglalinks' (Orascom) existing Data Migration from Oracle to Teradata. * More than 1 Terabyte data migrated through Informatica9.1. * Design and develop test plans. Core Divisions: * Core Banking (Source System Analysis): Oracle Flexcube UBS Release(10.5,11.2,12.1,12.2). * Enterprise - Oracle Applications, Oracle Forms, Oracle PL/SQL, Business Analytics * Mata-mart - Oracle, Teradata, MS SQL Server 2012 * Databases - Teradata13.1, Oracle 11g/10g, 9i/8i, SQL Server 2012/2008/2005/2003. * Sector Expertise - Project & Programme Management, Business Analysts (Telecoms, Financial Services & Banking, Utilties, Pharmaceutical, Retail, Hospital) * Business Intelligence & Systemology - SAP BO XI R3, OBIEE, Microstrategy. - Cube and Relational Data Warehousing techniques, OLAP, MOLAP and ROLAP. * ETL - Informatica8.5/9.1, OWB11g, ODI11g, SSIS etc. * Methods and Concepts - Data Modeling (Conceptual, Logical and Physical Relational, ER & Dimensional Modeling. Functional: .Risk Calculation Engine Development .Credit Risk Flow (Functional & Technical) .Market Risk Flow (Functional & Technical) .Operational Risk Flow (Functional & Technical) .Data Migration on ATM data, Card Division Data .Basel II Business requirements – Source system (.GL) To Basel Data Warehouse .Business Analysis . PD, LGD, EAD, RW, RWA calculation .Basel II Business requirements - Data warehouse to Risk Engine .Settings for the Risk Calculation engine .Risk Engine Results layer to Basel II reporting layer .Solution for National Discretions (Central bank Reporting) .Sample Source system , Data Warehouse & Risk Calculation data view

$15.00 /hr
22 hours