8 days old

ETL Data Developer

Bloomfield, CT 06002
  • Job Code
  • Payrate
    $40 To $50
job summary:


- 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

- 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


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.


Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

ETL Data Developer

Randstad Technologies
Bloomfield, CT 06002

Share this job

ETL Data Developer

Randstad Technologies
Bloomfield, CT

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast