Job title: ETL Developer

Location: Richmond, VA / Kennesaw, GA / Jacksonville, FL (Hybrid)

Duration: 12 Months

MUST HAVES: ETL , IDMC/ IICS experience

Glider and Full SSN is Mandatory at the time of submission.

Job Description:

• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Develop and maintain database stored procedures, views, and functions that support reporting data models. Develop and maintain ETL processes. Produce ad-hoc queries that develop reports to support business needs.
• The ETL lead plays a pivotal role in managing data extraction, transformation, and loading processes.
• They are responsible for coordinating with team members, setting up audit processes, and developing mappings using Java transformations.
• They also work on performance tuning, query tuning, and data profiling.
• Responsible for contributing to the planning of the work programs and the review, development, and modification of best practices and technical solutions.
• Provides supervision to a team of Developers. Manage work assignments of internal staff and schedule and monitor adherence to procedures, protocols, and standards.

Required Skills

• The responsibilities of ETL developers include designing, building, automating, and maintaining sophisticated programs that extract, convert, and load data. They are highly skilled and help in determining the company's storage requirements by performing multiple analyses.
• They must have deep knowledge of coding languages, such as Java, XML, and SQL. They should also have solid project management skills and be well-versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW.
• ETL Developers need to be adept at writing complex SQL queries, using data transformation functions, and applying business logic to cleanse, aggregate, and format data. They should also be capable of handling data quality issues and ensuring the integrity of the data throughout the ETL process.
• An ETL developer is responsible for the proper functioning of the system, which requires strong analytical thinking and troubleshooting skills.

Job Type: Full-time

Pay: $46.29 - $64.00 per hour

Benefits:

• Flexible schedule
• Health insurance
• Life insurance
• Paid time off

Schedule:

• 8 hour shift

Experience:

• Informatica: 1 year (Preferred)
• SQL: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)

Work Location: On the road