Urgent Hiring _ Redshift Advisory/SME role _ Remote at Remote, Remote, USA |
Email: [email protected] |
Hello My name is Raj Priyadarshi and I am a Staffing Specialist at 1 Point System LLC. I am reaching out to you on an exciting job opportunity with one of our clients Redshift Advisory/SME role 12 months , with extensions Dallas, TX (must be local) 100% remote job No h1b We have a customer that is migrating from Teradata to RedShift. This opportunity is initially, a P/T hours role, so approx., 20 hours a week. Will likely increase to more hours once established. Also, we need someone willing to consider going FTE after 12 months. NO , we do not want them to, we want them to continue contracting, of course! But they must be willing to play the game and then at that time, when asked, say that they would prefer to continue contracting. The basics: Deep data warehousing experience doing large scale implementations and migrations Knowledge of Teradata (modeling, indexing, bteq, etc.) Experience with Ab Initio or similar ETL tools Redshift DW expertise SME level This is not a doer role, this is more of an advisory / architect / thought leadership role to help steer, guide, CHAMPION the customer around corners. A senior person that has done Legacy to Redshift migrations before and knows the pitfalls and problems that can and usually DO arise. Description As a technical advisor on the Teradata to Redshift cloud data migration project, consultant is to provide expertise and guidance throughout the entire migration process. Consultant will work under the direction of project leadership as part of the project team and will provide services including and related to the following: 1. **Architecture and Design:** Collaborate with the project team to design the optimal cloud architecture for data migration, ensuring alignment with best practices, security standards, and scalability requirements. Provide recommendations on data modeling, schema design, and performance optimization for Redshift. 2. **Technology Evaluation:** Assess and recommend appropriate tools, frameworks, and methodologies for data extraction, transformation, and loading (ETL) processes, considering factors such as data volume, complexity, and source format. 3. **Data Migration Strategy:** Advise on the migration strategy that outlines the approach for transferring data from Teradata to Redshift, including migration timelines, dependencies, and potential risks, while minimizing downtime and ensuring data consistency. 4. **ETL Pipeline Implementation:** Collaborate with data engineers to design and implement efficient ETL pipelines for data transformation and transfer. Ensure data quality, integrity, and compatibility during the migration process. 5. **Performance Optimization:** Advise on the monitoring and fine-tuning of Redshift performance to ensure optimal query execution, efficient resource utilization, and minimal latency. Recommend indexing, partitioning, and distribution strategies for improved data processing. 6. **Security and Compliance:** Work with the security team to establish robust data encryption, access controls, and auditing mechanisms within the Redshift environment. Ensure compliance with data protection regulations and industry standards. 7. **Testing and Validation:** Advise and consult the testing team on the planning and execution of thorough testing procedures to validate data accuracy, completeness, and consistency after migration. Help to identify and address any discrepancies or anomalies that may arise during the transition. 8. **Knowledge Transfer and Training:** Provide training and knowledge transfer to the internal team to help ensure they are equipped to manage and maintain the data platform post-migration. Share best practices for ongoing monitoring, troubleshooting, and performance optimization Thanks & Regards, Raj kumar Priyadarshi | Sr. Technical Recruiter | 1Point System LLC Office: 704-980-0625 Fax: 803-832-7973 [email protected] https://www.linkedin.com/in/raj-kumar-priyadarshi-961b2bb/ 115 Stone Village Drive Suite C Fort Mill, SC 29708 An E-Verified company | An Equal Opportunity Employer DISCLAIMER: If you have received this email in error or prefer not to receive such emails in the future, please notify by replying with a ''REMOVE'' in the subject line and your email address shall be removed immediately from the mailer list. -- Keywords: access management information technology South Carolina Texas |
[email protected] View all |
Tue Sep 12 03:23:00 UTC 2023 |