We provide IT Staff Augmentation Services!

Technical Lead Resume

SUMMARY:

  • Confidential has 10+ years of professional experience IT especially in Data warehousing and Business Intelligence domains
  • Possess very good exposure in global delivery model by collaborating with business stakeholders across geographies
  • Possess expert knowledge in Data Warehousing domain
  • Possess very good knowledge in Dimensional Model as well as Data Model
  • Possess expert knowledge in ETL Architecture
  • Possess good experience in designing ETL framework
  • Possess good knowledge in MicroStrategy reporting as a developer on public objects
  • Hands on experience in Waterfall model as well as Agile Model execution using JIRA
  • Possess sound experience in SDLC end to end implementation
  • Optimize ETL codes (Mappings, Workflows) and SQL Queries for tuning performance
  • Hands on experience in configuration management
  • Execute projects in CMM level 5 standards
  • Involve in RFPs for solutions and estimations
  • He has worked for top - notch customers for various domains

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter (7.1.3, 8.1.1, 8.5.1, 8.6.1, 9.1, 9.5)

Reporting Tool: MicroStrategy 9.4

Database: Oracle, SQL Server, Teradata

Operating System: Windows (98/2000/2003/ XP/2008/2010)

Scheduling Tool: UC4 Scheduler

Script: Shell script (UNIX)

PROFESSIONAL EXPERIENCE:

Confidential

Technologies: Informatica, Oracle, Unix, UC4 Scheduler

Technical Lead

Responsibilities:

  • Requirement elicitation and assessment
  • Conduct impact assessment and determine size of effort based on requirements
  • Develop full SDLC project plans to implement ETL solution and identify resource requirements
  • Design application architecture with a framework of unanimous scheduling platform to migrate the schedule from platform-based execution which scales up from batch-based schedule to event-driven schedule architecture
  • Develop UC4 jobs, Job Plans and Events
  • Promote UC4 Jobs to the higher environments and provide hands on guidance to other team members
  • Develop mappings, sessions, workflows
  • Re-design ETL (existing workflows) execution to optimize performance
  • Coordinate SIT and UAT
  • Collaborate with business and stakeholders to resolve issues

Confidential

Technologies: Informatica, Oracle, Unix

Technical Lead

Responsibilities:

  • Worked in global delivery model
  • Requirement elicitation and assess requirements for completeness and accuracy
  • Determine if requirements are actionable for ETL team.
  • Collaborate with business across geographies and stakeholders to develop architectural requirements
  • Create application architecture document
  • Develop full SDLC project plans to implement the product
  • Lead ETL requirements and design
  • Assist offshore team to develop Spotfire solution as an UI application
  • Develop ETL codes (Mappings, Sessions, Worklets, Workflows)
  • Coordinate SIT and UAT
  • Collaborate with business and stakeholders to resolve issues
  • Production Deployment

Confidential

Technologies: Informatica, Oracle, Unix

Technical Consultant

Responsibilities:

  • Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture
  • Perform as leading role in shaping and enhancing overall ETL Informatica architecture
  • Identify, recommend and implement ETL process and architecture improvements
  • Assist and verify design of solution and production of all design phase deliverables

Confidential

Technologies: Microstrategy, Teradata

BI Engineer

Responsibilities:

  • Worked on Agile Methodology
  • Develop datasets, reports and report documents
  • Support SIT & UAT for defect fix
  • Implementation support

Confidential

Technologies: Data stage, Teradata

ETL Consultant

Responsibilities:

  • Requirement Analysis
  • Create Technical Architecture Document
  • Code development & unit testing
  • Code integration based on load dependencies
  • Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
  • Support SIT & UAT for defect fix
  • Deployment & validation

Confidential

Technologies Informatica Power Center 9.1, Oracle 11G

ETL lead

Responsibilities:

  • Team Management (Development as well as Maintenance)
  • Code development for complex design & testing
  • Code integration based on load dependencies
  • Code review for functional validation
  • Support SIT & UAT for defect fix
  • Production Deployment
  • Provide warranty support

Confidential

Technologies: Informatica Power Center 9.1, Oracle 11G

ETL lead

Responsibilities:

  • Create technical architecture document
  • Team Management
  • Design mappings end to end flow
  • Involved in code development & testing
  • Do code integration based on load dependencies
  • Coordination with SIT Team for defect fixing
  • Perform functional and data validations in the mapping and sessions based on the specification document
  • Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
  • Do code review
  • Create Implementation Plan
  • Deployment & warranty support

Project Scheduled Railway Project (SRP)

Confidential

Technologies: Informatica Power Center 8.6.1, SQL Server

ETL Sr. Developer

Responsibilities:

  • Actively contribute in requirement analysis
  • Create design documents (Master design document & detailed design) as per business requirement
  • Mentoring team members
  • Create test cases (Unit Testing & SIT)
  • Code development & testing
  • Code integration based on load dependencies
  • Create reusable objects to avoid repetitive effort and to meet schedule adherence
  • Coordinate with SIT Team for defect fixing
  • Perform functional and data validations in the mapping and sessions based on the specification document
  • Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
  • Do code review
  • Implementation & warranty support

Confidential

Technologies: Informatica Power Center 8.5.1, Oracle 10G, UNIX Scripts

ETL Developer

Responsibilities:

  • Actively contribute to requirement analysis in the project
  • Code development, performance tuning and defect fixing
  • Coordinate with SIT Team for defect fixing as well as QA team for defect tracking as well providing the fix
  • Perform functional and data validations in the mapping and sessions based on the specification document
  • Adhere to the quality standards practiced by the client in terms of compliance, code standards and data quality
  • Do gap analysis by reviewing mapping specification documents for each interface to ensure the business rules are highly unambiguous
  • Extensively worked in QA team
  • Create QA test cases in accordance with the specification document as well as execution

Confidential

Technologies: Informatica 8.1.1, Oracle 9i, UNIX Scripts

ETL Developer

Responsibilities:

  • Actively contribute to the design aspects as well as requirement analysis in the project
  • Code development & Unit testing
  • Written shell scripts to automate the source file check process
  • Schedule Informatica Workflows for the entire project as per the business flow
  • Actively involved in production rollout
  • Warranty support

Confidential

Technologies: Informatica 8.1.1, Oracle 9i, UNIX Scripts

ETL Developer

Responsibilities:

  • Requirement analysis
  • Understanding the Design doc / Specification doc and transform into technical docs
  • Design Low level design document (Md.200 Technical Design document)
  • Code development and testing of mappings and workflows as per UTC
  • Perform integration testing by integrating data with an upstream application data
  • Code migration from DEV to higher environments and go alive
  • Supported SIT and UAT

Confidential

ETL Developer

Technologies: Informatica 7.1.3, Oracle 9i

Responsibilities:

  • Requirement analysis
  • Designed Low level Design Documents
  • Code Development
  • Created Unit Test Cases
  • Done unit testing as per UTC
  • Created modules and chains to schedule the ETL loads in APPWORX scheduling tool

Hire Now