We provide IT Staff Augmentation Services!

Application Development Team Lead Resume

SUMMARY

  • Overall 9+ years of strong experience in Data Warehousing using the ETL tool Informatica 8x,9x &10x(Power Center Designer, Workflow Manager and Workflow Monitor).
  • Good experience on complete life cycle right from Source System Study, Requirement Analysis, Source System Analysis, Logical Data Modeling, Physical Data Modeling, Development, ETL Design, Code/Peer review, QA and Deployment of the project.
  • Developed and tested complex Mappings, used transformations such as WSDL, Router, Expression, Aggregator, Joiner, lookups, Sequence Generator and Update Strategy and also Worked on Slowly Changing Dimensions (SCD's), its implementation (Type1, Type 2) and Surrogate Key assignment.
  • Expertise in creating and testing Sessions, Workflows, Worklets by using the Workflow Manager tools like Task Developer, Worklets and Workflow Designer.
  • Experience working with databases like Oracle 9i/10g, Teradata SQL, DB2 & Snowflake DB
  • Strong understanding and involved in Performance Tuning, Debugging and Troubleshooting in Informatica.
  • Familiarity in in corporation of various data sources like Relational Databases, Flat Files and XML’s into DWH staging environment.
  • Have good knowledge on Source System Analysis and participated in Logical Data Modeling sessions.
  • Have good Knowledge on jobs scheduling by using DOLLAR U ($U) and having knowledge on TES (Tidal Enterprise Scheduler).
  • Have good Knowledge on PVCS, Artifactory, SVN,KINTANA and Jenkins for migration tools.
  • Effective Team Player with excellent presentation, logical skills, and problem - solving skills. Good Team member with the ability to motivate and lead team members.
  • Quest and Zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS

  • Informatica PC 8x/9x/10, Teradata/Oracle SQL, Snowflake
  • PVCS, Toad, Kintana, Quality Center, SVN Artifactory, Putty
  • Dollar U, Informatica Scheduler, Autosys (in use)
  • Microsoft, Unix/Linux
  • Teradata, Oracle, DB2 SQL’s, Snowflake Cloud DB
  • Financial(Insurance), Manufacturing

PROFESSIONAL EXPERIENCE

Confidential

Application Development Team Lead

Responsibilities:

  • Gather the all business requirements for new project, Data & Code migrations.
  • Mentoring the team members to improve their technical skills and project functional knowledge.
  • Prepare functional and technical documentations(STTM’s) which outline the approach for the requirement.
  • Prepare the estimation & staffing plan for business requirements.
  • Conduct internal team meeting and gather all new ideas about Automation.
  • Performed ODS source system analysis for moving of current architecture from DB2 to Oracle.
  • Design and created critical ETL mappings with different types of dimension & Fact with data cleansing and scrubbing rules as per business requirements.
  • Convert the existing ETL code to Snowflake cloud DB load compatibility.
  • Convert the existing AIX shell script to Linux compatibility.
  • Effective troubleshooting of data related problems while developing mappings independently.
  • Prepared Unit test cases and performed the effective unit testing and supported SIT team & UAT.
  • Migration of code using deployment groups, Jenkins process.

Confidential

Senior Analyst

Responsibilities:

  • Analyzed Salesforce source system for existing system integration.
  • Prepare functional and technical documentations(STTM’s) which outline the approach for the requirement.
  • Understanding the bottlenecks in the process and do effective performance tuning.
  • Design and created critical ETL mappings with different types of dimension & Fact along with data cleansing and scrubbing rules as per business requirements.
  • Effective troubleshooting of data related problems while developing mappings independently.
  • Prepared Unit test cases and performed the effective unit testing and supported SIT team & UAT.
  • Migration of code using deployment groups, XML’s & Jenkins process.
  • Fixing of high priority Production defects.

Confidential

Application development Analyst

Responsibilities:

  • Fixing/implementing priority defects/Enhancements.
  • Analyzed the business requirements and functional specifications.
  • Perform Technical and Functional Responsibilities (Analysis and Design, Coding, Support to Client Teams in their Applications)
  • Extracted data from MF CDC tables and staged into a single place and applied business logic to load them in the central DB2 database.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Involved in performance tuning by determining bottlenecks at various points like session logs,targets, sources, mappings and sessions.
  • Review changes going to production and advice where appropriate.
  • Maintaining 24*7 production support with daily, Weekly, Monthly, Yearly loads.
  • Monitor job execution progress and Troubleshoot in collaboration with relevant teams.
  • Identifying opportunities for improvement in the productions loads/data quality.
  • Analyze the business queries which were raised by users and provide the results. If any defects found in existing code will fix the ETL process as per cycle.

Confidential

Developer

Responsibilities:

  • Design and Created ETL mappings with different types of mappings (E.g. SCD Type1&Type2) and also done the data cleansing and scrubbing operations.
  • Design and developed the complex ETL mappings.
  • Effective troubleshooting of data related problems while developing mappings.
  • Done the code and peer reviews.
  • Prepared Unit test cases and performed the effective unit testing.
  • Implemented ETL scheduling through the $U tool.
  • Migrating code to different environments using Artifactory and KINTANA packages.

Developer

Confidential

Responsibilities:

  • Design and Created ELT/ETL mappings with different types of mappings (Eg: SCD Type1&Type2) and also done the data cleansing and scrubbing operations.
  • Effective troubleshooting of data related problems while developing mappings.
  • Prepared Unit test cases and performed the effective unit testing.
  • Implemented ETL scheduling through the $U tool.
  • Migrating code to different environments using Artifactory and KINTANA packages.

Hire Now