Below are the 4 ETL Developers & 6 Data Migration/Extraction Pros with multiple systems/technical expertise. The Thor Group® provides ETL developers & data migration/extraction pros with your systems, software & industry experience on a consulting, contracting or direct hire basis.

Would hiring a senior ETL developer with experience working in a health system help meet the needs of your organization? Educational attainment involves Bachelor of Technology in Computer Science. Database skills include Oracle 11g/10g /9i/8i, SQL Server 2000/2005/2008, Teradata, and Sybase 12/11. Programming languages skills include SQL, PL/SQL, T-SQL, C, C++, JAVA, VB.Net, HTML, PERL scripting and Unix Shell Scripting. Expertise in ETL tools is composed of Informatica (PowerMart/PowerCenter) (9.1/8.6/8.5/8.1.1/8.0/7.1/7.0), SSIS and DataStage.

Acting as a senior ETL developer in a health system, has worked on a project that consolidated the data loading from disparate sources into Oracle Data warehouse. Data was then loaded into downstream data marts. Some of the responsibilities included being involved in the entire SDLC (Software Development Life Cycle) process that includes implementation, testing, deployment and maintenance. This developer also performed Oracle Data Warehousing development including data modeling and backend processes, specifically Extraction, Transformation and Loading (ETL) of data into staging tables and then into Data Marts/Warehouses for presentation.

While working as a senior ETL developer, has used Oracle Golden Gate to replicate the change data from the source system to staging area. Some of the tasks were developing complex mappings to Parse the XML string by using XML parser, Java Transformation and loading the parsed data into Netezza Target tables, as well as analyzing source system tables to build the Logical and physical data models. Part of the job was to gather the ETL requirements and work closely with the DBA to generate the DDL in the target system (Netezza) for the ETL loads.

Would hiring an ETL developer with experience working in insurance and IT solutions industries help meet the needs of your organization? Technical skills include Oracle 10g/9i/8i, Informatica PowerCenter, SQL Server and PL/SQL.

Acting as an ETL developer in an IT solutions company, has analyzed and understood business and customer requirements by interacting with Business Analysts and Data Modelers. Some of the tasks were writing and reviewing of ETL Specifications and Source to Target mappings (STMs), as well as working on data conversion/transformation between Flat Files to Oracle and SQL Server. This specialist has worked on data migration, data mirroring, and data replication using Informatica Cloud. Also, has maintained and followed documents like design documents, functional specifications and technical specifications. Environment: Oracle 10g, Informatica Power Center 8.6.1 and Informatica Data Quality 8.6.1.

While working for an insurance company as an ETL developer, responsibilities included interacting with business representatives for requirement analysis and defining business/functional specifications. Part of the job was to design and build data marts for Disability, Life, Accident and underwriting divisions. Moreover, has loaded data to the Interface tables from multiple data sources such as MS Access, SQL Server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connection.

Could the future success of your organization be helped by this ETL developer with work experience in an academic medical center? Educational attainment involves Bachelor of Technology in Information Technology. Software skills include Oracle SQL Developer, SQL Navigator and Toad. Database skills are composed of Oracle 9i, Oracle 10g, Oracle 11g, SQL, PL/SQL, and SQL PLUS. Knowledge in ETL tools involve Informatica PowerCenter 9.1,8.6,7.1,6.2.

Contributed to the organization’s success by creating mappings using Flat Files and Relational Targets, as well as performing data analysis, assisting data analysts with mapping data from existing systems and helping in generating required SDLC documentation. Serving in an academic medical center as an ETL developer, responsibilities included automation of ETL processes with scheduling tools and exception-handling procedures, as well as evaluation of the performance issues in the data marts, which included analyzing query plans by involving the DBAs for the SQL override lookups. Working with fellow employees and client team members in planning, and design development of ETL solutions was also one of the duties performed.

Supported organizational goals and objectives by working closely with business analyst and the end users in writing the functional specifications based on the business requirement needs. Acting as an ETL/Informatica developer, some of the responsibilities were being involved in Dimensional modeling (Star Schema) of the Data warehouse as well as using Erwin 4.5 to design the business process, dimensions and measured facts. Also, was responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter 8.6.1.

What contributions could a sr. ETL developer with experience working in IT solutions and financial services industries bring to your organization? Educational attainment is composed of Bachelor of Technology. This specialist has experience in integrating data from various Heterogeneous sources like Oracle, SQL Server, DB2, UDB, Flat Files (Fixed Width and Delimited), COBOL files, XML Files and Excel files into Data Warehouse and Data Mart. Also, has worked on ETL development projects with multiple team members, providing mentoring, technical assistance, troubleshooting and alternative development solutions. RDBMS expertise involves Oracle 8, 9i, 10g, 11g, DB2 8.1, SQL Server 2005 and Teradata.

