View Our Website View All Jobs

ETL Developer

Great opportunity for large Government Contractor. Looking ETL Developer. 


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
Supported Technologies
Teradata BTEQ & Utilities Informatica Power Center Oracle
Teradata DBMS SQL Tableau
Hadoop Micro Strategy HDFS
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
● 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

Apply with
Attach resume as .pdf, .doc, .docx, .odt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file