Database Architect
3 weeks ago
- Working with large and complex Oracle data warehouses, data marts and OLTP databases.
- Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation.
- Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
- Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Centre and Rhapsody.
- Guiding the ETL team in shaping, enhancing, and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture
- Investigating and resolving difficult design and build issues, data loading and data integrity issues.
- Performance tuning Informatica/Rhapsody workflows.
- Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets."
Required Skills:
- 84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings.
- 48 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring, and managing millions of records of data including XML and HL7 message formats.
- 84 Months Experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings.
- 84 Months Experience with Informatica Data Quality 8.x or higher, including 10.2, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match, and merge.
- 84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.
- 72 Months Experience working with Health Data with HIPAA, HL7 or similar standards.
-
Database Architect- Expert
2 weeks ago
Albany, United States Mindlance Full timeProvide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...
-
Database Architect- Expert
4 days ago
Albany, United States Mindlance Full timeProvide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...
-
Database Architect/Developer
1 day ago
Albany, United States Empire State Full time*Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements. Applicant must possess a...
-
Database Architect/Developer
4 weeks ago
Albany, United States Empire State Full timeJob DescriptionJob Description*Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements....
-
Database Administrator
1 day ago
Albany, United States Absolute Staffing & Consulting Solutions Full timeAbsolute Staffing is searching for a Database Administrator to work with our client. Location: Albany, NY (12207) Duration: 24 Months Job Description: 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. 84 months of Experience designing and...
-
Software Architect
2 weeks ago
Albany, United States Five Cubes, Inc. Full timeJob Title: Software Architect - 13184 Location: Albany, NY Duration: 30 Months Direct ClientJob Description: Daily Tasks include but not limited to the following: Evaluate existing and emerging technology, business requirements for the purpose of architecting efficient, portable and scalable solutions. Analysis, modeling, design, coding, testing and...
-
Software Architect Expert
4 days ago
Albany, United States Cedar Park Group Full timeCedar Park Group is looking for an Expert Software Architect. Full-time. 8:30am-5:00pm 30 month contract. Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system. Day-to-day Tasks: Analysis of...
-
Java / JEE Architect
3 weeks ago
Albany, United States Trigyn Technologies Full timeJob Description: Trigyn's direct government client has an immediate need for a Java / JEE Architect in Albany, NY. Description: The consultant will design and assist with the implementation of both small and large-scale software systems. The Software Architect will design, develop, implement, support, and enhance, custom applications written in...
-
Technical Solution Architect
7 days ago
Albany, United States Omtech llc Full timeJob DescriptionJob DescriptionJob description:As a Technical Solution Architect, you'll be responsible for designing and overseeing the implementation of technical solutions that meet business needs while adhering to all policies and standards. You'll collaborate with cross-functional teams to analyze requirements, architect solutions, and ensure...
-
Technical Solution Architect
2 weeks ago
Albany, United States Omtech llc Full timeJob DescriptionJob DescriptionJob description:As a Technical Solution Architect, you'll be responsible for designing and overseeing the implementation of technical solutions that meet business needs while adhering to all policies and standards. You'll collaborate with cross-functional teams to analyze requirements, architect solutions, and ensure...
-
Technical Solution Architect
7 days ago
Albany, United States Docstrats Full timeJob Description Technical Solution Architect Location: Albany OR NYC - Hybrid - The consultant will be expected to work onsite 50%. The remainer will be remote or traveling. Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately. Required Job Duties: • Design end-to-end technical solutions that address...
-
Technical Solution Architect
6 days ago
Albany, United States Experienced Recruiting Partners Full timeJob DescriptionJob DescriptionContract roleLocation: Albany, NY Hybrid – The consultant will be expected to work onsite 50%. The remainder will be remote or traveling.Travel: Approximately 20-50%. This could vary based on client need. Length: currently until 7/30/2025Overview:As a Technical Solution Architect, you'll be responsible for designing and...
-
Technical Solution Architect
2 weeks ago
Albany, United States Experienced Recruiting Partners Full timeJob DescriptionJob DescriptionContract roleLocation: Albany, NY Hybrid – The consultant will be expected to work onsite 50%. The remainder will be remote or traveling.Travel: Approximately 20-50%. This could vary based on client need. Length: currently until 7/30/2025Overview:As a Technical Solution Architect, you'll be responsible for designing and...
-
Technical Solution Architect
2 weeks ago
Albany, United States Themesoft Inc. Full timeTechnical Solution ArchitectLocation: Albany OR NYC – Hybrid – The consultant will be expected to work onsite 50%. The Remainer will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately.Required Job Duties:Design end-to-end technical solutions that address business requirements...
-
Technical Solution Architect
2 weeks ago
Albany, United States Themesoft Inc. Full timeTechnical Solution ArchitectLocation: Albany OR NYC – Hybrid – The consultant will be expected to work onsite 50%. The Remainer will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately.Required Job Duties:Design end-to-end technical solutions that address business requirements...
-
Technical Solution Architect
2 weeks ago
Albany, United States Themesoft Inc. Full timeTechnical Solution ArchitectLocation: Albany OR NYC – Hybrid – The consultant will be expected to work onsite 50%. The Remainer will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately.Required Job Duties:Design end-to-end technical solutions that address business requirements...
-
Java Architect in Albany NY
3 days ago
Albany, United States INA Solution Inc Full timeJob DescriptionJob DescriptionPosition: Software ArchitectLocation: Albany NY (Onsite/Hybrid)Duration: Long-TermShift: M-F 8.5-hour days (time ranging from 8:00 am-6:00 pm)Job QualificationsMakes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or...
-
Technical Solution Architect
6 days ago
Albany, United States Software People, Inc. Full timeJob DescriptionJob DescriptionPhone/Skype Hire. Onsite from day 1 Location: Albany, NYDuration: 12 - 24+ months (High Possibility of Further Extensions)ResponsibilitiesDesign end-to-end technical solutions that address business requirements and align with architecture principles and standards. Develop solution architectures, technical specifications, and...
-
Technical Solution Architect
1 week ago
Albany, United States Software People, Inc. Full timeJob DescriptionJob DescriptionPhone/Skype Hire. Onsite from day 1 Location: Albany, NYDuration: 12 - 24+ months (High Possibility of Further Extensions)ResponsibilitiesDesign end-to-end technical solutions that address business requirements and align with architecture principles and standards. Develop solution architectures, technical specifications, and...
-
Software Architect
2 weeks ago
Albany, United States PamTen Full timeImplement Integrated Justice Portal standards related to application technologies, including UI standards, development methodology, and coding and style guides. • Act as the primary technical liaison with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance. • Work with the...