Challenges like being responsible for design and development of Clinical Data Warehouse project leveraging Informatica PowerCenter ETL tool were welcomed and successfully completed. Serving in an IT solutions company, this sr. ETL developer was responsible for Impact Analysis, upstream/downstream impacts. Some of the duties were analyzing business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow, as well as creating detailed technical specifications for data warehouse and ETL processes. Part of the job was to extract/load data from/into diverse source or target systems like Oracle, XML and Flat Files.

Shared expertise by performing analysis in business requirements and creating design specifications as well as developing code using Informatica PowerCenter 8.6.1 and Oracle 11g. While employed in a financial services company as a senior ETL developer, responsibilities included extracting data from Oracle, XML, Flat files, Sequential files and loading in Enterprise Data warehouse on Oracle. Furthermore, has extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.

Could the future success of your organization be helped by this DBA reporting manager with experience working in trailer, financial services and direct marketing industries? Educational attainment is composed of BS Computer Science/Business. Technical skills consist of QuickBooks, TakeStock, Traverse & DataPro as well as SQL Server v4.2, T-SQL, DTS, SSIS, SSAS, OLTP, OLAP, SSRS, Data Warehousing, C#, VB.NET, Visual Studio, SaaS, SOAP and WCF Web.

Contributed to the organization by being responsible for the consolidation of various ERP systems (TakeStock, Traverse, DataPro, and QuickBooks) from the various ATW business units. This was to provide a consolidated data warehouse for data exchange with Salesforce and enterprise wide reporting. While working in a trailer company as a DBA reporting manager, has designed and developed first company-wide data warehouse to facilitate MDM and enterprise wide reporting. Also, has developed custom SSIS packages to extract, transform and load data from the various ERP systems and transfer the data to an Azure based data warehouse. Some of the tasks were developing OLAP data cubes to facilitate reporting on accounts, purchase order, and sales data, as well as working with BI analysts and developers to identify and build custom dataset for specialized reporting in Microsoft Power BI and Excel. In addition, has provided database administration and support for all business units.

Supported organizational goals and objectives by designing and implementing (IMS) an automated multi-stage data import, export, and reporting management system for client and vendor data exchange. While employed in a communications services company as a sr. enterprise architect, has designed and implemented an automated data cleansing workflow stored procedures using SQL.

How can your organization gain an advantage with the help of a migration support/desktop support who is skilled in QuickBooks with work background in banking, business services and technology industries? Technical skills cover QuickBooks, Adobe Acrobat, Citrix Client and PCAnywhere. Educational attainment includes courses in Electronics and Networking.

Main functions of this migration support/desktop support involved imaging desktops/laptops with SOE Zero touch installation, entering system serial number to DOE database and booting Windows 7 image to the network. Installing and assuring the operation of non-standard software used by employees, migrating user data at system deployment, using USMT utility, assuring user pertinent data, network printing and sharing drive mappings were some of the duties. AD user passwords were changed and reset. IMAC, troubleshooting and break fix were efficiently carried out.

Notable tasks in other jobs included upgrading the HP server, performing data migration, connecting computers or printers to the network, re-assuring connectivity/ communication to remote administration and database functionality. Responsibilities consisted of assisting with imaging, connectivity, installation and functionality of Windows 7 migration from Windows XP of laptops/desktops; data migration was assured. Other roles covered creating user login in Active Directory, network printing, testing the functionality of email to be migrated from the server, as well as troubleshooting and break fix. Assistance was provided with connectivity, installation and functionality of Windows 7 migration from Windows XP of desktops, assured data migration and user login to active directory. This individual assured the computer to be moved to OU in AD and assured the functionality of the bank business software, and network printing.

Could the future success of your organization be helped by this IT consultant/data migration consultant who worked in software and IT services industries? Educational background is composed of Associate Degree in Finance and Investments. Professional certifications earned as: CWNP Certified Wireless Technology Specialist (CWTS), CompTIA Certified A+ IT Technician and CompTIA A+ IT Technician. Technological know-how involves NetSuite, Oracle and Android OS.

Supported organizational goals and objectives by installing, managing, troubleshooting and training technicians for omni-directional antennas and access points. In addition, has created, managed quality control, DAS technician and access point technician. Serving in an IT services company as an IT consultant, served as an assistant PM, quality control, installer, trainer, and migration technician. Furthermore, has created, managed omni-antenna, access point, as well as carried out installation and quality control procedures. Additional responsibilities were migrating operating systems, settings, and data, from old computers to new computers.

