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 I -136603 Create date: 23-Oct-2024 No of Submissions : 1 start date : 11/18/2024 End date : 06/30/2025 submission deadline : 10/25 at 4 CST. client info : DPI Note: * Interview Process: Via Teams * Duration: Till June 30, 2025, with possibility of extension * Onsite or Remote: Candidate must.... (This job is for - Data Warehousing Jobs in WI Madison Developer - (in Madison, WI)) Programmer Analyst 6 - 135098 Create date: 17-Sep-2024 No of Submissions : 1 Start date : 10/21/2024 End Date : 1 Years from projected start date Submission deadline : 9/24 at 10AM EST. Client Info : LARA Note: * Interviews: 1st round interviews will be held via MS Teams. 2nr round interviews may be held in person, so candidates must b.... (This job is for - JavaScript Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDPI - SQL/Snowflake-Tableau Analyst - Senior (746385) Create date: 09-Sep-2024 No of Submissions : 2 Start date : 09/16/2024 End Date : 09/15/2025 Submission deadline : 09/13/2024 Client Info : NCDPI Note: * Agency Interview Type : In Person Only * Onsite Description : Currently, the enterprise is a complex, multi-platform data.... (This job is for - SnowflakeDB2 Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Senior Quality Assurance Specialist - 134717 Create date: 04-Sep-2024 No of Submissions : 1 Start date : 10/1/2024 End Date : 10/1/2027 Submission deadline : 9/11/2024 3:00:00 PM Client Info : MDHS Note: * No max bill rate * Onsite Required * Do not submit remote/hybrid candidates, MDHS does not make exceptions to this rule and .... (This job is for - Visio Jobs in MS Jackson Specialist - (in Jackson, MS)) Technical Specialist IV - B36991W112 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote * Candidate must be local or willin.... (This job is for - job Jobs in OR Salem Specialist - (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 Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)