Must Have Technical/Functional Skills:
Roles & Responsibilities
ETL Methodologies: Extensively applied ETL concepts to support data extraction, transformation, and loading processes using Informatica PowerCenter.
ETL Job Design: Designed and developed PowerCenter ETL jobs to extract data from heterogeneous source systems and load into DB2 Data Marts.
Business Requirement Analysis: Collaborated with business analysts to understand processes and translate user requirements into optimized Data Mart solutions.
Transformations Expertise: Implemented complex data manipulations using Filter, Expression, Lookup, Aggregator, Joiner, Router, Rank, Sorter, Update Strategy, and Slowly Changing Dimensions (SCD).
Data Integration: Processed data from multiple source systems including relational databases and flat files, ensuring seamless integration.
SCD Type Implementation: Designed and implemented Slowly Changing Dimension Type methodology to maintain historical data accuracy.
ETL Mapping & Workflow Design: Created and optimized mappings in Informatica PowerCenter Designer using Source Analyzer, Mapplet Designer, and Mapping Designer; developed sessions and workflows in Workflow Manager to enable seamless data loading and monitored execution in Workflow Monitor for performance and reliability.
SQL & Database Expertise: Demonstrated strong proficiency in SQL queries, database design, and development; performed data processing, identified issues, and implemented solutions to ensure accuracy and efficiency across relational databases.
...Position Title : NATURAL DECOMPRESSION TECHNICIANLocation : MIDLAND, TXFLSA Class : NON-EXEMPTResponsible to : OPERATIONS MANAGERPosition... ...for the day-to-day operations and maintenance of natural gas treating and processing equipment including refrigeration, decompression...
Location: Oak West Health Ctr Primary Purpose: Responsible for the assessment of women's health education needs, presentation of appropriate educational materials, and evaluation... ...years of experience in health education, community outreach programs. Equivalent...
...and compassionate Licensed Mental Health Counselor to join our team at Aman Lee Behavioral Healthcare Unit. This full-time position offers the unique opportunity to work in a remote setting while providing essential mental health services to patients in a hospice center....
...Job Description Job Description Construction Project Coordinator (Contract-to-Hire) Robert Half is partnering with a growing and well-established... ...vendor coordination, compliance tracking, purchase order management, and bid support while working closely with Project...
...Job Description Job Description Housekeeping Attendant Oasis at the Keys Nursing and Rehab, an Assisted Living Facilities in Tavernier, Florida, is seeking a reliable and detail-oriented Housekeeping Attendant to join our team. As a Housekeeping Attendant, you...