Sr. ETL Developer in Bloomfield, CT at APEX Systems

Date Posted: 9/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.

 

 

 

 

 

 

 

 

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178