Job Specifications
Contact Details:
1.Harika Mamidala
Email: harika.mamidala@peer-consulting.com
Cell: +17322424175
Job Title: ETL Developer
Location:Brooklyn, NY (Hybrid)
Duration: 12 Months+
Years of Experience: 8+ Years
Required Hours/Week: 35hrs./Week
Job Overview:
The end-client seeks a contract position for ETL/Data warehouse/Data Lake Developer in the Bureau of Technology and Development Systems.
Required Skills/ Experience:
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 modelling, 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.
About the Company
Peer Consulting Resources Inc. is a minority- and women-owned IT consulting and services firm dedicated to empowering government and private sector organizations through impactful, measurable solutions. By combining technological innovation, deep industry expertise, and business process acumen, we enable our clients to achieve new levels of productivity and operational efficiency.
Our services span the entire project lifecycle--from conceptualization, architecture, and implementation to rigorous testing and ongoing support-...
Know more