Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Job Title: ETL Developers (Informatica)
Location: Albany, NY
Duration: 30 Months
Client: State of NY

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. If you are seeking a role that offers you the opportunity to work on rewarding projects, consider a career with Cloud and Things.

Mandatory Skills (4-6 Years Must):

• Informatica PowerCenter 10 or higher
• ETL development
• Informatica Data Quality
• PL/SQL
• Oracle DB 11 or higher

Duties/Responsibilities:

• Perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation
• Work with teams to resolve problems and implement solutions to technical issues impacting application performance
• Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
• Participate in troubleshooting technical issues.

Mandatory Qualifications:

• Experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases such as Oracle DB 11g or higher.
• Five (5) years or more of hands-on experience using ETL Development tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
• Five (5) or more years of experience in implementing and maintaining data integration processes using Informatica suite of products including Informatica PowerCenter 10 or higher and Informatica Data Quality.

Desirable Qualifications:

• Five (5) or more years of experience developing complex SQL, PL/SQL 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.
• 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.
• Experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.
• Experience with Health & Human services applications.

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