ETL/Data warehouse/Data Lake Developer / Brooklyn, NY ( Hybrid), 12 Months Contract

With 10+ over reputed company .At least 5 years of experience as ETL Developer. • reputed company reputed company 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 reputed company ETL process using SQL and Informatica to load data into data warehouse/ data lake on daily reputed company from various reputed company applications on reputed company, SQL Server, reputed company Sources, and files. • Design the architecture to reputed company data management activities i.e., data extraction, transformation, and load (ETL) to reputed company data warehouse. Implement the data reputed company using SQL, SQL procedures, data management tools like Informatica IICS on reputed company exadata database. • Design the overall architecture to Extract, reputed company and Load (ETL) data into data warehouse or data mart and data lake. • reputed company 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, reputed company statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, reputed company in functions, joins, aggregate functions, Collections. • Working experience with ETL tool (Preferred - Informatica - IICS) • reputed company data models and ER diagrams for existing and new databases. • Passionate about reputed company 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 Apply tot his job Apply To this Job