We provide IT Staff Augmentation Services!

Technical Dw Lead Resume

PROFESSIONAL SUMMARY:

  • Over 11+ years of experience with development in complex and high volume Informatica Powercenter, Datastage and Talend ETL applications including requirement gathering, design, implementation, unit testing, debugging, documentation under Unix Environment. Good experience in leadership. Excellent Data warehousing technical skill set with robust knowledge of DWH architecture.
  • Experienced in building the Bigdata solutions using Hadoop echo system including HDFS, Hive, Sqoop, MapR, MongoDB and RESTful web APIs handling large volume data sets and handling multiple sources like JSON, XML etc.
  • Experienced in Phython programming with Spark for data ingestion and data enrichment techniques with different source systems.
  • Experience working with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Experience working with IBM Infosphere Datastage Designer, Director, Administrator and Manager.
  • Experince with Talend studio building the ETL and Bigdata solutions.
  • Deep understanding of NoSQL technologies including column family, graph, document, and key - value data storage technologies
  • Strong experience in both waterfall as well as agile methodology.
  • Experience in requirement gathering, impact analysis, data cleansing, data transformations, data relationships, source systems analysis. Worked as business system analyst.
  • Good experience in Erwin Data Modeling tool with ER, logical and physical data modeling concepts.
  • Adequate knowledge and experience of Data Mart, Data Modeling, Dimensional Modeling, OLTP, OLAP, star schema, snowflake schema, data warehousing concepts, fact and dimensions tables, logical and physical data modeling, ETL processes, SCD, data analysis, surrogate keys and normalization/de-normalization.
  • Strong working experience in RDBMS development using Teradata,Oracle and SQL and large scale database management including building and tuning complex SQL queries.
  • Good exposure to UNIX shell scripting, commands, problem solving and analytical capabilities.
  • Good experience in various kinds of testing like Unit testing, Regression testing, and System integration testing including preparation of test plan, creation of test cases, test case documents, test data creation.
  • Good exposure on bringing data from applications using REST architecture.
  • Extensive knowledge and experience of Banking and Financial, Securities, Retail Domain applications.
  • Experience in providing 24*7 Production Support and real time issue resolution for ETL applications.
  • Excellent communication, interpersonal skills and strong ability to work as part of a team and as well as handle independent roles with positive attitude towards responsibilities and challenges.
  • Liaison for customers/clients/vendors, both internal and external. Demonstrated ability to articulate written and oral presentation of proposals, concepts, and well-reasoned alternative solutions. Strong listening, interpersonal, speaking and analytical skills.
  • Demonstrated ability to Identify Root Causes of problems, considering both the long and Short-term impact of Proposed Solutions, and Develop Realistic Workable Solutions.
  • Promoted Team Collaboration and demonstrated ability to work well with all Management Levels. Fostered cooperation and collaboration among team individuals, helped team Resolve Conflicts Constructively and demonstrated ability and willingness to request Mentoring when required. A Self Starter with a Positive Attitude, willing to learn new concepts and accept Challenges.

TECHNICAL INDUSTRY SKILLS:

SDLC Methodologies: Agile, Waterfall

SEI CMM or ISO Employers: Wipro Technologies, IBM India Pvt Ltd

Languages: Phython,SQL, PL/SQL, UNIX

Platforms: Windows 98/XP/7, UNIX

Developmental Tools: Informatica Powercenter 9.5 / 10.1, Talend, Datastage 8.5/7.5, Erwin, Informatica Data Validation, Hadoop, HDFS, Hive, Sqoop, MongoDB, Erwin, Spark

Other Skills: Scheduling tools Tivoli and ESP, Incident management Quality Center, Version controlling PVCS, Data Manipulation (Analytics, Analysis, Mapping, Migration and Conversion), Development of Test Plans, Reports, Procedures and Analysis, Production Support, Business analyst.

PROFESSIONAL EXPERIENCE:

Confidential

Technical DW Lead

