SUMMARY

• 7+ years of experience in development, design, implementation and support with major focus on Data Warehousing, and Database Applications.
• Experience in design and development of data warehouse & business intelligence solutions using Talend, Informatica and Ab Initio.
• Vast experience on Talend Open Studio & Enterprise Version, using different component from Talend
• Having solid experience in theAnalysis, DesignandDevelopment ofData warehousing solutions and in developing strategies forExtraction, Transformation and Loading (ETL)mechanism usingAb Initio.
• Experience in Object - Oriented Programming(OOPS) within networks as well as online applications.
• Worked with various operational data sources like Flat files, Oracle, and SQL Server, Netezza, Vertica and MySQL
• Hands on experience in working with PL/SQL statements, Stored Procedures and Triggers.
• Experience inOracle supplied packages,Dynamic SQL, RecordsandPL/SQL Tables.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Developed Talend ESB services and deployed them on ESB servers on different instances.
• Worked closely with the business analysts, business users, higher management to understand the requirements to develop better code.
• Developed code to extract, transform, and load (ETL) data from inbound flat files and various databases into outbound flat files and XML files using complex business logic.
• Working experience with Agile Software development method.
• Expertise in extracting data from multiple sources, data cleansing and validation based on business requirements.
• Implemented Parallelism & ELT using Talend in Very Large Database Systems Environment.
• Worked with a variety of scheduling tools including Autosys and Job Conductor.
• Experienced in UNIX shell scripting.
• Having good knowledge in Finance Domain.
• Excellent Experience inHadooparchitecture and various components such asHDFS Job Tracker Task Tracker NameNode Data NodeandMapReduceprogramming paradigm.
• Have sound exposure to Retail market including Retail Delivery System.
• Provide payments processing support for the company’s call center help desks and infrastructure network operations center (NOC) to include responding to inquiries, troubleshooting, and issue analysis across 870 plus locations and 20,000 plus processing terminals including point of sale (POS), quick service restaurant (QSR), and fuel pump terminal types.
• Hands on experience in installing configuring and using Hadoop ecosystem components like HadoopMapReduce HDFS HBase Hive Sqoop Pig ZookeeperandFlume.
• Good Knowledge of Big Data (HDFS & Hive) using Talend
• Designed, developed, and deployed well-tuned Talend Jobs including Sandboxes (Generic and Custom) for UNIX environment.
• Great expertise in testing web services via SOAP, using the open source testing tool SoapUI.
• Configured Talend environment to connect to database using DB configuration file, Input Table, Output Table, and Update Table components
• Along with JDBC also has worked with alternatives like Spring JDBC Template. Developed complete Web tier of the application with Spring MVC framework.
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
• Wrote Pythonscripts to parse XML documents and load the data in database.
• Thorough Knowledge of Waterfall SDLC Process & Agile Methodology.
• Experienced on Incident, defect, change records management and Problem records.
• Hands on knowledge of HDFS and Hive.
• Expertise in design and coding of N-tier architecture enterprise Applications using Core Java, JSP, JSTL, Servlets, EJB 2.0/3.0, JDBC, JMS, RMI, JTA, JNDI, AJAX, JavaScript, JQuery 1.6, Sencha Ext JS 4.2, XML, XSD, HTML.
• Knowledge of installing, upgrading and configuring business intelligence and OBIEE tools.
• Having knowledge on SAP Integration and Amazon cloud services.
• SAP cross-functional expertise working in the areas of Sales and Distribution evolving through SAP.
• Working experience on Splunk tool using DB connections and with the Log files.
• Experience with monitoring tool Splunk, to check modifications and reporting alerts to concerned teams.
• Experience in designing and developing applications in Spark using Scala to compare the performance of Spark with Hive and SQL/Oracle.
• Used Spark-Streaming APIs to perform necessary transformations and actions on the fly for building the common learner data model which gets the data from Kafka in near real time and Persists into Cassandra.
• Build Business Reports using Tableau for Senior Management and business users.
• Self-motivated and proactive leader with superb technical acumen and exemplary communication skills. Exceptional ability to create, implement and improve IT standards, policies, and procedures. experience, leading, Mentoring, coordinating with teams in an Onsite-Offshore model.

TECHNICAL SKILLS

ETL Tools: Talend Enterprise (6.2.1/5.5.1 ),Talend Studio 5.6.2, Informatica Power CenterAb-Initio.

Database: Oracle, MySQL, MSSQL, RedShift, Vertica

Languages: C, SQL, C#, PL/SQL

Scripting: UNIX Shell scripting

Operating Systems: Linux, Windows

Scheduling Tools: Autosys, Job Conductor

Tools: Toad, DBVisualizer, SQL Developer, MySQL Workbench

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Talend Consultant

Responsibilities:

• Administration, configuration, analysis, design, development, maintenance and support of Talend
• Working with following tool for data integration needs: Talend Enterprise 6.2.1 (Big data edition)
• Technology assessments and recommendation.
• Design and development of ETL jobs (Extraction, Transform and Load).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Performing other tasks as assigned by Project Manager.
• Creating detail design specifications for the extraction, transformation and load processes coded for audit and maintainability purposes.
• DesignedRESTAPIs that allow sophisticated, effective and low-cost application integration.
• Write efficient ETL code within established timelines to successfully deliver projects on schedule.
• Write shell script for cleanup activity, run job from background.
• Developed complex jobs to read the data from webservices, transforming the data with txmlmap and used routes to publish the data into webservices with Talend ESB.
• Build ESB routines to read the data from webservices and pushing the load into Big Data Lake withTalend ESB and TalendBigdata.
• Thoroughly unit test ETL code to ensure free of errors. Document the results of testing prior to hand off tested ETL code to the Quality Assurance department.
• Participating in regular technical review sessions to identify non-adherence to standards, design and performance issues/improvements in ETL code.
• Accountable for assigned Data Integration Development Deliverables.
• Seek out best practices to find opportunities for improvements in develop processes and makes recommendations for implementation.
• Leverage skills and experience to contribute to overall architecture for IM systems, in developing end-to-end system design for specific data warehouse application.

