11 days old

Developer - ETL - Application

McLean, VA 22102
  • Job Code
    577973
  • Payrate
    $55 To $60

ETL


Typically has 3-5 years of experience in Informatica or other ETL tools and technologies.


Strong background in processing large volumes and variety of data (Structured and unstructured data, XMLS, JSONs, PDFs).


Cleanse, analyze and Develop ETL scripts to load large datasets into Relational databases, Understand re-usability, parametrization, workflow design, etc.


Develop ETL maps using Informatica, Scripting (Batch, shell), Data analysis, data mapping, data loading, and data validation.


Maintain and manage technical meta data and documentation for data warehousing and ETL processes.


Perform overall ETL solution design and creation of design specifications to implement changes.


Database


Good knowledge of database concepts with working knowledge on SQL and Stored Procedures.


SQL Development - ability to write, troubleshoot and optimize SQL code and design ( stored procedures, functions, views, triggers, indexes, constraints ).


Understanding of logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types.


Automation/Production Support


Participate in Requirements Analysis, design Applications based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy applications


Experience with Unix Shell script, Autosys, Stored Procedures, Complex SQLs tuning, data replication between databases is preferred.


Testing


Develop test plan and/or test application in development status or debug application in production mode.


Document or review documentation of steps in specification development, coding, testing and user acceptance for future reference and for internal control purposes.


Analytical Skills


Independently determines and develops approach to solutions, ability to work under limited direction.


Collaborate with team members and Must be able to manage multiple priorities and meet deadlines.


Ability to demonstrate a constant and quick learning ability and should be flexible to adapt to the new developing technologies.


Excellent problem solving skills and the ability to handle pressure situations without compromising on quality are a must.


Basic Requirements:


- Experience in ETL and exposure to data modeling


- Experience in development and troubleshooting of complex ETL/Data applications (Informatica tool sets preferred)


- Analytical and testing support for others in the team


- Hands-on experience with XML and XSD based interfaces and tools


- Experience working with JSON, XML and unstructured data processing


- Possess Excellent analytical, programming, written and verbal communication skills.


Preferred Skills:


- Knowledge of SAS would be helpful


- Knowledge of Python is preferred


- Familiarity with Big Data Hadoop environment is a plus.


- Agile development methodology experience preferred


- Experience with ParAccel/Matrix is highly desired.


- Understanding of the secondary mortgage industry is desirable.

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

Developer - ETL - Application

Randstad Technologies
McLean, VA 22102

Share this job

Developer - ETL - Application

Randstad Technologies
McLean, VA
US

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