View Our Website View All Jobs

ETL Developer

Great opportunity for large Government Contractor. Looking ETL Developer. 

Responsibilities: 

Data Establish design and methodology for the database build processes
● Architect and design complete data model solutions
● Create security models
● Create validation mechanisms
● Create extract processes for access layer
● Translate business problems/information requirements accurately to logical/physical data
models aligning with customer’s data architecture standards
● Perform research and analysis to come up with solutions for complex business problems
Monitor query performance and fine tune queries/PL SQL if required on a regular basis
Regularly profile data, publish data profiles and take corrective actions if required to
ensure high quality data
● Automate naming standards while script generation
● Document / describe data migration techniques used
● Document / reverse engineer / analyze data mapping using data integration code/tools
● Positively impact projects by completing tasks assigned on timemodeling for reporting and
Carnwennan Job Description
Carnwennan Job Number: DB002
Job Title: ETL Developer
analysis
Supported Technologies
Teradata BTEQ & Utilities Informatica Power Center Oracle
Teradata DBMS SQL Tableau
Hadoop Micro Strategy HDFS
MapReduce
Skills and Qualifications
● Minimum 8+ years of experience using Teradata DBMS to develop large data warehouse
and data mart applications
● Proven experience and exceptionally strong understanding of Teradata BTEQ & Load
Utilities (TPT, Fastload, FastExport, Tpumps, Mload)
● Able to write and tune SQL queries of medium to high complexity with high volumes
(millions or 10s of millions of rows per job run)
● Minimum 5+ years of experience with Informatica Power Center, or a similar ETL tool or
language in a real time environment
● Demonstrated problem solving and decision making skills and strong written and verbal
communication skills
● Ability to work effectively in a fast paced environment as part of a highperforming
development team quality skills
● Ability to communicate clearly and effectively with coworkers both in written and verbal
communications
● Demonstrated data analysis and problem solving skills.
● Essential to have strong interpersonal and written communication skills.
● Experience supporting training and/or learning environments is a definite plus.
● Positive attitude focused on customer satisfaction

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150