| ETL Data warehouse Developer || LOCATION: New York, NY. || DURATION: 12 + month at New York, New York, USA |
| Email: [email protected] |
| From: Prajojita, VYZE INC [email protected] Reply to: [email protected] Hi, Hope you are doing well please find the requirement below and kindly let me know if you have good consultant for this. ROLE: ETL/Data warehouse Developer LOCATION: New York, NY. DURATION: 12 + month VISA: USC/GC/H4EAD Need only local /No representation Job Description: Key Responsibilities: The Fire Department, City of New York, seeks a contract position for ETL/Data warehouse/Data Lake Developer in the Bureau of Technology and Development Systems. Mandatory Qualifications: At least 5 years of experience as ETL Developer. Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Proficient in SQL and ETL processes, ETL and DB performance tuning. Design and develop ETL process using SQL and Informatica to load data into data warehouse/ data lake on daily basis from various source applications on Oracle, SQL Server, Cloud Sources, and files. Design the architecture to perform data management activities i.e., data extraction, transformation, and load (ETL) to enterprise data warehouse. Implement the data management solutions using SQL, SQL procedures, data management tools like Informatica IICS on Oracle exadata database. Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake. Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support. Expertise in PL/SQL Programming including Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, built in functions, joins, aggregate functions, Collections. Develop data models and ER diagrams for existing and new databases. Passionate about complex data structures and problem solving. High attention to detail. Ability to pick up new data tools and concepts quickly. Maintain and improve already existing processes. Desired Qualifications: Working experience with ETL tool (Preferred - Informatica - IICS) Best Regards, Prajojita Biswal Technical Recruiter, Vyze Inc. (An E-Verified Company), 25179 Methley Plum Place, Aldie, VA 20105 Email: [email protected] Desk: (571) 367-1411 www.vyzeinc.com Disclaimer: This communication, along with any documents, files or attachments, is intended only for the use of the addressee and may contain confidential information. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of any information contained in or attached to this communication is strictly prohibited, To remove your email address permanently from future mailings, please send REMOVE to [email protected] Keywords: database green card procedural language New York Virginia |
| [email protected] View all |
| Fri Oct 06 06:49:00 UTC 2023 |