What are the responsibilities and job description for the ETL-PL/SQL Developer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Prutech Solutions, is seeking the following. Apply via Dice today!
Job Title: ETL-PL/SQL Developer
Location: Brooklyn Heights, NY 11201, USA
Company: PruTech Solutions, Inc.
About PruTech
Founded in 1998, PruTech is dedicated to problem-solving, creating solutions, and maintaining strong partnerships with its clients. PruTech serves a diverse list of clients in different industries from government to finance, retail, and manufacturing. PruTech has offices in New York City, Washington DC, North Carolina, and two nearshore offices in Mexico City and India.
With over 20 years of Information Technology and system integration experience, PruTech provides multiple ways to assist organizations with future technology requirements including:
Project based system integration
Custom software solutions
Package implementations
Consulting and advisory services
Big data and analytics
Nearshore and offshore services
ETL/Data Warehouse/Data Lake Developer
Interview Process: Video Call & In-person
Job Title: ETL-PL/SQL Developer
Location: Brooklyn Heights, NY 11201, USA
Company: PruTech Solutions, Inc.
About PruTech
Founded in 1998, PruTech is dedicated to problem-solving, creating solutions, and maintaining strong partnerships with its clients. PruTech serves a diverse list of clients in different industries from government to finance, retail, and manufacturing. PruTech has offices in New York City, Washington DC, North Carolina, and two nearshore offices in Mexico City and India.
With over 20 years of Information Technology and system integration experience, PruTech provides multiple ways to assist organizations with future technology requirements including:
Project based system integration
Custom software solutions
Package implementations
Consulting and advisory services
Big data and analytics
Nearshore and offshore services
ETL/Data Warehouse/Data Lake Developer
Interview Process: Video Call & In-person
- 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.
- 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. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.