We provide IT Staff Augmentation Services!

Etl Architect Resume

NJ

SUMMARY:

  • Overall 13 years of IT experience in Architecture Designing and IT development. BI Architect with over 6+ years of leadership experience in designing innovative business solutions. Skilled in designing Data warehouse/ Datalake, cloud computing, information management, application development, and visualization.
  • Demonstrated mastery in evaluating requirements for business application integration and service activation.
  • Proven mentor and training with expertise in communicating across organizational levels and with cross - functional teams to drive shared vision and foster culture of excellence.
  • Predominant experience in designing and developing datalake and datawarehouse. Designing ETL and BI solution using BIG DATA technologies. Very strong in HADOOP, HDFS, HIVE and PySpark.
  • ETL Design and hands on experience on Talend 6.1/6.2, Informatica 9.6 and Python based ETL.
  • 1+ years of experience working with Qliksense scripting and Visualization. Good Knowledge of Tableau architecture.
  • Very strong in database programing Oracle, SQL and PL/SQL.
  • Experience in AWS Cloud technologies like Redshift, EMR, EC2, lambda, Athena.
  • Expertise in Analysis and Design, Data modeling, Database design.
  • Actively involved in project management, Project Delivery, documentation as per standard process followed by the organization.
  • Responsibilities include client interaction, requirement gathering, design, and development, planning & tracking for a small team.
  • Excellent team player with recognized analytical, strategic planning and interpersonal skills. Highly motivated, enthusiastic and self-starter.

TECHNICAL SKILLS:

Solution architecture

ETL architecture

ETL - Talend

ETL - Infomatica

AWS Redshift

Oracle

Python

HIVE, Hadoop, Spark

Agile - Project planning and co-ordination

Project Management

Talend Studio 6.2 and 6.1

Informatica 9.6

Erwin Data Modeler, Microsoft Visio

Tableau 10

Qlik View Qlik Sense Desktop

Waterfall/Iterative Lifecycle

Test Driven Development

Sql workbench/TOAD/Putty

Redshift, Oracle 10g

PROFESSINAL EXPERIENCE:

Confidential, NJ

ETL Architect

Responsibilities:

  • Analyze and define client’s business strategy and determine system architecture requirements to achieve business goals.
  • Gather detailed business requirements and use cases, and translate technical specifications into development requirements.
  • Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.
  • Develop data architecture design to facilitate targeted customer analysis.
  • Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize ETL, database, reporting development.
  • Database designing and Data modeling, Building ETL Framework.
  • Pharma SME (Subject matter expert), Business communication and Data Quality Framework.
  • KPI identification, Designing BI semantic layer and visualization

Technologies Involved - Hadoop, HIVE, Spark, Talend, S3, EMR, Amazon Redshift, Qliksense.

Confidential, NJ

ETL Architect

Responsibilities:

  • Collaborated with business analysts, developers, and technical support teams to define project requirements and specifications.
  • Led team to plan, design, and implement application.
  • Designed, developed, and managed Python scripts, databases, visualizations.
  • Pharma SME (Subject matter expert), Business communication and Data Quality Framework.
  • Designing innovative UI and onboarding new data sources.

Technologies Involved: Informatica 9.6.1,Oracle,Python, R, S3, EC2, Amazon Redshift, Tableau.

Confidential, NJ

ETL Architect

Responsibilities:

  • Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
  • Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews
  • Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
  • Led team to plan, design, and implement application.

Technologies Involved: Informatica 8.6, Oracle, Tableau.

Confidential, NJ

Data Architect

Responsibilities:

  • Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
  • Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
  • Led team to plan, design, and implement application.
  • Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews

Technologies Involved: Informatica 8.6, Unix,Oracle 10G,VBA.

Confidential

Data warehousing Consultant

Responsibilities:

  • Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
  • Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
  • Led team to plan, design, and implement application.
  • Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews

Technologies Involved: Datastage, DB2, Oracle 10g.

Confidential

Oracle Programmer

Responsibilities:

  • Oracle PL/SQL Programming. Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
  • Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
  • Led team to plan, design, and implement application.
  • Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews

Technologies Involved: Datastage, DB2, Oracle 10g.

Hire Now