We provide IT Staff Augmentation Services!

Tech Lead Resume

4.00/5 (Submit Your Rating)

Austin, TX

SUMMARY

  • 12+ years of extensive experience in data warehouse projects. Primarily working as Tech/Delivery Lead, Sr ETL developer on ETL Design, Technical Specification, Data Modeling, ETL Development, Analysis, Scoping & Assessment and Performance Tuning.
  • Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems.
  • Experience working with IICS data integration, Monitor, Administrator, Deployments, Scheduler.
  • Expert in designing ETL process with different sources like Flat file, RDBMS - Oracle, SQL Server.
  • Expert in ETL Performance Tuning.
  • Proficient in designing and implementing Error Table, Error Flow and Metadata Table design.
  • Strong Knowledge of data warehousing concepts, Dimensional Data Modeling, Star/Snowflake Schema. Physical, Logical and conceptual data modelling.
  • Data Warehousing experience in designing and building using Informatica including developing Informatica Mappings, creating Sessions, developing UNIX scripts and creating Oracle procedures/functions.
  • Extensively worked on Informatica Data Quality, expert in data profiling.
  • Experienced in Snowflake implementation.
  • Strong analytical and data analysis skills including a thorough understanding of how to interpret customer business needs.
  • Experienced in end-to-end project lifecycle and Strong delivery management skills.
  • Certified AWS Technical Professional.
  • Hortonworks Certified Associate (HCA). https://verify.skilljar.com/c/mra8ctas247p
  • Experience with Agile development - Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups.
  • Experienced in coordinating with business users in requirement clarification, source data files, defining data elements, business rules, data and process flow documentation, prepare High level design documents.
  • Excellent communication, interpersonal and presentation skills.

TECHNICAL SKILLS

