We provide IT Staff Augmentation Services!

Etl/hadoop Developer Resume

Charlotte N, C

SUMMARY:

  • Software Professional around 5 years of IT experience with strong background in Data Warehousing with emphasis on Business Requirements Analysis, Application Design, Development, Testing and Implementation.
  • Involved in all stages of Software Development Life Cycle (SDLC) from analysis and planning to development & deployment and followed Agile methodology & Scrum process.
  • Experience on Teradata database, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
  • Experience on big data processing using Hadoop, Hive, Sqoop and Kafka .
  • Strong knowledge of Teradata RDBMS Architecture (AMP, PE, BYNET and Data distribution).
  • Extensively created and used various Teradata Set Tables, Multi - Set Tables, Global Tables, Volatile Tables, Temp Tables.
  • Very good understanding of Teradata UPI and NUPI, Secondary Indexes and Join Indexes.
  • Data warehousing experience specializing in RDBMS, ETL Concepts to load data from diverse sources into data warehouse using Teradata Utilities (BTEQ, FLOAD, MLOAD, FEXPORT and TPUMP) and Informatica Power Center.
  • Proficient in Performance Analysis with query tuning using Explain Plan, Collect Statistics, NUSI and Join Indexes including Join and Sparse Indexes.
  • Expertise in writing large/complex queries using SQL and by using Teradata SQL Assistant.
  • Proficient in ETL (Extract, Transform and Loading data) process in analyzing, designing and developing Data Warehousing projects using Informatica Power Center.
  • Expertise in designing and developing complex ETL mappings and reusable transformations, scheduling workflows and worklets using Informatica Workflow Manager and monitoring using Informatica Workflow Monitor.
  • Vast experience in designing and developing Informatica Power Center mappings from varied transformations like Unconnected & Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Sequence Generator, Rank.
  • Implemented Slowly Changing dimensions methodology for accessing/maintaining the history of accounts and transaction information.
  • Good team player with excellent technical and interpersonal skills. Pro-active, self-motivated and able to work independently as well as in team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.x, Podium 3.x

RDBMS: Teradata 15, Oracle, DB2

Reporting Tools: Tableau 10.x, 2018.x

Teradata Tools: Teradata SQL Assistant, Teradata Studio

Hadoop Tools: Hive, beeline, Sqoop, TDCH

Teradata Utilities: BTEQ, Fast Load, Multi Load, Fast Export, TPump

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, N.C

ETL/Hadoop developer

Responsibilities:

  • Involved in analysis and understand the requirement on the Teradata database design.
  • To work closely with the business users on getting clarification on business logic and provide extended support on Teradata SQLs and Scripts.
  • To understand ETL objects, logics for daily support activities.
  • Involved in loading of data into Teradata from legacy systems and flat files using complex scripts and Informatica.
  • Used Podium ETL tool for creating the partitions in HDFS.
  • Worked on Hive External tables for data processing and retrieving.
  • Developed Sqoop and TDCH Scripts for loading the data from Hadoop to Teradata.
  • Developed BTEQ scripts for SCD4 tables to load data from staging table to target table.
  • Tuning SQL Queries to overcome spool space errors and improve performance.
  • Scheduling jobs using One Automation to automate the daily workflows Sessions.
  • Involved in setting up of data for UAT environment and supporting.
  • To analyze and fix issue raised in daily ETL jobs to meet daily SLA.
  • Create visualizations and reports for the business intelligence team, using Tableau.
  • To directly interact with the business users about the criticality and impact during load failure and downtime.
  • Proficient with Performance tuning techniques and experience in handling performance improvement in multiple projects.

Environment: Informatica 10.2.1, Teradata 15, Oracle 11g, Hive, Sqoop, TDCH, Tableau

Confidential, Columbus, OH

ETL developer/Data Analyst

Responsibilities:

  • Involved in requirement gathering, business analysis, design & development, testing and implementation of business rules.
  • Profound experience in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous System using ETL tool Informatica.
  • Experience in interacting with cross functional teams.
  • Proficient in writing and debugging SQL queries.
  • Experience in defining project scope and developing detailed systems specifications that are in accordance to the required architecture standards.
  • Participating in project management process, including participating in project meetings.
  • Documenting issues, action items, user requirements, or deliverables from project meetings. Performs a variety of project related activities, including analysis or preparation of documentation and presentations.
  • Production support and helping business user in resolving report, Tableau desktop & Informatica level issues.
  • Expert skills in meeting with stakeholders, system owners, and end users to define business requirements and systems goals, and identify and resolve business process issues
  • Experience in Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data.
  • Provide application support and monitor ad hoc jobs.
  • Preparing technical requirements document through analysis of the data, and work with end users on required outcome.
  • Proficient with Performance tuning techniques and experience in handling performance improvement in multiple projects.

Environment: Informatica 9.6.1, Teradata 14, Oracle 11g, flat files, SQL Server, PL/SQL

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

  • Analyze and understand the requirement on the Teradata database design.
  • To work closely with the business users on getting clarification on business logic and provide extended support on Teradata SQLs and Scripts.
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
  • Automated and scheduled ETL jobs using Control-M.
  • Proficient with Performance tuning techniques and experience in handling performance improvement.
  • To analyze and fix issue raised in daily ETL jobs to meet daily SLA.
  • To understand ETL objects, logics for daily support activities.
  • To suggest a better approach for existing process to optimize the cost and effort.
  • To directly interact with the business users about the criticality and impact during load failure and downtime.

Environment: Teradata, Oracle 11g, SQL Assistant

Confidential

Informatica Developer

Responsibilities:

  • Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
  • Creates and maintains the overall and detailed project plan(s) and supervise the D/W ETL processes.
  • Responsible for integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area
  • Developed several Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings.
  • Developed several Maps and Mapplets using corresponding Source, Targets and Reusable Transformations.
  • Responsible for performance tuning at various levels like mapping level, session level, and database level.
  • Set up Batches and Sessions to schedule the loads at the required frequency using Server Manager
  • Developed Re Usable Transformations, and Re-Usable Mapplets

Environment: Informatica, Oracle 11g, SQL Assistant, Windows Server 2008, Autosys

Hire Now