Environment: Talend Enterprise for Big Data 6.2.1, ESB, Oracle, PL/SQL, MS SQL Server, RedShift, Linux, JIRA, TAC, SVN, GitHub.

Confidential, NY

ETL Consultant/MDM Developer

Responsibilities:

• Followed the Insurance code standard.
• Migration of Informatica project using Talend
• Used ETL (Informatica, Talend) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Had participated in requirement meetings with Business Analysts and ETL Architect to understand Source and Data warehouse data model, technical metadata and cleansing/transformation rules.
• Extracting,rating data from MS SQL Server and created flat files using Talend
• Involved in designing an ETL, ESB and Bigdata jobs to validate a Flat File API using tschema check compliance component and checking the data integrity using tmap component against list of static values provided by the client.
• Using Docker, Jenkins, VMWare, RHEL, Satellite, OpenShift, Kubernetes, Artifactory, Ansible & GitLab
• Organized Financial files for patients.
• Had conduct required source system analysis and data availability audit.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Provided deep technical expertise and direction in architecting, designing, developing, deploying, monitoring, supporting and administering Data Warehouse Solutions.
• Responsible for analyzing source and target data models and making necessary changes.
• Onshore and offshore coordination.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Experience in importing and exporting data usingSqoopfromHDFSto Relational Database Systems and vice-versa.
• Development, Unit Testing and interaction with testing team to solve the defect.
• Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM.
• Splunk deployment, configuration and maintenance across a variety of UNIX and Windows platforms.
• Developed data validation rule in the Talend MDM to confirm the golden record.
• Data governance and Clean up old reports everyday generated by a Data base.
• Impact analysis on current system by the new requirement.
• Production Implementation and Creating SQL Queries using Netezza.
• Monitoring the job, checking job status using Autosys.

Environment: Talend Open Studio 5.6.2,Talend ESB, Talend MDM, Oracle 11g, Unix, Autosys, RedShift, Service Now, SVN.

Confidential

Informatica/Talend Consultant

Responsibilities:

• Responsible for translating technical design documents into detail design documents using skill sets like Informatica mappings detail design/development/unit.
• Migration of Informatica project using Talend 5.5.1
• Produced technical requirements, test plans, implementation plans, and data quality processes for new implementations and prepared necessary system documentation as required.
• Worked on every monthly release within CDM Core Team
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Performed very detailed testing within the complex schedules and functional Requirements
• Rewrite of Informatica code logic to SQL to solve the production issues.
• Interaction with testing team to solve the defects.
• Tech changes related to optimization of code (simplify and reduce the run time).
• Code migration to upper environment.

Environment: Talend 5.5.1, Informatica power center 8.5.1, Oracle 11g, PL/SQL, Sybase, Unix, Autosys Scheduling tool, Service Now

Confidential

Sr. Support Analyst

Responsibilities:

• Involved in developing complex mappings and unit testing
• Used Informatica components a lot to implement scenario’s for creating: input file, outputfile, input table and output table.
• Gathering business requirement, take part in discussion with BA.
• Impact analysis of new requirement.
• Performed member Services transactions and processed loan applications on multiple account systems for bank and credit union customers in a 24/7 Financial services call center.
• Development as per the business requirement.
• Followed the acquisition and loading process.
• Responsible for Financial risk management in both commercial and consumer operations.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Extraction of data from different sources, having some data in hex format as well.
• Convert the target data into the required format per the requirement.
• Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Created the XML files for as input for MDM.
• Support the testing cycle and solve the defects.

Environment: Informatica MDM, Oracle, Unix, XML Processing

Confidential

Sr. Support Analyst

Responsibilities:

• Monitoring the cycles.
• Resolving the production issues.
• Analyzed PROD issues and fixed Informatica code.
• Participated in status and related meeting.
• Interaction with key entities incl. customers, infrastructure support group, other feeding partners.
• Identifying RCA and solving the problem within SLA
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Worked on problem tickets and followed ITIL process.
• Carried out audits on postal Financialoperations to ensure the respect of working procedures and check the event of any fraud.
• Worked on different architectural and infrastructure environments.
• Followed the ITIL process like incident, problem record and change record.
• Created and reported Releases using the Release Management framework and documented operational readiness assessments.
• Support PROD post implementation.
• Participating in SIT/UAT

Environment: Informatica, UNIX, Service Now, ITIL.

Confidential

Support Analyst

Responsibilities:

• Provide 24x7 production support.
• Monitoring the cycles.
• Redirecting production issues to correct team.
• Pre-analysis of PROD issues, solve them if standard issue else pass to 3rd line.
• Engaging different teams to solve the production issue
• Keep updated to the business if any delay or notification.
• Help in maintenance activity.
• Followed the ITIL process like incident, problem record and change record.
• Created and reported Releases using the Release Management framework.
• Follow up on Problem records.

Environment: Unix, Informatica, ITIL, Service Now

Confidential

Software Engineer

Responsibilities:

• Involved in Framework & UI Designing
• Database Design
• Banking Domain Design
• Coding
• Unit testing.

Environment: C#.Net, WPF, MS-Access, Window XP