We have multiple locations for the same role - Addison, TX/Chicago, IL/Atlanta, GA/Richmond, VA.
- The role is responsible for the design, development, coding, testing, debugging and documentation of data-warehouse/database/business intelligence applications.
- This role is Primarily PL SQL/SQL Development with ETL Informatica.
- PL SQL & writing/optimizing advanced SQL queries
- Duties include hands-on new development as well as support, maintenance, or enhancement of existing applications.
- Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.
- Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams
- Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server.
- Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )
- Hands on experience to develop and support Unix Shell Scripting.
- Should have understanding of scheduler (Autosys)
- Perform data analysis and data profiling. Identify data quality