Tri-Force Consulting Services, Inc.
Data Integration Specialist
Tri-Force Consulting Services, Inc., Phila, Pennsylvania, United States, 19117
Job DescriptionJob Title:
Data Integration Specialist
Duration:
06 Months
Client:
City of Philadelphia
Location:
Philadelphia, PA
Note: This is a hybrid position, and
onsite or virtual interviews are acceptable.
"The applicant is at the heart of our universe."
Job Description:
We are seeking a skilled and experienced Data Integration Specialist for a temporary assignment to join our dynamic team.This position will be responsible for the migration, integration, and maintenance of data within Amazon S3 and Amazon Redshift environments.This position will also be responsible for ensuring data integrity and security throughout the entire process, from initial migration to continuous data operations.This position requires 3 or more years of experience working as a Data Integration Specialist.Design and implement data pipelines to extract, transform and load data (ETL and/or ELT) into Amazon S3 using Azure Data Factory and other toolsSet up automated workflows to ensure continuous data migrationConfigure Amazon S3 buckets for data storageSet up data schemas and tables in Amazon RedshiftMigrate cleaned and pre processed data into Amazon S3 and RedshiftEnsure data integrity and security during migrationMonitor data pipelines for performance and reliabilityPerform regular maintenance to address any issuesImprove data integration processes for increased efficiency and scalabilityDocument data integration processes and proceduresRequired Skills:
Experience with various cloud platformsProficient with Azure Data FactoryStrong knowledge of Amazon AWS S3, AWS Redshift and AWS LambdaProficient in SQL and ETL toolsEffective communication and documentation abilitiesExpertise in data security and integrity measuresExcellent problem-solving and analytical skills3 years of experience creating, documenting, implementing, and maintaining data pipelinesHighly Desired/Preferred
Experience using AWS GlueProficient with Python, C# and spark SQL
"If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit."
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.
Data Integration Specialist
Duration:
06 Months
Client:
City of Philadelphia
Location:
Philadelphia, PA
Note: This is a hybrid position, and
onsite or virtual interviews are acceptable.
"The applicant is at the heart of our universe."
Job Description:
We are seeking a skilled and experienced Data Integration Specialist for a temporary assignment to join our dynamic team.This position will be responsible for the migration, integration, and maintenance of data within Amazon S3 and Amazon Redshift environments.This position will also be responsible for ensuring data integrity and security throughout the entire process, from initial migration to continuous data operations.This position requires 3 or more years of experience working as a Data Integration Specialist.Design and implement data pipelines to extract, transform and load data (ETL and/or ELT) into Amazon S3 using Azure Data Factory and other toolsSet up automated workflows to ensure continuous data migrationConfigure Amazon S3 buckets for data storageSet up data schemas and tables in Amazon RedshiftMigrate cleaned and pre processed data into Amazon S3 and RedshiftEnsure data integrity and security during migrationMonitor data pipelines for performance and reliabilityPerform regular maintenance to address any issuesImprove data integration processes for increased efficiency and scalabilityDocument data integration processes and proceduresRequired Skills:
Experience with various cloud platformsProficient with Azure Data FactoryStrong knowledge of Amazon AWS S3, AWS Redshift and AWS LambdaProficient in SQL and ETL toolsEffective communication and documentation abilitiesExpertise in data security and integrity measuresExcellent problem-solving and analytical skills3 years of experience creating, documenting, implementing, and maintaining data pipelinesHighly Desired/Preferred
Experience using AWS GlueProficient with Python, C# and spark SQL
"If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit."
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.