Position: Senior ETL Developer
Location: Albany, NY
Duration: 48 Months
Who we are:
Cloud and Things is building a platform to allow you to build your career! Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of the transformation of the public sector's IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers you the opportunity to work on rewarding projects, consider a career with Cloud and Things.
Responsibilities:
- Analyze requirements, design & develop end to end Master Data Management
(MDM) solutions. - Design & build data models, data quality rules, match & survivorship
rules etc. - Perform analysis, design, development, and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation.
- Manage and administers ETL solutions for medium to large scale OLTP and OLAP projects.
- 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. - Explore, actively support, and work on new technology initiatives that may be of
interest to the organization. - Actively participate in troubleshooting any technical issues that the program
may have.
Mandatory Skills:
- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer
- Five or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.
- Three or more years of experience in working with Informatica Master Data Management (MDM) or similar products.
Desirable Skills:
- Five years or more of hands-on experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
- Five or more years of 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 Informatica Data Quality.
- Five or more years of experience developing complex SQL, PLSQL objects with Oracle 11g 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.
- Five or more years of experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.
- Experience with implementing ETL solutions for medium to large scale OLTP and OLAP projects.
- Experience in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.
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.