*Please send replies/profiles to mohan.ga...@somasoftsol.com <mohan.ga...@somasoftsol.com>*
*-All our requirements are Direct client Requirements.* *-Please Do submit only qualified profiles.* *-Please share the resumes only after you discuss with your consultant. * Please review the below SQL positions open with our direct clients and let me know your availability and comfort. *Positions #1:* Location: Mtn. View, CA 6 months contract Mandatory Skills: - The Database Developer for eBIO will report to the Manager of Data Platform at eBIO and be responsible for the definition and implementation of eCommerces worldwide data platform administration, development and Project Release Management for eBIO. - Specifically, it requires developing custom reports and custom ETL scripts for datamarts, ensuring reliable performance and availability in a 24x7 environment for a worldwide community. Success in this role will result in the Database Developer for eBIO assisting development and release management for the entire data platform for eCommerce globally. - Generating custom SQL reports to address ad-hoc requests from Business communities. - Developing and maintaining ETL processes to populate departmental datamarts and key data feeds. - Investigating data issues and recommending realistic solutions based on operational constraints. - Performing data analysis and data mining. - Designing, developing and implementing database processes and programs to import, export and process data for reporting and analysis to measure the efficiency of business operations globally. - Automating, maintaining and improving current processes to ensure uninterrupted operations and pro-active warnings. - Observing Project Lifecycle and performing object migration across different environments (DEV/QA/PROD.) - Participating in design and code reviews. - Fine tuning reporting queries and report implementation to ensure that the BI/RDBMS Servers are not impacted adversely. - Defining and maintaining Business Continuity plans for data platform for eBIO. - Working in a distributed global team environment across US, Europe and Asia. - -Must be a proven top performer and team player that enjoy challenging assignments in a high-energy and fast growing workplace. - Must be able to manage multiple tasks to deliver according to schedule and priority. - Must be a self-starter and quick learner. - 4+ years experience in database, data warehouse, business intelligence, or software development. - 3+ years experience delivering ETL solutions with SQL Server Information Services (SSIS). - Heavy experience with MS SQL Server is required. Some experience with other databases such as Oracle is assumed. - Experience in performance tuning. - Experience in OLTP and OLAP techniques and technologies. - Deep understanding of RDBMs and Data Modeling Techniques. - Experience with Microsoft and Unix Operating Systems Desktops and Servers. - Excellent verbal and written communication skills with the ability to clearly present complex technical topics to technical and non-technical audiences. - Must be a good listener. - Detail oriented with superior analytical, problem solving, pragmatism and organization skills. - Bachelors or Master’s degree, or foreign equivalent, in Computer Science, Engineering or a closely related discipline and 4 (four) years of experience in the Job Offered or 6 (six) years of experience in software engineering, Databases, Data warehouse, Business Intelligence, Architecture and Operations. - Knowledge of MS SQL Server and SSIS is required. - Knowledge in Microsoft Excel and Access as supplementary tools is required. - Knowledge of other databases like Oracle is a BIG plus. *Position #2:* Business Intelligence Lead Irving, TX 6 months (contract to hire) Need GC/Citizens – EAD also fine Business Intelligence Lead Responsibilities: - The Business Intelligence Lead is responsible for the technical implementation of current and future data warehouse, business intelligence solutions and data migration strategies. - Implement new business intelligence and data warehouse requirements through the use of SQL, ETL, business intelligence tools, and database programming and reporting tools. - Meet with customer business and technical leaders to identify and scope the business opportunities, document and vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats. - Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse. - Develop optimized database design to achieve acceptable performance by tuning view, tables and indexes for proper response time. - Develop new capabilities and architectures that capitalize on the development of client portal, and ad- hoc BI capabilities - Respond to ad-hoc query requests from various departments including Product, Vendor Services, Finance, and Professional Services. - Full life-cycle development and maintenance of data warehouse, ETL, and business intelligence solutions. - Implement new business intelligence and data warehouse requirements through the use of SQL, ETL, business intelligence tools, and database programming and reporting tools. - Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners. - Provide guidance and recommendation on BI reporting packages Business Intelligence Lead Required Skills: - Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners. - Strong experience with the Microsoft BI stack (SSRS, SSIS, SSAS) - Strong experience developing SSAS and implementing date warehouse solutions - Proficient with the design of database architectures, data warehouses, data migrations, data marts, business intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge. - Must have management skills to drive projects to completion on schedule with junior team members and mid-level business professionals. - Strong understanding database methodology, data analysis, advanced SQL queries, ETL and business intelligence application required. - Strong communication skills, both written and oral; Ability to build and deliver presentations to all levels of the business and effectively explain complex issues and concepts in simple, understandable language. *Position #3:* SQL Server Developer cum DBA Loc:Madison,NJ Dur:6+ months contract • At least 7+ years working with SQL Server 2000, 2005 & 2008/2008R2. • Strong T-SQL development skill is a must. • Expertise in SQL Server Architecture and Data Modeling. • At least 5 years of experience analyzing, designing, developing, testing, and supporting SQL Server solutions for web based applications. • Experience with SQL Server administration. • Expertise in SQL Server Integration Services (SSIS) and stored procedure development. • OLTP/OLAP Design and development. • Experience working with large data sets. • Performance tuning using indexing and partitioning techniques. • Monitoring queries and report behavior to assure performance expectations are met. • Conducting data investigations and assisting business partners with complex data analysis and ad-hoc queries. • Good understanding of SDLC. • Use of version control software, such as Microsoft TFS. • Excellent problem solving and root cause analysis skills. • Must be able to communicate clearly with management, peers, and customers regarding requirements, issues, and resolutions. • Familiarity with job scheduling tools such as Argent. • Knowledge of accounting/financial software or real estate systems. • Excellent written and verbal communication skills. • Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field or equivalent. *Position #4:* Candidate should be local/ willing to go for F2F. Req: SQL BI Analyst (2 positions) Contract for at least 6 mos. but extendable/Hire Location: Dublin, CA (Locals only) This is our direct Client is opening for Business Intelligence Developer located in Dublin, CA. This is a full time or Contract position. The salary and hourly rate DOE. This position will require the following tasks The person who joins our team will be responsible for gathering business requirements, analysis, reengineering, design, and implementing the solutions. You should also have the capability to quickly find novel and innovative solutions to both business and technical challenges. Responsibilities: Interact with functional experts, at all levels, to understand business issues, challenges and identify new opportunities; Write clear detailed functional requirements; Develop functional and technical design specification documents; Collaborate with users and team members to provide accurate estimates for assigned tasks; Develop test plan and specification to ensure that developed solution meets all user requirements; Identify potential risks/issues and recommend creative solutions; Deliver assignments on-time and on-budget with high level of quality; Provide accurate timely status reports/scoreboards; Perform support and troubleshooting to ensure stability of our BI environments; Work individually and as a team member to ensure stability of our production systems; Follow entire Software Development Lifecycle methodology. Qualifications: Bachelor's degree in Computer Science or equivalent; 4-6 years development experience in Data Warehouse/Business Intelligence environment is required; Must have at least 2 data warehouse development efforts, preferably in SQL Server environments; Expertise in the Microsoft BI solution offerings including SSIS, SSRS, SSAS/MDX, Performance Point is required; Experience in developing ETL/reports/cubes in Microsoft Dynamics - AX environment will be preferred; Knowledge of C#.Net, Visual Basic.Net and ASP.Net preferred; Complete understanding of Software Development Lifecycle methodologies is required Experience guiding and mentoring both technical and non-technical individuals is required; Working knowledge of Oracle PL/SQL, Crystal Reports, Hyperion Essbase and Sharepoint is preferred. Experience in OLAP architecture design, multi-dimensional data modeling, data architecture, data mart design, data security and process modeling is preferred. Perform other assigned tasks/ duties and participate in projects as assigned Please let me know if you need any more information. Thanks & Regards, *Mohan Ganti* Mail: mohan.ga...@somasoftsol.com <recruite...@metmox.com> *Disclaimer: We respect your Online Privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact Information and a method to be removed from our mailing list. If you are not interested in receiving our emails then please reply with a "REMOVE" in the subject line and mention all the email addresses to be removed with any email addresses.* -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.