| IT Specialist Expert at York, New York, USA |
| Email: [email protected] |
| From: Praveen Kumar, Largeton inc [email protected] Reply to: [email protected] IT Specialist Expert 100% ONSITE - Albany, NY locals only *When responding to this email, please be sure to use the requirement number in the subject line of your reply* ONLY SEND YOUR #1 CANDIDATE THAT MATCHES ALL OF THE REQUIRED SKILLSETS (ONLY ACCEPTING 1 CANDIDATE PER VENDOR, SO PLEASE MAKE SURE THE CANDIDATE YOURE SUBMITTING IS A PERFECT MATCH)!! Please NOTE: All interviews are IN-PERSON! Please find attached the details of our new requirement: IT Specialist Expert 100% ONSITE - Albany, NY locals only Client: State Government of NY / Information Technology Services (ITS) Your candidates MUST meet the number of months requested for each skill set listed below A copy of Bachelors Degree and other credentials such as any certifications MUST be submitted with the Candidate Response Form USC/GC Job Description, Required Skills, & Experience: Provide a short description of the Position: These data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical ITS initiatives as well as requirements from various agencies. These positions will also develop and maintain ETL solutions, operational reports, executive dashboards, and analytics. Additionally, these positions respond to all data warehouse and BI related ad hoc inquiry requests, development of dashboard features, and development of BI technical solutions for continued reporting requirements. Provide a complete list of the day-to-day tasks to be performed by the Selected Candidate: Gather and validate of BI and reporting requirements. Document requirements & solutions Perform Data profiling on the source (OLTP) systems Design and review dimensional models 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 r SQL Server Integration Services (SSIS) or Oracle Data Integrator (ODI) Develop reports and analytics using one of the tools like SQL Server Reporting Services Develop complex queries using Transact-SQL leveraging analytic functions. Perform necessary Testing Complete Documentation Position Mandatory Qualifications (ALL REQUIRED): Position Skill Level Description: 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. List all the Position Requested Qualifications (ALL REQUIRED): 84 months of experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using ETL tools like SQL Server Integration Services (SSIS) or Oracle Data Integrator (ODI) 60 months of experience in reporting and analytics tools such as Tableau or Power BI 84 months of experience in complex SQL development leveraging analytics functions using in SQL Server or Oracle 84 months of experience in SQL Server Integration Services (SSIS) development. 60 months of experience in Dimensional or OLTP Modeling to support data warehouse environments. 84 months of experience in internal and external stakeholder communications and outreach, including the development of presentations and other material. Thanks & regards Praveen Kumar Sr. US IT Recruiter Phone: 571-479-4034 EXT : 327 Email: [email protected] LARGETON INC. 13800 Coppermine Rd, Herndon, VA 20171 Disclaimer: If you are not interested in receiving our e-mails. Then please reply with a "REMOVE" in the subject line Keywords: business intelligence active directory rlang information technology green card New York Virginia |
| [email protected] View all |
| Tue Jan 16 20:38:00 UTC 2024 |