PruTech Solutions, Inc. · 4 hours ago
Informatica ETL Developer
Brooklyn, NY
Full-time
Hybrid
Senior Level
5+ years expPruTech Solutions, Inc. is dedicated to problem-solving and creating solutions for a diverse list of clients across various industries. They are seeking an Informatica ETL Developer to develop complex data pipelines and design data management architectures for enterprise data warehouses.
Big DataConsultingMobileMobile AppsPredictive AnalyticsProfessional ServicesRoboticsSoftwareStaffing Agency
Responsibilities
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 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
Working experience with ETL tool (Preferred - Informatica - IICS)
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
Any Experience in public safety systems is a plus
Qualification
Required
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 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
Preferred
Working experience with ETL tool (Preferred - Informatica - IICS)
Any Experience in public safety systems is a plus
Company
PruTech Solutions, Inc.
PruTech Solutions is an information technology company - Your Partner for Digital Transformation
501-1000 employees
H1B Sponsorship
PruTech Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (34)
2024 (14)
2023 (26)
2022 (40)
2021 (17)
2020 (57)
Funding
Current Stage
Late StageLeadership Team
Deepak Chopra
COO
Company data provided by crunchbase