Solution Architect
TradeJobsWorkForce12214 Albany, NY, USFull-time
Solution Architect Job Duties: Responsible for assisting in the establishment of an IT Architect... Show more
Sr. Informatica ConsultantSligo Software Solutions • Menands, NY, United States
Sr. Informatica Consultant
Sligo Software Solutions • Menands, NY, United States
4 days ago
Job type
- Full-time
- Quick Apply
Job description
Description
Support the Data warehouse Informatica Powercenter ETL (Extract, Transform, Load) processes, Informatica administration, and redesign and implementation of current and future OMH projects.
Duties
- Analyze and translate patient health data business requirements into ETL code. This includes admission, discharge and day to day census records, financial, billing, human resource, payroll, Medicaid and Pharmacy data. Participate in Datawarehouse design and architecture planning, Using Kimball methodologies of Star schema design and Dimensional Data Modeling techniques.
- Collaborate with developers as a team lead in designing Informatica Powercenter ETL and database architecture using advanced data warehousing concepts.
- Extract and interpret Informatica Metadata repository data.
- Implement Fine Grain Access Control Audit (FGACA) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
- Analyze and code complex UNIX scripts to validate and FTP files and monitor Informatica workflows.
- Perform Informatica Administration including installation, patching and deployment of Informatica ETL code across all platforms.
Mandatory Requirements
- Experience (14+ Years)
- Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Requirements
- This is an 100% Onsite.
- 84 Months Experience using Informatica Powercenter 10.5.x or higher and Informatica Intelligent Data Management Cloud in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings.
- 84 Months Experience with Informatica Powercenter Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository optimization.
- 84 Months Experience analyzing and converting, heterogenous Health systems data, including admission, discharge, census, financial, billing, human resource, payroll, Medicaid and Pharmacy data into complex ETL code.
- 84 months Experience in relational data management disciplines and design and development using Oracle technologies including designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine grained Auditing (FGACA) in an Enterprise Data Warehouse environment to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
- 60 Months Experience working with UNIX and or LINUX Operating Systems.
- 60 Months Experience collaborating with developers as a team lead in designing Powercenter ETL and database architecture using advanced data warehousing concepts.
- Bachelor's degree in computer science, business intelligence, information science or related field.
- R sum
- Copy of Candidate Identification (i.e., driver's license and/or passport and Visa if applicable)
- Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Create a job alert for this search
Sr. Informatica Consultant • Menands, NY, United States
Similar jobs
Regional Integrated Content Manager, Latin America & GFG, J.P. Morgan Private Bank
JPMorgan ChaseAlbany, NY, United StatesFull-time
Regional Integrated Content Manager.Help shape a modern content capability that brings ideas to life.In this role, you will set editorial standards, establish governance, and build AI-enabled workf... Show more
IT Manager, Application and Business Intelligence
cb20 Managed IT & AV ServicesSaratoga Springs, NY, United StatesFull-time
IT Manager, Application and Business Intelligence.IT and Managed Services expertise and category-leading customer service.We partner with the world's leading hardware and software companies to deli... Show more
US ETF Platform Management - Senior Associate
ChaseAlbany, NY, United StatesFull-time
ETF Platform Management Associate.As an ETF Platform Management Associate within our ETF Platform team, you will partner with ETF Product Development, ETF Capital Markets, Investment Professionals/... Show more
Consultant
TradeJobsWorkForce12255 Albany, NY, USFull-time
Consultant Job Duties: Conducts research to understand how a company functions and ... Show more
Sr. Project Manager
KeyCorpAlbany, NY, United StatesFull-time
Location: 4910 Tiedeman Road, Brooklyn Ohio.Leads one or more cross functional IT project teams or workstreams on a program and ensures effective communication and collaboration among team members,... Show more
Asset Management - AMPX Reporting & Information Provision - Data Product Manager - Senior Associate
ChaseAlbany, NY, United StatesFull-time
Senior Associate, Data Product Manager.As a Senior Associate, Data Product Manager in the Asset Management Product and Experience (AMPX) team, you will play a key supporting role in high-visibility... Show more
Sr Grants Management Spec
University of RochesterAlbany, NY, United StatesFull-time
Director Of Grant Financial Management.As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better.Embedded in that ideal are the values we share: equity, l... Show more
Manager II, Engineering - Secure Compute Platform
ConfluentAlbany, NY, United StatesFull-time
Location: Remote, United StatesEmployment Type: FullTimeLocation Type: RemoteDepartment EngineeringCompensation: $252.K - $297K - Offers EquityAt Confluent, we are committed to providing competitiv... Show more
Sales Consultant
Victra - Verizon Wireless Premium RetailerAlbany, NY, United StatesPart-time
Are you a positive, upbeat, passionate, ambitious, and determined? One that thrives in a rapidly changing environment? Are you looking for an opportunity to work within a growing retailer and inspi... Show more
Information Technology Professional
US NavyTown of Colonie, NY, United StatesFull-time
Job Title: Information Technology Professional (IT/CTN/IS).Category / Component: Enlisted • Both.Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specialists keep... Show more
vCIO
redShiftSaratoga Springs, NY, United StatesFull-time
Are you a seasoned IT professional with a passion for helping businesses succeed through strategic technology planning and execution? We're seeking a vCIO to act as the primary technology consultan... Show more
Asset Management - AMPX Reporting & Information Provision - Data Product Manager - Senior Associate
JPMorgan ChaseAlbany, NY, United StatesFull-time
Senior Associate, Data Product Manager.As a Senior Associate, Data Product Manager in the Asset Management Product and Experience (AMPX) team, you will play a key supporting role in high-visibility... Show more
Sr Lead Product Manager - Network
Lumen IncAlbany, NY, United StatesFull-time
About LumenLumen connects the world.We are igniting business growth by connecting people, data and applications - quickly, securely, and effortlessly.Together, we are building a culture and company... Show more
Enterprise EOC Console Operator
CMA Consulting Services, IncAlbany, NY, United StatesFull-time
Position OverviewMonitoring batch processes for errors, timely initiation and successful completions.Monitor file transmissions for errors, timely initiation and successful completions.Monitoring t... Show more
Business Consultant
TradeJobsWorkForce12233 Albany, NY, USFull-time
Meeting with and advising senior executives throughout the consultation process.Determining business needs and identifying weaknesses.Assessing and analyzing business practices and procedures.Compi... Show more