Lead over 25 Salesforce implementations from start to finish requiring the analysis of business processes, developing system level requirements, configuring the Salesforce.com platform, migrating data, and training ends users on system operations. 100% client satisfaction on Salesforce implementations. Extensive knowledge of Salesforce configurations including custom fields, workflows, visual flow, validation rules, reports, dashboards, custom buttons, custom objects, web-to-lead integration, approval processes, and Visualforce pages. Experience conducting large-scale data migrations that required thorough data analysis, the cleansing of data, and the deduplication of data using advanced functions within Extract, Transform, and Load (ETL) tools. Researched, implemented, and configured several applications from the Salesforce App Exchange including EchoSign, Marketo, Hubspot, Datahug, Mattermark, Click Tools, Conga Composer, Pardot, and several other applications.
Browse "Extract, Transform and Load (ETL)" job posts for project examples or post your job on oDesk for free!
"Extract, Transform and Load (ETL)" Job Cost Overview
Typical total cost of oDesk "Extract, Transform and Load (ETL)" projects based on completed and fixed-price jobs.
oDesk "Extract, Transform and Load (ETL)" Jobs Completed Quarterly
On average, 14 "Extract, Transform and Load (ETL)" projects are completed every quarter on oDesk.
Time to Complete oDesk "Extract, Transform and Load (ETL)" Jobs
Time needed to complete a "Extract, Transform and Load (ETL)" project on oDesk.
Average "Extract, Transform and Load (ETL)" Freelancer Feedback Score
"Extract, Transform and Load (ETL)" oDesk freelancers typically receive a client rating of 4.56.
In the last 5 years, I have developed a wide range of integration solutions between ERP several and online shop like Magento and Virtuemart using an Opensource ETL platform called Pentaho Data Integration. My skill includes full experience in DB development on MySql, Oracle and MS Sql Server, PHP development and Windows and Linux.
I am a Senior Java Developer/Architect with over 14 years of professional experience in Object Oriented Analysis and Design (OOAD), developing Java based systems which include multi-tiered and web based enterprise applications using J2EE technologies like Servlets, JSP, EJB(3.0,2.0), JDBC, JNDI, JMS, JPA, Java Beans, JAXB, JAXP(SAX/DOM), and JAX-WS. I have experience developing end-to-end applications in both the public and private sector across multiple disciplines including: telecommunications, finance, marketing, academia, health, public health, state and federal government. Examples of applications developed include, but are not limited to: websites, web-based surveys, surveillance systems, training software, order entry systems, integration applications utilizing SOAP/REST, and ETL applications utilizing Rapid and Agile development methodologies. My current interests include OSGI application development, ESB integration, and Big Data using Hadoop.
I am a technology consultant and Certified Project Management Professional (PMP) with over fifteen years of experience designing, developing and implementing technology solutions in support of business strategies and objectives. My expertise lies within the areas of data management, software development and systems integration. I am proficient in all phases of the Software Development Lifecycle (SDLC) and have experience in both the public and private sector building solutions with the Microsoft Technology stack.
16 years of experience in information technology working in various roles: developer, system analyst and business architect, project manager, team manager, coach, mentor and consultant. Currently I have dedicated the following activities: - Project integration between e-commerce / sites with ERP systems using PDI Pentaho tools and REST Web services for integration with mobile applications. - Implementation of agile practices for maintenance and evolution of software products, such as Scrum, Kanban, Continuous Integration and Delivery. - Project management and business analysis, making the interface between development team and customer / users in projects and Mobile Web development.
Over 7 years hands-on proven experience on Linux System Administration and Maintenance focused on BI & Big Data Solutions, Data Quality Management, Systems Integration Development with different Landscape Scenarios (Development / Production). Also worked as BI & BigData Consultant / Developer. Skills and Expertise: - Linux System Administration (RHEL, Suse, CentOS, Debian, others) - Linux Server / Services (Tomcat, HTTP, Nginx, LAMP, DHCP, SSH, SFTP, Samba, IPTables, Hadoop, others) - Programming Languages (Java, ShellScript, PHP, SQL, Perl/CGI) - Database (MySQL, Postgres, MongoDB, DB2, Sybase ASE)
Exceed your Expectations I began surprising people while in my teens, and decades later, that hasn't stopped. Whether my next surprise is rescuing a seemingly hopeless system, sending you 50$ refunds for every bug found in my software, turning an everyday report request into the discovery of a new cost-saving business process, herding cats (e.g. programmers) living around the world into becoming a world class team, or helping you learn what you didn't know you needed to learn, I can't yet say. But everyone likes unexpected gifts. I look forward to working with you. P.S. I am fluent in German. In French I have some reading knowledge and a *very* basic conversational ability (French is such a beautiful language, I look forward to having a pressing business need to rapidly become fluent). I used to be fairly fluent in Japanese; someday I hope to regain that as well.
• Project to process Transactional Processing. We designed the dataware house and we are moving this business transactional data to dataware house. • Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica. • Performed data cleansing and transformation using Informatica. • Worked extensively with Designer tools like Source Analyzer, warehouse Designer,Transformation Developer, Mapping and Mapplet Designers. • Created data mappings to extract data from different source files, transform the data using Filter,Update Strategy, Aggregator, Expression, Joiner Transformations and then loaded into datawarehouse. • Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information. • Used Update Strategy Transformation to update the Target Dimension tables, type2 updates where we insert the new record and update the old record in the target so we can track the changes in the future. • Developed various mapplets that were then included into the mappings. • Used Workflow Manager to read data from sources, and write data to target databases and manage sessions. • Review of the mappings. • Extensively used various transformations like Aggregator, Lookup, Expression, Router and Filter Transformations. • Developed various worklets that were then included into the workflows. Tuned and tested the mapping to perform better using different logic’s to provide maximum efficiency. • Review of the mappings. Monitor, Repository Data modeling duties: • Create Logical Data Model and Conceptual Data Model • Review current System Design Document, Functional Requirement Document and existing Physical Data Models • Create Logical Data Model, Conceptual Data Model for existing application using bottom up approach while following data modeling standards. • Update Client’s Enterprise Logical and Conceptual Data Model Job Detail • Update models with promoted entities, attributes and relationship at application level for which could be used at Enterprise level • Review and Develop Information Exchange Package (IEDP) • Develop IEDP using NIEM for Information Sharing • Create and Update Client’s Taxonomy • Develop and update the enterprise data harmonization with data definitions • Support the development of Data Management Plan and investigate unstructured data
Senior Data Warehouse-Business Intelligence (BI) Engineer/Architect, and Database (RDMBS) Developer/Administrator, with extensive hands-on experience in agile, fast-pace, cross-functional environments. Well-versed in all areas of system development life-cycle for centralized client-server, and distributed, multi-tenant RDBMS platforms; such areas include: data analysis, architecture, modeling, development, testing, implementation, and maintenance. Engineered and implemented transactional (OTLP) and analytic (OLAP) database applications for following industries: Healthcare Practice Management/Electronic Medical Records, Life/Health Insurance, Distributed Marketing Resource Management, On-line Payment Processing, Credit Risk Management, and Corp. Banking. Specializes in scale-up and/or conversion of monolithic client-server database systems into highly robust, scalable, distributed data service platforms, utilizing following architectural practices: Service Oriented Architecture, Software-as-a-Service, and Platform-as-a-Service. Designs and deploys DB applications for dedicated and/or hybrid, Operational and Data Warehouse/Mart systems, incorporating various development stacks, with following technologies: RDBMS (PostgreSQL 9.x, MySQL 5.x, Oracle 10.x, DB2); Data Warehouse (DW)/BI/BigData (Pentaho BI Server 4.x CE, Mondrian 5.x, Hadoop Hive); ETL/DI (Pentaho, Talend, Informatcia, DataStage); Reporting (Pentaho, Jasper); Data Modeling (Erwin, Embarcadero, Toad); Programming (DB: SQL, PL/SQL, MDX, HQL, Shell Script, PHP, Python, Java, HTML, XML); NoSQL DMS (Cassandra 2.x, MongoDB 2.x, Hadoop Hbase); Operating Systems (CentOS 6.x, FreeBSD8.x, Ubuntu 12.x, Fedora Linux 7.x, Solaris 10.x, Windows Server 2003/NT); Backup & Recovery Managers (pgBarman 1.2.x, Oracle RMAN), Load-balancing & High Availability (PosgreSQL Replication Clusters, Oracle RAC, HAProxy); VCS and CI (GIT, Jenkins, Chef); Project Management (JIRA, RedMine)