Responsibilities:

  • Build the Talend jobs implementing the Bigdata solutions from different strucred and unstrucred source systems
  • Implemented different solutions using HDFS,Hive, RESTful web API, sqoop etc.
  • Read data from the MongoDB / NoSQL database.
  • Data ingestion and enrichment using phython programming language.
  • Good exposure on the project sizing, estimates and stakeholders management across cross functional teams.
  • Built multiple Informatica workflows for different business transformations and data enrichments to provide the centralized data warehouse solution.
  • Worked as Business system analyst to understand the business needs and translate to the technical requirements to provide the Data warehouse solutions.
  • Working in an agile team environment with a high performing engineering team
  • Requirement gathering by interacting with client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks.
  • Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
  • Worked on the Erwin data modeler tool to create logical and Physical Data models as per business requirements.
  • Worked on the disaster recovery project for refactoring whole ETL design to recover the data in disaster scenario and make sure the continuity of business.
  • Worked on Informatica Developer tool for profile different source system data.
  • Providing unit testing, module testing, and regression testing and system integration testing of the scripts, workflows, shell scripts and SQL queries.
  • Code reviews to ensure code developed meets the requirements.
  • Involved in requirement analysis and prepared the technical design document.
  • Supported the QA, UT and production activities
  • Involved in different initiatives to give value add solutions to customer to help the business productivity and efficiency effectiveness.

System Environment: Informatica, Teradata, Phython, HDFS,Hive,Oracle,Erwin, Informatica Developer, Unix scripting, SQL, PL/SQL

Confidential

Onsite coordinator /Technical DW Lead

Responsibilities:

  • Implemented end to end Datastage applications enterprise Datawarehouse for different countries in 3 different regions as multi phase project, to facilitate reporting requirement using Datastage PX jobs, Teradata and Unix Shell scripting.
  • Requirement gathering by interacting with client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks.
  • Worked in onsite-offshore model and lead onsite team. Interact with release management, configuration management and quality assurance, database modeling support, other upstream and downstream development teams and operation support team.
  • Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
  • Providing unit testing, module testing, and regression testing and system integration testing of the scripts, jobs and queries.
  • Code reviews to ensure code developed meets the requirements.
  • Provide KT sessions, preparing documentation, mentoring junior resources.
  • Performed lead level activities and independently handled various modules.
  • Worked on Performance tuning initiate to complete the different batches within SLA.
  • Involved in requirement analysis and prepared the technical design document.
  • Supported the SIT, UAT and PROD activities
  • Implemented continuality of Business model for Disaster recovery.
  • Production support activities to ensure the smooth execution of batch for each country and meet the defined SLA time.

System Environment : Datastage, Teradata, Oracle, Unix scripting, SQL, PL/SQL, Tivoli

Confidential

Technical DW Lead

Responsibilities:

  • Requirement gathering by interacting with client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks.
  • Involved in requirement gathering meetings, data planning, client meetings to understand the new requirements, existing applications problems.
  • Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
  • Working proactively and independently to articulate issues/challenges to address project delivery risks.
  • Worked in onsite-offshore model and coordinating team of 10 members from offshore.
  • Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
  • Providing unit testing, module testing, and regression testing and system integration testing of the scripts, datastage jobs, Tivoli scheduling, Unix shell scripts and SQL queries.
  • Performed technical lead level activities to develop the Deposits and Cards streams.
  • Preparation of unit test plan and review checklist document
  • Supported the SIT, UAT and PROD activities
  • Analyzing and fixing the SIT and UAT defects
  • Involved in project environment setup activities
  • Performed Datastage Admin activities.

System Environment: Datastage,Teradata, Oracle, Unix scripting, SQL, PL/SQL

Confidential

Senior DW Developer

Responsibilities:

  • Responsible for handling different project modules independently.
  • Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
  • Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
  • Working proactively and independently to articulate issues/challenges to address project delivery risks.
  • Providing unit testing, module testing, and regression testing and system integration testing of the scripts, Jobs and queries
  • Responsible for Requirement Analysis and Development of jobs and validation of processed data through ETL.
  • Supported QA, UAT and PROD activities.
  • Responsible for handling end-to-end process starting from Development till Live.

System Environment: Datastage, Oracle, Unix scripting, SQL, PL/SQL

Hire Now