| DBA or DBE- Data Migration Specialist at Irving, Texas, USA |
| Email: [email protected] |
| From: Vanitha Mani, Themesoft [email protected] Reply to: [email protected] Hi I hope you are having a great day. Happy New Year 2024! This is Vanitha, working as a Technical Recruiter with Themesoft Inc, a national staffing agency. I have shared the requirement details below for you. It would be great If I get a chance to connect with you and share more information about the job. If interested, please let me know a good time and number to reach out to you and I will be glad to explain more on this job. We are Hiring DBA/DBE- Data Migration Specialist Role- DBA/DBE- Data Migration Specialist Location - Irving, TX (onsite) DBA/DBE Primary Skill Apache Tomcat, BIZTALK, CFI/MFT, DB2, Informix DBA, Middleware, MongoDB, MySQL, NGNIX, Oracle DBA, Oracle PL/SQL, Postgres, SQL DBA, Weblogic Administration, WebSphere Specialization Database & Middleware Support: Associate Engineer, Applications & Platforms Job requirement As a consultant within the DI team, you will work with our clients to define their digital strategy and execution roadmap, and design and implement differentiated digital solutions to help deliver measurable value. Your responsibilities in this role will include: Primary Skill: Oracle and PostgreSQL Database: Creation of Views, Materialized views and wrote PL/SQL Procedures, Functions, Triggers and Packages in Oracle Database. Development of highly complex yet optimized and performance-oriented queries to extract data from PostgreSQL to Flat Files. Performance tuning of very complex queries which includes joins and aggregate functions. SQL Query development which requires a good understanding of PostgreSQL JSON/JSONB processing functions and SQL Query development on JSON/JSONB data structures. Data Analysis: Work on Source Data Analysis and creation of Data Mappings for Extraction of bulk data from various sources. Implement the data formulation process which included identification of attributes, exploratory data analysis, data transformation, and temporal layout. ETL: Develop Solutions for business include the Extraction, Transformation, and Loading of Data between systems (ETL Process). Develop ETL Jobs using Talend which will load data from Stage Environment to Landing Environment. Staging Area in Oracle (Source Database) to corresponding tables in PostgreSQL (Target Database) Analyse and resolve the ETL and migration issues as a part of UAT, Regression testing and Production issue resolution. Perform a spectrum of ETL activities according to clients needs and specifications. Manage and implement the data extraction and data importing procedure to ensure Data Migration integrity and quality. Work in Unix/Linux environment to perform the Data Migration. Thanks & Regards, _____________________ Vanitha Mani. M US IT Recruiter E-Mail: [email protected] https://www.linkedin.com/in/vanitha-mani-1145b216a/ Keywords: information technology procedural language Texas |
| [email protected] View all |
| Wed Jan 03 00:55:00 UTC 2024 |