ETL Developer

Vacancy expired!

Position: ETL Developer

Location: Albany, NY

Duration: 18 Months

Who we are:Cloud and Things is a quick growing company lead by a team of former State government executives who understand the public sector business environment. We are building a platform to allow you to build your career! Our goal is to solve problems and deliver results for our clients. This is enabled by our culture which encourages individual development and embraces innovation. If you’re passionate about your future and developing your career, we want you to join our team!

Job Duties:

• Perform analysis, design, development, and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation.
• Manage and administer ETL solution for a legacy system to Oracle ETL implementation.
• Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
• Communicate and coordinate with members of the development team to work across multiple projects.
• Actively participate in troubleshooting any technical issues that the program may have.
• Participate in Agile Team ceremonies (such as: Daily Stand up, Backlog Grooming, Product Demos).
• Other duties as assigned.

Required Qualifications:

• Experience and Expertise (5 years minimum; 8 preferred) in analysis, design, development, testing and implementation of data integration solutions using SQL & relational databases.
• Experience and Expertise (5 years minimum; 8 preferred) in implementing and supporting data integration processes using Talend.
• Experience and Expertise (4 years) with implementing ETL solutions for medium to large scale OLTP and OLAP projects.
• Experience and Expertise (2 years) with git-based source control.

Preferred Qualifications:

• • Bachelor's degree in a technical or professional specialty degree
  • Demonstrated continued progression through roles to mid to senior level information technology professional, such as an ELT engineer, database developer, software developer, database administrator, or data architect
  • Experience and Expertise in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.
  • Experience using Atlassian software (Jira, confluence)
  • Hands-on experience using ETL tools like Talend to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
  • Experience with mainframe to RDBMS data migrations.
  • Experience developing complex SQL, PLSQL objects with Oracle 12c or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including SQL Loader, external tables, and Oracle built in packages to migrate data.
  • Experience with Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match, and merge functionality using tools such as Talend.
  • Experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.
  • Experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views, and indexes.
  • Experience working in a java shop
  • An understanding of Hibernate, flyway and JPA.
  • Familiarity with DMSII mainframe database and/or Databridge.

Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state or local laws

Vacancy expired!