| Lead ETL Developer--Austin, TX (Hybrid or Remote) - Please share only Local profiles. Client will not consider non locals at Austin, Texas, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1732001&uid= From: Shujath, Panzer [email protected] Reply to: [email protected] Dear Consultant, How are you doing well! My name is Shujath Ali and I am working as a Lead Talent Acquisition at Panzer Solutions LLC. We deal with US IT and non IT recruitment services. We have the below opening with our preferred client, let me know if you are available & interested in this position. If interested please share a copy of your resume and best time, number to reach. Job Title: Lead ETL Developer Location: Austin, TX (Hybrid or Remote) Duration: 4+ months with possible extension Please share only Local profiles. Client will not consider non locals backfill position 100% Closable Role Immediate Interview Years Skills/Experience - Bachelors Degree or equivalent related work experience. 5+ Experience in Data Modeling, Database Design, PL/SQL procedure writing, and advanced ETL mapping. 3+ Experience using Informatica PowerExchange for IMS including creating from scratch ETL mappings from IMS to a RDBMS. ---OR--- Experience using Informatica PowerCenter including creating, debugging, and unit testing workflows. 2+ Experience with Oracle as a source or target. 2+ Experience using Data Modeling software such as ER/Studio, Erwin, or Toad Modeler (Toad Modeler preferred). 1+ Experience in hierarchical database and relational database design concepts including direct experience in IMS Databases, VSAM structures. 1+ Experience performing discovery of and translation of COBOL programs, VSAM, and IMS to relational database structures. - Experience in the documentation of complex database concepts, data objects, data governance, data ETL processes, and database schemas including the creation of ERD diagrams and UML parent/child data relationship diagrams. - Experience with taking convoluted and unfactored database structures and unmodeled data and having an end-to-end vision for both logical, physical and conceptual database construction and architecture. - Experience with Informatica Navigator to create mainframe Capture Registrations. - Experience with static maps and Change Data Capture (CDC) for bulk data movement. - Ability to work well within a small, diverse team under various competing deadlines. - Good communication skills (interpersonal, listening, written and oral), be self-motivated, organized, thorough, and efficient. Preferred (Optional) Years Skills/Experience 8+ Reviewing data storage and data flow to develop data models to ensure data integrity. 4+ Generating advanced SQL queries and using other data interrogation methods. 8+ Reviewing and interpreting business requirements and design specifications and translating them into Informatica mappings and workflows. 8+ Writing, revising, and verifying Informatica processes and procedures (including interface control documents, process workflows in Visio, and operational processes for Informatica). 8+ Leading the Informatica-related technical direction of a small team, to include the ability to troubleshoot and review code for staff knowledge transfer or training. 8+ Skill with data movements/Extracts (ETL) from Mainframe applications (prefer IMS COBOL). 7+ Experience in relational database design concepts including direct experience in Oracle RDBMS. 5+ Experience in hierarchical database and relational database design concepts including direct experience in IMS Databases, VSAM structures. 8+ Development with Informatica on-premise software. Experience must be with Navigator data mappings or with PowerCenter workflow development. ---OR--- Experience using Informatica PowerExchange for IMS including creating from scratch ETL mappings from IMS to a RDBMS. ---OR--- Experience using Informatica PowerCenter including creating, debugging, and unit testing workflows. ---OR--- A combination of experience in Informatica PowerExchange and PowerCenter that has a minimum of 3 years in one and a total of over 8 years combined. 3+ Experience using Informatica/ PowerExchange Navigator to create mainframe Capture Registrations. 3+ Experience with static maps and Change Data Capture (CDC) for bulk data movement. 1+ Experience or knowledge with Microsoft SSIS ___________________________________________________________________________________________________ Warm Regards, Shujath Ali | Lead - Talent Acquisition Panzer Solutions LLC 50 Washington Street, 9th Floor, SONO Corporate Center - Norwalk CT 06854 Fax: 203-286-1457 Email: [email protected] Notice of Confidentiality: Keywords: access management information technology procedural language Connecticut Texas Lead ETL Developer--Austin, TX (Hybrid or Remote) - Please share only Local profiles. Client will not consider non locals [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1732001&uid= |
| [email protected] View All |
| 10:10 PM 09-Sep-24 |