Job for ETL Developer
NYC,NY
24 months
Posted on: 06/08/22
Job Description:

  • Ensuring application documentation is complete, organized, accessible, and follows office standards.
  • Writing, testing, debugging new and existing code based on program area knowledge, conceptual and technical design specifications. 
  • Write and test procedures, parameters and other specifications required to implement programs.
  • Develop or assist with the development of unit, component and program test plans.
  • Implement program changes and provides user support as required.
  • Database design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Work Protections.
  • Develop, test and implement program logic for data mining and ETL development.
  • Implement ETL technical specifications from development through test, staging and production environments.
  • Optimize ETL data load jobs to improve performance and automate.
  • Investigating and resolving data loading and/or data integrity issues.
  • Create solutions to improve system performance and availability.
  • Develop and maintain logical and physical dimensional data models for data warehouse/data mart.
  • Write clear documentation of process and data modelling and all associated tasks and documents including unit and quality assurance test plans.

Requirements:

  • 72 Months ETL development experience in Oracle environment with IBM DataStage In collaboration with the CISO and IT team develop the agency information security strategy and key initiative
  • 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming Develop budget & resource requirement and execution plans for key cybersecurity initiatives
  • 84 Months Experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries Provide technical expertise for security projects
  • 84 Months UNIX Shell Scripting experience
  • 60  months experience in program and unit testing.
  • 60 months experience in program code documentation, mentoring and assisting other developers
  • 60 months experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) for production system error diagnosis, debugging, and code modification
  • 84 Months Experience developing dimensional data models for Cognos data analytics
  • 84 Months Experience developing data analysis and metrics queries for operational oversight
  • 84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for

Copyright @2021 RighTalents. All Rights Reserved by RightTalents LLC