04 Nov
Senior ETL Developer
Maryland, Baltimore , 90001 Baltimore USA

Title: Senior ETL Developer

Duration: Long Term Contract (3-8 years)

Location: Baltimore, MD / REMOTE for now (until the end of Covid pandemic)

Number of Positions#- 3

Key Required Skills: ETL, PL/SQL scripting, PostgreSQL/Greenplum

Position Description:Design, develop, and unit test software modules/functionality.
  • Peer review team members code for quality and standards.
  • Demonstrate completed functionality and assist testers with approaches to validate features and refine test cases.
  • Attend team meetings with team members to understand and refine business features.
  • Attend regular customer meetings and provide status on assigned tasks.
  • Analyze and troubleshoot the existing Oracle 19c data models, PL/SQL and Linux scripts, and code for opportunities to optimize performance and migrate into the Enterprise Data Warehouse (EDW).
  • Monitor and troubleshoot daily production jobs and job failures.
  • Coordinate with various other teams to resolve production job failures.
  • Develop design documentation and guidelines.
  • Develop presentation material.
  • Occasional weekend support may be required for releases and upgrades.

Skills Requirements:Strong experience in design, building and testing graphs and

Extract, Transform, and Load (ETL) applications
  • Strong understanding of data recovery and job rerun needs in an ETL environment.
  • Strong experience with SQL, mapping, and integration of databases such as

    DB2, Oracle 19c, and Greenplum.
  • Proficiency writing scripts using Oracle PL/SQL, and PostgreSQL
  • Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files.
  • Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
    • Knowledge of when to use plain SQL vs. PL/SQL.
    • Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.
    • Hands on experience with data warehouse Business Intelligence (BI) / Management Information (MI) reporting environment. Knowledge in both client-server and mainframe-based systems and the connectivity/infrastructure requirements to support, design, develop and implement such systems.
    • Experience working with enterprise data warehouses.

Desired Skills:
  • Knowledge of SSA software development practices, environments, and disability applications.
  • Experience with data warehousing designs/concepts such as star and snowflake schemas.
  • Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)
  • Experience with modern development software, tools, and methodologies, Jenkins, Jira/VersionOne, Nexus, Jenkins, OpenShift, UrbanCode Deploy, XML/XSLT, and Amazon Web Services.
  • Experience working on Agile projects and understanding Agile terminology.

  • Bachelor's Degree or higher preferred with 8 years with advanced IT experience or professional IT certifications.
If interested in the above mentioned position, then please send your resume in word format to rajesh.m(at)pace-solutionsinc.com Thanks & Regards,

Rajesh Kumar

Pace Computer Solutions Inc. (An Inc. 500 Company)10500 Little Patuxent Pkwy, Suite 310 Columbia, MD 21044Email: Rajesh.M(at)pace-solutionsinc.comPhone number: EXT: 209www.pace-solutionsinc.com

Related jobs

Report job