Input your fixed/hourly price in this field.
Freelancers
freelancer

Anjesh K

0.0/5 (0 Feedback)
Member since March 24, 2021

1

  • $1.00 / hr
  • GA
  • Save

• 13+ years of IT experience, primarily with IBM, specialized in the field of Leading Software Development, Architecture, Design, Data Modeling, Enhancement, Testing and Quality Assurance. • Experience in leading and managing ETL, Data warehouse, Data integration projects; handling conflicts, providing feedback and team assessment. • Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF and 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. • Strong programming and analytical skills. Worked as Project lead for large ETL projects, implemented using latest Informatica versions 9x, Teradata and Oracle Exadata. Handled and manipulated really large tables with multi terabytes of data. • Experienced in working with Teradata utilities like BTEQ, Fast load, Multiload, Fast export, Tpump, TPT. Experience in planning and carrying out of Teradata System loading processes, data warehousing, and large-scale database management. • Good knowledge on UNIX/Linux/Korn Shell Scripting, Window scripting and job scheduling of batch jobs. • Extensive experience on Mainframe to write new jobs, BTEQs and executing them utilizing command line and scheduling tools like IBM TWS, Control-M, and ESP. • Excellent understanding of Teradata Architecture and Teradata concepts. • Strong ETL knowledge of Informatica PowerCenter, Teradata Tools and utilities including MLOAD, FASTLOAD, FASTXPORT, 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. • Experienced in developing Business reports by writing complex SQL queries using views, macros, volatile temporary tables, joins, analytic functions etc. Experienced in creating and analysis of Stored Procedures. • Experienced with Physical Data Modeling, Primary Index, usage of Partitioned Primary Index, choosing Secondary Indices. • Experienced in extracting high volume data into text files, applying techniques to keep low impact to performance of the system, and system availability. • Responsible for volumetric analysis, capacity planning and forecasting of data warehouse growth. Worked closely with reporting team in modeling data warehouse. • 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. • Worked with business users and transformed business ideas/requirements into technical work product. Experienced in ad hoc querying, industry-leading analysis, quick deployment, and rapid customization, making it easier for users to make business decisions. • Expertise in project management, test management, risk management, issue handling, handling critical deadlines, and system support. • Proficient in analyzing and translating business requirements to technical requirements and capable of designing complex business application architecture. • Experienced in different industry domains – Insurance, Telecom, Retail/Restaurant, Automotive and healthcare. Experienced in Data Conversion, Informatica PowerExchange and CDC projects. • Demonstrated ability to adapt to ever changing technologies and methodologies. Conformed to different technologies and domains very quickly. • Excellent interpersonal and leadership skills, ability to effectively multitask, quick learner and a good team player. Technical Skills Abilities Databases: Teradata, DB2, Oracle, Oracle Exadata, Netezza, SQL Server ETL Tools: Informatica, Power Exchange, Teradata Loader Utilities (Multi-Load, Fast-Load, T-Pump, BTEQ, TPT), Teradata SQL Assistant, Hyperion, Erwin, Teradata ViewPoint, OBIEE, SQL Developer, SQL Server Management Studio, WinSQL, SQL Tools Languages: PL/SQL, Ruby, XML, Cobol, JCL, CICS, VAGEN, REXX, Java Operating System: HP-UNIX, Windows, MVS, AS/400, z/OS, LINUX, MS DOS Other Tools: Teradata CRM, IBM MDM, SalesForce, Apex DataLoader, MS Visio, HP Quality Center, Clarity, Maestro/IBM Tivoli Workload Scheduler, CA7, SAR, ESP, Pegasys, Changeman, Control-M, Cucumber, Subversion, Connect Direct, Hadoop Methodology: Agile Methodologies and Waterfall Methodology

0

Ongoing 
Projects

0

Completed 
Projects

0

Cancelled 
Projects

3

Ongoing 
Services

0

Completed 
Services

0

Cancelled 
Services

$0.00

Total 
Earnings

* Click the button to send an offer

Send Offer