Dear Consultant,

How are you doing well!

My name is Zaid khan and I am working as a 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.

I have a backfill position , 100% Closable Role . Please Follow As Per below JD

Immediate Interview

Candidates Must be Local Texas to Only

Lead ETL Developer

Austin TX

Years Skills/Experience

- Bachelor’s 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,

Zaid Khan| Talent Acquisition

Panzer Solutions LLC

50 Washington Street, 9th Floor,

SONO Corporate Center - Norwalk CT 06854

Email: zaid.khan@panzersolutions.com