We are looking for a SQL/PL SQL Developer with ETL Informatica expertise. The position is onsite in one of the following locations: Atlanta, GA; Richmond, VA; Chicago, IL; or Addison, TX. The candidate should have 10+ years of IT experience.
The role involves designing, developing, coding, testing, debugging, and documenting data warehouse, database, and business intelligence applications. Key responsibilities include:
- Hands-on development, support, and enhancement of applications.
- Translating business requirements into technical specifications.
- Designing and implementing ETL processes using Informatica, SQL, and Linux shell scripting.
- Performing data analysis, writing advanced SQL queries, and resolving defects across multiple teams.
- Collaborating with development teams to manage interdependencies, set up test cases, and ensure data quality.
- Engaging in logical and physical data modeling and database design with a focus on dimensional modeling.
- Leading and developing complex Informatica PowerCenter ETL flows across heterogeneous databases (e.g., Oracle, MS SQL).
- Developing complex Oracle procedures, functions, and packages for API calls and DW reporting.
- Conducting performance tuning activities for new and existing applications.
- Supporting and developing Unix shell scripts.
- Understanding scheduler tools like Autosys.
- Performing data analysis, profiling, and ensuring data quality.