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
10835 Albany, NY 12226 ETL Developer: ETL Tools, Pentaho Business Analytics, Tableau, SQL, Sybase ASE, PDI, Star Schema DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
1196-MH2857@apply.maxhire.net    

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

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

Mandatory Requirements

Senior 60 – 84 Months

Desired Requirements

  • At least 60 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 60 months experience delivering reporting and analytics solutions using tools such as Pentaho or Tableau
  • At least 60 months experience in complex SQL development leveraging analytics functions using Sybase ASE or SQL Server
  • At least 24 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 60 months experience in doing data profiling and source to target mappings.
  • At least 60 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