Job Overview:
Pay Range: $53/hr - $58/hr
Requirement/Must Have:
- 7+ years of experience in ETL/Data Integration/Data Warehousing.
- Strong hands-on experience in Informatica (PowerCenter / IICS).
- Strong expertise in Oracle and SQL Server databases.
- Proficiency in SQL and PL/SQL development.
- Experience in ETL design, development, and optimization.
- Good understanding of data warehouse concepts (Star/Snowflake schema).
Responsibilities:
- Design, develop, and implement ETL processes using Informatica PowerCenter / IICS.
- Build and maintain data integration pipelines across multiple source systems.
- Perform data extraction, transformation, and loading (ETL) from various OLTP and flat file sources.
- Develop and optimize SQL and PL/SQL scripts, stored procedures, and complex queries.
- Work extensively with Oracle and SQL Server databases for data processing and validation.
- Implement data mapping, transformation logic, and data modeling techniques.
- Design and maintain data warehouse structures (fact & dimension tables).
- Perform performance tuning and optimization of ETL jobs and database queries.
- Implement CDC (Change Data Capture) and slowly changing dimensions (SCD Type 1 & 2).
- Ensure data quality, consistency, and integrity across systems.
- Troubleshoot ETL issues and resolve data discrepancies.
- Collaborate with business analysts, architects, and QA teams for requirement gathering and delivery.
Nice to Have:
- Familiarity with Unix/Linux scripting.
- Experience with version control (Git) and CI/CD tools.
- Experience with SSIS or other ETL tools.
- Exposure to cloud data platforms (Snowflake, AWS, Azure).
- Experience in BI tools (OBIEE, Power BI, Tableau).
- Domain experience in Healthcare.
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading staffing and recruiting powerhouse. Proudly recognized as a nationally and locally certified diversity firm, Cynet delivers agile, scalable talent solutions across industries. With an active footprint in all 50 U.S. states and Canada, we support thousands of consultants through our expansive, high-performing recruitment engine operating across North America and Asia—ensuring speed, quality, and consistency in every hire.