We provide IT Staff Augmentation Services!

Datawarehouse Architect Resume Profile

5.00/5 (Submit Your Rating)

VA

Professional Summary

  • Over 8 years of experience in Software Development and Data Warehousing encompassing Development, Testing and maintenance of ETL's on Hadoop, Big data, Teradata, Informatica, Unix and Mainframes.
  • Hands on experience in DBA activities including development, performance tuning, disaster recovery management, database administration migration, and software development activities.
  • Thorough understanding of the SDLC with proficiency in mapping business requirements, technical documentation, application design, development, integration, testing and troubleshooting for Information Systems Management.
  • Skilled in Informatica design, development of mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
  • Skilled in DA activities like requirement gathering, designing, development, accessing churn in and out, implementing the thresholds and performance tuning.
  • A project executor with exposure in handling projects and ensuring delivery of projects within the time cost parameters executed multiple key projects involving Data warehousing using various technologuies like Informatica Power Center 7.1, Informatica Power Center 8.5.1 and Informatica Power Center 8.6 Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer Transformation Developer , Big Data, HDFS and tableau.
  • Possess strong communication, relationship management, analytical and problem-solving skills.
  • Comfortable in interacting with people across hierarchical levels for smooth project execution.

Technical Expertise

Domain : DW- Informatica Power Centre 8.x, Teradata, Map-R Hadoop HDFS, Big data, Hive

Operating Systems : Windows, UNIX, LINUX

Languages : UNIX Shell Scripting PL-SQL, SQL, HQL

Tools : Quality Centre, UC4.

Functional

Data Warehousing

  • Handling the design, development, testing and deployment of custom data warehouse systems.
  • Defining data requirements and designing databases to satisfy client business objectives.
  • Participating in design reviews, and assisting with allocation of functionality to specific system components.
  • Analysing content and quality of databases, recommending data management procedures, and developing extraction/ ETL processes.
  • Identifying the appropriate data sources for loading data warehouse.

SDLC Planning / Testing / Project Coordination

  • Managing requirement gathering, system analysis and finalisation of technical / functional specifications and high level design documents.
  • Defining best practices for project support and documentation.
  • Designing, developing, testing, troubleshooting and debugging of the applications.
  • Ensuring smooth implementation and testing of application at client location.
  • Providing post-implementation, application maintenance and enhancement support to the client with regard to the product / software application.
  • Managing providing technical guidance / support to the project team.
  • Delivering implementing the projects as per scheduled milestones.

BigData/Hadoop

  • Setting up the Big data environment from scratch.
  • Established a Data Analysis Procedure for end to end delivery of data.
  • Connecting various source system with the HDFS file system and delivery of quality data to the end customers.
  • Participated in the scalability of the environment from a 5 node cluster to 200 node cluster environment.

Professional Experience

Confidential

Role : Datawarehouse Architect

Environment : Big Data, MAP-R Hadoop, HIVE, HDFS, UNIX, UC4 Application Manager version 8, Toad Data Point 3.3, Tableau 8.0

Responbilities:

  • Data Analysis and Quality checks implemented throughout the lifecycle of the data , collection storage publish analysis.
  • Working collaboratively with customers using Agile methodology to create a common shared Hadoop platform across the projects.
  • Tuning the jobs and process to get the maximum output with even the minimum set of data nodes.
  • Playing the role of the Data Analyst, Managing the Quality Checks and procedures in this End to end project delivery.
  • Taking a deep dive into the data analysis for the DVR's, VOD's, Linear clickstream data and the Ad-Diplay's and providing a meaningful result to the end customers.
  • Ensured in getting the delivery done by coordinating between multiple teams.
  • Placed many processes in place such as reviewing at each stage of delivery.
  • Involving in requirement gathering, business analysis, user meetings, discussing the issues to be resolved and translating user inputs into meaningful outcome.

Confidential

Role : Lead Dataware Engineer

Environment : Informatica Power Centre 8.6.1, Oracle, Teradata 13, UNIX, Windows XP, Tortoise SVN version control tool, HP Quality Centre 10.0, UC4 Application Manager version 8

