ETL InfoSphere Specialist (Jobs in Columbus, OH)   Requirement id 119638 Job title Specialist Job location in Columbus, OH Skills required SQL, ETL, Informatica, InfoSphere Open Date 06-Oct-2021 Close Date Job type Contract Duration 8 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: SQL, ETL, Informatica, InfoSphere Description: Responsibilities Our client in Columbus Ohio is seeking a Data Warehouse / ETL / Informatica Cloud Specialist. CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR ABLE TO RELOCATE BY DAY ONE FOR CONSIDERATION. Our client is looking for a Data Warehouse / ETL / Informatica Cloud Specialist to support implementing/maintaining new cloud and on-premises Data Warehouse environments. This will include new Data Lake, Operational Data Store and Data Marts for Business Reporting on Snowflake, related AWS infrastructure, and on-premises data sources. Data sources will include a variety of Relational Databases and Semi-structured data. Both ETL and ELT jobs for on-premises and cloud environments will use a combination of technologies (Python, SQL, and DBT). Experience with Snowflake and DBT is a plus but not required. The position would continue through FY22, with the possible of continuation into FY23. Job Duties: Provide periodic on-call production support for on-premises and cloud environments, averaging 25% of weeks Integration of new technologies and workflows Work with Business and Data Analysts, Data Modelers, and potentially Business Customers, to verify requirements Follow design documents involving source and destination databases Interpret design documents to understand mapping and transformational requirements Design, develop and test ETL/ELT processes using DBT/SQL/Python to move data to/from relational and star-schema based data structures Optimize ETL/ELT processes to fit in a desired time frame Build batch flows with an Enterprise Batch Scheduler (e.g. Automic) Languages Must have English Native or bilingual proficiency Experience required Requirements: 10 or more years of experience in design, development, modification and testing of ETL processes 10 or more years of experience developing with SQL 10 or more years of experience building ETL processes using SQL/Python and/or ETL tool experience (such as DBT, Informatica, IBM InfoSphere, DataStage, Abenicio, Talend) 5 or more years of software development experience with Relational databases (i.e. Oracle, SQL Server, DB2, Vertica) 5 or more years of experience developing ETL processes against dimensional/star-schema based data structures including fact tables (commonly referred to as Kimball) Desired Skills: Experience developing and modifying ETL/ELT processes Experience with MPP Databases (Snowflake, RedShift, etc.) Experience with AWS Cloud Technologies Experience with development in Python Experience scheduling ETL processes Experience with Cognos/Tableau business intelligence tools Experience developing against normalized data structures (commonly referred to as Inmon) Knowledge of property and casualty insurance systems and/or Medical industry processing Knowledge of Ohio business model and processes Experience using SQL development tools Experience with Red Hat Enterprise Linux Experience developing and modifying scripts in a Windows environment Experience in measuring/tuning performance of batch systems in a Windows environment Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, MS Teams)   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 119638 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), SQL job openings in Columbus, OH Jobs List Business Analyst (IT) III Senior - 20230407090751 Create date: 07-Apr-2023 Start date :4/28/2023 End Date :8+Months from the start date Submission deadline :04-14-2023 Note: * Job Site On-Site Description : Huntington Bank is seeking a passionate, data-savvy Analyst to join the Enterprise Analytics team to fuel our mission of growth through data-driven insights and opp.... (This job is for - Python Jobs in OH Columbus Analyst - (in Columbus, OH)) COM-Programmer 5 / PR5 (679101) Create date: 28-Mar-2022 Start Date : 04/11/2022 End Date : 06/30/2022 Submission Deadline : 03/31/2022 Client Info: Note: * Agency Interview Type: Requirement Description: The candidate will be supporting The Ohio Department of Commerces Liquor Permitting Modernization project. .... (This job is for - ASPNet MVC Jobs in OH Columbus Consultant - (in Columbus, OH)) Test Lead - 59346 Create date: 07-Feb-2022 Description: Responsibilities Our client in Columbus Ohio is seeking a Test Lead for a contract role. Candidates must be local to central Ohio or relocated by day one for consideration. Top skills required for the Test Lead: Bachelors degree in Computer Science, Information Technology, Comp.... (This job is for - TOAD Jobs in OH Columbus Consultant - (in Columbus, OH)) Azure Developer - 59335 Create date: 02-Feb-2022 Description: Responsibilities Our client in Columbus Ohio is seeking an Azure Developer. Candidates must be local to central Ohio or relocated by day one for consideration. Top skills required for the Azure Developer: Bachelors degree in an appropriate field of study like Computer Science, .... (This job is for - Azure Jobs in OH Columbus Developer - (in Columbus, OH)) Database Administrator - 59320 Create date: 31-Jan-2022 Description: Responsibilities Our client in Columbus Ohio is seeking a Database Administrator for a contract position. Candidates must be local to central Ohio or relocated by day one for consideration. Top skills required for the Database Administrator: Bachelors degree in an appropriate f.... (This job is for - job Jobs in OH Columbus Administrator - (in Columbus, OH))    SQL job openings in other states Jobs List Data Warehouse Developer II -129094 Create date: 11-Apr-2024 start date : 05/13/2024 End date : 06/30/2024 submission deadline :4/18/2023 4:00PM CST. client info : DPI Note: * Interview Process: Microsoft Team, 1 round, with audio and video on, also be prepared to share your screen. Additional interviews are possible. * Duration: Until Ju.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) NC DIT-DATA-Business Analyst- Expert (721283) Create date: 29-Sep-2023 Hybrid start date :10/02/2023 End date :10/01/2024 submission deadline :10/02/2023 client info :NCDIT Description : The Department of Information Technology (DIT) serves as the Technology Center for the State of NC. Services that DIT p.... (This job is for - Analytical Skills Jobs in NC Raleigh Expert - (in Raleigh, NC)) Programmer 5 - 119294 - SP Create date: 19-Jun-2023 Start date : 07/10/2023 End Date : 1 Years from projected start date Submission deadline : 6/23 at 10am EST. Client Info : Note: * Interviews: In-Person ONLY * Duration:1 year to start with extension likely. Long term position. * Position location: Lansing, MI CANDIDATES MUST BE LO.... (This job is for - job Jobs in MI Lansing Consultant - (in Lansing, MI)) Programmer/Developer - 60912 Create date: 16-Jun-2023 Start date : 06/24/2023 End Date :06/06/2024 Submission deadline :06/24/2023 Client Info : CT DCF Note: * Position Location Hybrid Description : The candidate will serve in the capacity of an application COBOL/DB2 developer. Participating in various SDLC processes including requirem.... (This job is for - Cobol Jobs in CT Hartford Developer - (in Hartford, CT)) Business Systems Consultant III - 60911 Create date: 16-Jun-2023 Start date :07/24/2023 End Date :12/31/2023 Submission deadline : 06/21/2023 Client Info :OSL Note: * Position Location Remote Description : Full-time professional Information Technology Project Development work experience and/or Function/Business Process Analysis work exper.... (This job is for - job Jobs in OR Salem Consultant - (in Salem, OR))    SQL job openings in OH Jobs List Sr. Data Engineer, Digital Services - 72629 Create date: 04-Mar-2021 Candidate must be our W2 Employee. Job Description: Client is the nations 2nd largest IT Staffing organization, has an immediate and exciting opportunity for a Data Engineer at a Fortune Global 500 healthcare services company in Columbus, Ohio. Location: Columbus, OH. Will be able to work remotely initially due to C.... (This job is for - Python Perl Jobs in OH Dublin Engineer - (in Dublin, OH)) UAT Tester - 71347 Create date: 28-Jan-2021 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description: The highly experienced quality professional who works under supervision , learns quickly , and brings ideas and passion to their daily responsibilities and executes work to completion with excellence in.... (This job is for - job Jobs in OH BlueAsh Tester - (in BLUE ASH, OH)) Data Engineer - 71115 Create date: 21-Jan-2021 Candidate must be our W2 Employee. Candidate must be local: Yes Job Description: Job Title: Data Engineer Location: Columbus, OH (Remote to start, eventually on-site in Columbus) Contract: Long term contract Required skills: Adept with relational databases: E.... (This job is for - OLTP Jobs in OH Gahanna Engineer - (in Gahanna, OH)) DevOps Engineer (DMP) - 69981 Create date: 07-Dec-2020 Candidate must be our W2 Employee. Job Description Accountable for developing and delivering technological responses to targeted business outcomes. Analyze, design and develop enterprise data and information architecture deliverables, focusing on data as an asset for the enterprise. Understand and follow reusable standards, de.... (This job is for - Azure Jobs in OH Cincinnati Engineer - (in Cincinnati, OH)) DMP Data Engineer - 69913 Create date: 04-Dec-2020 Candidate must be our W2 Employee. Job Description : The Kroger team is looking for a Data Engineer experienced in implementing data solutions in Azure. The Data Engineer will analyze, design and develop enterprise data and information architecture deliverables, focusing on data as an asset for the enterprise. The Data Engine.... (This job is for - AzureCI CD Jobs in OH BlueAsh Engineer - (in BLUE ASH, OH)) (Specialist: SQL, ETL, Informatica, InfoSphere in Columbus, OH)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)