etl data developer in bloomfield

posted
job type
contract
salary
US$ 40 per hour
apply now

job details

posted
location
bloomfield, connecticut
job category
Information Technology
job type
contract
salary
US$ 40 per hour
reference number
632242
phone
.
apply now

job description

job summary:

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

 
location: Bloomfield, Connecticut
job type: Contract
salary: $40 - 50 per hour
work hours: 9 to 5
education: Associates
 
responsibilities:

- 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

 
qualifications:

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

 
skills: 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.


Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

skills

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.

qualification

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

responsibilities

- 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

educational requirements

Associates