OnBenchMark Logo

ANKIT (RID : 210ulopu9ji4)

designation   DATA ENGINEER

location   Location : PUNE, India

experience   Experience : 10 Year

rate   Rate: $21 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 1
Total Views : 56
Key Skills
Data Engineer AWS Red Shift Data Ware Housing Salesforce SQL ORACLE POWER BI PYTHON
Discription

Ankit

Sr. Software Engineer                                                                                       

Objective:

       To pursue a challenging career in a progressive organization that gives me scope to apply my knowledge, experience and provides ample opportunity to grow along with the organization in both personal and professional level.

 

Professional Details:

  • Around 9 years of I.T experience in Development and Implementation of Data warehousing with Informatica Power Center, OLTP and OLAP using Data Extraction, Data Transformation, Data Loading and Data Analysis.
  • Working on AWS, S3, Redshift with IOT data for creating Data lake and Data Warehouse.
  • Writing algorithm to predict future device failures
  • Involved in creating AWS infrastructure from scratch
  • Successfully completed POC and data migration using Hadoop Ecosystem
  • Having very good exposure to GERMAN language (Studied for 2 years in my High School)
  • Successfully completed POC and migrated data from local to google cloud using google cloud platform.
  • Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Unit Testing.
  • Sound Knowledge on Informatica Power Center (9.5.1,10.2), Talend 7.2, Oracle, Toad, DB2, Data warehouse concepts and UNIX, SQL server, Salesforce, Amazon Redshift, Amazon S3.
  • Worked on Salesforce Integration with informatica, and CRM Module to help users in their report design and development.
  • Having good exposure google cloud platform.
  • Worked on Amazon redshift, Amazon S3 with Talend help users in their report design and development.
  • Created every possible scenarios in SQL while implementing. Also Implemented SCD1 and  SCD2 in purely SQL on redshift.
  • Well versed in developing complex SQL queries, unions and multiple table joins and experience with Views.
  • Extensively used Informatica tools such as Informatica Server and Client tools like Designer, Workflow manager, Workflow Monitor, Repository Manager.
  • Experience in implementing the complex business rules by creating transformations, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy, HTTPS transformation, XML), and developing complex Mapplets and Mappings.
  • Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
  • Involved in Designing Warehouse for multiple projects thereby creating dimensional model and HLDD” s and LLDD’s
  • Experience in working with Agile Methodologies
  • Experience in working with SCRUM and KANBAN
  • Developed Slowly Changing Dimension Mappings of type I, II and type III (version, flag and time stamp).
  • Developed mapping using Parameters and Variables. Extensively used parameter file to pass mapping and session variables.
  • Experienced in Data modeling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
  • Have knowledge on Kimball/Inmon methodologies.
  • Experience in Investment Banking & Financial Domain, Insurance and Pharma.
  • Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.
  • Involved in requirement gathering/analysis, design, development, and testing and production roll of Reporting and A
 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!