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
10838 Albany, NY 12243 ETL Developer: PL/SQL, UNIX Shell Scripting, ETL Design/Data Warehouse Development, Cognos 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=10838 (ETL Developer: PL/SQL, UNIX Shell Scripting, ETL Design/Data Warehouse Development, Cognos) in Albany NY 12243 (AMI)

Estimated Length: 24 months Full-Time 8 hour days with start time at or after 7:30

Mandatory Requirements

Expert 84+ months 

Desired Requirements

  • 84 Months Demonstrated hands-on experience Developing and testing query solutions using Oracle PL/SQL query
  • 84 Months Demonstrated hands-on experience with UNIX Shell Scripting
  • 84 Months Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/ IBM Data Stage
  • 72 Months Demonstrated hands-on experience with Performance tuning and Optimization of sessions, mappings, sources and targets, Production support, trouble shooting and solving migration issues, and identifying errors during data loads and transformations for Cognos or OBIEE 10/11g environment.
  • 72 Months Demonstrated hands-on development experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10/11g environment
  • 72 Months Demonstrated hands-on ETL development experience in Oracle environment with IBM Datastage 
  • 60 Months Demonstrated ETL development experience working with PPI, SSA, or HIPPA data security requirements.
  • 84 Months Demonstrated experience mentoring and assisting other developers
  • Bachelor Degree in computer science, information science, health science, engineering, or mathematics

 

Responsibilities

  • Capture and load source system data via ETL processes into the data warehouse; 
  • Develop, test and implement program logic for ETL development. 
  • Efficiently implement team developed ETL technical specifications 
  • Optimize ETL data load jobs to improve performance and automate them and identify and create solutions to improve system performance and availability; 
  • Develop and maintain logical and physical dimensional data models for Data Warehouse/Data Mart 
  • Following agency standards to ensure the accuracy and integrity of data and applications through analysis and coding as performed by the ETL process; 
  • Writing clear ETL process and data modeling documentation and clear documentation of all associated tasks and documents. 
  • Ongoing design, development, maintenance, and support of ETL workflows; 
  • Investigating and resolving data loading and/or data integrity issues
 
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