Sr. Software Developer

IKCON TECHNOLOGIES INC delivers exceptional IT services and solutions that provide clients with definite edge over competitors and promoting highest standards of quality. We are currently looking for a Sr. Software Developer with one of our clients in Remote. If you are actively looking for opportunities, please send us your updated resume with your contact details.

"U.S. Citizens and those authorized to work in the U.S. are encouraged to apply."

JOB DESCRIPTION

Responsible for writing and modification of SQL Server, SQL, PL/SQL stored procedure, packages, functions, and Database triggers, implemented performance tuning for long running scripts.

Creating physical, logical and presentation layers in sematic layer of OAC and responsible for building reports and workbooks in data visualizer

Proving business insights and visualizations by using AI/ML functionalities and Python Libraries

Working on ODI Designer for designing interfaces, defining the data stores, interfaces, and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.

Developing SQL, PL/SQL stored procedures, functions, views, triggers and other database objects and analyzed database performance with SQL Profiler and Optimized indexes to significantly improve slow running queries.

Serving as the Oracle SQL performance tuning expert tasked with optimizing the stored procedures, functions, triggers and ad-hoc SQL scripts that were part of the daily SLA used to load the marketing and sales datamarts.

Responsible for designing and deploying ODI processes and procedures with GitHub. Familiar with analyzing and resolving conflicts related to merging of source code for clear case.

Creating ODI Packages, Jobs of various complexities and automated process data flow.

Using ODI Operator for debugging and viewing the execution details of interfaces and packages.

Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle, DB2, XML, Hyperion Essbase) feeds using ODI and CDC

Implementing SCD type-2 process as per the updated KM and automated to run weekly loads.

Designing and developing Data Marts by following Star Schema and Snowflake Schema Methodology by using Modeling tools like ERWIN and EMBARCADERO ER Studio.

Providing nightly on-call support for ODI jobs and fix the issues and re-run the ODI jobs in case of failures.

Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design

Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP

Developing the required data warehouse model using Star schema for the generalized model

Writing UNIX scripts for backups, archiving, wrapper programs etc.

Querying the databases, wrote test validation scripts, and performed the System testing, Data Profiling and Data Quality

MINIMUM QUALIFICATIONS

Bachelor's Degree or Master's Degree in the field of Computer Science or Information Technology or a related field.