W2 only - Lead ETL / Informatica Developer - Must have worked with Oracle Exadata , PL/SQL and understanding of Hadoop
3 days Hybrid-– onsite in Plano Tx ( local candidates only )
Role not open for 3rd party or C2C submissions . We can consider visa transfers for right candidate.
Lead ETL Developer with 9+ years of overall IT experience having worked extensively with Informatica , Data Warehousing
Must have skills - ETL with Oracle Exadata , Datawarehousing and some Hadoop
- Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle / MS SQL server.
- Strong experience in Informatica, Datawarehousing, data architecture, databases and Writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasets
- Experience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plus
- Experience automating ETL with job scheduling tools. Autosys Preferred
- Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.
- Hands on logical and physical data modeling and database design responsibilities.
- Good understanding of Dimensional modeling - Understand Data Federations, Data Lake, Data Mesh
- Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )
Please email resume with contact numbers
Viral Patel , IT Talent Acquisition Manager
Mitchell Martin Inc.
Office : 646.723.7330
vpatel@itmmi.com | www.mitchellmartin.com
