ER/Studio TOAD Data Analysis ETL Sql Developer User Requirements Business Requiremen   Requirement id 109470 Job title Developer Job location in Albany, NY Skills required ER/Studio, TOAD, Data Warehouse Development, Data Analysis ETL Sql Developer User Req Open Date 21-Aug-2020 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type Phone Screen and Face to Face interview    Email Recruiter: coolsoft Job Description Developer: ER/Studio, TOAD, Data Warehouse Development, Data Analysis ETL Sql Developer User Req Note: * On-site/Remote: On-site * Interview: Phone or video call * All responses must be received by Monday, 8/24/20 by 2PM. * Candidate must be on your direct W2, can not work with layers. * This is NOT AN HBITS JOB-No form 2 skillsheet to fill out. * Job is remote for now. * Candidate must have Informatica and ER Studio Requirements Years of work experience: 3 year(s) Responsibilities Are you an expert in an industry vertical or specific technology? Then you should contact us! We have a project with our client in Albany, NY that requires a Senior Data Warehouse Developer This position will be integrating data from the NYS Office of Court Administrations Universal Case Management System (UCMS), into OASAS Data Warehouse application. Minimum Qualifications: A Bachelors degree with a minimum of 4 years of professional experience in a substance use disorder, health, or mental health area as described below. A Masters degree or J.D. with 3 years of noted professional experience; or a doctorate with 2 years of noted professional experience. Data Warehouse Modeling Duties and Qualifications: Review and evaluate user requirements and processes to create data models that align with business requirements. Create data models using various tools such as ER Studio, TOAD and SQL Developer. Perform data analysis/profiling and creating logical data mapping in conjunction with Extract/Transform/Load (ETL) developers. Conduct data model reviews with Extract/Transform/Load (ETL) developers & technical lead. Develop and implement comprehensive documentation & test plans to ensure that data models are accurately designed, tested, and debugged. Document & submit ITSM tickets to support system migration & implementation. Participate in team meetings to determine software application needs and implement the same into a functional design. Participate in troubleshooting & diagnosing data anomalies. ETL Developing Duties and Qualifications: Designing data mappings to perform Extract/Transform/Load (ETL) of heterogeneous source applications including ORACLE and flat files using Informatica PowerCenter Participate in data model reviews with data modeler & technical lead. Develop, implement, and maintain ETL code based on data models developed to support business features. Coordinate with technical lead to analyze business requirements, develop technical specifications, and design ETL modules. Troubleshoot and diagnose issues related to Informatica Production MDM data loads and transformations. Document & submit ITSM tickets to support system migration & implementation. Participate in team meetings to determine software application needs and implement the same into a functional design Other Apps Experience: Experience in Oracle 10g or 11g utilizing JDeveloper or similar tool Experience in Oracle PL/SQL development utilizing J Developer, Toad and/or Oracle SQL Developer Experience in Unix shell script development Strong Analytical and Troubleshooting skills Team Player Preferred Qualifications: Demonstrated experience implementing projects of similar size and complexity is desirable, including examples of projects and references who can speak to the success of those projects. Candidates should have strong project management, writing, and oral communication skills. Ability to work cooperatively with diverse stakeholders; and ability to work independently and as part of a team. Ability to adapt to a fast-paced work environment with changing needs and priorities. Proficiency in Microsoft Exce   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 109470 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),    ER/Studio job openings in other states Jobs List Systems Analyst Lead - IT - 53032 Create date: 20-Sep-2019 Candidate must be our W2 Employee We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description: Come join the Starbucks Enterprise Information Architecture Team (EIA)! We are building new experiences for our customers. Supporting the emerging information architecture team you will be working to .... (This job is for - ER Studio Data Architect Jobs in WA Seattle Consultant - (in Seattle, WA))     (Developer: ER/Studio, TOAD, Data Warehouse Development, Data Analysis ETL Sql Developer User Req in Albany, NY)

Featured Jobs AWS .NET FRAMEWORK UI CSS Tester (Jobs in Little Rock, Arkansas) Microsoft Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Nashville, Tennessee) Written Specialist (Jobs in Salem, Oregon) VLAN Subnets Routing Engineer (Jobs in Staunton, Virginia) Training Specialist (Jobs in Atlanta, Georgia) Adobe Analyst (Jobs in Jackson, Mississippi) MS Office EHR Consultant (Jobs in Richmond, Virginia) Information Manager (Jobs in Madison, Wisconsin) Jira UFT Defect Tester (Jobs in Raleigh, North Carolina)