Job Description :
Position : 250120 : Specialty Development Senior
Location : Dearborn, MI
Duration : 12 Months
Position Description:
ITI/RRS Provide in-depth systems analysis, design and development for existing mainframe Teradata Enterprise Data Warehouse (EDW), which is a Ford Credit warehouse used for reporting & metrics across the company globally (North America, Latin America, Europe, Asia/Pacific The applications supported are highly integrated with other Ford Credit systems and contain numerous internal/external dependencies/interfaces.
Position also includes analysis of issues/questions, design/development and launch of changes, participation in testing with Enterprise Release Management (ERM)/projects/other applications, handling multiple tasks with varying deadlines, and being flexible to changing priorities.
Position Duties: Support Enterprise Data Warehouse utilizing Teradata, DataStage, COBOL, & DB2/SQL.
Apply analytical skills to diagnose problems, develop solutions and implement corrective actions. Work closely with business and systems partners in issue/question identification and resolution.
Interface with numerous information technology groups, including application and service teams
Use USDM methodology while coding application changes/enhancements, developing and executing test plans, and participating in technical reviews.
Participate in technical reviews at appropriate stages of development.
Work on-site 40 hours/week, Monday - Friday
Skills Required:
Experience in a Teradata, data warehousing environment
Experience in DataStage or similar ETL technology
Experience in SQL and extract, transform and load (ETL) programming
Strong mainframe skills including COBOL, MVS, JCL, CA7, TSO/SPF, Xpeditor and FileAid
Knowledge and experience with DB2/SQL, FTP, Connect Direct
Proficient in MS Office products (Word, Excel, Outlook)
Exceptional analytical experience of complex applications and data relationships
Strong written/oral communication and interpersonal skills
Strong drive for results and ability to work independently and respond to changing priorities
Self-starter with proven innovation skills .Ability to work with cross-functional teams
Demonstrated commitment to quality and project timing
Demonstrated ability to document complex systems. Experience in obtaining and understanding business requests
Experience in creating and executing detailed test plans. Experience with financial business functions a plus
Skills Preferred:
Five or more years in Information Technology
Experience Required:
Data Stage or similar ETL technology
Teradata, DB2, data warehousing environment
COBOL, JCL, TSO/SPF, SQL
MS Office products (Word, Excel, Outlook)
Experience Preferred:
Extract, Transform and Load (ETL) programming
Xpeditor and FileAid
FTP, Connect Direct
Analytical experience of complex applications and data relationships
Experience in obtaining and understanding business requests
Experience in creating and executing detailed test plans
Experience with financial business functions
Education Required:
Bachelor''s degree in an information technology related discipline
Additional Information:
Weekend and off-hour support may be required
Position :250412 Systems Engineering Senior
Location EARBORN,MI,
Duration : 5 Months
Position Description:
ETL IBM DataStage Developer with emphasis on Hadoop Data Processing
Coding and testing compledata from multiple sources such as SQL databases and Hadoop) IBM DataStage jobs. - Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
Work closely with project management, analysts, data modelers and the existing ETL design and developers to understand project requirements and contribute to the project solution. - Provide technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration
Partner with Business Intelligence and business operational teams to understand data sources and implement new requirements.
Analyze and summarize data to facilitate Business Intelligent decisions.
Skills Required:
4+ years IBM DataStage development in an environment where candidate had ADMIN privs in DataStage.
Candidate"s resume MUST demonstrate that candidate utilized DataStage for recent projects (i.e. cannot just list DataStage in skill area of resume)
Experience processing data from SQL Server and Oracle databases. Must be proficient in writing complex SQL statements.
Candidate must be comfortable coding LINUX shell scripts (IMPORTANT)
Skills Preferred:
N/A
Experience Preferred:
Strong DataStage experience is a MUST, but nice to have that experience in DS version 11.5
ETL tool data processing using Oracle and Teradata databases is nice to have (SQL Server experience is a MUST)
ETL data processing using Hadoop - Must have top notch written and verbal communications skills - Candidate must be a very organized and detail oriented person
Education Required:
Bachelor"s degree in Computer Science or equivalent