AWS & Azure Cloud Architect, Informatica ETL, RPA Developer Certified

freiberufler AWS & Azure Cloud Architect, Informatica ETL, RPA Developer Certified auf freelance.de
Verfügbarkeit einsehen
Europa
en  |  hi  |  de
auf Anfrage
65760 Eschborn
07.08.2019

Kurzvorstellung

With more than 13+ years of progressively responsible experience, I hold a distinguished career earmarked by accomplishments in leading and directing Enterprise Data Warehouse products, ETL development, testing, production support, project management

Ich biete

IT, Entwicklung
  • Informatica
  • Datawarehouse / DWH
  • Cloud Computing
  • Microsoft Azure
  • Amazon Web Services (AWS)
  • Solution Architektur
Technik, Ingenieurwesen
  • UiPath

Fokus
  • SAP Automation

Projekt‐ & Berufserfahrung

Freelance Consultant
Eurex Clearing AG, Eschborn
1/2018 – 3/2019 (1 Jahr, 3 Monate)
Financial Industry
Tätigkeitszeitraum

1/2018 – 3/2019

Tätigkeitsbeschreibung

Involved as a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of DW / OLTP applications
Developed ETL programs using Informatica to implement the business requirements.
Mainly involved in the ETL of numerous Dimension tables and Fact table in StatistiX application, developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, Sequence Generator and XML- SQ, XML Parser and defining XSD transformations.
Analysis of the Source system issues.
As a part of UAT, QA and Production support handled the number of QC’s in each release. QC’s used to register in post-production 11.
Handled the queries from User and QA team which need clarification.
Provides support for QA, UAT and Post Production. This includes product feature, technology enhancements and testing the same.
Closely worked with the Off-shore teams (TCS) which includes the daily status updates, requirement issues, user queries etc...
Created documents such as Informatica code review checks, test results documents, daily status format, release/migration lists.

Eingesetzte Qualifikationen

Informatica


Senior Data Warehouse Developer
Deutsche Boerse Group, Eschborn
10/2016 – 12/2017 (1 Jahr, 3 Monate)
Banken
Tätigkeitszeitraum

10/2016 – 12/2017

Tätigkeitsbeschreibung

Involved as a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of DW / OLTP applications
Involved in Design, Develop & Test components across dev, test, production environments and implementation support as necessary
Involved in data verification and quality checks and system standard procedures used to support Enterprise DW/BI platforms
Developed complete descriptions of all specifications and solutions as required
Worked on Real-time technologies like wire protocol, Web services, AMQP and TCP/IP.
Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans

Eingesetzte Qualifikationen

Informatica, Oracle Database