ETL Tool: Informatica Intelligent Cloud Services(IICS) Informatica PowerCenter (10.2, 9.6/9.1//8.6,7.x) Informatica Developer(IDQ) 10.2, 9.6

Cloud: Amazon Web Services (AWS) AWS-RDS, AWS-DMSAzure

Cloud Datawarehouse: Snowflake

Analytics Tool: Power BI

Relational Databases: Oracle 11g,10g, 9iMicrosoft SQL ServerIBM DB2, MS Access

Data Modeling Tool: Erwin, SAP Power Designer

Querying Tool: SQL* PlusTOAD

Programming Languages: C, Unix shell scriptingPL/SQL

Big Data Technology: Hadoop 2.0, HDFS, Hbase, Hive. MS Azure - HD Insight, Hive, Hbase, Spark SQLSqoop.

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Tech Lead

Environment: IICS, Informatica 10.2, Oracle 12c, Sales Force, Sql Server, Unix

Responsibilities:

  • Worked on PC to IICS conversion Project as a Tech/Delivery Lead.
  • Analyzed, Designed and implemented conversion of Informatica PowerCenter 10.2 to IICS.
  • Worked on issue resolution and promoted use of best practices
  • Designed and built IICS mappings, mapping tasks to extract data from SFDC, Oracle and loaded into Sales Force.
  • Designed and built IICS mappings, mapping tasks to extract data from SAP to Datawarehouse Tables and Sales Force.
  • Implemented IICS Replication tasks.
  • Involved in enhancements and maintenance activities of the data warehouse.
  • Prepare and Review Effort estimation.
  • Review Code and technical documents to meet client specifications as required.
  • Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
  • Standardize the existing development process for effective coding.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
  • Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
  • Preparation of Code movement and implementation plans to UAT and Prod.
  • Responsible to follow release management and defect tracking for UAT and Prod.

Confidential, Boston, MA

Data Lead

Environment: Informatica 10.2, Oracle 12c, Unix, QC, AWS S3, IICS

Responsibilities:

  • Analyze functional Requirement.
  • Design CML data layer.
  • Prepare Technical Mapping documents.
  • Prepare ETL HLD doc
  • Designed and developed ETL Process for data load in AWS.
  • Prepare and Review Effort estimation.
  • Review Code and technical documents to meet client specifications as required.
  • Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
  • Standardize the existing development process for effective coding.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
  • Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
  • Preparation of Code movement and implementation plans to UAT and Prod.
  • Responsible to follow release management and defect tracking for UAT and Prod.
  • Manage project risks and issues.
  • Provide Project Status reporting.

Confidential, Glendale, CA

Sr ETL Developer

Environment: Informatica 9.6, Oracle 11g, DB2, Unix, Microstrategy, QC. AWS-S3

Responsibilities:

  • Analyze functional Requirement and prepare Technical Mapping documents.
  • Prepare ETL HLD doc.
  • Prepare and Review Effort estimation.
  • Work with onshore and offshore development teams to complete code deliverables
  • Review Code and technical documents to meet client specifications as required.
  • Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
  • Standardize the existing development process for effective coding.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
  • Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
  • Preparation of Code movement and implementation plans to UAT and Prod.
  • Responsible to follow release management and defect tracking for UAT and Prod.
  • Manage project risks and issues.
  • Provide Project Status reporting.

Confidential, Hoboken, NJ

ETL Architect.

Environment: Informatica 9.6, Oracle 11g, MS SQL Server, Unix, Tableau, Google Cloud, JIRA

Responsibilities:

  • Analyze functional Requirement and prepare Technical Mapping documents.
  • Prepare ETL HLD doc.
  • Prepare and Review Effort estimation.
  • Create and Execute Project Plan, Resource Plan and revise as appropriate to meet changing needs and requirement.
  • Work with onshore and offshore development teams to complete code deliverables
  • Review Code and technical documents to meet client specifications as required.
  • Worked with MDM team and BA to get Product data.
  • Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
  • Standardize the existing development process for effective coding.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
  • Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
  • Preparation of Code movement and implementation plans to UAT and Prod.
  • Responsible to follow release management and defect tracking for UAT and Prod.
  • Manage project risks and issues.
  • Provide Project Status reporting.

Confidential, New York

ETL Architect

Environment: Informatica 9.6, Oracle 11g, Unix, SQL, SharePoint.

Responsibilities:

  • Analyze functional Requirement and prepare Technical Mapping documents.
  • Prepare ETL solution, HLD doc.
  • Create and Execute Project Plan, Resource Plan and revise as appropriate to meet changing needs and requirement.
  • Prepare and Review Effort estimation.
  • Work with onshore and offshore development teams to complete code deliverables
  • Review Code and technical documents to meet client specifications as required.
  • Standardize the existing development process for effective coding.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
  • Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
  • Preparation of Code movement and implementation plans to UAT and Prod.
  • Define and clarify project scope
  • Manage project risks and issues.
  • Provide Project Status reporting.

Confidential, Orlando

ETL Architect

Environment: SQL, Informatica 9.6, Teradata 14, Unix, Agile Methodology, JIRA.

Responsibilities:

  • Analyze functional Requirement and prepare Technical Mapping documents.
  • Prepare ETL HLD doc.
  • Involved in Detail solution and ETL design
  • Prepare and Review Effort estimation.
  • Work with onshore and offshore development teams to complete code deliverables
  • Review Code and technical documents to meet client specifications as required.
  • Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
  • Standardize the existing development process for effective coding.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
  • Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
  • Preparation of Code movement and implementation plans to UAT and Prod.
  • Responsible to follow Project management methodology which includes promptly updating Defect Logs, System Pass Detail Document.
  • Manage project risks and issues.
  • Provide Project Status reporting.

Confidential, Iowa City

Tech PM / Engagement Lead

Environment: SQL, Informatica 9.1, Oracle 10 g, Unix

Responsibilities:

  • Analyzing / Review requirement, Define and clarify project scope
  • Involved in Detail solution design and ETL design
  • Review Estimation.
  • Create and Execute Project Plan, Resource Plan and revise as appropriate to meet changing needs and requirement.
  • Provided the project plan and successfully delivered on-time, within scope and budget by monitoring and tracking the progress
  • Manage project risks and issues.
  • Work with technical onshore and offshore development teams to complete deliverables
  • Preparation of Production move and implementation plan.
  • Review technical documents to meet client specifications as required.
  • Provide Project Status reporting.
  • Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
  • Standardize the existing development process for effective coding.
  • Manage multiple projects.

Confidential, Columbia, MD

ETL Architect / Tech Lead / Account Lead

Environment: SQL, Informatica 9.1, Oracle 9i, Netezza, Unix, SharePoint.

Responsibilities:

  • ETL specification design.
  • Prepare Technical Mapping documents laying out the application logic.
  • Effort estimation.
  • Responsible to Migrate Maps and Workflow to test and pre-production environments.
  • Preparation of Production move and implementation plan.
  • Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL maps
  • Performance Tuning of ETL maps at Mapping, Session, Source and Target level.
  • Code Review.
  • Successfully manage Type1-Type 2 Slowly changing dimension with complex business requirements.
  • Responsible to analyze the GSD system.
  • Responsible to follow Project management methodology which includes promptly updating Defect Logs, System Pass Detail Document, Migration Checklist.
  • Responsible for writing Change Control request (Database, Specification, and Mapping) and its actual implementation at all affected phase of project.

We'd love your feedback!