ETL Developer
Walmart labs
Skills
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
Project history
01/2018
-
06/2018
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.
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.
12/2015
-
12/2017
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.
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.
09/2012
-
12/2015
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).
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).
Local Availability
Only available in these countries:
India
Other
Informatica lead with the experience of 8.5 years in IT industry. I have hands on experience on Informatica 9.5,SSIS, Power exchange, Unix,Oracle, SQL server, salesforce. My current location is Bangalore