Informatica Technical Lead
On Demand Agility, Bangalore
8/2015 – 6/2016 (11 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

8/2015 – 6/2016

Tätigkeitsbeschreibung

Involved in business requirement analysis and prepared functional requirement document
Involved in the ETL technical design discussions and prepared ETL high level technical design document
Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents
Extracted data from multiple systems using Informatica ETL mappings / PL - SQL scripts and loaded to Data Store Area.
Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area

Created and executed Control-M jobs to schedule Informatica Workflows
Prepared Unit Test cases and executed unit test scripts successfully
Involved in performance tuning of Informatica code using standard informatica tuning steps
Used web based bug tracking tool Mercury Quality center for tracking and supporting the maintenance and development tasks.
Involved in creating the DB and ETL tags for quicker deployment into QA Environment
Supported during QA/UAT/PROD deployments and bug fixes
Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Oracle Database, Informatica


Sr. Consultant
Value Consulting Inc, New Jersey
4/2013 – 5/2014 (1 Jahr, 2 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

4/2013 – 5/2014

Tätigkeitsbeschreibung

Involved in Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
Designed the Source - Target mappings and involved in designing the Selection Criteria document.
Created multiple Mappings, Workflows and Sessions to accomplish data transformation and load process.
Involved in reverse engineering for Apptio web Application of Goldman Sachs.
Implemented the Control Process / Audit Tables Framework, without Metadata access.
Involved in migration from Dev to UAT and PROD
Involved in Production Support in resolving issues and bugs.
Developed and documented Mappings/Transformations and Informatica sessions.
Designed several mappings to extract the data from Flat files, DB2, SQL Server and Oracle
Designed the test cases and tested the sessions and workflows to meet the Unit Test Requirements.
Developed design documents and Unit Testing Process for the modules developed.
Worked closely with QA team and closed the tickets on daily basis.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Oracle Database, Informatica, UNIX


Sr. Consultant / Lead
Polaris Financial Technologies, Hyderabad
12/2010 – 3/2013 (2 Jahre, 4 Monate)
Banken
Tätigkeitszeitraum

12/2010 – 3/2013

Tätigkeitsbeschreibung

Developed and documented Mappings/Transformations and Informatica sessions.
Designed several mappings to extract the data from Flat files.
Created mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
Designed the test cases and tested the sessions and workflows to meet the Unit Test Requirements.
Used debugger to test the data flow between source and target and to fix the invalid mappings
Developed design documents and Unit Testing Process for the modules developed.
Tuned the performance of the mapping to load the data quicker.
Worked closely with QA team and closed the tickets on daily basis.

Eingesetzte Qualifikationen

SAP BO-PC, Datawarehouse / DWH, Oracle Database, Informatica, UNIX


Sr ETL Developer
Technocrafts Inc, Virginia
1/2008 – 11/2010 (2 Jahre, 11 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2008 – 11/2010

Tätigkeitsbeschreibung

Participated in complete SDLC – requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests.
Developed and documented date Mappings/Transformations and Informatica sessions.
Designed several mappings to extract the data from Flat files and Relational Sources.
Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data warehouse.
Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions
Created mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
Designed the test cases and tested the sessions and workflows to meet the Unit Test Requirements.
Used debugger to test the data flow between source and target and to fix the invalid mappings
Developed design documents and Unit Testing Process for the modules developed.
Tuned the performance of the mapping to load the data quicker.

Eingesetzte Qualifikationen

Datawarehouse / DWH, SAP BusinessObjects (BO), Oracle Database, Informatica, UNIX


Sr. ETL Develope
Verizon Data Services India Pvt Ltd, Hyderabad
8/2005 – 10/2007 (2 Jahre, 3 Monate)
Telekommunikation
Tätigkeitszeitraum

8/2005 – 10/2007

Tätigkeitsbeschreibung

Using Informatica Designer, developed mappings, which populated the data into the target.
Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create edit and run workflows, tasks, shell scripts.

Developed complex mappings/sessions using Informatica Power Center for data loading.
Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
Extensively used aggregators, lookup, update strategy, router and joiner transformations.
Extensively used TOAD to analyze data and fix errors and develop.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Oracle Database, UNIX, XML, Cobol


Zertifikate

AWS Solution Architect
August 2019

Azure Could Architect
August 2019

UIPath Developer Advanced
November 2018

PRINCE2® Certified in Project Management
Februar 2017

Certified Power Center Data Integration 9.x Developer Specialist
Juni 2016

Certified Oracle PL/SQL Developer Certified Associate
Juni 2016

Certified Data Warehouse Concepts from Brain Bench
Juni 2013

Qualifikationen

With more than 13+ years of progressively responsible experience, I hold a distinguished career earmarked by accomplishments in leading and directing Enterprise Data Warehouse products, ETL development, testing, production support, project management, database technologies, strategic planning and technology implementation. In these years, I acquired vast experience in using ETL tool Informatica Power Center, Oracle DB, deep DWH, OLTP and OLAP concepts. I successfully made an effort to be certified as Informatica power center 9 Developer and Oracle PL/SQL Developer

Having gathered 5 years of international exposure, working with different clients in USA, my experience has strengthened my teamwork, leadership, problem solving and decision making abilities and has enabled me to acquire expertise in all facets of successful environment.

I believe that these factors, along with a broad functional and technical knowledge and personal skills such as initiative, creativity, adaptability and willingness to learn will enable me to excel in this role.

Über mich

I would like to introduce myself. I am currently located in Eschborn, Hessen, Germany and at the moment looking for a challenging opportunity, where I can demonstrate my skills and capabilities, which I gained during my long years of experience in the USA and India at a number of high-profile companies. I am holding a B. Tech. in Computer Science and Engineering from Andhra University, Visakhapatnam, AP - INDIA

With more than 13+ years of progressively responsible experience, I hold a distinguished career earmarked by accomplishments in leading and directing Enterprise Data Warehouse products, ETL development, testing, production support, project management, database technologies, strategic planning and technology implementation. In these years, I acquired vast experience in using ETL tool Informatica Power Center, Oracle DB, deep DWH, OLTP and OLAP concepts. I successfully made an effort to be certified as AWS Solution Architect, Azure Cloud Certified, Informatica power center 9x Developer, Oracle PL/SQL Developer and Prince 2 in Project Management and UIPath Advanced Developer.

Having gathered 5 years of international exposure, working with different clients in USA, and my experience has strengthened my teamwork, leadership, problem solving and decision-making abilities and has enabled me to acquire expertise in all facets of successful environment.

I believe that these factors, along with a broad functional and technical knowledge and personal skills such as initiative, creativity, adaptability and willingness to learn will enable me to excel in the role offered with the company.

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Hindi (Muttersprache)
  • Deutsch (Grundkenntnisse)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
1175
Alter
38
Berufserfahrung
14 Jahre (seit 08/2005)
Projektleitung
3 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden »