LanceSoft
IT Developer - Database / Ab Initio Developer
LanceSoft, Charlotte, North Carolina, United States, 28245
Position - IT Developer - Database / Ab Initio Developer
Location - Charlotte, NC 28203
Duration - 12 Months (Possible extension)
Pay Range - $65 to $78/hr on W2 (depending on experience/skillset)
Top Skillset Required -
Ab Initio,
PySpark, AWS, Cloud Data Engineer (Senior)
Job Description: The primary role of the
Ab Initio Developer
is to function as a critical member of a client's data analytics team by designing data integration solutions that deliver business value in line with the company's objectives. They are responsible for the design and development of dashboards, data/batch processing, data manipulation, data mining, and data extraction/transformation/loading into large data marts using Ab Initio.
Responsibilities: • Provide scoping, estimating, planning, design, development, and support services to a project. • Identify and develop the Technical detail design document. • Work with developers and business areas to design, configure, deploy and maintain custom ETL Infrastructure to support project initiatives • Design and develop dashboards, data/batch processing, data manipulation, data mining, and data extraction/transformation/loading (ETL) into large data marts. • Document and present solution alternatives to clients, which support business processes and business objectives. • Work with Front End (Reporting) teams to understand their data display capability • Create a design and framework for the generic Ab Initio Code to handle the multiple and ever expanding list of data files coming from source • Work with business analysts to understand and prioritize user requirements • Design, development, test, and implement application code • Follow proper software development lifecycle processes and standards • Quality Analysis of the products, responsible for the Defect tracking and Classification • Track progress and intervene as needed to eliminate barriers and ensure delivery. • Resolve or escalate problems, and manage risk for both development and production support. • Coordinate vendors and contractors for specific projects or systems. • Maintain deep knowledge and awareness of technical & industry best practices and trends, especially in technology & methodologies.
Skills and Knowledge: • Hands-on experience with Ab Initio • Hands-on development experience with various Ab Initio components such as Rollup, Scan, Join, Partition by Key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, etc. • Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using Ab Initio. • Experience with SQL database programming, SQL performance tuning, relational model analysis, queries, stored procedures, views, functions and triggers • Knowledge in developing UNIX scripts, Oracle SQL/PL-SQL • Strong experience with Agile/SCRUM methodology • Experience with other ETL tools (Pentaho, Datastage, Informatica, ect) Pyspark, AWS, Cloud Data Engineer (Senior)
Employee Benefits: At LanceSoft, full time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits:
Four options of medical Insurance Dental and Vision Insurance 401k Contributions Critical Illness Insurance Voluntary Permanent Life Insurance Accident Insurance Other Employee Perks
About LanceSoft:
LanceSoft is rated as one of the largest staffing firms in the US by SIA. Our mission is to establish global cross-culture human connections that further the careers of our employees and strengthen the businesses of our clients. We are driven to use the power of our global network to connect businesses with the right people, and people with the right businesses without bias. We provide Global Workforce Solutions with a human touch.
EEO Employer:
LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. #NIT001
Top Skillset Required -
Ab Initio,
PySpark, AWS, Cloud Data Engineer (Senior)
Job Description: The primary role of the
Ab Initio Developer
is to function as a critical member of a client's data analytics team by designing data integration solutions that deliver business value in line with the company's objectives. They are responsible for the design and development of dashboards, data/batch processing, data manipulation, data mining, and data extraction/transformation/loading into large data marts using Ab Initio.
Responsibilities: • Provide scoping, estimating, planning, design, development, and support services to a project. • Identify and develop the Technical detail design document. • Work with developers and business areas to design, configure, deploy and maintain custom ETL Infrastructure to support project initiatives • Design and develop dashboards, data/batch processing, data manipulation, data mining, and data extraction/transformation/loading (ETL) into large data marts. • Document and present solution alternatives to clients, which support business processes and business objectives. • Work with Front End (Reporting) teams to understand their data display capability • Create a design and framework for the generic Ab Initio Code to handle the multiple and ever expanding list of data files coming from source • Work with business analysts to understand and prioritize user requirements • Design, development, test, and implement application code • Follow proper software development lifecycle processes and standards • Quality Analysis of the products, responsible for the Defect tracking and Classification • Track progress and intervene as needed to eliminate barriers and ensure delivery. • Resolve or escalate problems, and manage risk for both development and production support. • Coordinate vendors and contractors for specific projects or systems. • Maintain deep knowledge and awareness of technical & industry best practices and trends, especially in technology & methodologies.
Skills and Knowledge: • Hands-on experience with Ab Initio • Hands-on development experience with various Ab Initio components such as Rollup, Scan, Join, Partition by Key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, etc. • Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using Ab Initio. • Experience with SQL database programming, SQL performance tuning, relational model analysis, queries, stored procedures, views, functions and triggers • Knowledge in developing UNIX scripts, Oracle SQL/PL-SQL • Strong experience with Agile/SCRUM methodology • Experience with other ETL tools (Pentaho, Datastage, Informatica, ect) Pyspark, AWS, Cloud Data Engineer (Senior)
Employee Benefits: At LanceSoft, full time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits:
Four options of medical Insurance Dental and Vision Insurance 401k Contributions Critical Illness Insurance Voluntary Permanent Life Insurance Accident Insurance Other Employee Perks
About LanceSoft:
LanceSoft is rated as one of the largest staffing firms in the US by SIA. Our mission is to establish global cross-culture human connections that further the careers of our employees and strengthen the businesses of our clients. We are driven to use the power of our global network to connect businesses with the right people, and people with the right businesses without bias. We provide Global Workforce Solutions with a human touch.
EEO Employer:
LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. #NIT001