Hello Partners,
Please check the following requirement and share your consultant resumes to email: ra...@lor-venk.com / Phone: 804-554-1121. *1)Role: Senior Data Modeler* *Client: Capital One* *Location: Richmond VA and McLean VA* *Duration: Long term* *Any visa is accepted/ All EAD Visa and H1B transfers also accepted* *Minimum Experience: 9+ Years Mandatory* *Description:* · Over *8 *years of experience in Software development and consulting industry involving and support project in *Client Server, Data warehouse, Data modeling and Web application environments.* · Expert knowledge in *SDLC Software Development Life Cycle.* · *5* Years of Experience in Designing the Data models and developing the Database Schemas using *Erwin*. · Experience in *Data warehousing DW, Master Data Management MDM, Dimension data modeling* in different environments like Healthcare, Food services, Telecoms, Airlines and Banking. · Extensive experience in *Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources, and proficient in Relational Database Management Systems RDBMS .*. · Experience in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverable in the Organization by creating *Use Case Models, Data Flow Models, Work flow Analysis, Functional decomposition Analysis, Object Modeling* along with Activity Diagrams, *Sequence Diagrams, Report Flow* and *State Diagrams* using Rational Rose and Microsoft Visio. · Experience with *Business Process Modeling, Process Flow Modeling, Data Flow Modeling* · Proficient in designing *Star Schema, Snow Flake Schema, OLAP and OLTP Data Modeling* using Erwin modeling tool. · Experience in both *Inmon and Kimball methodology* for a data warehouse environment. · Strong *RDBMS concepts* and well experience in creating database *Tables, Views, Sequences, triggers etc* by taking the Performance and Reusability into consideration. · Optimal in performing *Database Tuning* in reducing the *Cost and Cardinality* of the SQL Queries by using various Hints and Optimizers on looking at the *Explain Plan and using TKprof and AWR.* · Experience in *creating Normal, Unique and Bitmap Indexes to *improve the performance of the *SQL Queries, Functions, Procedures, Packages and Database.* · Experience in *Relational, XML, DTD, XML Schemas in Oracle 11g/10g/9i/8i, SQL Server 2000-2005, SQL Server-2008, DB2, Sybase and Teradata databases.* · Experience in performance optimization at Database level for *SQL and PL-SQL scripts*. · Excellent problem solving and communication skills. *Required Skills:* · *Data Modeling: *Erwin 7.x, Erwin 8.x, Power designer, UML, ER studio, Visio, Toad Data Modeler, Oracle Designer, Embarcadero. · *Oracle: *Oracle 10i/9i/11g, SQL Server 2005/2008, DB2, MS Access 2000, Sybase. · *BI Tools: *Tableau, SAP Business Objects. · *Other Skills: *Rapid SQL 7.x, Toad, Putty, SSH, Ultra edit, FileZilla FTP client. *2)Role: Sr. Data Engineer/ Big Data/ Hadoop/ Spark/ ML EngineerClient: Capital OneLocation: Richmond VADuration: Long termAny visa is accepted (OPT, CPT, H1B, H1B Transfers, GC, GC-EAD, H4-EAD, USC, E3, L2-EAD)Minimum Experience: 8+ years/ Mandatory* *Description:* 1. Designs, modifies, implements, tests, and provides operational support for enterprise software products and platforms, including software infrastructure and development tools for Data Platform components and modules in AWS-hosted environments 2. Engages in building solutions leveraging technologies including but not limited to Scala, Spark, Hive and AWS services such as EC2, S3, EMR, ELB, Kinesis, SNS, Redshift, Data Pipelines 3. Provides consultation on complex projects and is considered to be a top-level contributor 4. Relies on extensive experience and judgment to plan and accomplish goals according to timelines and budgets agreed upon with business stakeholders 5. Communicates proactively and effectively with team members and other project stakeholders in a highly Agile environment. *Required Skills:* 1. Minimum of 7 years in the IT industry with a focus on the development of complex business systems. 2. Strong knowledge and minimum of 3 years of hands-on experience with Big Data technologies with data stores such as DynamoDB, Cassandra and related tools and systems 3. Deep technical understanding of Spark, and Hive. 4. Strong background in Scala, relational databases, and complex systems integration. 5. Experience building and supporting complex systems in AWS Cloud environment 6. Experience in data modeling for NoSQL databases 7. Strong knowledge of continuous integration and deployment, test driven development, and unit test automation 8. Experience in developing an enterprise product line using Agile-Scrum development methodologies 9. Excellent verbal and written communication and presentation skills 10. Experience in the Healthcare software or IT industry preferred. -- You received this message because you are subscribed to the Google Groups "Resumes" group. To unsubscribe from this group and stop receiving emails from it, send an email to resumes+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/resumes/ba27dee2-bf78-4aec-8b68-c963b6aea612n%40googlegroups.com.
