SUMMARY

• Over 12 years of IT experience in the Design, Analysis, Development, Modeling, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications and Over 7 years of solid experience in Extraction, Transformation and Loading (ETL) mechanism using Talend, Datastage and Informatica and more than 5 years of experience in data modeling and AWS Redshift, TERADATA. Expert in full life cycle development for building a data warehouse and datamart including 3 years of onshore experience worked with customer in USA and Australia, have worked extensively in AGILE methodology.
• Self - motivated person with strong debugging, problem solving, and analytical skills.
• Good experience on ETL tool like - Talend, Datastage, Informatica
• Worked extensively with AWS Redshift, TERADATA, AWS REDSHIFT and Cassandra - good experience on creating Datamart, FACTS and DIMENSIONS for reporting use.
• Have good experience on creating Semantic layer design.
• Good experience on preparing High level design document like SRS, HLD, IDDD, SIDIA.
• Have good experience in preparing Scope document impact (IA)
• Good experience on tool Erwin 7.3 for DATA MODELLING and DESIGN (LDM/PDM),
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Very good experience on Mapping document preparation for ETL input for development
• Extensively worked with SVN (Subversion tool.)
• Worked on RDBMS like Sybase, Oracle.
• Worked on OS like Windows, UNIX platforms.
• I have around over 5 years of experience on TELECOM domain, Capital and good knowledge on Banking Applications.
• Having good problem solving skills and leadership qualities, handling the team by resolving their issues and concerns which they raised during implementation, testing and deployment.
• Having direct interact with the business to perform in decision making and requirement analysis
• Worked extensively with the AGILE methodology where need to perform different kind of roles and areas for discovery, analysis, design implementation and testing
• Worked on cost and effort estimation for the new scope where we need to access actual for the business requirements.
• Good knowledge in Ataccama data quality tool for data profiling and data analysis using DQC and DQ Dashboard.
• Having good experience with Control-M, Appworx and TIDAL scheduling tool
• Good knowledge on Alteryx analytics for data preparation and analytics process

TECHNICAL SKILL SET

Development Tools: ETL tools like Talend, Datastage and Informatica.

Big data capabilities: Spark, FiloDB, Cassandra, Hadoop.

No SQL Tools: Cassandra.

Data Management Tools: Teradata, AWS Redshift, AWS S3, Oracle, Sybase.

Data Modelling Tools: Erwin 6.5

DQ Tools: Ataccama

PROFESSIONAL EXPERIENCE

Confidential

ETL Technical lead.

Responsibilities:

• Prepared Technical Design documents for the various gaps identified during the Fit-Gap phase.
• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Provide data flow diagram for multiple source systems for understanding the data lineage.
• Do the impact analysis based on the requirements and existing source data
• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the customer and offshore team to implement the requirements using Talend ETL.
• Clarify the concerns raised from development team as ETL Lead.
• Perform code review, impact analysis, involving in problem solving,
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Mentor the offshore team members by providing assistance with the functional environment/Technical aspects
• Understand the Redshift architecture dat includes S3, FACT, DIM data load and Unload data back to S3 from target tables
• Automate the metadata driving mechanism thorough Talend ETL
• Capture the audit log for each flows from source to target
• Implement the restart ability process from where it failure by using Talend

Environment: Talend 9.6.2, AWS Redshift, Tableau reporting.

Confidential

ETL Lead.

Responsibilities:

• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Provide data flow diagram for multiple source systems for understanding the data lineage.
• Do the impact analysis based on the requirements and existing source data
• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the customer and offshore team to implement the requirements using Talend ETL.
• Clarify the concerns raised from development team as modeler.
• Perform code review, impact analysis, involving in problem solving
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Mentor the offshore team members by providing assistance with the functional environment/Technical aspects.

Environment: Talend 9.6.1, Cassandra, Spark, FiloDB, Sybase.

Confidential .

Technical Specialist

Responsibilities:

• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the Onsite co-coordinator and offshore team to implement the requirements
• Perform code review, impact analysis, involving in problem solving,
• Come up with ETL requirements based on existing ETL CODE developed based on Bankware Rate Driver ETL
• Come up with analysis documents based on comparison between existing ETL and TOBE ETL
• Creation of ETL Detailed Design documents, Mapping Specification, Data Flow Diagram documents
• Created Teradata BTEQ scripts
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Mentor the offshore team members by providing assistance with the functional environment/Technical aspects
• Also performed PDO based optimizations on the ETL Code
• TEMPEffectively utilized various TPT connection operator connections for resolving the performance bottleneck issues
• Performed detail analysis for existing SPS Fleet and come up with design for TO BE approach.

Environment: Talend 9.6.1, Teradata V13, UNIX.

Confidential

Technical Consultant

Responsibilities:

• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the Onsite co-coordinator and offshore team to implement the requirements
• Perform code review, impact analysis, involving in problem solving,
• Come up with analysis documents based on comparison between existing ETL
• Creation of ETL Detailed Design documents, Mapping Specification, Data Flow Diagram documents
• Created Teradata BTEQ scripts
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Mentor the team members by providing assistance with the functional environment/Technical aspects

Environment: Talend, Teradata V2R5, Erwin 7.3.

Confidential .

Solution Designer

Responsibilities:

• Performing Semantic layer design
• Developing facts and dimensions
• Identifying source data to map them into target
• Designing activities like creating LDM and PDM
• Creating Mapping document which input for development activities for the developer
• Clarify the concerns raised from development/production/testing team as modeler

Environment: Datastage 7.5, Teradata V2R5, Erwin 7.3

Confidential .

ETL Developer

Responsibilities:

• Developing the DataStage Parallel jobs to populate source data to staging tables.
• Source File Validation and Extraction.
• Exception and Rejection Handling
• Developing the jobs extensively on different stages like Mload and Transformer stages.
• Handling the rejected data.
• Creating and executing the unit test cases.
• Involved in QA/Test and Production Support.
• Perform performance tuning for Bteq queries

Environment: Datastage 7.5, Teradata V2R5Signet banking Corp.

ETL Developer

Confidential

Responsibilities:

• Participate in technical fit/gap workshops.
• Source File Validation and Extraction.
• Understand the requirement and design provided by modelling team and implement the ETL job using Datastage
• Perform sort, aggregation, lookups and transformation to process the data from source to target
• ETL specification document preparation
• Exception and Rejection Handling.
• Design and various transformations are implemented through designer.
• Incremental Loading.

Environment: Datastage 7.5, Oracle 9i, UNIX.