IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
10834 Albany, NY 12226 ETL Developer: ETL Tools, Pentaho Business Analytics, Tableau, SQL, Sybase ASE, PDI Develop (2pos) DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
jobs@iit-inc.com    

Subject=IIT Career Site/Resume for JobID=10834 (ETL Developer: ETL Tools, Pentaho Business Analytics, Tableau, SQL, Sybase ASE, PDI Develop (2pos)) in Albany NY 12226 (AMI)

Estimated Length: 24 months Negotiable daily work hours (strongly prefer starting between 7:30 and 9:00am through 4:00 or 5:30pm).

Mandatory Requirements

Expert 84+ Months 

Desired Requirements

  • At least 84 months experience in building extraction and transformation of transactional data using ETL (extract, transform, load) tools like Pentaho Data Integration (PDI) or SQL Server Integration Services (SSIS)
  • At least 84 months experience delivering reporting and analytics solutions using tools such as Pentaho Business Analytics or Tableau
  • At least 84 months experience in complex SQL development leveraging analytics functions using Sybase ASE or SQL Server
  • At least 48 months experience in Pentaho Data Integration (PDI) development.
  • At least 60 months experience in Star Schema / Dimensional Modeling to support data warehouse environments
  • At least 84 months experience in doing data profiling and source to target mappings.
  • At least 84 months experience in internal and external stakeholder communications and outreach, including the development of presentations and other materials

Responsibilities

  • Gather and validate of BI and reporting requirements
  • Document requirements & solutions
  • Perform Data profiling on the source systems
  • Design and review star schema dimensional model to support data warehouse and data marts
  • Perform Source to Target Mapping between source system database and data warehouse target database
  • Develop ETL transformations using one of the ETL tools like Pentaho Data Integration (PDI), or SQL Server Integration Services (SSIS)
  • Develop reports and analytics using one of the tools like SQL Server Reporting Services (Pentaho or Tableau)
  • Develop complex queries using Transact-SQL leveraging analytic functions
  • Perform necessary Testing
  • Complete Documentation
 
Submit Resume For This Job (via email)
 
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
 
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer