ETL Developer - Data Engineer - Data Analyst Resume Example

UGAP is a national consolidated data warehouse for UnitedHealth Group. Contains data from multiple claim processing systems such as UNET, COSMOS, MAMSI and GALAXY data sources categorized into flat files and DB2 database. Data extracted is transformed by applying business logics and loaded into UGAP data mart which is on Teradata. Final warehouse describes the complete details about an individual claim with provider details, member details and pharmacy details.

Responsibilities:

• Worked as an onsite/offshore coordinator and lead developer.
• Involved in BRD gathering and translation of BRD into functional specification, so that developer can understand and design the ETL components.
• Involved in data modeling from simple data marts to complex data warehouse.
• Involved in migration of legacy DW applications to Spark environment.
• As an SME proposed best solution to complex business logics to technical translations.
• Designed Teradata Bteq, MultiLoad, FastLoad and TPT scripts according to volume of data.
• Design and development of ETL components using IBM DataStage.
• Involved in the capacity planning, data profiling and data quality check design.
• Involved in the performance tuning of ETL(IBM DataStage all versions) components and Teradata components.
• Understand the technical differences between the Teradata/Traditional ETL technologies and Spark technologies.
• Demonstrations to customers and convinces them to migrate to advanced open technologies like PySpark ETL pipelines and trained them according to technical differences.

Worked for the Group Economic Capital project with Basel Accords (calculating the risk capital required for the HSBC group) and Global Business Market (creating a simple data mart for the global group decision making reports) project.

Responsibilities:

• Responsible for requirement analysis and creating low level design specifications for ETL jobs and developing the jobs.
• Extraction of monthly financial data feeds and applying required defaulting before processing the data with required aggregations and business rules.
• Validation of data after applying required business transformations.
• Validation of extracted and staging area data before loading to the data mart for RiskFrontier application.
• Masking of production data when dealing with third party vendors by following the firm guidelines for the privacy of customers.
• Automation of the production run with Control-M scheduler.
• All the ETL jobs are run through Shell Scripting.
• Generating the required QA jobs within ETL workflows and sending the validated values to the business for immediate confirmation within the required SLA.
• Unit testing to post production testing responsibilities with documenting test cases and managing testing and defect control with HP Quality Center.
• Maintenance of version control of the code in all the environments.
• Lead all the project related SCM activities.