TAA Solutions, LLC ยท 1 day ago
ETL/Data Warehouse Developer
United States
Full-time
Remote
Senior Level, Lead/Staff
$62.59/hr - $62.59/hr
8+ years exp
Maximize your interview chancesConsultingFinancial Services
Insider Connection @TAA Solutions, LLC
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Analyze existing PeopleSoft data structures and confirm transformations for Data Warehouse compatibility.
Extract data from PeopleSoft using SQL and other relevant tools.
Create efficient data structures, including expertise in dimensional and entity-relationship (ER) modeling, to support reporting and analytics.
Develop and implement data transformation processes to clean, standardize, and enhance data quality during migration.
Design data mapping documents outlining relationships between source and target data fields.
Develop and implement ETL processes for loading data into the Data Warehouse, ensuring efficient performance and data integrity.
Validate the accuracy and completeness of migrated data post-migration.
Utilize ETL tools to facilitate data integration.
Collaborate with business analysts, data architects, and stakeholders to understand data requirements and align with business objectives.
Ensure compliance with data governance, security protocols, and regulations, including encryption and data masking for PII and HIPAA compliance.
Recommend and analyze the feasibility of cloud-based Data Warehousing solutions.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
At least 8 years of relevant experience in data migration, ETL processes, and data integration.
Minimum of 5 years of experience in data migration projects, specifically from PeopleSoft to a cloud-based Data Warehouse system.
Strong proficiency in SQL for data extraction and manipulation.
Extensive experience with ETL tools and data integration techniques.
Familiarity with databases such as Oracle, SQL Server, Sybase, Informix, and DB2.
Deep understanding of data warehousing concepts, data modeling, and reporting tools.
Preferred
Experience with cloud-based Data Warehouse solutions, including Oracle FDIP, Snowflake, Amazon Redshift, or Google BigQuery.
Relevant certifications in data management or ETL tools are highly desirable.
Company
TAA Solutions, LLC
TAA Solutions, LLC is a fast growing company, providing a full spectrum of IT services for global organizations through operations in USA and other parts of the Globe with a team of motivated consultants on a needed basis.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase
