Job Description
Job Title: ETL Tech lead with Actimize
Company: SysMind
Location: Auburn Hills, MI
Pay:
AI Pay Analysis: To analyze the competitiveness of the hourly rate for an “ETL Tech Lead with Actimize” role in Auburn Hills, MI, we need to consider both the local job market and industry standards for similar positions. Typically, ETL Tech Leads in the financial services sector, especially those with expertise in Actimize, command higher rates due to the specialization required. In 2023, hourly rates for such roles generally range between $60 to $100, depending on experience and the complexity of the projects. If the offered rate falls within or above this range, it would be considered competitive; otherwise, it might be less attractive compared to similar positions in the region or industry. To provide a conclusive evaluation, the specific hourly rate would need to be compared to these figures.
Job description:
Job Description
We are seeking a highly skilled professional with over 8 years of experience in Data Warehousing and ETL development, specifically utilizing Informatica PowerCenter versions 10.x or 9.x. The ideal candidate will have a robust background in working with relational databases, including Oracle (versions 10g and 9i) and SQL Server 2008.
Key Responsibilities and Qualifications:
- Extensive experience in designing and developing complex mappings and mapplets using Informatica ETL tools.
- Proven expertise in integrating Actimize Data Models, specifically in the areas of Suspicious Activity Monitoring (SAM) and Currency Transaction Reporting (CTR).
- Comprehensive understanding of the Actimize Unified Data Model (UDM).
- Proficient in utilizing scheduler tools such as Autosys.
- Familiarity with the AWS platform, including configurations for EC2 and RDS.
- Strong capability in integrating various data sources with multiple relational databases, including Oracle (11g, 10g, 9i), MS SQL Server, DB2, Teradata, and flat files into a staging environment.
- Exceptional scripting skills in both UNIX and Windows environments.
- In-depth experience in database performance tuning, particularly in SQL Server.
If you are a detail-oriented professional with a passion for data warehousing and a strong foundation in ETL processes, we invite you to apply and join our dynamic team.
Job Posting Date: Fri, 25 Oct 2024 06:31:09 GMT
Apply now!