Sign upLog in

ETL Developer

Plymouth Rock Assurance Corporation

Woodbridge, NJ

Apply
JOB DETAILS
SALARY
$139,660–$142,660 Per Year
SKILLS
Acceptance Testing, Amazon Web Services (AWS), Automation, Best Practices, Business Administration, Business Intelligence, Change Control, Change Management, Cloud Computing, Code Reviews, Computer Engineering, Computer Science, Crystal Reports, Data Mart, Data Quality, Data Structures, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Debugging Skills, Git, IBM DB2, Informatica, Model Validation, Oracle Database, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Python Programming/Scripting Language, Quality Assurance, Release Management/Engineering, Requirements Management, SAP Administration, SAP BusinessObjects, SQL (Structured Query Language), Security Design, Snowflake Schema, Software Administration, Source Code/Configuration Management (SCM), Standards Development, Stored Procedures, Subversion, System Migration, Unit Test, Unix Shell Programming, Validation Plan
LOCATION
Woodbridge, NJ
POSTED
1 day ago
### Experience Required 60 ### Minimum Education Required Bachelor’s degree in Computer Science, Computer Engineering or related field ### License(s) Required N/A ### Training Required/Provided N/A ### Compensation $139,660.00 - $142,660.00 / Yearly ### Hours Per Week 40 ### Number Of Positions 0 ### Shift Unspecified ### Job Description EMPLOYER: Shared Technology Services Group LLC JOB DUTIES: • Responsible for designing, developing, testing and implementing modifications to our existing Data Warehouse and Data Mart ETL Loads and processing for the Data Services team. • Modernize our development code for the future to migrate to AWS and Cloud tools and data structures (Snowflake/DBT) • Maintains application code required to load & balance our data warehouse daily and serve as the source of truth for historical data for the enterprise. • Participating in Business Requirements review, assistance with system specifications, development of technical specifications, development of code changes in Informatica Power Center as well as DBT Cloud, unit testing and implementation in production. • Follow the defined Informatica development standards and best practices and attend code reviews to assure compliance. • Implement code changes based on system specifications. • Analyze problems and propose solutions. • Work with DBA’s to implement database changes. • Develop code changes using Informatica Power Center and DBT Cloud. • Perform in-depth unit testing prior to promoting to QA. • Responsible for supporting and taking direction from manager. • Look for opportunities to enhance existing code & processes. • Participation in System and User acceptance testing. • Ability to performance tune internal and user queries and ETL loads. • Production implementation, including all required documentation. 20% Telecommuting permitted. REQUIREMENTS: Position requires a Bachelor’s degree in Computer Science, Computer Engineering or related field and five (5) years of progressive, post-baccalaureate experience in the job offered or in an ETL Developer-related occupation. Alternatively, employer will accept a Master’s degree in Computer Science, Computer Engineering or related field and three (3) years of experience in the job offered or in an ETL Developer-related occupation. Position requires demonstrable experience with the following: • Demonstrable experience with Informatica PowerCenter/IICS to develop & optimize mappings, workflows, and sessions. • Demonstrable experience with SQL (Oracle/DB2) to perform queries, stored procedures, performance tuning, and SQL optimization for reporting. • Demonstrable experience with Data Warehousing including Data Mart design, data quality checks/profiling. • Demonstrable experience with Scripting including Unix & Python for automation. • Demonstrable experience with Snowflake to perform migration planning, validation, performance tuning. • Demonstrable experience with dbt supported POCs, translated Informatica logic into dbt models, and validation. • Demonstrable experience with Version Control including Git & SVN for branching, merging, and release management. • Demonstrable experience with Testing & Release Management including unit, system, UAT, and change control. • Demonstrable experience with Informatica ETL support and ETL optimization to perform debugging and code changes. • Demonstrable experience with SAP Business Objects Administration for users, security, Universe design, and Crystal reports. • Demonstrable experience with System performance monitoring & tuning for BI/reporting environments, and UAT requirement gathering with functional teams. • Demonstrable experience with Change management & production support for BI systems. 20% Telecommuting permitted. CONTACT: To apply please email resume clearly referencing Job Code 21765.119 to recruit@plymouth.com ### Place of Work Hybrid ### Requisition ID 21765.119 ### Job Type Full Time ### Application Instructions CONTACT: To apply please email resume clearly referencing Job Code 21765.119 to recruit@plymouth.com

About the Company

P

Plymouth Rock Assurance Corporation