Database Architect

Oak Tree Software; City of Albany (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

Oak Tree Software in Albany, NY is seeking an experienced Oracle/ETL engineer for a 30-month onsite engagement. You will work with Oracle data warehouses, data marts and OLTP systems, guiding the ETL team and shaping Informatica/Rhapsody architectures to ensure data integrity.

Required 84 months in SQL/PL/SQL with Oracle 12c+, experience with Informatica Power Center and Rhapsody, and a PMP certification. Eligible candidates must be USC/GC. Pay is $65/hour on W2, onsite from day one.

Qualifications

• 7+ years SQL/PL/SQL with Oracle 12c+
• 7+ years developing Informatica mappings
• 7+ years building Rhapsody routes
• 7+ years in data warehousing/ETL environments
• 7+ years with Informatica Data Quality 8.x+
• 7+ years performing system testing (unit/integration/load)
• 5+ years in government IT projects
• Project Management Professional Certification

Responsibilities

• Working with Oracle data warehouses, data marts and OLTP databases.
• Overseeing the creation/modification of Oracle database tables for the situation.
• Writing/executing SQL for querying Oracle databases and Informatica Metadata Repository for validating testing and investigating issues.
• Guiding the ETL team in development and monitoring ETL processes and test plans using Informatica Power Center and Rhapsody.
• Guiding the ETL team in shaping and recommending best practices to Informatica/Rhapsody architecture.
• Investigating and resolving data loading and data integrity issues.
• Performance tuning Informatica/Rhapsody workflows.
• Using Informatica/Rhapsody to develop ETL mappings and workflows including mapplets, reusable transformations and worklets.

Job description

Duration: 30 Months

Role Type: Onsite from day 1

Location: Albany, NY 12226

Pay Rate: $65.00/hour on W2.

Eligibility : (USC & GC only, No C2C)

Description:

• Working with 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 Center 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.

Mandatory Qualification:

• Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 Months Experience writing SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
• 84 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
• 84 Months Experience working with Health Data with HIPAA, HL7 or similar standards
• 60 months experience developing project timelines, gathering and documenting business requirements
• 48 Months experience in programming public sector government IT projects.
• Project Management Professional Certification