SQL Experience Relational Database Unix Shell Scripting Powerpoint Word And Excel   Requirement id 114299 Job title Expert Job location in Columbus, OH Skills required Data Integration, Develop Procedures, ETL Design And Documentation, SQL Experience Relational Database Unix Open Date 23-Feb-2021 Close Date Job type Contract Duration 4 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Expert: Data Integration, Develop Procedures, ETL Design And Documentation, SQL Experience Relational Database Unix Job industry: Public Sector and Government On-site/Remote: On-site Responsibilities Our Client in Columbus, Ohio is seeking an experienced Sr Enterprise Data Warehouse Manager CANDIDATES MUST BE LOCAL TO CENTRAL OHIO FOR CONSIDERATION Will be responsible for Client Enterprise data warehouse design, development, implementation, migration, maintenance and operation activities. The candidate will work closely with Data Governance and Analytics team. Will be one of the key technical resource for data warehouse projects for various Enterprise data warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics and exchange with Client partners. This position is a member of ITS and works closely with the Business Intelligence & Data Analytics team. Responsibilities: Participate in Team activities, Design discussions, Stand up meetings and planning Review with team. Perform data analysis, data profiling, data quality and data ingestion in various layers using Database queries, Informatica PowerCenter, Informatica Analyst score cards, Pyspark programs and UNIX shell scripts. Follow the organization coding standard document, Create mappings, sessions and workflows as per the mapping specification document. Updating the production support Run book, Control M schedule document as per the production release. Create and update design documents, provide detail description about workflows after every production release. Continuously monitor the production data loads, fix the issues, update the tracker document with the issues, Identify the performance issues. Performance tuning long running ETL jobs by creating partitions, enabling bulk load, increasing commit interval and other standard approaches. Perform Quality assurance check, Reconciliation post data loads and communicate to vendor for receiving fixed data. Participate in ETL code review and design re-usable frameworks. Create Pyspark programs to ingest historical and incremental data. Create SQOOP scripts to ingest historical data from EDW oracle database to Hadoop IOP, created HIVE tables and Impala views creation scripts for Dimension tables. Writing complex SQL queries and performed tuning based on the explain plan results. Extract unstructured and semi-structured data using data processor transformation in IDQ. Participate in meetings to continuously upgrade the Functional and technical expertise. REQUIRED Skill Sets: 8+ years of experience with Informatica Power Center on Data Warehousing or Data Integration projects Proven ability to write high quality code 7+ years of experience with Expertise implementing complex ETL logic 3+ years of experience Develop and enforce strong reconciliation process Accountable for ETL design documentation 5+ years of Strong SQL experience (prefer Oracle) 5+ years of Good knowledge of relational database, data vault and dimensional model design 3+ years of Basic knowledge of UNIX/LINUX shell scripting Utilize ETL standards and practices towards establishing and following centralized metadata repository Computer literacy with Excel, PowerPoint, Word, etc. Effective communication, presentation, & organizational skills Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision Required Education: BS/BA degree or combination of education & experience Familiar with Project Management methodologies like Waterfall and Agile Perform other duties as assigned Analysis, Design, development, support and Enhancements of ETL/ELT in data warehouse environment with Cloudera Bigdata Technolog   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114299 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Data Integration job openings in Columbus, OH Jobs List Sr. Data Warehouse Designer - 57812 Create date: 23-Feb-2021 Job industry: Public Sector and Government On-site/Remote: On-site Description: Responsibilities Our Client in Columbus, Ohio is seeking a Sr. Data Warehouse Designer / Developer CANDIDATES MUST BE LOCAL TO CENTRAL OHIO FOR CONSIDERATION The Sr Developer/ Designer w.... (This job is for - Analysis Jobs in OH Columbus DBA - (in Columbus, OH)) Data Analyst - 53868 Create date: 24-Jul-2019 Description: Data Analyst. A Data Analystwith the following skill set is needed for a contract role with our direct client: 5 years of data integration development and engineering experience 4 years of SQL development / scripting 3 years of Bash development / scripting 2 years of PL/SQL developme.... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH)) Requirements Analyst - 7568 Create date: 18-Sep-2017 Requirements Analyst to support a Data line in the ITBSA. Standard RA skills and knowledge of tools and processes; Technical background with exposure to data integration concepts and relational concepts desired. (This job is for - Jobs in OH Columbus Analyst - (in Columbus, OH)) Data Analyst -6302 Create date: 16-May-2017 Our direct client is in need of a Data Analyst for their Columbus, OH location. The candidate will evaluate information from multiple sources, provide recommendations, reconcile conflicts, clean data into a consumable format and classify the information into logical categories. Responsibilities: Uses visualization techni.... (This job is for - Web Services Jobs in OH Columbus Analyst - (in Columbus, OH)) Data Architect - 6245 Create date: 09-May-2017 This role is for a DA that will be assigned to a modernization program at the client. The role will service project architecture delivery associated with the connections work stream for the program. Qualifications: Data integration, modern data architecture (hadoop, nosql, self service data access/prep) are preferred. Hadoop Jobs in OH Columbus Architect - (in Columbus, OH))    Data Integration job openings in other states Jobs List VDOT Sr Oracle Database Developer (725963) Create date: 03-Jan-2024 Hybrid start date :01/16/2024 End date :06/30/2024 submission deadline : 1/9/2024 client info : VDOT Description : *Local Richmond candidates due to onsite work requirement *ONSITE interviews only *Candidates must be willing an.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) NCDWS Business Analyst- Expert (716437) Create date: 04-Aug-2023 Hybrid Start date :08/18/2023 End Date :08/17/2024 Submission deadline :08/04/2023 Client Info :NCDWS Description : ------------------------------------------------------ The RESEA/EAI Business Analyst will take the lead in working with our partner agency to restart our process that r.... (This job is for - job Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Data Warehouse Developer III -118230-SP Create date: 17-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline :May 19th at 4:00PM CST Client Info : Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortly after .... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III -118228-SP Create date: 17-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline :May 19th at 4:00PM CST. Client Info : Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortly after.... (This job is for - Jobs in WI Madison Developer - (in Madison, WI)) Business Intel Technical Lead IV - 111390 - SP Create date: 09-Nov-2022 start date:11/21/2022 End date:06/30/2023 submission deadline:11/11/22 at 4:00PM CST client info : UW - Madison Note: * Interview Process: Remote, Microsoft Teams * Duration: 2 year contract with possible renewal of 1 year. * Onsite or Remote: Fully remote * Addit.... (This job is for - Business IntelligenceAWS Jobs in WI Madison TechLead - (in Madison, WI))     (Expert: Data Integration, Develop Procedures, ETL Design And Documentation, SQL Experience Relational Database Unix in Columbus, OH)

Featured Jobs IT Specialist (Jobs in Raleigh, North Carolina) IT Specialist (Jobs in Raleigh, North Carolina) Systems Specialist (Jobs in Raleigh, North Carolina) Functional Analyst (Jobs in Madison, Wisconsin) Biztalk PowerShell XSLT Developer (Jobs in Hartford, Connecticut) DFS DHCP Active Engineer (Jobs in Madison, Wisconsin) Team Developer (Jobs in Hartford, Connecticut) Quality Assurance Ms Consultant (Jobs in Durham, North Carolina) PMP PMI Agile Manager (Jobs in Richmond, Virginia) TSQL Specialist (Jobs in Raleigh, North Carolina)