SUMMARY

• An ETL Lead/Big Data developer with an experience of around 10 years within the IT industry and the skills to manage all aspects of IT Application Services for Confidential, Banking, Financial and Confidential clients.
• Proficient in Confidential, SQL, Confidential, Tableau, Data Modeling, BigData, HDFS, Hive, Sqoop, Spark SQL, Unix/Linux shell scripting.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently.
• Quick study, with an ability to easily grasp and apply to the application with new ideas, concepts, methods and technologies. Dedicated, innovative and self-motivated team player/builder.
• Exceptional leadership, organizational, oral/written communication, interpersonal, analytical, and problem resolution skills. Thrive in both independent and collaborative work environments.
• Avid learner and adaptable to any new technology.

TECHNICAL SKILLS

Tools: Informatica Power Center 10.x/9.x, Tableau, SQL Developer, Erwin, JIRA, Zephyr, GIT

Databases: Confidential 11g/10g, DB2, Confidential 13.0, Facets, SQL Server

File System: BigData Hadoop

Commands/Languages: Python, SQL, HDFS, Hive, Spark SQL, HBase, Sqoop, Unix/Linux shell scripting

Operating System: Windows 10, Unix, Linux, Mainframes

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

Lead/ Data Modeler/ Tableau Developer

Skillset: Confidential 10.2, Confidential 11g, Data Modeling, Facets, SQL, SQL Developer, Erwin, Tableau, UNIX, Flat files, Tivoli, QC

Responsibilities:

• Analyze the existing Admin and Claims Architecture and the Weekly/Monthly/Annual Invoices/Reports that are generated.
• Understand the requirements and design new solutions to bill new Accounts/Programs under the existing Admin and Claims Process.
• Analyze the existing source data in Confidential marts and the architecture to create the Source to Target Mapping document with the required Mapping logic.
• Design/Create new Confidential marts as part of the solution using Erwin tool to stage required data and create Informatica mappings to extract/load data into new/existing Confidential Marts.
• Create different charts, dashboards, stories as per the Business requirements using Tableau.
• Mentor and guide Development team to create all the required mappings as per the Design.
• Work with Confidential, create SQL’s to extract and load data as per the requirements.
• Extract data from Confidential marts/Facets and flat files and transform it in accordance with the Business logic and load it into Confidential data marts using ETL tool.
• Create Unix shell scripts to execute the Informatica Workflows and Tivoli Jobs to schedule the Unix scripts.
• Involved in Performance Tuning of mappings in Informatica.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews. Support QA team during testing.
• Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Confidential

ETL Lead/Big Data Developer

Skillset: Confidential 10.x/9.x, Confidential, SQL, SQL Developer, HDFS, Hive, Sqoop, Spark SQL, Hadoop, Unix/Linux, Maestro

Responsibilities:

• Gather requirements from the business owner and perform requirements analysis.
• Understand Mapping documents and Non-functional requirements to create detailed design specifications.
• Using Informatica Power Center Designer analyze the source data to Extract & Transform from source systems by incorporating business rules using different objects and functions that the tool supports.
• Create mappings, mapplets and User defined functions to transform the data according to the business rules.
• Use various transformations like Source Qualifier, Joiner, Lookup, Normalizer, SQL, Router, Filter, Expression, Aggregator and Update Strategy.
• Create Hive tables using Hive Commands to load data into HDFS from incoming flat files.
• Build Sqoop import/export commands to load/extract data from SQL Server to HDFS/Hive tables.
• Build complex Spark SQL's to load data into target Hive tables.
• Create and Configure Workflows and Sessions to load the data from Big Data source to Confidential staging tables.
• Create shell scripts as per the project requirement to schedule workflows.
• Use Maestro as a scheduler to run the UNIX scripts.
• Constantly interacted with business users to discuss and clarify the requirements.
• Assign and monitor work allocated to the team.
• Attend everyday status meetings and ensured the work is delivered as per the schedule agreed.
• Overseeing quality procedures for the project and ensuring process adherence.
• Review of deliverables, Implementation & verifying final results.
• Preparation of Work status and process improvement related reports.
• Work with dependent teams to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Export/Import the mappings/sessions/Worklets /workflows from development to Test Repositories and promoted to Production.
• Use Workflow variables, Session parameters, Mapping parameters and created Parameter files for imparting flexible runs of workflows based on file specific values.
• Perform Unit testing and Integration testing. Resolved issues identified in QA, UAT and promoted the code to Production.
• Prepare required documents for handling post development issues.

Confidential

Confidential Developer

Skillset: Confidential 9.x, Confidential, Teradata, SQL, GIT, JIRA, Tivoli, Zephyr, Agile

Responsibilities:

• Followed Agile-Scrum methodology to design, develop, test and deliver the code.
• Designed ETL flows to implement using Informatica Power Center as per the mapping sheets provided.
• Involved in creating databases, views of required Confidential datamarts to represent the source tables & staging data marts.
• Involved in ETL development, creating required mappings for the data flow using Informatica.
• Used transformations like Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.
• Involved in developing the mapplet, reusable transformations and User defined functions according to the data flow requirements.
• Performance tuning done by implementing all mappings to come under (PDO) Push down Optimization.
• Used BTEQ to create and edit Confidential table/view definitions.
• Used Fast Export to export data from Confidential tables to Flat files.
• Used Fast Load to load data from Flat files to Confidential tables.
• Confidential Parallel transporter connection was used for loading data into Confidential data marts.
• Developed UNIX scripts to schedule the workflows.
• Used mapping & workflow parameters to make the ETL process more flexible.
• Validated the output according to the mapping sheet specifications.
• Developed Mainframe jobs to schedule the UNIX scripts which run the Informatica workflows as per the business requirements.
• Enhancements in existing mappings according to the business logic.
• Attended daily scrum calls to post the required status update.
• Testing the data against the existing logic and defect fixing by correcting the ETL logic.
• Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.

Confidential

Mainframes Developer/Support

Skillset: JCL, COBOL, DB2, IMS, CA-7, Incident Management, Problem Management

Responsibilities:

• Performing job monitoring activities and fixing the job abends.
• Enhancements to the existing functionality.
• Support tasks for answering user queries and provide the required information to the users in the format that they requested.
• Analysis of issues encountered in Live environment and taking responsibility to resolve them by providing best solutions, either by code changes or database changes and track them till closure.
• Solving Batch incidents.
• Analyzing and solving user & problem tickets within the described SLA.
• Preparing monthly reports on tickets resolved and tracking the progress of all the team members.