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.