Sr. ETL-Data warehouse-Data Lake Developer Brooklyn,New York at Brooklyn, New York, USA |
Email: [email protected] |
From: Ashok Reddy, Sligo Software Solutions Inc. [email protected] Reply to: [email protected] Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have a urgent requirement for Sr. ETL-Data warehouse-Data Lake Developer position with our client. Role: Sr. ETL-Data warehouse-Data Lake Developer Location: Brooklyn, New York Duration: 12 Months Client: NY State Client Job ID#: NYST-132 Duties 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. 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. Develop data models and ER diagrams for existing and new databases. Maintain and improve already existing processes. Mandatory Requirements Experience (15+ Years) Requirements This is an 100% Onsite Job Qualifications: Bachelor's Degree 5 years of experience as ETL Developer Required Skills: Proficient in SQL and ETL processes, ETL and DB performance tuning. 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 Working experience with ETL tool (Preferred - Informatica - IICS) Preferred Skills: Passionate about complex data structures and problem solving. High attention to detail. Ability to pick up new data tools and concepts quickly. Ashok Reddy Akkala Sligo Software Solutions, Inc. NYS and NYC MBE Certified Company. Office : 518 908 0002 Ext 113 Email:[email protected] www.sligosoft.com LinkedIn: https://www.linkedin.com/in/ashok-reddy-a88b471b7/ Keywords: database information technology procedural language Idaho New York |
[email protected] View all |
Wed Aug 09 18:51:00 UTC 2023 |