*Hello,* *Hope you are doing great!!!!!!*
*Posting ID: 43377 Columbus, OH - IT - DOT - Business Analyst 3/BA3* *Role: Business Analyst 3/BA3* *Location: Columbus, OH* *Onsite Interviews are REQUIRED. Local candidates. * *Do not submit candidates unavailable to interview onsite! * *Re-post from 41464 (I would not recommend re-submitting candidates previously submitted, but they will NOT be automatically rejected). Candidate previously selected was removed from assignment. * Description of Duties: 50% of Total Work Effort: Elicit, analyze, document, and communicate business requirements as well translate them into more detailed user stories and/or use cases, and other functional requirements documents such as process flows, screen mock-ups, gap analysis (also known as Business Requirements Documents) 40% of Total Work Effort: Work with business units and other stakeholders to gather requirements, using techniques like interviews and requirement gathering sessions 10% of Total Work Effort: Work closely with the program manager, project manager and senior business analyst. Candidate will be working on a RIMS projects. RIMS is the modernization of our Roadway Inventory maintenance, editing and distribution of related data to system throughout the enterprise Minimum Requirements: • 7 years’ experience in the analysis, documentation of business requirements functional and non-functional • 7 years’ experience creating application prototypes and screen mockups • 7 years’ experience creating graphical representations of complex business processes • 7 years’ experience in using Microsoft products; Visio, PowerPoint, Excel and Word • 7 years’ experience facilitating workshops for requirements gathering • 5 years’ experience managing requirements on several projects at the same time • 7 years’ experience in analyzing data elements of enterprise applications; determining how the data elements relate to each other • 6 years’ experience with business process modeling methods and techniques • 7 years’ experience performing Gap analysis As-Is/To-Be for large applications *Please revert back with the below requested information along with a latest copy of your profile.* Position id: Full Name: Phone: Email: Location: Availability: Available for Face to Face: Work Authorization: Validity if H1b: Skype: Rate (Hourly): *List of Domains you worked with:* *Technical Specializations :* *Hello,* *Hope you are doing great!!!!* *Posting ID: 43379 Columbus, OH - IT - DOH - Technical Specialist 1/TS1* *Re-posted from ID# 42746 (no candidate selected after interviews were completed). Please do not re-submit candidates previously submitted to 42746 (they will not, however, be removed automatically from consideration). They are looking for someone with as many of the skills listed below as possible, the more exposure to various technologies, the better. ONSITE INTERVIEWS REQUIRED* *Technical Specialist 1/TS1 SSIS ETL Developer* *6+Mothns* *In person interview (only Locals)* Description of Duties: 25% of Total Work Effort: Requires 5-7 years’ experience as an SSIS ETL Developer working in Microsoft SQL Server 25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems 25% of Total Work Effort: Strong cube/analytical data model design expertise (preferred) 25% of Total Work Effort: Snowflake and Star Schema design The *SSIS ETL Developer* is responsible for designing, developing, and delivering high-quality output and proactive involvement in the successful delivery of BI systems; through coordination within the rest of the technology department and the business owners. The SSIS ETL Developer is responsible for data profiling of new source systems, designing custom reporting tables (such as fact and dimension), and using SSIS to create ETL packages to fully support reporting solutions in Cognos. Has thorough knowledge of data warehousing and ETL (SSIS required). The Resource must have a good understanding of the business needs and the technical capabilities and be able to help align the BI solutions to meet the business growth objectives. *Must have:* • 5-7 years of experience as an SSIS ETL developer • Data profiling and data modeling experience • Strong in data warehousing concepts and techniques • SQL, T-SQL, PL/SQL techniques • Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension) • Snowflake and Star Schema design • Effective verbal and written communications skills and effective presentation skills • Self-motivator, independent, cooperative, flexible, creative *Preferred:* • Strong OLAP/cube/analytical data model design expertise • Cognos experience *MINIMUM REQUIREMENTS * • Bachelor’s degree in Computer Sciences or Computer Engineering or associated discipline or the equivalent experience. • Microsoft Certified Solutions Developer (MCSD) certification is a plus • Knowledge of administration of SQL Server for transactional and analysis systems • Strong cube/analytical data model design expertise (preferred) • Specific knowledge of Software Deployment Requirements for BI/DW Projects (preferred). • Effective verbal and written communications skills and effective presentation skills. • Self-motivator, independent, cooperative, flexible, creative. *Essential Duties and Responsibilities* • Designs, develops and monitors Enterprise Transformation Language (ETL) processes using SSIS • Performs data profiling, ETL development and administration, and release management • Data modeling using modeling tools and methodologies • Gathering, documenting, and designing data requirements • Strong quantitative and analytical skills with accuracy and attention to detail • Ability to work well independently with minimal supervision, manage multiple priorities, and remain flexible in a dynamically changing environment. • Establishes and implements standards and strategies for data management, lifecycle, and quality • Defines and implements best practices and standards for the data modeling processes. • Creates and maintains the logical and physical data models for the production and Business Intelligence Data Warehouse and Data Marts. • Collaborates in data design walkthroughs to communicate Data Warehouse and Data Mart table designs to the development team. • Develops prototype views and works with business users both internal and external to refine their requirements. • Demonstrates self-reliance in researching technical solutions and product functionality. • Continuously improves existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions. • Monitors production support issues and develops corrective solutions. • Conducts performance tuning of existing data structures. *Data Profiling* We currently are pulling data from a few source systems and are gathering requirements for dozens of new dashboards, each from at least one (and maybe more) source systems. Each dashboard project will require data profiling, ETL, and report development work. On some projects, the ETL developer will take on the data profiling responsibilities in addition to the actually ETL work itself. This involves working with the business analyst, end-user, report developer, and maybe the technical subject matter expert. The Resource must have strong experience creating reporting tables. The reporting tables created will contain the business logic required for the reports, so that the calculations are performed during ETL. There will be reporting tables created for each dashboard project. The ETL Resource needs to have strong SQL skills in order to optimize the table builds, in addition to reviewing and optimizing the SQL code of other developers. *ETL Development* Create ETL packages and jobs to pull data from source system and also create reporting tables (such as fact and dimension). Resource must have experience with data warehousing techniques, including aggregates and slowly changing dimensions. Create new ETL jobs and tune existing ETL jobs. Review code from other data modelers and make recommendations for changes in order to improve performance. Create indexes for tables which are being pulled in as needed. *Administration* Administer ETL system by setting-up new data sources, monitor performance of ETL jobs and resolve all issues, communicate any issues to team and business users, implement practices to mitigate issues, and work with DBAs as needed to investigate any data source connection issues. Schedule ETL jobs to run at optimal times as to not interfere with live operational data, yet pull the most current data. Set-up notification emails to monitor success or failure of ETL jobs. Communicate status of ETL jobs to team and mentor other developers on how to resolve issues. Monitor ETL sequence and make changes as needed. Mid-day data refresh as needed in Development and Production environments. Coordinate Cognos read access to Data Warehouse data sources. *Monitor Growth* The data housed in our data warehouse will be growing exponentially, and in a short time frame. This Resource will be responsible for tracking the growth rate and keeping the team and management updated on any hardware changes and recommendation so that our systems can handle our growth. *Release Management* Selected Resource will learn and follow our release management process. This includes identifying the schedule in which the deployment needs to occur (standard release, non-standard release, or emergency release). The ETL Resource will be responsible for identifying the database rollback process for each database deployment. *Please revert back with the below requested information along with a latest copy of your profile.* Position id: Full Name: Phone: Email: Location: Availability: Available for Face to Face: Work Authorization: Validity if H1b: Skype: Rate (Hourly): *List of Domains you worked with:* *Technical Specializations :* *Hello,* *Hope you are doing great!!!!* *Posting ID: 43374 Columbus, OH - IT - DPS - Programmer 5/PR5* *Job Classification .Net PR5 (Programmer)* *Location: Columbus, OH* *Candidates MUST be available for interview on October 27th between 8:30am and 11:30am.* *(This is a repost of 43104. Two of the three positions have been filled.)* Requirement Description: short description on what they will be working on, objectives, and tasks/deliverables The selected Consultants will work closely with the designated I.T. supervisor, project managers and other developers in an agile development environment. The work scope of the consultant will include requirements gathering, application design, application development, testing, deployment and technical support. *The Consultants, in working with ODPS staff, will be responsible for rewriting legacy applications to .NET applications utilizing C#, MVC, WCF, SQL Server and other technologies. * The new applications will implement a N-tiered architecture and comply with ODPS coding standards. This is canned statement with hours, background check and interview date/time During the interview process with the ODPS staff, the resource consultant must demonstrate competence/experience in their specific area(s) of project assignment. The resource’s experience must also be documented for review and verification. Offered resources not showing technical or functional competence/experience will be sufficient reason to reject the Offeror’s proposal. It is the responsibility of the Offeror to pre-screen their candidates to ensure compliance. Resource will have a background check conducted by ODPS. 1. Strong communication/ leadership skills. 2. Strong influence, collaboration and negotiation experience. 3. Ability to collaborate with supporting resources across business and/or functional lines. 4. Have excellent oral and written skills/possess strong meeting and work session facilitation skills. 5. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines. 6. Have strong understanding of prioritization stemming from the elicitation of system and/or user requirements. 7. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills. 8. Must be knowledgeable in the English language/speak clearly and understandably use the English language. *Mandatory Requirements/Time* 1. 5 years of verifiable experience as a Senior .Net Web Developer developing ASP.NET WebForms applications at least 4 years 2. 5 years of verifiable ASP.NET experience developing with the C – Sharp (C#) language. 3. 5 years of verifiable experience with SQL Server Database Design and development including optimization of queries, creating tables, views, stored procedures, and functions. 4. 2 years of verifiable experience developing web applications utilizing the 4.0 .Net Framework or higher. 5. 3 year of verifiable Service Oriented Architecture (SOA) experience developing and securing Windows Communication Foundation (WCF). 6. 1 year experience or a demonstrable understanding of N-tier environments as it relates to development and deployment. 7. 2 year experience or a demonstrable understanding of code repository strategies, code promotion strategies and recovery using Team Foundation Server. 8. 2 years of verifiable experience implementing Asynchronous JavaScript and XML (AJAX) enabled controls within Active Server Pages (ASP).Net Web applications. 9. 1 year of verifiable experience developing reports in SQL Server Reporting Services (SSRS) and making them accessible within an MVC web application. *Please revert back with the below requested information along with a latest copy of your profile.* Position id: Full Name: Phone: Email: Location: Availability: Available for Face to Face: Work Authorization: Validity if H1b: Skype: Rate (Hourly): *List of Domains you worked with:* *Technical Specializations :* Thanks and Regards, *Kalyan Kumar* *Data Systems Integration Group Inc, *5131 Post Rd, Suite 175, Dublin, OH - 43017 Email : kal...@dsiginc.com Gmail & Yahoo :* kalyankumar.recruiter* Direct: 614-344-4600 x 113 *http://kalyankumarrequirements.blogspot.in/ <http://kalyankumarrequirements.blogspot.in/>* www.dsiginc.com [image: Email Signature2] -- You received this message because you are subscribed to the Google Groups "US_IT_ Jobs" group. To unsubscribe from this group and stop receiving emails from it, send an email to chandrakants+unsubscr...@googlegroups.com. To post to this group, send email to chandrakants@googlegroups.com. Visit this group at https://groups.google.com/group/chandrakants. For more options, visit https://groups.google.com/d/optout.