Job Description :
Hi,
Position: ETL/DataStage Developer
Type : Contract to hire
Location: San Antonio, TX
Required Skills :
Bachelor''s degree in Computer Science or STEM (Science, Technology, Engineering, Math) majors, or 4+ years of equivalent work experience in IT working with BI/ETL
experience in ETL, BI/BO disciplines
ETL
Must have Knowledge on Datastage and informatica or Hadoop
Hands on data quality presence
Experience in reporting/analytic role with a focus on visualization design and development
Experience with SAP Business Objects including Universe Designer, Web Intelligence, Xcelsius/Dashboards and Explorer
Advanced SQL development skills, perform data profiling and to extract data out of tables and do joins as per requirements and requests.
Proficient in dimensional database design
Experience with DataStage
Experience leading teams in an Agile environment
7+ years of Data Warehousing experience in the Design, Development and Testing of ETL methodologies in all the phases of the Data Warehousing life cycle.
Extensive knowledge in translating business requirements into Data Warehouse and Data Mart design and developing ETL logic based on the requirements using DataStage.
Worked extensively with different stages of DataStage like Oracle, DB2, Datasets, Aggregator, Transformer, Merge, Join, Lookup, Funnel, Filter, Sort, Pivot, Change capture, Remove Duplicates, Sequential file, Copy, Peek, and Shared Containers for developing parallel jobs.
Efficient in incorporation of various data sources such as Oracle, SQL Server, and DB2, XML and Flat files into the staging area.
Familiarity with ProfileStage and MetaStage for further repository management.
PRIMARY RESPONSIBILITIES:
You will work to harden, enhance and support our data and analytics environments, cycles, data quality, dashboards and reports. You will partner with team members on projects that include Return-to-Service (RTS) analysis, break-fix enhancements, ETL framework enhancements, data quality enhancements, usage reporting and general design, coding and release/build activities.