SUMMARY:

• 6+ Years of IT experience in ETL development using Informatica Power Centre, Ab - Initio, Teradata, Oracle and performing Data analysis and Solution design in the field of Enterprise Data warehousing and having extensive knowledge on the Banking Domain and complete SDLC process execution.
• Extensively worked on ETL design phase on high level requirement interpretation and writing pseudo code as an intermediate between Line of Business and Core development Team.
• Complete Knowledge on Dimensional modeling (LDM/ PDM) with OLAP implementation approach.
• Exhaustive knowledge and hands on all major Informatica PowerCenter Transformations such as Source Qualifier, Expression, Filter, Router, Aggregator, Rank, Joiner, Lookup, Normalizer, Update strategy, Transaction Control and SQL, etc., to implement complex business Logic.
• Experience in creating reusable components like Informatica mapplets/worklets using various connected and unconnected transformations and also with different RDBMS and DBMS file systems (ASCII, EBCDIC and XML etc).
• Worked on complex ETL configurations such as SCD, PDO enabling, session partitioning, PMCMD invoking and metadata validation.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Developed and executed emailing, automation, creating updating parameter file, archiving the source files, purging the archive files and creating an indicator file.
• Having clear understanding on Teradata architecture and have interest on writing sql for complex requirements such as Recursive sql, MERGE statements and volatile/ temp objects.
• Knowledge on Teradata indexes and partition configurations (PPI, secondary Index, Join index and Teradata statistics)
• Having skill on diagnosing and interpreting Parser explain plan, performance optimization and AMP distribution.
• Expertise in working with Teradata Utilities like BTEQ, FirstLoad, FirstExport, MultiLoad and Teradata Advance SQL.
• Experience in UNIX shell scripting for ETL wrapper creation.
• Secondary skills on Ab-Initio ETL development.
• Experience on Oracle SQL, partitioning and Indexing and also knowledge on basic PL/SQL.
• Extensive knowledge on Control M job Advance scheduling and configurations.
• Expertise on Scaled Agile Framework and executed project on Agile board.
• Experience in conducting internal training on fundamental DWH.
• Good skill on presentation and leadership skill. (Recently presented on TCS Tech-Talk)
• Extensive domain knowledge in Financial / banking domain

TECHNICAL EXPERTISE:

Database Utilities: BTEQ, FastLoad, MultiLoad, FastExport, Sqoop, Hive

Reporting Tool Business Object:

Modeling tool Microsoft Visio:

Scheduling Tool Control M (8.0/9.0), CronTab:

Scripting Language Unix Shell:

Programming Language C, C++, HTML,Python, Core-Java:

Operating Systems Windows 7/8/10,UNIX HP-UX, LINUX:

Others Jira Agile Board,Hadoop, SVN, WINSCP, Bitbucket, Git stash:

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer, Data Analyst

Responsibilities:

• Understanding the Business Requirement and help Dev team on design interpretation.
• Convert requirement into High level/low level solution design.
• Created Data flow diagram for semantic layer
• Created Data strategies and road map for Data governance.
• Prepared the data analysis and quality analysis report for line of business Team
• Created Blue print/ pseudo code for ETL implementation of Business Logic.
• Involved in ETL coding comprising Informatica mapping, workflows, mapplets as per the design finalized to automate the file parsing and validation.
• Worked on major database performance improvement part.
• Planed out the Testing strategy with the help of Quality Team
• Taken Lead part on reporting status from to Client and Line of Business Team

Confidential

ETL Lead Developer

Responsibilities:

• Provide solution approach documentation and functional requirement gathering
• Preparing FSD and convert requirements into HLD/LLD solution.
• Developing Informatica Mapping, Workflows, mapplets as per the design finalized.
• Once the code is ready, to get the code review done in order to maintain the standardization across the modules and check common practices set at the organization level.
• Preparing test data, unit test plans and documenting results
• Coordinating with other developers to accomplish the task as a team and completing the deliverables will within the stipulated timelines.
• Developed Control-M jobs to automate the job scheduling and runs.
• Troubleshoot issue related to Performance tuning.
• Reusability of effort
• Smart status reporting
• Evaluating certain common design patterns in the existing ETL code and designing reusable components

Confidential

ETL Developer

Responsibilities:

• Involved in analyzing, gathering and Understanding the business reporting requirements.
• In the initial phase of development, I was involved in data flow diagram (DFD) design.
• In very next, I was the part of ETL code design, performance optimization and regular status to client as well.
• Extensively used Ab-Initio GDE 3.1.1, Co-Operating system 3.2.4 to develop and run the graphs as per the decided Technical design.
• Developed Generic graphs for data loads, data cleansing, data validation and data transformation.
• Responsible for Cleansing data from SOR (source system) using Ab-Initio Components such as Join, Dedup, Sorted, Reformat, Filter By Expression, Rollup, Aggregate, Scan etc.
• Worked with Departition Components like Concatenate, Gather, Interleave and Merge in order to departition and repartition data from Multifile accordingly.
• Worked with Partition Components like Partition-by-key, Partition-by-expression, Partition-by-Round Robin to partition the data from serial file
• Extracted and loaded data to HDFS (Hadoop) system using Ab-Initio tool.
• One of the most important phases was documentation which includes micro design document and schedule execution run book.

Confidential

ETL Developer

Responsibilities:

• Analyzing the Abi graphs and formulating the method to do the Reverse Engineering
• Worked on reverse engineering from EDW to ICDW by understanding the Ab-Initio Graphs.
• Created Data flow diagram as part of HLD/LLD.
• Building the ETL code (mappings, workflows, mapplets) with the use of Informatica Power center.
• Utilized Informatica parameterizations to increase code reusability better control through dynamic value assignment.
• I was the part of the Performance optimization and regular status to client.
• Applied optimized version of CDC into various dimensions.
• Involved in Unit testing and providing thorough knowledge transfer to QA team for the integrated testing.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Supported migration of ETL code from development to QA and QA to production environments through ITSM.
• Handled complete configuration of customized/new scheduling jobs and loading process through Control-M jobs

Confidential

ETL Developer

Responsibilities:

• Acquired knowledge on ICDW framework
• Worked on reverse engineering from EDW to ICDW by understanding the Ab-Initio Graphs.
• Created Data flow diagram for CDI modules
• I was the part of ETL code design, performance optimization and regular status to client as well.
• Effectively worked on Informatica parameterizations, FTP connections and relational connections.
• Applied optimized version of CDC into various dimensions.
• One of the most important phases was documentation which includes micro design document and schedule execution run book.
• Involved in providing explanations/artefacts on the concerns raised by user during the Business User testing.
• The project has been through 2 major production deployment where I took the active part in code packaging and migration.
• Co-coordinating with the onsite resource to ensure timely and quality deliverables.