HIRING : Programmer Analyst 3 - Information Developer in Remote but candidates that live in Texas are highly preferred at Remote, Remote, USA |
Email: [email protected] |
From: aftab, convextech [email protected] Reply to: [email protected] Hope you are doing good.!! Please let me know if you are interested in the below position.!! Position : Programmer Analyst 3 /Information Developer Location : Remote but candidates that live in Texas are highly preferred Duration: 6+months Visa : H4EAD ,Green Card, US Citizens Interview mode: : video Job Description Candidates with State/Government Experience will be priority and highly required. Do not share candidates that do not have recent experience on Primary Skills or aligned to job description Railroad Commission of Texas Primary Skills: (ETL) AND (SQL) AND (INFORMATICA) AND (IICS) Development of ETL/ELT data mappings and workflows for data pipeline development with Informatica Cloud Data Integration. Practical experience using and building Informatica Mass Ingestion Pipelines. Demonstrated experience with Oracle Database as a Data Connector source. Expert with Snowflake as a Target database platform. Experience with the Snowflake platform and ecosystem. Knowledge of Snowflake data sharing and Snowpark is a plus. Knowledge of the advantages as well as previous experience working with Informatica push-down optimization Experience with Snowflake database creation, optimization, and architectural advantages. Practical experience with Snowflake SQL. Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems. Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures. Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply. Performs related work as assigned. Practical experience with one time data loads as well as Change Data Capture (CDC) for bulk data movement. Creation of technical documentation for process and interface documentation is a key element of this role, as the Team is working on release two of a multiple release effort. Ability to review the work of others, troubleshoot, and provide feedback and guidance to meet tight deliverable deadlines is required. Ability to promote code from development environments to production. Familiarity with GitHub or equivalent version control systems. Experience working with state agencies as well as security protocols and processes. II. CANDIDATE SKILLS AND QUALIFICATIONS Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 8 Required 6+ Experience with Informatica Products with at least 4 years direct experience with Informatica Cloud Data Integration 5 Required Generating advanced SQL queries and using other data interrogation methods.. 5 Required Reviewing, interpreting, and translation business requirements and design specifications into data mappings, and data pipeline development using all major data integration patterns. 4 Required Experience in relational database design concepts which including direct experience in Oracle RDBMS. 3 Required Experience with Data Warehouse architectural patterns including modeling Facts and Dimensions. 3 Required Experience with static mapping and Change Data Capture (CDC) for bulk data movement. 2 Required Experience with Informatica Mass Ingestion 2 Required Experience using Snowflake (creating, managing, optimizing databases as well as time-travel and other technical advantages of cloud data warehousing). 1 Preferred Any experience working with Snowpark, servicing the needs of Python programmers, or understanding Data Scientists requirements against Snowflake databases will make the candidate more successful MD AFTAB ALAM US IT Recruiter ConvexTech Inc. Direct : 4693007818 ext-412 Email : [email protected] Keywords: information technology Maryland |
[email protected] View all |
Wed Mar 20 02:00:00 UTC 2024 |