| Great Career opportunity:- State of Ohio - MCD-Technical Specialist 4 / TS 4 #758975 at Columbus, Ohio, USA |
| Email: shikhar.sharma@flairsoft.net |
|
https://jobs.nvoids.com/job_details.jsp?id=2240655&uid= Proficiency in Data Warehousing, Data migration, and Snowflake is essential for this role. Technical Specialist 4 / TS 4 is Hybrid role The contract manager will change the hybrid status based on the criticality, prioritization and project deadlines. Hello Professional, Greetings, I hope you're doing well. Your skills and experience could be a great match for a key role I am filling here at Flairsoft. I would like to connect with you for a quick call to learn more about your career aspirations and further discuss our opportunity. What is your best availability to connect Thank You! Position: Technical Specialist 4 / TS 4 Location: Columbus, OH Agency: MCD Interview Type: webcam Position ID: 758975 The Technical Specialist will be responsible for migrating the current data, framework and programs from the ODM EDW IOP Big data environment to the ODM EDW Snowflake environment. Technical Specialist will also involve in Medicaid Enterprise Data Warehouse design, development, implementation, migration, maintenance and operation activities. Works closely with Data Governance and Analytics team. Will be one of the key technical resources for ingesting the data to ODM EDW Snowflake environment and to build new or support existing Data warehouses and DataMarts for data analytics and exchange with State and Medicaid partners. This position is a member of Medicaid ITS and works closely with the Business Intelligence & Data Analytics team. Responsibilities: * Participate in Team activities, Design discussions, Stand up meetings and planning Review with team. * Provide Snowflake database technical support in developing reliable, efficient, and scalable solutions for various projects on Snowflake. * Ingest the existing data, framework and programs from ODM EDW IOP Big data environment to the ODM EDW Snowflake environment using the best practices. * Design and develop Snowpark features in Python, understand the requirements and iterate. * Interface with the open-source community and contribute to Snowflakes open-source libraries including Snowpark Python and the Snowflake Python Connector. * Create, monitor, and maintain role-based access controls, Virtual warehouses, Tasks, Snow pipe, Streams on Snowflake databases to support different use cases. * Performance tuning of Snowflake queries and procedures. Recommending and documenting the best practices of Snowflake. * Explore the new capabilities of Snowflake, perform POC and implement them based on business requirements. * Responsible for creating and maintaining the Snowflake technical documentation, ensuring compliance with data governance and security policies. * Implement Snowflake user /query log analysis, History capture, and user email alert configuration. * Enable data governance in Snowflake, including row/column-level data security using secure views and dynamic data masking features. * Perform data analysis, data profiling, data quality and data ingestion in various layers using big data/Hadoop/Hive/Impala queries, PySpark programs and UNIX scripts. * Follow the organization coding standard document, Create mappings, sessions and workflows as per the mapping specification document. * Perform Gap and impact analysis of ETL and IOP jobs for the new requirement and enhancements. * Create mockup data, perform Unit testing and capture the result sets against the jobs developed in lower environment. * Updating the production support Run book, Control M schedule document as per the production release. * Create and update design documents, provide detail description about workflows after every production release. * Continuously monitor the production data loads, fix the issues, update the tracker document with the issues, Identify the performance issues. * Performance tuning long running ETL/ELT jobs by creating partitions, enabling full load and other standard approaches. * Perform Quality assurance check, Reconciliation post data loads and communicate to vendor for receiving fixed data. * Participate in ETL/ELT code review and design re-usable frameworks. * Create Change requests, workplan, Test results, BCAB checklist documents for the code deployment to production environment and perform the code validation post deployment. * Work with Snowflake Admin, Hadoop Admin, ETL and SAS admin teams for code deployments and health checks. * Create re-usable framework for Audit Balance Control to capture Reconciliation, mapping parameters and variables, serves as single point of reference for workflows. * Create Snowpark and PySpark programs to ingest historical and incremental data. * Create SQOOP scripts to ingest historical data from EDW oracle database to Hadoop IOP, created HIVE tables and Impala views creation scripts for Dimension tables. * Participate in meetings to continuously upgrade the Functional and technical expertise. REQUIRED Skill Sets: * Proficiency in Data Warehousing, Data migration, and Snowflake is essential for this role. * Strong Experience in the implementation, execution, and maintenance of Data Integration technology solutions. * Minimum (4-6) years of hands-on experience with Cloud databases. * Minimum (2-3) years of hands-on data migration experience from the Big data environment to Snowflake environment. Skill Required / Desired Your Amount of Experience in years/month Proficiency in Data Warehousing, Data migration, and Snowflake is essential for this role. Required Strong Experience in the implementation, execution, and maintenance of Data Integration technology solutions. Required Minimum (4-6) years of hands-on experience with Cloud databases. Required Minimum (2-3) years of hands-on data migration experience from the Big data environment to Snowflake environment. Required Thanks & Regards , Shikhar Sharma Technical Recruiter Flairsoft Limited Desk: 6148880700 Ext: 257 Linked In: linkedin.com/in/shikhar-sharma-08a8a9237/ CMMi and ISO 9001 Certified http://flairsoft.net/capability-statement/ We Deliver.You Succeed. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer Keywords: access management information technology Idaho Ohio Great Career opportunity:- State of Ohio - MCD-Technical Specialist 4 / TS 4 #758975 shikhar.sharma@flairsoft.net https://jobs.nvoids.com/job_details.jsp?id=2240655&uid= |
| shikhar.sharma@flairsoft.net View All |
| 07:29 PM 10-Mar-25 |