Contributed to the organization’s success by configuring, installing, sending data and troubleshooting smartphones, tablets, MiFi hotspots and IBM MaaS360. While employed in a technology company as a mobile device software technician, installed, configured software, managed reset, troubleshot mobile devices, implemented new processes, and configured/activated SIM. This individual configured mobile settings, ran scripts, updated tablet BIOS, managed/formatted SD cards, as well as installed/configured software on mobile devices, and documented devices defects. This professional has worked with different departments and teams, processed each client order, as well as performed installation deployment and new device installation configuration. Also, has updated tablet BIOS, updated software installation folders, web-based installation, web-based connectivity, web-based cellular data sending and data verification.

Does a data extraction analyst who is skilled in NetSuite, Oracle, PeopleSoft and Cerner, with work background in a general hospital and a medical group pique your interest? Technical knowledge includes NetSuite, Oracle, PeopleSoft, Centricity, Cerner, Ceridian, SharePoint and Unifi. Educational background includes Bachelor of Science (in progress).

Primary functions of this data extraction analyst included researching and gathering routine information from a variety of sources. Aside from organizing, developing, maintaining and monitoring a variety of manual and electronic records and files, this individual obtained, compiled and recorded data. Responsibilities consisted of developing reports, data mining, data extraction, data entry and updating user accounts. Performing a variety of clerical, data entry tasks and entering information into appropriate computer programs were carried out. Data was reviewed and assistance was provided with new system migration. Tasks consisted of maintaining tact and diplomacy, in addition to using good judgment regarding sensitive/confidential matters and information. The ability to multitask and work in a fast-paced work environment was applied.

Another job covered managing the worker compensation caseload, along with interviewing and preparing initial statements from members or insurance organizations. Other duties included maintaining client files and maintaining office supplies with great attention to detail. Detailed data entry was performed. Appointments for advisors and office manager were set. Medical payments were processed. Skills brought to the table involved adjusting claims, creating third party/worker compensation files and verifying third party member information. Third party liability/worker comp phone calls to attorney, members and insurance organizations were managed.

Could your organization use a data migration contractor who is knowledgeable in NetSuite and Epic with experience in a general hospital and medical centers? Technical proficiencies cover NetSuite and Epic. Educational background includes Bachelor of Arts in Communications.

Primary tasks of this data migration contractor involved setting up Epic sessions and working with business partners to verify applications or special programs on their computers. Key roles covered following up with business partners after the computers had been placed, to answer any questions with their new computer in updating inventory spreadsheets. The job consisted of handling data migration and assisting members of the staff with their computer moves and trouble tickets.

In other jobs, this individual created email databases, created mailing labels, letters and printed envelopes for mailing and providing assistance with any questions or issues with Microsoft Office. Challenges like maintaining wireless carts in the emergency department, replacing hard drives and RAM, in addition to reordering parts such as monitors, mice and motherboards were successfully completed. Re-imaging computers with the most up to date approved image and reissuing them to the business partners were other tasks. Functions involved replacing broken printers or cables, assisting in computer moves and responding to trouble Remedy tickets in a timely manner. Assistance was provided with reconciliation reports. The new shipment of computers was unpacked. Computers were imaged with the most up to date approved build. Working with business partners was done to verify all applications and special programs that they had on their computers.

How can your organization gain an advantage with the help of a data analyst who is skilled in QuickBooks with work background in a university hospital? Technical skills cover QuickBooks, SQL and Python. Educational attainment includes Bachelor’s in Computer Science with concentration in Database Technology. The individual is fluent in English, French & Arabic.

Main functions of this data analyst involved monitoring, analyzing and improving financial system operations for an assigned unit in the department (financial operations patient access, denial management). Operational studies were conducted, utilizing data collection and advanced unit knowledge to proactively troubleshoot problems and improve systems along with performance of the relating staff. Duties included reviewing and analyzing financial operations patient access or denial management errors, in addition to correcting processes appropriately. This individual coordinated the gathering, organizing demographic patient insurance and financial information to identify problems/ deficiencies.

One of the notable tasks included maintaining insurance sites tables/security administration, proving access to end users. Reports were created utilizing MS Office and SQL tools with data extracted via ad hoc and data warehouse. Performing the unit financial functions of a complex and specialized nature, requiring the application and interpretation of policies/ procedures was efficiently carried out. Any related financial policies/ procedure problems were corrected and improved. Advanced and current working knowledge of relating policies/ procedures was maintained. Area-specific support activities were performed, including technical lead and training duties of staff.