Responbilities :

  • Working collaboratively with customer's IT team using Agile methodology to rationalise and migrate all existing data warehouses to a single Teradata cLDM platform. Validated and defined implementation roadmap for Teradata cLDM and overall data management
  • Focus on ongoing productivity improvement and tapping into cost optimization opportunities like performance initiatives, Teradata compression etc.
  • Playing the role of the ETL Lead, Managing the development team in this End to end project delivery.
  • Handling multiple roles in this project including the ETL development and Test Lead. Managing the data of has 6.3 million fixed-line phone customers along with its mobile division with data for more than 33 million subscribers.
  • Agile delivery - Streamlined and standardised processes to meet agile delivery needs. This includes
  • cLDM mapping template. Estimation and tracking templates
  • Ensured in getting the delivery done by coordinating between clients and offshore teams.
  • Played the successful role of scrum master in implementing the Agile methodology.
  • Placed many processes in place such as reviewing at each stage of delivery, setting up OLA's with the different parties like Source system, downstream applications to make smooth processing of the Project helping in delivering the data through production jobs within stipulated timeframe.
  • Preparing design documents based on the functional/requirements specifications document for the clients.
  • Preparing mapping documents, data migration documents and other project related documents.
  • Involving in requirement gathering, business analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

Confidential

Role : Lead Datawarehouse Engineer

Environment : Informatica Power Centre 8.5.1, Oracle 9i, SQL PLUS, TOAD 8.6, UNIX, Windows XP

Responbilities :

  • Leading a team of 30 in production cum enhancement projects.
  • Handled multiple Data Warehouse like BOBI, RDW, EDW, This project eCDW data warehouse consists of around 300TB of data for 80 Million customers.
  • Leading and Handling Production support activities. Achieving 100 SLA for the critical application.
  • Signing a OLA with the different teams like Source system, downstream applications to make smooth processing of the Project helping in delivering the data through production jobs within stipulated timeframe.
  • Preparing design documents based on the functional/requirements specifications document for the clients.
  • Interacting with users for preparing documents like Detailed Designs for ETL processing, Dev to Production Migration plan and Integration test plan.
  • Conducting coding and unit testing of Informatica mappings for various stages of ETL.
  • Working on mappings using Flat files, XML Files and Oracle as sources and Flat files, XML files, oracle tables and Teradata Tables as targets.
  • Performing extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
  • Preparing mapping documents, data migration documents and other project related documents like mapping templates.
  • Involving in requirement gathering, business analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

Confidential

Role : Senior Datawarehouse Engineer

Environment : Informatica Power Center 7.1, Informatica Power Center 8.5.1, Oracle 9i, SQL PLUS, TOAD 8.6, UNIX, Windows XP

Responsibilities :

  • Steering initiatives for leading a team of 20 in production cum enhancement project.
  • Preparing design documents based on the functional/requirements specifications document for the clients.
  • Interacting with users for preparing documents like Detailed Designs for ETL processing, Dev to Production Migration plan and Integration test plan.
  • Conducting coding and unit testing of Informatica mappings for various stages of ETL.
  • Working on mappings using Flat files, XML Files and Oracle as sources and Flatfiles, XML files, oracle tables and Teradata Tables as targets.
  • Performing extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
  • Preparing mapping documents, data migration documents and other project related documents like mapping templates.
  • Involving in requirement gathering, business analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

Confidential

Role : Datawarehouse Engineer

Environment : Informatica Power Center 7.1.3, Oracle 9i, SQL, Windows XP, UNIX

Responbilities :

  • Fixing invalid mapping's, tested stored procedures and functions, unit testing of informatica sessions, workflows.
  • Creating sessions, reusable worklets in workflow manager and scheduled the sessions to run at a specified frequency and using session logs to debug sessions.
  • Executing sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, email, command and pre / post SQL.
  • Developing UNIX shell scripts to run the PMCMD functionality to start and stop sessions.

We'd love your feedback!