Sr. ETL Developer in Bloomfield, CT at APEX Systems

Date Posted: 7/13/2018

Job Snapshot

Job Description

Job #:  866079

Apex Systems is looking for an Informatica ETL developer for our Fortune 100 client in the Hartford, CT area. 

Interested candidates should send resumes to Alexis Fanning at afanning@apexsystems.com.

**Candidates must be able to work directly on Apex W2**

 

Duties: Responsibilities:

- Design ETL solutions and data conversion strategy and solutions for multiple disparate systems - Create end-to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, and creating database procedures and functions - Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes - Support proper functioning and performance tuning of Informatica platform - Develop stored procedures and triggers using Oracle database to support ETL jobs - Provide production support from development teams for existing systems, troubleshoot data and/or system issues - Identify root causes and resolve data related issues - Review and optimize query performance

Skills: Required Qualifications: - Informatica v9.1 or higher - Converting functional specifications into ETL technical specifications and source to target mappings - Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies - Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc - Hands on experience with database Performance tuning like Oracle, MSSQL Server, MySQL, and strong database languages like SQL, PL/SQL, TSQL, Unix Shell and Perl Scripting - Good Experience in tuning of Informatica mappings and Database scripts and procedures. - Experience in implementation of BI projects in a large scale enterprise data warehouse environment - Solid work ethic, self-driven with the ability to work with minimal supervision - Implement and maintain the database design - Create database objects (tables, indexes, etc.) - Write database PLSQL Packages, procedures, functions and triggers - Assist team members (Developers/QA/devops) with database activities - Tune database queries - Monitor application related jobs and data replication activities

Education: Bachelors degree in Computer Science or a related discipline, at least eight, typically ten or more years of solid, diverse work experience in IT with a minimum of four years experience application program development, or the equivalent in education and work experience.