Professional Summary:

• Confidential has 12+ years of experience working as a Data warehouse Developer and Architect in on - premise and AWS Cloud Environment focusing on Big data Ecosystem, DW Design, Data Cleansing, Data Profiling and building OLTP system.
• Expert in building data lake over S3, Redshift, RDS and other AWS components as AWS Cloud data Engineer.
• Expertise in Database development for OLTP and OLAP systems.
• Expertise in Database migration, Data integration and Data warehouse projects.
• Experience in modernizing traditional database and move to Cloud data lakes and Hadoop Environment.
• Experience in Database design, dimensional modelling and building data warehouse system from scratch.
• Extensive development experience for DBs like Oracle, AWS Redshift, AWS RDS, Postgres, Greenplum.
• Strong experience in Talend, Creating Jobs, Jobllets, workflow, implementing SCDs, events, Mapping parameters, Context variables etc.
• Experience in building CICD pipeline for ETL jobs using Jenkins.
• Proficient in Project management.
• Also worked as Scrum master in Agile framework.

Technical Skills:

• Databases: Oracle, Postgres, Greenplum, SQL Server, AWS Redshift, Aurora
• Languages: SQL, PL/SQL, Unix Shell Scripting, Python
• ETL Tools: Talend, Informatica, Native Languages (Unix, PL/SQL, etc.)
• Data Modeling: Logical/Physical data modelling, Reverse/forward Engineering, Dimensional modelling
• Big Data: HDFS 2.6.5, Hive, Kafka, Sqoop, Presto and Apache Drill for Hetro NoSQL DBs, Phoenix for HBase, Cloudera Impala
• AWS: S3, Glacier, EC2, Kinesis Firehose, Redshift, Spectrum, Athena, Glue, Schema Conversion Tool, AWS RDS, Aurora, EMR, and Other Hadoop Components on EMR, DMS, QuickSight

PROFESSIONAL EXPERIENCE

Confidential

Talend ETL Developer

Responsibilities:

• Data profiling, design and ETL creations.
• Talend jobs, Joblets and ABAC framework creation and pushing this over Talend Cloud.
• Pulling data from Informix, Salesforce, Oracle, Flat files and SAP system.
• Merging them all in S3 data Lake.
• Create Glue Catalog tables and Redshift external Schema on top of S3 data lake, so that S3 data set can be queried like normal tables.
• Writing SQL queries for all the S2T mappings and performance tuning for Queries.
• Project manager for the USCC PRE project.
• Worked as a Data profiler and Business analyst at same time.
• Defined and implemented ETL Architecture Framework.
• Worked on Logical & Physical Data Models for Data Warehouse.
• Designed and implemented data staging areas, data warehouse, Data Marts and other data stores.
• Study and analysis of the business requirement and accordingly identifying reports and dashboards with client's requirements.
• Review the data model and make necessary changes in the database, data model, RPD and dashboards to incorporate new requirements or enhancements.
• Creating data models in Tableau to facilitate business users to create their own report requiring least intervention from development team.
• Creating and helping team for Talend ETL mappings for pulling data and loading into Hive.
• Using Talend Big data component and loading data in Hive tables.
• Creation of documentation and processes like naming standard, best coding practices, high level design document, Unit testing document, Deployment strategy, implementing CI/CD, implementing BAC framework etc.
• Perform unit testing and worked with the business users at various stages of the UAT to ensure that measures have been implemented correctly.
• Writing SQL queries for all the S2T mappings and performance tuning for Queries.
• Used SSIS etl tool for pulling data from multiple locations, creation of Dimensions and facts.
• Created Profit-Loss and Balance sheet reports for Clients using SSRS and PowerBI tools.
• Managing the day to day activities of the BI team.

Confidential

Technical Lead

Responsibilities:

• Done database design and data modelling for client database and produced logical and physical data model for the database.
• End to end backend system delivery for client portal.
• Written all oracle objects, Packages, Procedures, functions, Ref cursors, collections.
• Co-ordinated with Client for Functional specification, document generation at the time of requirement gathering, Functional specification document and wireframe generations.
• Involved in requirement gathering, designing of database and development of complete backend system.
• Co-ordination with Front End, Middleware and testing team for delivery of Product, requirement gathering, design, development, testing, UAT and Production deployment.
• Mapping of oracle objects with Application express tool to make it simpler front-End user and provide non-technical people a GUI.
• Creating new reports and investigating missing data.
• Implementing the new ADM structure (Admin development and maintenance).
• Re-building the bug free system with existing logic.
• All Database and Unix level production support activities.

Confidential

Associate Software Developer

Responsibilities:

• Written Oracle Procedures, functions, Ref cursors Packages, collections and UTL file and UTL mail packages.
• Writing shell script and SQL/PLSQL queries & Procedure.
• Created Informatica mappings to build business rules to load data.
• Shell scripting batch file creation and scheduling in the Crontab
• Complete End to end delivery of the products
• I was part of the development team of Mobile number portability Application for Vodafone.
• Develop ESS one of the major Vodafone internal application for NAM, AM, AS, and NAS users.
• Develop the Vodafone Delight Application in very short span of time and got appreciation.

Tools used: Oracle SQL, PL/SQL, Windows 7 and Unix, Toad

Confidential

Assistant manager

Responsibilities:

• Written Oracle Procedures, functions, Ref cursors Packages, collections and UTL file and UTL mail packages.
• Error Handling in eBSS Billing Application
• Handling Problems such as Payment is not reflecting, duplicate records, not getting treatment in the system.
• Enhancement for due date synchronization.
• ETL procedures writing for eBSS Billing

Tools and technology used: Oracle 9i, Toad, Single view, Unix, windows, Putty.

Confidential

Associate Software Engineer

Responsibilities:

• Written Oracle Procedures, functions, Ref cursors Packages, collections and UTL file and UTL mail packages.
• All production support activities.
• Informatica mapping creation, Kalido job creation, BO reports creation.
• Tools used: Oracle SQL, PL/SQL, Informatica 8.5, Business Object, Kalido, Control M, Peregrine, Toad, Unix,

Tools and technology used: Oracle 9i, Informatica 8.5, Business Object, Kalido, Control M, Peregrine, Toad, Unix.