Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

ETL Developer

Expired Job

Inscope International, Inc. Washington , DC 20049

Posted 2 months ago

Design, Develop and Provide support in all aspects of data movement for a data warehouse environment residing on Netezza, with emphasis on the Extract-Transform-Load (ETL) process using Informatica. Ability to administer ETL system and upgrade to new releases Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements.

Design Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies. Document database design including data modeling, metadata and business process flow for the new business integration requirements. Create data model and reverse engineer data warehouse using CASE tools like ER Studio.

Create test plans and scripts for data warehouse testing, ranging from unit to integration testing. Ensure delivered Data warehouse code is running and conforms to specifications and design guidelines. Create Informatica mappings, transformations, stored procedures and functions to implement the data process flow defined by the business rules.

Document technical ETL specifications for data warehouse. Perform periodic code reviews and test plans to ensure data quality and integrity. Navigate on the host server for file management, file cleanup and configuration tasks.

Maintain Informatica on UNIX and Windows environments. Write Shell scripts, PL/SQL scripts and SQL scripts Prior Experience in Upgrading Informatica Power Center versions.

Excellent communication skills with knowledge of ETL field, tools and technologies, implementations and solutions, as well as specific experience with the Informatica ETL tool Excellent motivational skills required to ensure good team synergy and collaboration of cross functional teams. A strong facilitation and positive attitude will be mandatory. Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning, and High Volume Data Loads Excellent ability to multi-task. Demonstrated proficiency with a database SQL language for user-defined database extracts or updates statements. Proficient in Netezza 7.1 Proficient on all Informatica 10.x Platform tools (Power Exchange, Power Center) Proficient use of CASE tools (Embarcadero ER Studio preferred)
7-10 years of prior software development experience required.

ETL, Informatica, PL/SQL

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
ETL Developer

Booz Allen Hamilton Inc.

Posted 2 months ago

VIEW JOBS 9/28/2018 12:00:00 AM 2018-12-27T00:00 Job Description Job Number: R0038948 ETL DeveloperKey Role: Design, implement, and manage databases and data delivery systems and transform it into beautiful insights, analysis, and reporting. Leverage knowledge of Extract, Transform, and Load (ETL) tools to create structure and value out of complex and ambiguous technical challenges with little guidance. Use expertise with structured and unstructured data, streaming and batch data processing, ETL, data wrangling, data ingest, and data access. Basic Qualifications: * 2+ years of experience with PL/SQL and stored procedures * 2+ years of experience with Python development * 2+ years of experience with ETL tools and processes * 1+ years of experience with scripting * 1+ years of experience in working with data toolsets, including data warehouse, data marts, data lake, 3NF, and dimensional models, modeling tools, and profiling tools * 1+ years of experience with extracting and summarizing data from a variety of data source types * Top Secret clearance * BA or BS degree Additional Qualifications: * 1+ years of experience with Informatica * Experience with SQL * Experience with Agile/Scrum methodologies preferred * Knowledge of data modeling and design patterns and applying them * Knowledge of IT processes, including quality assurance, release management, and production support * Ability to meet project deadlines and test, troubleshoot, and resolve system problems under tight deadlines * Possession of excellent analytical and problem-solving skills Clearance: Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; Top Secret clearance is required. We're an EOE that empowers our people—no matter their race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or veteran status—to fearlessly drive change. SIG2017 Booz Allen Hamilton Inc. Washington DC

ETL Developer

Expired Job

Inscope International, Inc.