ETL Developer/Data Modeler

Rockville MD

1 year plus contract


f2f in second round needed

This position is responsible for extracting, transforming, cleaning and
moving data and metadata so they can be loaded into the data warehouse,
which is a mixture of MS SQL Server Integration Services, SAS, and SQL

*Primary Duties*

·         Design conceptual and logical models for data warehouses.

   - Update data models to meet new and changing business requirements.
   - Map source system data to data warehouse models.
   - Develop, test, and maintain ETL processes for all sources and
   destinations in SQL Server SSIS.
   - Adapt ETL processes to accommodate changes in source systems and to
   respond to changes in business requirements.
   - Develop processes for capturing and maintaining metadata from all data
   warehousing components
   - Define and capture metadata and rules associated with ETL processes.
   - Maintain recommended specifications for client access, application
   servers, database servers and networks
   - Work collaboratively with Systems Analysts and Subject Matter Experts
   to identify and understand source data systems.
   - Provide a feedback loop to advise on data standards in transaction
   systems that will lend better to long term analytic use of institutional


·         Intermediary to advanced relational and dimensional data
modeling, database design, and technical design skills.

·         Intermediary to advanced SQL data integration skills.

   - Understanding of source and target data structures.
   - Understanding of data analysis and presentation concepts that
   facilitate collaborative work with BI Analysts and end users.
   - Ability to read technical documentation and architecture artifacts.
   - Familiar with Agile processes.
   - Understanding of system analysis, business analysis, and requirements
   development and able to utilize such information in analyzing and solving
   complex problems.
   - Ability to work quickly and efficiently in designing and implementing
   technical solutions.
   - Ability to analyze technical and functional aspects of a program and
   troubleshoot complex issues, take corrective actions and implement
   - Ability to work successfully in a team environment and possess the
   flexibility and adaptability to changing requirements is required.
   - Ability to translate needs analysis results into functional designs
   and to develop and learn new technical skills quickly.
   - Familiarity with process recovery capabilities, outcome monitoring and
   audit recording is preferred.

*Experience and Technologies*

The following technologies are typical of the context within which the Data
Modeler/ETL Developer will work. As such, the DM/ETL Developer must have
experience with, or be able to adapt quickly to these types of technologies.

   - Five or more years of SQL Server development experience with at least
   three years Integration service experience.
   - Demonstrated experience with SQL Server Integration Service to accomplish
   regular, non-disruptive data refreshes implementing data validation,
   business rules, and aggregations; design error handling and deployment
   - Experience building data refreshes in SQL Server Integration Service
   from ground up without using any existing packages.
   - Team Foundation Server 2010 or later.
   - Data modeling tools such as ERwin, Altova Database Spy.
   - Productivity tools such as Microsoft Office, Visio
   - Exposure Trillium a plus
   - Exposure to GIS data a plus

Candidates must be willing to submit to a basic background investigation
and drug screening test as a condition of employment.  The position
requires access to sensitive, confidential health data; candidates will be
required to sign and adhere to data use agreements on an annual basis for
certain of the data they handle.  No security clearance is required, but
U.S. citizenship or permanent resident status is a condition of employment.
Candidates must be able to obtain a public trust certificate.

What happens after you submit a resume for an open position?
All job related inquiries are answered via email
Resumes with complete information including rate and visa status are
reviewed first
Only If your resume is a good fit you will be reached via email or phone
You will be informed once your resume is submitted to the client
Once an interview is requested you will be updated
If no interview is requested and you don't hear back from us post
submission, your resume didn't pass the client's screening


Nimra Nayyab
Technical Recruiter
FAAZ Consulting LLC
Please maintain correspondence electronically- based on the number of phone
call inquiries we receive for every positing it is preferred to send
inquiries via email. It may not be possible to give feedback on every
resume we receive. If your consultant may be a good fit, I would personally
reach out to you.We thank each one of you for helping out and being patient.
*P*Please consider the environment before printing this e-mail!

We at FAAZ Group deal with direct client requirements only. If you have
such requirements please add us to your distribution list. If you no longer
wish to receive messages from us kindly mail us with the subject REMOVE. We
apologize for any inconvenience caused.

You received this message because you are subscribed to the Google Groups "SAP 
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
To post to this group, send email to
Visit this group at
For more options, visit

Reply via email to