*Hello,* *Hope you are doing great!!!!!*
*Job Title/Job Code: Senior ETL Developer with Business Intelligence Test Analyst* *Location : Columbus, OH Need Locals* *Duration : 6+Months* *39852 Columbus, OH - IT - DAS* *Job Description:* *Key Role Responsibilities* •Participates in multi-organizational, multi-disciplinary teams to determine, articulate, & codify business requirements; models/designs and is responsible for Extract, Transformation & Loading (ETL) design and development •Design and development of ETLs in data warehouse (with Informatica/Oracle) environment; •Conducts facilitated discussions with customers to review current & gather additional business requirements; analyzes & writes business requirements, scope documents, program specifications & system documentation; •Designs test procedures & tests system for validity & reliability; ensures logical & systematic conversion of customer requirements into total systems solutions that acknowledge scope, schedule & cost constraints; provides data analysis, data architecture & design assistance to functional/systems analysts, application developers & users; •Creates and maintains logical & physical data models & data dictionaries; writes system requirements, general & detailed design documents; participates in management short & long-term planning & assists in agency-wide policy & program development as impacts automated systems; *Each vendor candidate responding to this solicitation must demonstrate the following experience: * *•A minimum of two (2) recent years of experience in ETL development (Informatica) and system analysis;* *•Two (2) years of Dimensional Data Modeling and Data Profiling experience for data warehouse development. * *•Experience integrating disparate systems of record into conformed dimensions and fact tables;* *•Excellent documentation and communication skills;* *•Strong performance tuning skills with ETLs * *Hello,* *Hope you are doing great!!!!!* *Role: Senior Business Intelligence Solutions Architecture* *Duration: 6+Months* *Location Columbus, OH Need Locals * *Interview: Face to Face * *39848 Columbus, OH - IT - DAS * *Role and Responsibilities * Serves as technology solutions leader for the Ohio Business Intelligence solution, responsible for the overall design and implementation of a complex system supporting multiple source data integration and advanced data analytics. Performs the necessary leadership, analysis and design tasks related to the development of enterprise solution architecture (ESA) and enterprise technical architecture (ETA). Work to be performed on the following OHT initiatives, on an enterprise level include: Statewide Data Sharing - Share information across State and Local Data systems to strengthen Decision Support at all levels Data capture, data integration, simple to complex reporting, data augmentation/enhancement, data standardization/master data management, data analytics, data visualization and implementation of data marts Analyze enterprise business drivers to determine corresponding change requirements. Analyze the IT hardware and software environment to detect critical deficiencies, and recommend solutions for improvement. Apply architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability. Define the principles to guide solution decisions for the enterprise. Facilitate communications between IS workgroups and business stakeholders for technical issues and/or major changes; acting as the technical domain subject matter expert. Design and lead the implementation of the Ohio Business Intelligence technology solution based on enterprise business requirements and IT strategies. Design and direct the governance activities associated with ensuring ESA compliance. Develop a road map of the evolution of the enterprise application portfolio from current to future state (as defined by the ESA). Coordinate solution architecture implementation and modification activities. Facilitate the evaluation and selection of software product standards, as well as the design of standard software configurations. Document all solution architecture design and analysis work. Communicates and enforces coding standards Performs code reviews and mentors junior developers. Provide technical guidance to coach and mentor team members; provide performance feedback to manager(s). Keep current and informed of domain related technologies and best practices. Serve as technical owner and point of contact for domain specific solutions. Provide coaching and mentoring to team members in the areas of technical skills and competencies. *Required Experience * *** A minimum of 10 years of Information Technology experience including the development and maintenance of IT technical architecture and standards. * *** 5 years or more in the 3 known DW methodologies (Third Normal Form (Inmon), Dimensional (star schema or Kimball) and Data Vault) and relevant tools, with a proven track record of successfully delivering BI and/or data warehousing projects. * *** 5 or more years of experience modern enterprise architecture, hands-on experience with enterprise business intelligence platforms dealing with large sets of data using newer architecture solutions to help process data with greater speed and scale * *** 5 or more years’ experience of all components of an enterprise technical architecture. * *** 5 or more years’ experience of business process re-engineering principles and processes. * *** 5 or more years’ experience of network architecture and application development methodologies. * *** 2 plus or Years of experience with deployment and administration of: * *§ **ETL technology (preferably Informatica) * *§ **Oracle database technology * *§ **BI Platforms: Business Objects, Cognos, SAS, etc. * *§ **New Technology: Cloud Computing, Data Virtualization, Big Data Analytics etc. * *§ **Unix/Wintel Platform/Infrastructure * *Desired Skills * Experience with mobility of BI applications a plus Experience with healthcare, Medicaid, Medicare, managed care, public sector and/or financial information systems a plus Proven Thought Leadership in the Analytics domain that includes: § Data Integration, Data management, MDM § BI Architecture/Strategy, Analytics, Self Service BI models *Hello,* *Hope you are doing great!!!!!* *Job Title/Job Code: Technical Specialist 4/TS4 Business Intelligence QA/Test Analyst* *Duration: 6+Months* *Location Columbus, OH* *Interview: Face to Face * *DAS -Posting ID: 39850* *Business Intelligence QA/Test Analyst* *Scope of Activities:* • Adhere to formal QA processes, ensuring that the Systems Implementation [SI] team is using industry-accepted best practices. • Oversee all aspects of quality assurance including establishing and reporting on metrics, applying industry best practices, and developing new tools and processes to ensure quality goals are met. • Act as key point of contact for all QA aspects of releases, providing test services and coordinating QA resources internally and externally. • Collaborates with the data warehouse architect, the ETL lead and data warehouse developers in the construction and execution of test scenarios including those applicable to the development, test, and production data warehouse environments • Lead and mentor QA team members, as well as manage outside contract testers. • Create and Provide feedback on test cases, scripts, plans and procedures (manual and automated). Responsible for executing them. • Diagnose defects and track them from discovery to resolution. • Ensure that the SI maintains high quality and accuracy up to software release • Ensure all testing work is carried out in accordance with the Testing Plan, including schedule and quality requirements • Provide feedback to the SI on the implications of testing outcomes on the Ohio Benefits systems • Respond to all requests from stakeholders in a timely professional manner. *Required Skills* *• 2+ years’ of recent experience in the following areas* *o The software quality field including prior hands-on quality assurance experience* *o Data quality and performance acceptance criteria.* *o BI Test Strategy development experience and demonstrate the knowledge in the key areas of the strategy* *o Experience developing and executing test cases, scripts, plans and procedures to support various development methodologies including waterfall and agile* *o The entire software development life cycle and test cycles (Unit, Regression, Functional, Systems, Stress & Scale, Smoke & Sanity)* *o multi-tier web application architecture and deployment* *o QA best practices and methodologies to design, implement and automate processes* *o Experience coordinating with external QA resources between at least 4 teams * *o Using a metrics-driven approach and closed-loop feedback to improve software deliverables and improve predictability and reliability of releases* *• Detailed and effective written communication skills for documenting the features tested and bugs found* *• Highly organized, detail oriented, extremely responsive and able to prioritize a large number of tasks* *• Self-motivated, works well independently and with others* Please revert back with the below requested information along with a latest copy of your profile. Full Name: Phone: Email: Location: Availability: Available for Face to Face: Work Authorization: Validity if H1b: Skype: Rate (Hourly): Thanks and Regards, *Kalyan Kumar* *Data Systems Integration Group Inc, *5131 Post Rd, Suite 175, Dublin, OH - 43017 Email : [email protected] Gmail & Yahoo :* kalyankumar.recruiter* Direct: 614-344-4600 x 113 <http://www.anveta.com/> -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.
