09/06/2022 updated

**** ******** ****
100 % available

ETL Developer, ETL Developer, ETL Developer

bangalore, India
India
B tech
bangalore, India
India
B tech

Profile attachments

CV - ashish chaurasiya

Java (Programming Language)Microsoft WindowsIBM AIXBusiness LogicAtlassian JiraUnit TestingCA Workload Automation AeBugzillaUnixData IntegrationExtract Transform Load (ETL)Data QualityData WarehousingLinuxDocument Management SystemsGitHubUnix ShellMicrosoft SQL ServersTeam Foundation ServerOracle Business Intelligence Enterprise EditionOracle DatabasesOracle ApplicationsScrum MethodologySalesforce.ComService-Oriented ArchitectureSimple Object Access Protocol (SOAP)PL-SQLSQL DatabasesSQL Server Integration ServicesSubversionTeradata SQLSoftware VersioningWeb ServicesWeb Services Description LanguageExtensible Markup Language (XML)Salesforce CommunitiesScriptingNetezzaSybaseTest ScriptsInformatica CloudHp AlmGitMicrosoft TfsApache KafkaSalesforce Object Query Language (SOQL)Oracle EbusinessSoftware Version Control
Informatica 9.5, Power exchange, DAC 11.1.1, Unix scripting, PL/SQL, Oracle, Informatica, Informatica Analyst, Informatica Developer, Oracle 11g, ControlM, OBIEE RPD, SalesForce development/Admin, file versioning control tool, GITHUB, SVN, GIT shell, defect, STM, JIRA, Bugzilla, SQL server, Netezza, TeraData, Informatica 10.x, Power center, OBIEE 11g, Informatica power exchange CDC, OBIA 7.9.x, Informatica Data quality, Informatica Cloud integration, Informatica scheduler, AutoSys, DAC. OS Windows, Linux, Unix, IBM-AIX, TCS STM, HP ALM, Version Control, GIT HUB, directory, Microsoft TFS, Scripting Language, Phyton, SalesForce, Windows XP, SSIS, Rally, Informatica cloud, Salesforce Communities, App Builder, UI, Scrum, data quality, SOQL, Document management, Atlassian Suite - JIRA, TFS, Data integration, Kafka, queue, OBIEE, ETL, SOA, WSDL, SOAP request, web, Java transformation, Web services consumer, XML Parser, SQL, DWH, DAC, Oracle EBS 7.9.6.4, IDQ, Oracle EBS, test scripts, Sybase, ETL logic, EDW, Oracle 10g, Unit Testing, Regression, tab delimited, business logic, folder security

Experience

Professional experience5 - 10 years

Languages

EnglishGood

Project history

ETL Developer

Walmart labs
Project 2:
Client Name: Walmart labs
Project Name : ASDA Groceries

Operating Software Windows XP
Tools Used Informatica 9.5, Oracle 11g, Unix, OBIEE 11.x, JIRA.
Role ETL Developer
Duration Jan.2018 to June2018

Responsibilities:
* Writing code according to JIRA story, HLD (High level design) doc.
* Worked on SOA (Service oriented architecture) WSDL, SOAP request, web services hub.
* Followed agile methodology and scrum planning.
* Implementation of Java transformation, Web services consumer, XML Parser, SQL transformation.
* Developed and maintained informatica power exchange jobs.
* Maintained the informatica administration part of the project.
* Handled the Automation of the project and the deployment part of the Walmart ASDA.
* Application Development & Supporting application post implementation.
* Responsible for End to end delivery of DWH components along with OBIEE RPD development.
* POC on informatica Data validation option.

ETL Developer

Project 3:

Client Name : Daman Insurance
Project Name : Atlas(Abu dhabi)

Operating Software Windows XP
Tools Used Informatica, DAC, Oracle EBS 7.9.6.4, IDQ, OBIA
Role ETL Developer
Duration DEC.2015 to Dec.2017( Abu dhabi, UAE)

Responsibilities:
* Configured and Installed informatica, Oracle 11g for ST, DEV Environment.
* Performance Tuning of Mappings with methods like Partioning, Lookup Caches, Sort Input etc.
* Implementation of Oracle EBS in windows environment for HR and FINANCE schema.
* Validate the data using automated test scripts and SQL, PL-SQL etc.
* Load data into Sybase/Oracle based datawarehouse.
* Develop, test and support ETL logic using Informatica.
* Informatica administration and repository maintenance.
* Requirement gathering from client and develop using informatica 9.5
* Used Data Validation Option and Informatica data quality.

ETL Developer

Project 4:

Client Name : HDFC Bank
Project Name : HDFC EDW

Operating Software Windows XP
Tools Used Informatica 9.5, Netezza, SQL Server, Oracle 10g, Unix scripting, PL/SQL, Autosys, Informatica Data
quality(Informatica Analyst, Informatica Developer)
Role ETL Developer
Duration Sep.2012- Dec.2015

Responsibilities:
* Design and develop the modules with high scale of reusability and best performance.
* Involved in Unit Testing, Regression Testing.
* Data migration across various platforms.
* Working with wide range of source systems - Netezza, Oracle, SQL Server, Flat Files
(delimited and fixed width), xls, tab delimited and Power exchange CDC.
* Use mapping parameters to standardize the business logic and mapping variables for
incremental extraction for SCD2, Familiar with parameter file and its usage.
* Manage Informatica repository and folder security (Informatica Administrator).

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in