Scroll To View More
Srikanth Bellamkonda, SQL Developer in New Jersey, NB, Canada
Srikanth Bellamkonda

SQL Developer in New Jersey, NB, Canada

Member since September 24, 2016
Srikanth has over 10 years of experience in designing, developing, and maintaining data warehousing applications in Finance, Healthcare, and Sales. He is very good at automating manual tasks and very enthusiastic about learning new technologies. Srikanth specializes in Oracle and Informatica with certifications in both technologies.
Srikanth is now available for hire

Portfolio

Experience

  • Oracle, 10 years
  • PL/SQL, 10 years
  • SQL, 10 years
  • Informatica, 10 years
  • Unix, 10 years
  • Unix Shell Scripting, 10 years
  • Data Warehouse, 10 years
New Jersey, NB, Canada

Availability

Part-time

Preferred Environment

Oracle, Informatica, Unix

The most amazing...

...thing I've created is a complex ETL application that loads data from more than 30 sources and is configurable based on the requirements of the source.

Employment

  • ETL Architect

    2015 - 2016
    Credit Suisse
    • Modified the existing ETL mappings to adhere to master data remediation requirements.
    • Created an Oracle package to compare the master data in two different environments, using two parallel jobs for performance increase.
    • Automated the manual testing process to decrease the time to deploy from development.
    • Modified Oracle procedures and queries as part of an Oracle upgrade.
    • Worked with customers on the new requirements and bug fixes, as well as documented the current design, implementation, and test plans.
    Technologies: Informatica, Oracle, Unix, PL/SQL, Linux Shell
  • ETL Architect

    2014 - 2015
    Kaiser Permanente
    • Designed the ETL process for generating EOBs (Explanation of Benefits).
    • Created configurable rules in Informatica that enable the same mappings to be used for different regions.
    • Created, tested, and deployed mappings and PL/SQL procedures.
    • Reviewed requirement changes and bugs, and provided timely solutions given these parameters.
    • Worked on performance tuning of ETL mappings and stored procedures.
    Technologies: Informatica, Oracle, Unix, PL/SQL, Shell Scripting
  • Senior ETL Developer

    2011 - 2014
    Standard & Poor's
    • Learned about the Finmaster data model and designed the ETL process for it.
    • Created a data model for process orchestration.
    • Designed and developed the ETL processes in PL/SQL and Informatica.
    • Worked with customers on the data loading intervals to the warehouse and was in charge of scheduling the jobs.
    • Created a data-viewing layer for downstream systems to access the data from warehouse.
    Technologies: Informatica, Oracle, Unix, PL/SQL, Shell Scripting
  • ETL Developer

    2006 - 2011
    Nortel Networks
    • Worked on gathering, storing, and generating audit reports on several databases for SOX compliance as part of a database audit process.
    • Convereted the existing PL/SQL procedures into Informatica mappings for GDW (Global Data Warehouse).
    • Created new ETL mappings for new subject areas in GDW.
    • Worked on indexing knowledge articles for search and retrieval.
    • Integrated the plan of records data with time entries to monitor the efficiency.
    Technologies: Oracle, Informatica, Unix, PL/SQL, Shell Scripting

Skills

  • Languages

    SQL, Python
  • Platforms

    Oracle, Unix
  • Storage

    PL/SQL, HDFS, Apache Hive
  • Other

    Informatica, Data Warehouse, Unix Shell Scripting, Data Modeling
  • Frameworks

    Apache Spark

Education

  • Master's Degree in Computer Applications
    2003 - 2006
    Andhra University - India
I really like this profile
Share it with others