Anjesh Kumar

Anjesh Kumar Email and Phone Number

Lead Technical Consultant at Infomatics Corp. Exp'ed in Healthcare, Auto, Telecom, Insurance, Retail/Restaurant industry @ Infomatics Corp
dulles, virginia, united states
Anjesh Kumar's Location
Atlanta Metropolitan Area, United States
Anjesh Kumar's Contact Details

Anjesh Kumar personal email

About Anjesh Kumar

-15+ years of IT experience, primarily with IBM, specialized in the field of Leading Software Development, Architecture, Design, Data Modeling, Enhancement & Testing. -Experienced in leading and managing ETL, Data warehouse, Data integration, BI reporting projects.-Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF & Database Architecture for OLTP and OLAP applications, Data Analysis and ETL processes.-Strong experience in modeling, designing, developing, loading and maintaining FACT and dimension tables. Expertise in projects utilizing relational and dimensional (star schema) modeling. -Worked as Project lead for large ETL projects, implemented using Informatica 9x, Teradata and Oracle Exadata. Handled and manipulated really large tables with multi terabytes of data.-Experienced in working with Teradata utilities like BTEQ, FastLoad, MultiLoad, Fast export, TPump, TPT. -Experienced in Perl, UNIX/Linux Shell Scripting/Korn Shell, Window scripting. -Strong ETL knowledge of Informatica PowerCenter, SSIS/SSAS/SSRS, Teradata Tools and utilities including MLOAD, FASTLOAD, FASTEXPORT, BTEQ, TPT. Strong knowledge in Oracle, DB2, MS SQL server and SQL scripting.-Very strong on Teradata SQL query optimization techniques like: EXPLAIN feature, COLLECT STATISTICS, Secondary Indexes, Partition Primary Index (PPI), Volatile and Global temporary tables.-Experience in Agile methodology, including Extreme Programming, Test Driven Development and Scrum/sprint/iterative development.-Excellent knowledge & working experience in all phases of software development life cycle (SDLC) including planning, analysis, design, development, testing, and implementation.

Anjesh Kumar's Current Company Details
Infomatics Corp

Infomatics Corp

View
Lead Technical Consultant at Infomatics Corp. Exp'ed in Healthcare, Auto, Telecom, Insurance, Retail/Restaurant industry
dulles, virginia, united states
Employees:
60
Anjesh Kumar Work Experience Details
  • Infomatics Corp
    Lead Technical Consultant
    Infomatics Corp Oct 2013 - Present
    Greater Atlanta Area
    - Working with Enterprise team to build overall architecture and build data models.- Implement projects requiring CDC (Change Data Capture), PowerExchange, Data Quality analysis, Data profiling, Data Cleansing and metadata management - Work with business to understand Business Requirements and prepare Technical Specification, Data Modeling, Design document, data flow diagram, use cases and test approach documents.- Understand requirements from Functional and Technical specifications and help team to understand the business use cases.- Design and construct ETL (Extract, Transform, Load) processes on Oracle Exadata/Teradata/SQL Server using Informatica. - Solve complex user requirements using Informatica transformations. Apply different approaches and constructing best possible solution for underline business requirements.- Create Informatica mappings using transformations such as the Source qualifier, HTTP, Java, Web Service Consumer, Normalizer, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.- Identify performance bottlenecks and optimize respective databases and processes for performance improvement. Experienced in analyzing query logs and explain paths. - Preparing technical business solution strategy/approach using ETL technologies and present it to Design Review Board for their approvals.- Modeling and Implementing FACT tables and Slowly Changing Dimension(SCD2) tables.- Providing Support to production job down scenarios and resolving issues quickly.
  • Ibm
    Sr Project Lead
    Ibm 2012 - Sep 2013
    ETL/Data warehousing development
  • Ibm
    Project Lead
    Ibm Nov 2010 - Mar 2012
    Columbus, Ohio Area
  • Ibm
    Team Lead
    Ibm Jan 2004 - Oct 2010

Anjesh Kumar Skills

Data Warehousing Db2 Agile Methodologies Etl Requirements Analysis Software Project Management Oracle Data Modeling Solution Architecture Software Development Informatica Testing Requirements Gathering Java Enterprise Edition Unix Soa Pl/sql Web Services It Strategy Test Automation Program Development Ruby Teradata Data Warehouse Business Intelligence Data Integration Microsoft Sql Server R Python Microsoft Azure Maestro Alteryx Tableau Ruby On Rails Cucumber Test Driven Development Atdd Amazon Redshift Postgresql Amazon Web Services Java

Anjesh Kumar Education Details

Frequently Asked Questions about Anjesh Kumar

What company does Anjesh Kumar work for?

Anjesh Kumar works for Infomatics Corp

What is Anjesh Kumar's role at the current company?

Anjesh Kumar's current role is Lead Technical Consultant at Infomatics Corp. Exp'ed in Healthcare, Auto, Telecom, Insurance, Retail/Restaurant industry.

What is Anjesh Kumar's email address?

Anjesh Kumar's email address is an****@****ail.com

What schools did Anjesh Kumar attend?

Anjesh Kumar attended Mahatma Jyotiba Phule (Mjp) Rohilkhand University.

What skills is Anjesh Kumar known for?

Anjesh Kumar has skills like Data Warehousing, Db2, Agile Methodologies, Etl, Requirements Analysis, Software Project Management, Oracle, Data Modeling, Solution Architecture, Software Development, Informatica, Testing.

Who are Anjesh Kumar's colleagues?

Anjesh Kumar's colleagues are Praneeth G, Prapthi V Anchan, Shubhangi Pardikar, Sunny Sunny, Syed Azhan Ahmad, Jessie Palli, Kanthishree Shenoy.

Not the Anjesh Kumar you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.